Flexsheet Excel Export with formatted cells

Flexsheet Excel Export with formatted cells

Posted by: kuhnimanagam_raznin on 27 November 2018, 3:34 pm EST

• 

  kuhnimanagam_raznin

  • Post Options:
  • Link
    Copy

  Posted 27 November 2018, 3:34 pm EST

  Team,

  I have my flexsheet with a few columns configured in number format f = ‘n2’ and datatype as Number.I have another column that calculates the sum of the numeric columns. When I try to export the sheet and copy the exported data and paste that back to the sheet,The sum calculation is throwing me error saying “Invalid Expression”.

  But when I convert the exported excel columns to generic format before pasting back to the sheet,it works correctly.Any help would be appreciated.

  Thanks,
  
  Raznin

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 November 2018, 4:21 am EST

  Hi Ranzin,

  We are sorry but we are unable to replicate the issue at our end.
  
  Here are our implementation steps:
  
  • Create a flexsheet with two number type columns(sales, downloads) and format = ‘n2’
  
  • Add an extra column to calculate the sum of the number types columns, we used the sum formula for this purpose.
  
  • Export the FlexSheet to excel
  
  • Open the exported excel file
  
  • Press Ctrl+a and ctrl+c to copy all the content of the excel sheet
  
  • Now press Ctrl+a on the FlexSheet to select all the data and press ‘del’ key to clear the content(so that we can observe the change easily after pasting back the data)
  
  • Press Ctrl+v to paste data into the grid
  
  : Data is successfully pasted into the FlexSheet.

  Could you please have a look at the following sample and our implementation steps and let us know if we are missing something important to replicate the issue:
  
  https://stackblitz.com/edit/js-rtpf6u?file=index.js

  We tested the sample with version 5.20183.550 and 5.20182.500. Please let us know if you are facing the issue on a different version.

  ~Sharad