คุณสมบัติ UseSharedFormulas SaveAs คืนค่าหรือตั้งค่าว่า =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.)
ไวยากรณ์
property UseSharedFormulas: Boolean;
ตัวอย่าง
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
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
ตัวอย่าง
This example opts a workbook into shared-formula emission before saving as a BIFF8 .xls file
Workbook.UseSharedFormulas := True;
Workbook.SaveAs('Report.xls', xlExcel97);