I want the attached table to be placed in a website with all functions in it. I've first made it in Excel. Understood from instructions that it should be made in Google Spreadsheet, so I did. I followed the instruction 'Google Spreadsheet configuration', but it is constantly giving an error when I use the formula in a copy spread that I would have to import. When I try the other way by inserting the url of the spread, then the formula's in the spread don't work. Pff, I don't know how to get this job done. Can you tell me what to do?
wpDataTables can't see empty rows or have subheaders, so the spreadsheet you sent will probably be imported with string-type columns (numerical columns need to have some value, starting from 0), and calculations can't be done with string-type columns.
Using Excel files that contain formulas is not possible, but you can use our Formula Columns and Calculation functions. If you want to use Formulas in Google Spreadsheet, you need to use the IMPORTRANGE function, as explained here.
I want the attached table to be placed in a website with all functions in it. I've first made it in Excel. Understood from instructions that it should be made in Google Spreadsheet, so I did. I followed the instruction 'Google Spreadsheet configuration', but it is constantly giving an error when I use the formula in a copy spread that I would have to import. When I try the other way by inserting the url of the spread, then the formula's in the spread don't work. Pff, I don't know how to get this job done. Can you tell me what to do?
the Excel file
Hello Paméla
Thank you for your purchase.
wpDataTables can't see empty rows or have subheaders, so the spreadsheet you sent will probably be imported with string-type columns (numerical columns need to have some value, starting from 0), and calculations can't be done with string-type columns.
Using Excel files that contain formulas is not possible, but you can use our Formula Columns and Calculation functions. If you want to use Formulas in Google Spreadsheet, you need to use the IMPORTRANGE function, as explained here.
That works without issues.
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