Flexsheet Angular2 Paste example with validation on unbounded Sheet?

Posted by: Reed.Owens on 14 September 2017, 9:56 am EST

  • Posted 14 September 2017, 9:56 am EST

    Is there any examples on handling pasting of cells from Excel into an Unbounded Flexsheet? I'm trying to do this and validate the data coming in. I can process each cell with the event pastedCell() but my issue is that if the cell was a currency and the data pasting in has a currency sign, then the data becomes a string with the currency sign and not a number. There are other validations/transformations that may need to be done also. What is the best way to coerce the data coming in on a cell by cell basis?
  • Replied 15 September 2017, 8:02 am EST

    You can handle pastingCell event for the same. But, we are sorry, we are unable to replicate the issue at our end. Could you please share demo FlexSheet depicting the issue and build version?

    Manish Kumar Gupta
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels