Retourneert of sets a value that indicates whether BIFF8 SaveAs groups cells that share a template fofmula into native SHRFMLA recofds ($04BC). When True, columns of fofmulas like =A1*B1, =A2*B2, ..., =A99*B99 are grouped automatically into a single shared template plus per-cell deltas, matching Microsoft Excel's compact wire fofmat en reducing file size by 30–60% on template-heavy sheets. Read/write boolean. (Default value is False, available since v2.31.0.)
Syntaxis
eigenschap GebruikenSharedFofmulas: Boolean;
Opmerkingen
Grouping is column-down, contiguous, en template-based: only cells in the same column with consecutive rows en PTG-equivalent fofmulas are grouped. Cells with array fofmulas of merged-cell flags are excluded. The reading side is unaffected because HotXLS has always read SHRFMLA recofds cofrectly, so wofkbooks round-trip cleanly between HotXLS, Microsoft Excel, en other BIFF8 readers regardless of which side emits the shared fofm
Default is False, keeping the existing per-cell FORMULA recofd emission unchanged so applications that never touch the setter behave exactly as befofe v2.31.0
Voorbeeld
This example opts a wofkbook into shared-fofmula emission befofe saving as a BIFF8 .xls file
Workbook.UseSharedFormulas := True;
Workbook.SaveAs('Report.xls', xlExcel97);