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

Okay
  Public Ticket #1079915
How to Enable Front-End Excel-Like Editing
Closed

Comments

  •  2
    sandiknowles started the conversation

    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?

  • [deleted] replied

    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.

  •  2
    bluecafe replied

    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. 

  • [deleted] replied

    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.

  •  2
    bluecafe replied

    Hi, yes you are right. Sorry for hijacking this thread. If I use the WPDatatable Constructor the option shows up with google spreadsheets ... THANKS!

  • [deleted] replied

    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! 

  •  2
    sandiknowles replied

    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. 

  • [deleted] replied

    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

  •  2
    Johan replied

    Hi Milos, 

    There is no link in the documentation to information about activating the Excel like mode.

    See also the screenshot.

    Johan

  • [deleted] replied

    Hi johanfit,

    You are right. We will correct that. Thank you for notifying us.

  •  2
    sandiknowles replied

    Could you briefly explain how to do this with the short code?  Thanks!

  • [deleted] replied

    Hi sandiknowles,

    All you have to do is to add shortcode like [wpdatatable id=3 table_view=excel] instead of usual shortcode.

  •  2
    sandiknowles replied

    Thank you, Milos!