Formula referencing different workbook

Formula referencing different workbook

Posted by: brian.ploe on 16 September 2019, 11:54 am EST

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 16 September 2019, 11:54 am EST

  Hello,
  
  I would like to reference a different workbook in a formula similar to excel’s multi workbook support. Both workbook would be open in the same page.

  As an example: sum([someotherworkbook]mytab!A1,B2)

  Is this possible?

  Alternately, can i open a hidden worksheet tab from the same workbook in a popup rather than changing the current tab over to a new one?

  Thanks!

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 17 September 2019, 1:38 am EST

  Hi Brian,

  Currently, SpreadJs do not support cross workbook formula references. It is in our backlog but we do not have an ETA. The internal tracking ID for the issue is SJS-1704. We will let you know about any updates regarding the same.

  >> Alternately, can i open a hidden worksheet tab from the same workbook in a popup rather than changing the current tab over to a new one?
  
  We can’t actually open a tab from workbook in popup but what we could do is make a copy of the current workbook data using the workbook.toJSON() method and then create a new workbook with the same data and display the new workbook in the popup and display the hidden tab.

  Regards
  
  Sharad

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 17 September 2019, 9:28 am EST

  Ok, thank you for the reply. I’ll use option 2 for now