Why there is no formula for opening a file

[dodgex]

  try
    sWorkbook := TsWorkbook.Create;
    sWorkbook.ReadFromFile(decPath);
    sWorksheet := sWorkbook.GetWorksheetByIndex(0);

    // do somethings......
   
    sWorkbook.WriteToFile(decPath, True);
    LCLIntf.OpenDocument( decPath );
  finally
    sWorkbook.free;
  end;

After writing data to excel, the original formula set in “ sWorkbook.WriteToFile(decPath, True)” will disappear；why??

[wp]

Since fpspreadsheet does not support all formulas to be found in spreadsheet files, reading of formulas is turned off by default. In order to activate it, add boReadFormulas to the workbook options before reading (and probably also boAutoCalc to automatically update calculated cells when cell content changes).

Code: Pascal  [Select][+][-]

1.   sWorkbook := TsWorkbook.Create;
2.   sWorkbook.Options := sWorkbook.Options + [boReadFormulas, boAutoCalc];
3.   sWorkbook.ReadFromFile(decPath);
4.   ...

[dodgex]

Since fpspreadsheet does not support all formulas to be found in spreadsheet files, reading of formulas is turned off by default. In order to activate it, add boReadFormulas to the workbook options before reading (and probably also boAutoCalc to automatically update calculated cells when cell content changes).

Code: Pascal  [Select][+][-]

1.   sWorkbook := TsWorkbook.Create;
2.   sWorkbook.Options := sWorkbook.Options + [boReadFormulas, boAutoCalc];
3.   sWorkbook.ReadFromFile(decPath);
4.   ...

Thank you！！
I have another question to consult. I have set zero values not to be displayed in the EXCEL template. Why does this setting disappear when I open EXCEL