Hallo ich möchte eine fertige Exceltabelle mit ein paar Kalkulationen und Funktionen hochladen, leider aber kommt es immer zu einem Fehler. Was mache ich da Falsch ?
As we pointed out on this Page, sorry to disappoint you, but it is not possible to use an Excel with any kind of formulas/functions with our Plugin as data source.
We also don't support merged cells coming from the source file ( Excel/CSV or any other).
The only way to use a source Sheet with formulas is, if you can switch to Google Spreadsheets.
We have this guide on how you can use an !importrange in order to pass the 'finished values' when the formulas on the Google Sheet are finished - so then our table will only 'pick up' the final values.
Please check it out and let me know if that can work for you.
Hallo ich möchte eine fertige Exceltabelle mit ein paar Kalkulationen und Funktionen hochladen, leider aber kommt es immer zu einem Fehler. Was mache ich da Falsch ?
Attached files: Screenshot 2024-09-09 182253.png
Hello,
As we pointed out on this Page, sorry to disappoint you, but it is not possible to use an Excel with any kind of formulas/functions with our Plugin as data source.
We also don't support merged cells coming from the source file ( Excel/CSV or any other).
The only way to use a source Sheet with formulas is, if you can switch to Google Spreadsheets.
We have this guide on how you can use an !importrange in order to pass the 'finished values' when the formulas on the Google Sheet are finished - so then our table will only 'pick up' the final values.
Please check it out and let me know if that can work for you.
Thank you.
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