Issue with decimal separator when exporting Grid to XLSX

[Federica Ricciardi]

Hi!

I’m having an issue when exporting data to XLSX.
Columns that contain decimal numbers (formatted with cellsFormat: “n2” or even without any format) are exported using a dot (.) as the decimal separator.

However, in Excel (with a locale that uses a comma , as the decimal separator, such as Italian), these values are not recognized as numbers but as text, which prevents performing numeric operations.

Is there a way to configure the export so that decimal numbers are written using a comma instead of a dot — for example, through a locale setting, an export option, or a callback like onExportData or exportDataTransform?

Thank you in advance for your help!

[Markov]

Hi Federica,

You can use the dataExport’s cellFormatFunction to format the exported values.

Here is a demo which shows how to use it: https://www.htmlelements.com/demos/grid/data-export-hyperlinks/

Best regards,
Markov

Smart UI Team
https://www.htmlelements.com/

[Author]

Posts