I am having endless problems with numbers/float/integers. They are being imported, but the decimals are not in the right places compared to the google sheet.
I am not 100% sure if you are having a table linked to synchronize from the Google Sheet source - or if you are importing it to make an editable/manual table, so we will advise for both cases.
If you use a table linked from the source Sheet, this is easy to solve :
This is most probably an issue with the current Number Format and Decimal places selected in your settings.
Please go in your Main Plugin settings/ and change the Number Format to the one you need;
Also double-check how many decimal places you need and set this accordingly as well.
Let me know if that solves the issue.
2. Or, if you are importing the data into an editable table, here are more details on that :
When we import the data in a new Manual Table - at the moment, there is this 'limitation' so to speak.
By default, it is going to set a 4 decimals as the format;
So during the Table creation, please choose for each Float column, edit this 'Type value' and leave the first number as 16, just edit the second one from the "4" as default decimal number to the decimal number you need :
Then this field will be created in your SQL Database as the set decimal number.
Also important to note, for presenting the default decimal number in the Plugin, you can set your desired number of decimals in the Main Plugin settings, too.
Later you will also be able to override this per Column;
So my Column here will become saved with 2 decimals - but i can go in Column settings/Data tab and change this to render as 4 to override it in the Table.
That way you can have different columns with different decimal points ( if needed).
I am having endless problems with numbers/float/integers. They are being imported, but the decimals are not in the right places compared to the google sheet.
I am having to format all my numbers are strings which means I am losing calculation functionality.
Hi Chipego,
I am not 100% sure if you are having a table linked to synchronize from the Google Sheet source - or if you are importing it to make an editable/manual table, so we will advise for both cases.
This is most probably an issue with the current Number Format and Decimal places selected in your settings.
Please go in your Main Plugin settings/ and change the Number Format to the one you need;
Also double-check how many decimal places you need and set this accordingly as well.
Let me know if that solves the issue.
2. Or, if you are importing the data into an editable table, here are more details on that :
When we import the data in a new Manual Table - at the moment, there is this 'limitation' so to speak.
By default, it is going to set a 4 decimals as the format;
So during the Table creation, please choose for each Float column, edit this 'Type value' and leave the first number as 16, just edit the second one from the "4" as default decimal number to the decimal number you need :
Then this field will be created in your SQL Database as the set decimal number.
Also important to note, for presenting the default decimal number in the Plugin, you can set your desired number of decimals in the Main Plugin settings, too.
Later you will also be able to override this per Column;
So my Column here will become saved with 2 decimals - but i can go in Column settings/Data tab and change this to render as 4 to override it in the Table.
That way you can have different columns with different decimal points ( if needed).
Let me know if that helps.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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