Spreadsheet Control is not formatting numbers correctly

[aswani_sanjay]

Hi Experts,

I am using Spreadsheet control in my application to export table data into Excel sheet. However in the exported excel sheet, the column type is not formatted properly. It should have been Number for all rows, but in some rows it is General and this is creating issues while performing arithmetic calculations.

Please find below the snapshot for the exported excel. The first and third row is formatted as "General" while the second row is formatted as "Number" and hence the sum and average is not calculating correctly in the footer.

excel-export.jpg

Could you please let me know if anyone has face similar issue or knows the solution to resolve the issue.

Please find below the JSFiddle for the issue.

https://jsfiddle.net/c178fzev/

Thanks,

Sanjay Aswani