As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
Hello,
I have a client who has created a formula in an Excel spreadsheet, and what he wants to do is display only specific values to a WordPress page, with the ability to auto-update from time to time.
I was hoping your plugin might be able to help me accomplish that?
Beven
Any feedback on this question?
Hi Beven
Thank you for reaching out to us.
Importing or linking to Excel files that have formulae is not possible. You would need to copy the columns and rows that contain raw data, and then use formula columns to perform the same calculations in wpDataTables.
Our Formula Columns accept only basic mathematical operations, and you can't use complicated formulas in there. The formulas in wpDataTables are not the same as in Excel, so you may be able to achieve what you need with nested formulas (for example if Formula1 column is A*B/12; and you need to divide Formula1 column in another Formula2 column, you'd need to include the formula again, so Formula2 would be (A*B/12)/4).