Formula reference to different instance

Formula reference to different instance

Posted by: tosch on 11 March 2022, 2:02 am EST

• 

  tosch

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 March 2022, 2:02 am EST

  Can I make a reference to cell in an other instance of fpspread on the same form?

  Thomas

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 13 March 2022, 9:18 pm EST

  Hi,

  We are getting in touch with the development team to get information on this and will let you know as soon as we have an update.

  Regards
  
  Avnish

  [Tracking ID SPNET-23113]

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 13 March 2022, 10:17 pm EST

  Hi Thomas,

  As per the development team, you can reference cell from other instance of Spread in the following way:

  fpSpread2.AsWorkbook().Name = "Book2";
  fpSpread1.AsWorkbook().WorkbookSet.Workbooks.Add(fpSpread2.AsWorkbook());
  fpSpread2.AsWorkbook().ActiveSheet.Cells["A1"].Value = "Book2";
  fpSpread1.AsWorkbook().ActiveSheet.Cells["A1"].Formula2 = "[Book2]Sheet1!A1";
  

  However, you must remember that when you add fpSpread2 to the workbookSet of fpSpread1, fpSpread2 must be empty. All initialized data should be executed after it’s added.

  Regards
  
  Avnish

• 

  tosch

  • Post Options:
  • Link
    Copy

  Posted 14 March 2022, 6:42 pm EST

  Thanks for your help, works fine.

  Thomas