in page it looks good but when i exported it to excel file then i see that values which are > 1000 in excel file are converted to another format ( see file attached )
and it's related actually not only for these columns but for all columns which has float format and value is more then 1000, i guess it's because comma symbol in it
f.e:
1,000.0,
1,800.0
1,300.0 etc...
pls advise how can i fix it? all exported to excel file values from these columns should have the one format i guess.
The export tools are based on a 3rd party HTML5 library and are quite limited when their functionality is in question.
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so the font, format, size, and other properties cannot be changed.
You can read about all limitations in our documentation, but I believe this can be sorted out.
The number format must be the same in wpDataTables, WordPress, and your local environment (PC, MS Office Suite, and so on). So if there are some settings different than in wpDataTables, the generated file may appear differently, like in your case.
Can you, please share the page where the table is located with me, so I can test it locally?
The 3rd party software that is responsible for export tables works if numbers contain both dot and comma in number. Here is the reference.
I managed to get it to work correctly when I used CSV as an export. Unfortunately, until this is resolved by datatables.net there's nothing we can do to help. When exporting to Excel, with the locale set to English US, the whole numbers will always ignore the .0 after them if they don't have a thousand separator (comma), while other floats, like 851.5 or 1,380.0 will be passed correctly.
So, numbers without a thousand separator will be saved without .0 at the end, while numbers with a thousand separator will show up correctly.
Hello, i have table with data
columns have column type float https://monosnap.com/file/Fx917uBniGF2zkFzMBQc4f3r5xxdif
this table have two columns which have different values which is <1000 and of course >1000 ( screenshot below )
https://monosnap.com/file/rumrNjUqCRGGSLnMFspkNehvEuj86d
in page it looks good but when i exported it to excel file then i see that values which are > 1000 in excel file are converted to another format ( see file attached )
and it's related actually not only for these columns but for all columns which has float format and value is more then 1000, i guess it's because comma symbol in it
f.e:
1,000.0,
1,800.0
1,300.0 etc...
pls advise how can i fix it? all exported to excel file values from these columns should have the one format i guess.
Hello Roman
The export tools are based on a 3rd party HTML5 library and are quite limited when their functionality is in question.
Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so the font, format, size, and other properties cannot be changed.
You can read about all limitations in our documentation, but I believe this can be sorted out.
The number format must be the same in wpDataTables, WordPress, and your local environment (PC, MS Office Suite, and so on). So if there are some settings different than in wpDataTables, the generated file may appear differently, like in your case.
Can you, please share the page where the table is located with me, so I can test it locally?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello,
page is here https://test.viewdemo.co/wp/spacinsider/weekly-spac-ipo-update/
pls check
any tab, any float columns with float values https://monosnap.com/file/YVvah3wEwJdXr77f5orvqdjpuaugXh
try to download it in excel file and check
Hi again Roman.
The 3rd party software that is responsible for export tables works if numbers contain both dot and comma in number. Here is the reference.
I managed to get it to work correctly when I used CSV as an export. Unfortunately, until this is resolved by datatables.net there's nothing we can do to help. When exporting to Excel, with the locale set to English US, the whole numbers will always ignore the .0 after them if they don't have a thousand separator (comma), while other floats, like 851.5 or 1,380.0 will be passed correctly.
So, numbers without a thousand separator will be saved without .0 at the end, while numbers with a thousand separator will show up correctly.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables