Hello,

I am using the premium version of wpDataTables and loading data from a Google Sheets file. The sheet contains numeric values representing currency, formatted like this: 3125,48 (with a comma as the decimal separator).

However, when the data is loaded into wpDataTables, the values are misinterpreted – the comma is not recognized as a decimal separator, and the numbers are either not displayed correctly or not treated as valid floats.

I need to keep the comma format (,) because it’s the standard in my locale (Bulgaria), and I also want the column to be treated as numeric so that sorting, filtering, and calculations work.

I’ve already tried adjusting the "Number Formatting" settings in wpDataTables > Settings, but it seems that wpDataTables still expects a dot (.) in the source file.

Is there a way to make wpDataTables recognize the comma as a decimal separator directly from the Google Sheet, without having to manually convert all values to dot format?

Thank you in advance!