Smart UI Components & Libraries – Grid, Scheduler, Gantt, Kanban for Angular, React, Next.js, Vue, Blazor, JavaScript › Forums › Data Grid › Issue with decimal separator when exporting Grid to XLSX

Tagged: , ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • October 28, 2025 at 10:47 am #113168
    Federica Ricciardi
    Participant

    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!

    October 28, 2025 at 1:40 pm #113169
    Markov
    Keymaster

    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
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.