Why there is no formula for opening a file lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- dodgex · 2026-01-09 08:33 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 · 2026-01-09 09:23 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][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i   sWorkbook := TsWorkbook.Create;  sWorkbook.Options := sWorkbook.Options + [boReadFormulas, boAutoCalc];  sWorkbook.ReadFromFile(decPath);  ... ---------------------------------------------------------------------- dodgex · 2026-01-12 01:56 Quote from: wp on January 09, 2026, 10:23:59 amSince 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][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i   sWorkbook := TsWorkbook.Create;  sWorkbook.Options := sWorkbook.Options + [boReadFormulas, boAutoCalc];  sWorkbook.ReadFromFile(decPath);  ... 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