Failed to export numbers with separators (1,234,223.45)Excel


#1

When you export a table with columns with a format for numbers with thousands separator, Excel takes the first separator as the decimal separator and truncates the rest of the number. Please, help us!!!



#2

Hi,
please, try to update grid-excel-php from attachment.
It includes required changes.
grid-excel-php.zip (790 KB)


#3

Ok, now we are whole numbers but in string format.
It could be number format?


#4

Hi,
updated package may be found in attachment.
It will be a number for now, dot is used as delimiter, comma is cut.


#5

Forgot to attach script
grid-excel-php.zip (790 KB)


#6

Thanks, you helped me a lot


#7

Could you please provide this number format solution in .Net
Regards


#8

In the newest version, when using ’ ’ [space] as thousand separator I get ie. 1 when number is 1 234,34 (This is polish local formatting) or 3 when we speak about 3 456,45


#9

Are you using php export script, or .net|java version?


#10

PHP Export


#11

Unfortunately the problem cannot be reconstructed locally.
numbers export to excel well for me.
If the problem still occurs for you please, provide with a complete demo or share with a demo link, where the problem can be reproduced.
Here you can find a tutorial about creating a complete demo:
docs.dhtmlx.com/tutorials__auxil … pport.html


#12

Here you are.
dev.blesksoft.pl/export_error/


#13

Any update?


#14

Hi,

We can confirm issue, thanks for the sample.
Fix will be available on the next week.


#15

Anything new? Is there a corrected version availabale?


#16

I apologize for the delay.
The issue is confirmed and fixed. Please, try to include the attached file instead of the original in your export package.
It should solve the problem.
gridExcelWrapper.zip (2.96 KB)