I have a problem with importing data table from excel.(cell contains Valuta in €)
When I import a table from Excel to create a table with prices in Euro (like € 100) the Euro sign € in WP data tables creates €/ (adds an / after the €).
I tried with other Valuta currencies like USdollar or pound and that gives no problem, only with EUR and €.
I did not have this problem with the free version of WP datatables.
(click tab PRIJSTABEL to see the table on our website)
How can I make this work again, (I already checked in the cell content suffix nothing there (there is no /). Also I don't want to use the pefix set as an € and then import from excel as a number, this works but then I need to change every colum etc., so I don't want to make use of the prefix function)
I don't know why this happens until I take a look at the file. Would you be able to send me that Excel file (just zip it and attach it to your response)?
If it contains some sensitive data, please make sure to enable the Private response.
My advice would be to remove the € sign, and use the column prefix. You can easily find & replace "€ " (euro sign followed by a space) with an empty value "", and it would remove the sign (and the space after it), and store the column as integer (or float):
Hereby the excel-file in .zip format it's just a test
file.
However I need to import hundreds of
tables later from excel, that's why I want to find out what is wrong. I don't
want to change all the € (Euro) signs, also when I use the function of Master
Detail tables, the Euro sign will not show if I use only numbers in Excel
(that's also a reason I don't want to use the prefix / suffix).
I also have another question.
Is it also possible to automatically find
the lowest price in a WPData Table and then show the lowest price somewhere
separate from the table (like a placeholder) in a page (without using the
Master Detail page, because this only refers to one page)
We use the latest version of Office 365
with Excel.
I believe the issue lies somewhere in the formatting.
When I copy the contents of your file into a new spreadsheet, and add the currency symbol, and format the date as 31.12.1999 it works normally:
Can you try with the attached file, and see if it will work normally?
As for the lowest price - that is possible, but only if you add the columns as integers or floats. Then, when you go to column settings/Data tab, you will see calculation options MIN, MAX, AVG and SUM which have their own shortcodes you can place somewhere outside the table. It will not work for strings, though.
Hello,
I have a problem with importing data table from excel.(cell contains Valuta in €)
When I import a table from Excel to create a table with prices in Euro (like € 100) the Euro sign € in WP data tables creates €/ (adds an / after the €).
I tried with other Valuta currencies like USdollar or pound and that gives no problem, only with EUR and €.
I did not have this problem with the free version of WP datatables.
https://www.bmair.nl/wp/trip/bangkok-koh-samui-tour/
(click tab PRIJSTABEL to see the table on our website)
How can I make this work again, (I already checked in the cell content suffix nothing there (there is no /). Also I don't want to use the pefix set as an € and then import from excel as a number, this works but then I need to change every colum etc., so I don't want to make use of the prefix function)
Hope you can help me solve this problem,
Thanks + brgds,
Ron Verbon
Hello Ron.
I don't know why this happens until I take a look at the file. Would you be able to send me that Excel file (just zip it and attach it to your response)?
If it contains some sensitive data, please make sure to enable the Private response.
My advice would be to remove the € sign, and use the column prefix. You can easily find & replace "€ " (euro sign followed by a space) with an empty value "", and it would remove the sign (and the space after it), and store the column as integer (or float):
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
Hi Aleksandar,
Thank you for your reply.
Hereby the excel-file in .zip format it's just a test file.
However I need to import hundreds of tables later from excel, that's why I want to find out what is wrong. I don't want to change all the € (Euro) signs, also when I use the function of Master Detail tables, the Euro sign will not show if I use only numbers in Excel (that's also a reason I don't want to use the prefix / suffix).
I also have another question.
Is it also possible to automatically find the lowest price in a WPData Table and then show the lowest price somewhere separate from the table (like a placeholder) in a page (without using the Master Detail page, because this only refers to one page)
We use the latest version of Office 365 with Excel.
Brgds,
Ron
Hello again Ron
I believe the issue lies somewhere in the formatting.
When I copy the contents of your file into a new spreadsheet, and add the currency symbol, and format the date as 31.12.1999 it works normally:
Can you try with the attached file, and see if it will work normally?
As for the lowest price - that is possible, but only if you add the columns as integers or floats. Then, when you go to column settings/Data tab, you will see calculation options MIN, MAX, AVG and SUM which have their own shortcodes you can place somewhere outside the table. It will not work for strings, though.
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
Hello Aleksander,
Thanks for your solution.
Changing the € type in Excel into "€ "#.##0 works ok now.
Also the lowest price.
Thanks + brgds,
Ron
Great news, Ron
Thanks for letting me know.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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