[Solved] Excel sheet position
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Jero · 2018-12-30 16:57

Hello,
When I open (with Excel) a sheet created with fpspreadsheet,
Excel display the end of the sheet (empty cell)

Is there a way to open the sheet directly on the first cells?

Thanks for your help.

----------------------------------------------------------------------
wp · 2018-12-30 18:41

I don't know how you write the file, but fpspreadsheet by default does
not move the active cell. The workbook created by the following code
is opened by Excel on the first cell of the first sheet:
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 program
Project1; uses  fpspreadsheet, fpstypes, fpsallformats; var  b:
TsWorkbook;  sh: TsWorksheet;begin  b := TsWorkbook.Create;  try    sh
:= b.AddWorksheet('Page 1');    sh.WriteNumber(0, 0, 1.0);   
sh.WriteUTF8Text(1, 3, 'abc');     sh := b.AddWorksheet('Page 2');   
sh.WriteNumber (1, 1, 2.0);    sh.WriteFormula(2, 1, '=B2*2');   
sh.WriteFormula(3, 1, '=Sum(B1:B3)');     b.WriteToFile('test.xls',
sfExcel8, true);  finally    b.Free;  end; end.

----------------------------------------------------------------------
Jero · 2018-12-31 06:30

Strange, a new installation of fpspreadsheet and it's OK!
Thank's