Hi, when I upload the excel file in the table I have a problem. The exacel files has numbers in this format 1.90 ; 2.20, etc...when I upload the file, in the table misses the "." and I get the number as 190 ; 220 instead of 1.90 ; 2.20
Can you please check option "Number format" in main settings of plugin? If you have dot for decimal numbers then the number format should be set to 15,000.00
I want to buy other 3 licenses, and to use the same excel file for all 4 websites, so this is very important for me, because adding the tips in a excel file, and uploading the same excel on 4 websites saves lots of time instead of adding those tips one by one on each website, so this is very important for me to work.
We saw your file and the reason why you are getting wrong results it's because you have different decimal separator in same column.(attachment) You have to use only one. If you choose dot you have to set Number format like 15,000.00 and if you want to use comma you have to set Number format 15.000,00 and than you will get right results.
I did exactly as you said but that dosn't solve the problem. Istead of having the number as 1.90, it appears as 190.00, or insteas of 1.75 appears as 175,00
Hi, when I upload the excel file in the table I have a problem. The exacel files has numbers in this format 1.90 ; 2.20, etc...when I upload the file, in the table misses the "." and I get the number as 190 ; 220 instead of 1.90 ; 2.20
How can I fix that?
Thank you very much!
Hi nandrei89,
Thank you for your purchase.
Can you please check option "Number format" in main settings of plugin? If you have dot for decimal numbers then the number format should be set to 15,000.00
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi, thank you for your answer. If I do that, it shows me just the number...instead of 1.90 for example, it appears just 1
Hi nandrei89,
Can you please send me that file so I can take a look? Thank you
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi, yes I attached the file here. I tried all possibilities to formating the cells, but no results.
I want to buy other 3 licenses, and to use the same excel file for all 4 websites, so this is very important for me, because adding the tips in a excel file, and uploading the same excel on 4 websites saves lots of time instead of adding those tips one by one on each website, so this is very important for me to work.
Hi nandrei89,
We saw your file and the reason why you are getting wrong results it's because you have different decimal separator in same column.(attachment) You have to use only one. If you choose dot you have to set Number format like 15,000.00 and if you want to use comma you have to set Number format 15.000,00 and than you will get right results.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I did exactly as you said but that dosn't solve the problem. Istead of having the number as 1.90, it appears as 190.00, or insteas of 1.75 appears as 175,00
PROBLEM SOLVED, INSTEAD OF "." I HAD TO CHANGE TO "," .
THANK YOU VERY MUCH
Hi nandrei89,
You are welcome. Glad that we help you.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables