Excel and numbers with commas


#1

When I export a grid (using the java server side code), and the grid contains numbers with commas such as 1,234.00 excel treats this as a “Number Stored As Text”.

When this happens it is a pain to click on each cell or column and tell Excel the data should be treated as a number.

This only happens when the data in the grid has a comma:

	gridRpt.setNumberFormat("0,000.00",1);

Is there a way to tell the export to not add the commas when sending the data to excel?


#2

thanks for looking into this…


#3

Any help with this one?


#4

Hi,
please, try to update grid-excel-java from attachment. It includes required fix.
grid-excel-java.zip (1.39 MB)


#5

This does fix the problem. Will this code update now be permanent? So the next time DHTMLx releases a new version will this change be in place or do I need to request it again?


#6

Yes, it will be included in the next release.


#7

Hi,

I have been using the newest version and it looks like the ‘number stored as text’ issue is back again. Any number with a comma such as ‘1,345.44’ is treated as text.

Is there a new java file available?

Brian