SpreadsheetGear 2009 uses workbook sets to group one or more workbooks. Workbook sets may be created directly with GetWorkbookSet and used to create, read, modify, calculate and write Microsoft Excel 97-2007 workbooks without Excel and without any GUI. Typically, each workbook view creates its own workbook set automatically.
Workbook sets created with Factory.GetWorkbookSet or Factory.GetWorkbook use the US English CultureInfo by default. To specify the CultureInfo, use one of the Factory.GetWorkbookSet or Factory.GetWorkbook methods which takes a CultureInfo as a parameter. Workbook sets created by the WorkbookView control create a workbook set using System.Windows.Forms.Application.CurrentCulture.
For external cell references to work between multiple workbooks, the workbooks must be loaded into the same workbook set.