Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #3503825
Float e ricerca
Closed

Comments

  • adriano started the conversation
    October 20, 2023 at 1:42pm

    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

  • Antonino replied
    October 21, 2023 at 11:12am

    Ciao,

    Dalle impostazioni di wpdatatable puoi cambiare i separatori

    https://wpdatatables.com/documentation/general/configuration/

    Prova a vedere se risolvi.

  •  1,847
    Miloš replied
    October 24, 2023 at 3:34pm

    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

    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