Export to Excel Problem

Question

User1915099872 posted

Good day!

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?
Thanks!

Answer 1

User1644755831 posted

Hello iamreverie,

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.

With Regards,

Krunal Parekh

Answer 2

User1915099872 posted

Hi Krunal,

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.

- IamReverie