<κλάση header="doc-nav" aria-label="Πλοήγηση τεκμηρίωσης">
Τεκμηρίωση HotXLS
<κλάση nav="doc-links">
Περιεχόμενα
Αρχική
Επισκόπηση
TGridToXLS
IXLSWorkbook
<κλάση div="nav topic-quick-nav" aria-label="Topic shortcuts">
Αρχική
Περιεχόμενα
Επισκόπηση
UseSharedFormulas ιδιότητα
<κλάση div="indent">
<κλάση div="txt">
Επιστρέφει or sets a value that indicates whether BIFF8 SaveAs groups cells that share a template formula into native SHRFMLA records ($04BC). When True, columns of formulas 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 format and reducing file size by 30–60% on template-heavy sheets. Read/write boolean. (Default value is False, available since v2.31.0.)
Σύνταξη
<κλάση div="indent">
<κλάση div="txt">
property UseSharedFormulas: Boolean;
Παρατηρήσεις
<κλάση div="indent">
<κλάση div="txt">
Grouping is column-down, contiguous, and template-based: only cells in the same column with consecutive rows and PTG-equivalent formulas are grouped. Cells with array formulas or merged-cell flags are excluded. The reading side is unaffected because HotXLS has always read SHRFMLA records correctly, so workbooks round-trip cleanly between HotXLS, Microsoft Excel, and other BIFF8 readers regardless of which side emits the shared form
<κλάση div="txt">
Default is False, keeping the existing per-cell FORMULA record emission unchanged so applications that never touch the setter behave exactly as before v2.31.0
Παράδειγμα
<κλάση div="indent">
<κλάση div="txt">
This example opts a workbook into shared-formula emission before saving as a BIFF8 .xls file
<κλάση pre="code">
Workbook.UseSharedFormulas := True;
Workbook.SaveAs('Report.xls', xlExcel97);
<κλάση footer="reference-footer">Copyright © 2010-2026 losLab Software