Custom Names in a multi-sheet control

Posted by: judir on 8 September 2017, 1:16 pm EST

  • Posted 8 September 2017, 1:16 pm EST

    We use range names to load and save data at runtime.  If I open a multi-sheet Excel file at runtime, I can see all the custom names in the entire file from each sheet.  Is this the intended behavior?
  • Replied 8 September 2017, 1:16 pm EST

    Hello,


    This is by design. In version 1, each sheet in a workbook was treated as a separate calculation unit (with each sheet having its own collection of custom names and its own collection of custom functions).  We got some complaints because this behavior was different from the behavior found in Excel.


    In version 2, we added an EnableCrossSheetReference property.  When EnableCrossSheetReference = True, all sheets in a workbook work together as a single calculation unit (with all sheets sharing a single collection of custom names and a single collection of custom functions).  This provides behavior that more closely matches Excel.  When EnableCrossSheetRefernce = False, you get the behavior found in version 1.  By default EnableCrossSheetRerence = True.

  • Replied 8 September 2017, 1:16 pm EST

    Thanks Scott, that makes perfect sense; just wanted to be sure that I could rely on seeing all custom names from any sheet.


     

Need extra support?

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

Learn More

Forum Channels