Are you able to copy and paste from an excel spreadsheet into the form with the same format?

  • sungas
    Asked on June 9, 2015 at 11:12 AM
  • Sammy
    Replied on June 9, 2015 at 12:08 PM

    You can paste the spreadsheet contents in design mode into the text element, a corresponding table will be created with the text element.

    Are you able to copy and paste from an excel spreadsheet into the form with the same format? Image 1 Screenshot 20

  • sungas
    Replied on June 9, 2015 at 12:12 PM

    Am I able to edit the cells after tho?

  • Sammy
    Replied on June 9, 2015 at 12:18 PM

    In the designer you are able to edit the cells, since it is now treated as an HTML table,

    Use the html section to edit

    Are you able to copy and paste from an excel spreadsheet into the form with the same format? Image 1 Screenshot 30

    Another cleaner approach is to use the data-grid under the widgets section, this allows for easier addition and removal of data, however you cannot directly paste the value with the excel format.

    Are you able to copy and paste from an excel spreadsheet into the form with the same format? Image 2 Screenshot 41

     

  • Sammy
    Replied on June 9, 2015 at 4:01 PM

    If you want the data to be editable by the end user before submissions, you can use the spreadsheet widget.

    This looks similar to the excel spreadsheet.

    Are you able to copy and paste from an excel spreadsheet into the form with the same format? Image 1 Screenshot 20

     

    Kindly confirm if this meets your requirements