We are using Aspose for one of our reporting application. I am facing some issues while assigning value to a Cell which is formatted to have percentage value.
Please find the sample Excel and Java Program simulating the issue for your reference. I will put up my scenario based on the "PercentageTester.xls" file attached in the mail.
1. Column D & E are formatted to have percentage value upto 4 decimal points.
------ Now lets capitalize on the cell E4 on the sheet named test -------
2.a. I manually go and change the value of the cell E4 to 5. The cell displays the value as 5.0000%.
2.b. I programmatically** update the value of the of the cell E4 to 5. The cell*** displays the cell value as 500.0000%.
I think this might be an issue with Aspose. If I am not wrong then the right way is the way Ms Excel is behaving and in-fact thats what our requirement is.
Please guide me through. Let me know if you need more clarification.
** - The java programmed is supplied in the attachment.
*** - The output file is supplied in the attachment.