Multiple FlexSheet instances sharing formulas

Multiple FlexSheet instances sharing formulas

Posted by: jorge.s on 3 April 2019, 8:09 am EST

• 

  jorge.s

  • Post Options:
  • Link
    Copy

  Posted 3 April 2019, 8:09 am EST

  Hi,

  We are evaluating the possiblity of using FlexSheet to migrate an Excel file to a web application (Angular 7+). We would need to be able to share formulas across multiple FlexSheet instances, and we were wondering if this is possible.
  
  In a way, it would be like having many sheets, but in separate windows/areas.

  So a formula could look something like:

  =SUM(Instance1(A1), Instance2(B3))

  , which would add up the cell A1 from FlexSheet instance 1, to cell B3 from FlexSheet instance 2.

  This would allow us to prevent having one big spreadsheet with various areas inside it, and have a website with multiple excel components communicating between them.

  Also, are there hooks we can subscribe to? Like for instance, when a cell has changed, when a formula has been recalculated, when the instance has been loaded, etc.

  Thanks a lot!

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 5 April 2019, 5:34 am EST

  Hi,

  Thanks for evaluating Wijmo.
  
  We are sorry but currently referring to cellRanges of different instances is not supported, however, we have added an enhancement request to add this feature(Internal tracking id #374191).

  >> Also, are there hooks we can subscribe to? Like for instance, when a cell has changed, when a formula has been recalculated, when the instance has been loaded, etc.
  
  FlexSheet provides different events for different purposes, please refer to the following doc for a complete list of supported events:
  
  https://demos.wijmo.com/5/Angular/WijmoHelp/WijmoHelp/topic/wijmo.grid.sheet.FlexSheet.Class.html

  Regards

• 

  jorge.s

  • Post Options:
  • Link
    Copy

  Posted 8 April 2019, 6:45 am EST

  Thank you very much for the reply (and the enhancement request!).

  Cheers!