Hi, when importing data from an xlsx file the numbers in all columns are divided by 1000. Also, I negative numbers are shown as 0.
How can I arrange correct import without the above data loss please? Also, how can I format columns to show -ve numbers in the (0.00) format and in RED?
The number format has to be the same in your Excel, local machine and wpDataTables, or the plugin will be confused and insert a wrong number due to formatting.
Can you send me the file, so I can test in my local environment?
You can take a look at our documentation about Conditional Formatting.
You can display the negative numbers in red by using advanced filtering. Just add a condition where cell value < 0, and set the color of the row to "red".
Hi, when importing data from an xlsx file the numbers in all columns are divided by 1000. Also, I negative numbers are shown as 0.
How can I arrange correct import without the above data loss please? Also, how can I format columns to show -ve numbers in the (0.00) format and in RED?
Thank you
Mark
Hello Mark
Thank you for your purchase.
The number format has to be the same in your Excel, local machine and wpDataTables, or the plugin will be confused and insert a wrong number due to formatting.
Can you send me the file, so I can test in my local environment?
You can take a look at our documentation about Conditional Formatting.
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
Thank you Aleksandar
This has worked, thanks. Is there a way to display negative number with brackets &/or in red?
Hello Mark
You can display the negative numbers in red by using advanced filtering. Just add a condition where cell value < 0, and set the color of the row to "red".
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