Hi, All columns of uploaded excel sheet are not visible after uploading on backend or frontend. Only has about 10 columns and 15 rows. Not sure whats wrong. Please look into this.
I am attaching the sheet which I uploaded for you to look at. Please see attahced.
As I can see the file is not properly created in order to create a table from it. You must have column names ( attachment) Can you please add column names and then tell me is every result displayed.
Here is an example from our documentation so you can see how you can properly create a file.
Okay, I see what you mean. Now I made it even shorter with all column heading. Now its displaying the table correctly. However its not picking the excel formula in "area" column, can you tell me what I might be doing wrong? I am attaching the sheet for your reference. Its a very basic multiplication and addition. If you could tell me step by step, I guess, I am not sure about the "integer: "float" "oneline string" etc and thats what is causing this issue. Please guide me to get this small calculator online. Regards,
All of the formatting in the file should be removed.
Now for the Total in the Area column you can use Sum option from the column settings. More information can be found in our documentation about Calculation functions
As for the formula column you can use our built in feature Formula columns. More information on this link
Hi, I see it can do "sum" "average" etc however, I need the result to be "multiplication" of two columns in "area" column. Is that not possible? How about more complex forumulas in excel? Do you have any other documentation that I can look at to perform these tasks?
Another quick question, I was able to add the formula column however, not able to get a total of all items in the column. Is there a way I can achieve doing that? Since formula column does not allow to do a " sum" "average" etc, its only allowed in an integer or float coloumn. Please suggest how can I get a total of all rows in " formula column" in the bottom. Thanks,
Sorry to disappoint you but unfortunately Calculating functions are not possible to display with the formula columns with the plugin built in features at the moment.
Also, I am trying to make one of the columns editable on front end. Its giving me this error as soon as I change somethign from front end. "There was an error trying to update the row! Error: Column count doesn't match value count at row 1"
Hi, All columns of uploaded excel sheet are not visible after uploading on backend or frontend. Only has about 10 columns and 15 rows. Not sure whats wrong. Please look into this.
I am attaching the sheet which I uploaded for you to look at. Please see attahced.
HI vikramjo,
Thank you for your purchase.
As I can see the file is not properly created in order to create a table from it. You must have column names ( attachment) Can you please add column names and then tell me is every result displayed.
Here is an example from our documentation so you can see how you can properly create a file.
Best regards.
Kind Regards,
Miloš Jovanović
[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
Thanks, Bogdan!
Okay, I see what you mean. Now I made it even shorter with all column heading. Now its displaying the table correctly. However its not picking the excel formula in "area" column, can you tell me what I might be doing wrong? I am attaching the sheet for your reference. Its a very basic multiplication and addition. If you could tell me step by step, I guess, I am not sure about the "integer: "float" "oneline string" etc and thats what is causing this issue. Please guide me to get this small calculator online. Regards,
HI vikramjo,
All of the formatting in the file should be removed.
Now for the Total in the Area column you can use Sum option from the column settings. More information can be found in our documentation about Calculation functions
As for the formula column you can use our built in feature Formula columns. More information on this link
Hope this can help you .
Best regards.
Kind Regards,
Miloš Jovanović
[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, I see it can do "sum" "average" etc however, I need the result to be "multiplication" of two columns in "area" column. Is that not possible? How about more complex forumulas in excel? Do you have any other documentation that I can look at to perform these tasks?
Okay, please ignore my response. I did not view the other link you sent your response.
Hi Bogdan,
Another quick question, I was able to add the formula column however, not able to get a total of all items in the column. Is there a way I can achieve doing that? Since formula column does not allow to do a " sum" "average" etc, its only allowed in an integer or float coloumn. Please suggest how can I get a total of all rows in " formula column" in the bottom. Thanks,
Hi vikramjo,
Sorry to disappoint you but unfortunately Calculating functions are not possible to display with the formula columns with the plugin built in features at the moment.
Best regards.
Kind Regards,
Miloš Jovanović
[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
Any way around this that you can suggest?
Also, I am trying to make one of the columns editable on front end. Its giving me this error as soon as I change somethign from front end. "There was an error trying to update the row! Error: Column count doesn't match value count at row 1"
Can you please tell whats causing this error?
HI vikramjo,
Unfortunately there is no solution or customization of the plugin that will enable this feature.
As for your second issue may I kindly ask you to open a new ticket so we can keep our "one issue per ticket" policy.
You can open as many tickets as you like.
Best regards.
Kind Regards,
Miloš Jovanović
[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