Copying computed columns to text Column gives error

Copying computed columns to text Column gives error

Posted by: shrihari.dani on 14 December 2017, 1:35 am EST

• 

  shrihari.dani

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 December 2017, 1:35 am EST

  Hi,

  We are using wijmo flexsheet licensed version. When I am copying a text/numerical field to text column it works. However, when I am trying to copy a computed column to a text column it gives error/0/NaN. Also as per my analysis of the issue the handler attached to pasting event gives me incorrect formula for computed columns. Similar behavior is observed here http://demos.wijmo.com/5/angular/FlexSheetIntro/FlexSheetIntro/ in formulas section when we copy any value from column Total to Fuel or parking per hour it gives either error or 0.

  Your help is appreciated.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 14 December 2017, 5:49 pm EST

  Hi,
  
  This is because of Formula update on pasting for target cell. If you would like to copy value only, you need to handle copying event and set Clipboard data.

  ~Manish