I have reviewed the documentation on spreadsheet (excel-like) editing. It mentions using this on the front end, but I cannot find how to do that. I have a MySQL table created using the wpDataTable Constructor that I would like to try that on. I don't see any options for Excel-like editing anywhere when I edit the table. Can I do this?
You just have to enable Front-end editing for that wpDataTable and then you'll be able to Front-end edit Excel-like table. Excel-like tables doesn't have editor modal like standard wpDataTables than you edit them by clicking directly on the cell.
Hi, I have the same problem. No front-end option if an excel spreadsheet or a google spreadsheet is the source. If I choose an excel spreadsheet as source there won't be an option "front-end editing" which I could check.
Tables made with Add from data source can't be editable. Only Manual tables and MySQL tables with server-side processing can be editable. Please take a look at this post from our documentation - Link.
No problem. That is the purpose of Public Tickets We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Thank you, Milos. I don't understand how to make it excel-like. Is this the same as in-line editing? I was thinking it was different because the arrow keys could be used to move from cell to cell. I only see how to make it in-line or modal.
When you are adding wpDataTable shortcode you can choose between Standard and Excel-like table type. If you choose Excel-like you will get Excel-like wpDataTable on the front-end.
Also you can take a look at this post from our documentation for Excel-like editor - Link
I have reviewed the documentation on spreadsheet (excel-like) editing. It mentions using this on the front end, but I cannot find how to do that. I have a MySQL table created using the wpDataTable Constructor that I would like to try that on. I don't see any options for Excel-like editing anywhere when I edit the table. Can I do this?
Hi sandiknowles,
Thank you for the purchase.
You just have to enable Front-end editing for that wpDataTable and then you'll be able to Front-end edit Excel-like table. Excel-like tables doesn't have editor modal like standard wpDataTables than you edit them by clicking directly on the cell.
Hi, I have the same problem. No front-end option if an excel spreadsheet or a google spreadsheet is the source. If I choose an excel spreadsheet as source there won't be an option "front-end editing" which I could check.
Hi bluecafe,
Tables made with Add from data source can't be editable. Only Manual tables and MySQL tables with server-side processing can be editable. Please take a look at this post from our documentation - Link.
Hi, yes you are right. Sorry for hijacking this thread. If I use the WPDatatable Constructor the option shows up with google spreadsheets ... THANKS!
Hi bluecafe,
No problem. That is the purpose of Public Tickets
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Thank you, Milos. I don't understand how to make it excel-like. Is this the same as in-line editing? I was thinking it was different because the arrow keys could be used to move from cell to cell. I only see how to make it in-line or modal.
Hi sandiknowles,
When you are adding wpDataTable shortcode you can choose between Standard and Excel-like table type. If you choose Excel-like you will get Excel-like wpDataTable on the front-end.
Also you can take a look at this post from our documentation for Excel-like editor - Link
Hi Milos,
There is no link in the documentation to information about activating the Excel like mode.
See also the screenshot.
Johan
Hi johanfit,
You are right. We will correct that. Thank you for notifying us.
Could you briefly explain how to do this with the short code? Thanks!
Hi sandiknowles,
All you have to do is to add shortcode like [wpdatatable id=3 table_view=excel] instead of usual shortcode.
Thank you, Milos!