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.
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
Krunal
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
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.
None
0 Points
2 Posts
Export to Excel Problem
Dec 09, 2015 03:54 AM|iamreverie|LINK
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!
All-Star
15252 Points
2074 Posts
Re: Export to Excel Problem
Dec 10, 2015 02:43 AM|Krunal Parekh|LINK
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
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
None
0 Points
2 Posts
Re: Export to Excel Problem
Dec 10, 2015 05:17 AM|iamreverie|LINK
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