! The visual name of a worksheet (tab set) can be set with: Spreadsheet.XSSSheet.Tabs.Texts[0] := 'MySheet';
You must also update the XLS object when changing sheet name: Spreadsheet.XLS[0].Name := 'MySheet';
! Spreadsheet is recalculated when cells that formulas are dependent of are changed.
! Numbers can be inserted as text (in the inplace editor) if prefixed by single quote.