[SOLVED] Bugs. Apostrophe. Error working with sheet names in formula lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- veb86 · 2024-07-17 08:01 In my calculator I use special names. which begin with <> characters. When writing a formula when the link goes to the name of a sheet with a special name, the name of the sheet is taken as an apostrophe. When performing calculations, I change the name of the sheet, but do not remove the apostrophes. An error occurs in this formula when the library is running. The error occurs in places where there is a range, where just a cell reference is fine. For my part, I can solve the problem of apostrophes or most likely change the special character. But this will not solve the bug in the library. 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     b.Options := [boReadFormulas];    b.ReadFromFile('d:\test1\5.xlsx', sfOOXML);    sh := b.GetFirstWorksheet;      sh.WriteFormula(3,5,Strin gReplace(sh.ReadFormulaAsString(sh.GetCell(2,5)), '', 'BD', [rfReplaceAll, rfIgnoreCase]));    b.WriteToFile('d:\test1\555111111.xlsx', sfOOXML, true);   Сell(3,5) contains an error The apostrophe works fine when there is a reference to one cell. Then I think it should work fine with the range ---------------------------------------------------------------------- wp · 2024-07-17 15:58 Removed second quoting of worksheet names containing forbidden characters. ---------------------------------------------------------------------- veb86 · 2024-07-18 05:34 Everything works perfectly