Buongiorno, ho un problema con gli importi e la ricerca. Se utilizzo gli importi come float, tutto funziona regolarmente, ma quando esporto il file excel, ottengo il numero suddiviso con punti come divisorio e virgole come decimali (e non posso obbligare i superiori a fare sostituisci caratteri). Se imposto i valori economici come string, ottengo il valore "corretto" nel file excel ma non funziona più la ricerca per testo. Sapete come posso risolvere questa situazione? Grazie Adriano
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.
Thank you for your understanding.
After further investigation, we found out that 3rd party software that is responsible for exporting tables in excel does not support the European number format.
It only works if numbers contain both dot and comma in the number.
Buongiorno,
ho un problema con gli importi e la ricerca.
Se utilizzo gli importi come float, tutto funziona regolarmente, ma quando esporto il file excel, ottengo il numero suddiviso con punti come divisorio e virgole come decimali (e non posso obbligare i superiori a fare sostituisci caratteri).
Se imposto i valori economici come string, ottengo il valore "corretto" nel file excel ma non funziona più la ricerca per testo.
Sapete come posso risolvere questa situazione?
Grazie
Adriano
Ciao,
Dalle impostazioni di wpdatatable puoi cambiare i separatori
https://wpdatatables.com/documentation/general/configuration/
Prova a vedere se risolvi.
Hi Antonino,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Please note that the official support language is English, and we have to use Google Translator to try and understand other languages. Since a lot can be lost in translation, we apologize in advance if we misunderstood some segments of your message, and we also ask you to please translate your future messages to English.
Thank you for your understanding.
After further investigation, we found out that 3rd party software that is responsible for exporting tables in excel does not support the European number format.
It only works if numbers contain both dot and comma in the number.
Here is the reference.
My suggestion is to use CSV as an export or to make those columns as a string,
or alternately, you can switch to using the other Number Format if it has to be an Excel Export from our Tables.
Sorry for this inconvenience.
Kind Regards,
Miloš Jovanović
[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