WriteText on fpspreadsheet lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- AG · 2015-09-14 11:52 Hello, I have been having trouble sending string data to the spreadsheet. i used for example the example in the FSP help webpate (http://wiki.freepascal.org/FPSpreadsheet) but it gives me the error: identifier Idents no member "WriteText". WriteNumber and all other commands work without problem. Any idea what the problem can be? i copied the following code exactly to test it, also added the package as a requirement and called the uses as in the example. This is the code: { excel5demo.dpr Demonstrates how to write an Excel 5.x file using the fpspreadsheet library You can change the output format by changing the OUTPUT_FORMAT constant AUTHORS: Felipe Monteiro de Carvalho } program excel5demo; {$mode delphi}{$H+} uses   Classes, SysUtils, fpstypes, fpspreadsheet, fpsallformats, laz_fpspreadsheet; const   OUTPUT_FORMAT = sfExcel5; var   MyWorkbook: TsWorkbook;   MyWorksheet: TsWorksheet;   MyFormula: TsRPNFormula;   MyDir: string; begin   // Initialization   MyDir := ExtractFilePath(ParamStr(0));   // Create the spreadsheet   MyWorkbook := TsWorkbook.Create;   try     MyWorksheet := MyWorkbook.AddWorksheet('My Worksheet');     // Write some number cells     MyWorksheet.WriteNumber(0, 0, 1.0);     MyWorksheet.WriteNumber(0, 1, 2.0);     MyWorksheet.WriteNumber(0, 2, 3.0);     MyWorksheet.WriteNumber(0, 3, 4.0);     // Write the formula E1 = A1 + B1     MyWorksheet.WriteFormula(0, 4, 'A1+B1');     // Creates a new worksheet     MyWorksheet := MyWorkbook.AddWorksheet('My Worksheet 2');     // Write some string cells     MyWorksheet.WriteText(0, 0, 'First');     MyWorksheet.WriteText(0, 1, 'Second');     MyWorksheet.WriteText(0, 2, 'Third');     MyWorksheet.WriteText(0, 3, 'Fourth');     // Save the spreadsheet to a file     MyWorkbook.WriteToFile(MyDir + 'test' + STR_EXCEL_EXTENSION, OUTPUT_FORMAT);   finally     MyWorkbook.Free;   end; end Does anybody see what i'm missing? ---------------------------------------------------------------------- Leledumbo · 2015-09-14 12:39 Quote from: AG on September 14, 2015, 01:52:03 pmDoes anybody see what i'm missing? You're using an old version. I just updated mine to trunk and the example compiles just fine. ---------------------------------------------------------------------- ffabio · 2015-09-14 13:12 Hello everyone I am using the component fpspreadsheet to read a file to open office. If the file there are images they are loaded into Lazarus and when I save the file nn I find more '. Someone can help me ??? thanks a lot .. ---------------------------------------------------------------------- wp · 2015-09-15 17:19 @AG: I try to keep the wiki up-to-date with the current trunk version of the library. If you are using an old version refer to the historical wiki version (http://wiki.lazarus.freepascal.org/FPSpreadsh eet#Wiki_documentation_of_old_releases); starting with fpspreadsheet v1.6 an offline version of the wiki is included in the package. @ffabio: No, fpspreadsheet ignores embedded images. I had begun reading documentation for biff, but images seem to be a mess...