The search feature does not seem to work when I search for a value that has decimals or commas in it. See the table on this page... http://mikegovernale.com/tariff-codes and try to search for any of the values in column 1 (i.e. 2.032.920,00).
I needed to set the column type to "String" upon importing my .XLS file into WPdatatables. Changing the column type after import messed up my data values.
The search feature does not seem to work when I search for a value that has decimals or commas in it. See the table on this page... http://mikegovernale.com/tariff-codes and try to search for any of the values in column 1 (i.e. 2.032.920,00).
How can I make this work?
Mike
I just realized the column type was set to Float, which was changing my data. The data in column 1 should follow this format... 0000.00.00
Setting the column to String removes the decimals. How can I keep the decimals?
Mike
Solved it.
I needed to set the column type to "String" upon importing my .XLS file into WPdatatables. Changing the column type after import messed up my data values.
Hi Mike,
Thank you for your purchase.
Can you please send me the that file from which you are creating the table, so I can take a look.
Best regards.
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