Formulas should be allowed to reference values in other Sheet objects. The syntax should be =TableName!A1. This requires a global object that has access to all Sheet (or Lightsheet?) objects in the environment, which we've referred to as SheetHolder in previous discussions. Cell formula resolving may need to be moved to the scope of the new object (right now ExpressionHandler is initialized by Sheet).
Formulas should be allowed to reference values in other
Sheetobjects. The syntax should be=TableName!A1. This requires a global object that has access to allSheet(orLightsheet?) objects in the environment, which we've referred to asSheetHolderin previous discussions. Cell formula resolving may need to be moved to the scope of the new object (right nowExpressionHandleris initialized bySheet).