Last post Dec 10, 2015 05:17 AM by iamreverie
Dec 09, 2015 03:54 AM|iamreverie|LINK
Hi, technically I'm still new here and hopefully someone could help me address an issue I'm having.
The problem here is when I export the file to Excel. Item 1's Total Cost turns to "668129.25" but item 2 is retained.
But if it is exported to PDF or Word, everything seems fine.
This only occurs during Export to Excel.
Can anyone enlighten me?
Dec 10, 2015 02:43 AM|Krunal Parekh|LINK
It could be that excel is rounding up the value. Did you check into the cell what actual value is not the displayed ? Check the Column Type In the excel (Number , String etc.) that formats the data accordingly. I suspect this is format issue rather then
wrong value being exported.
Dec 10, 2015 05:17 AM|iamreverie|LINK
When I checked in Excel, the data was not rounded. It's just plain "668129.25". But what bothers me most is that.. The second row's TOTAL COST column is correct. (rounded)
In my understanding, that column could be proof to disregard the issue of formatting. Am I correct?
Viewing the report in the system was okay. Exported in PDF or Word was fine too. Just this Excel part is what gives me headaches. I'm currently stuck with this issue as of the moment.
Thanks for the response.