How to set a number format for WriteNumber(...) and WriteFormula(...)?
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Jvan · 2021-05-06 22:56

Please, how to do it?

I'm using formulas to sum these numbers too.


Thanks.

----------------------------------------------------------------------
wp · 2021-05-07 08:40

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, fpsutils,
fpsopendocument;var  wb: TsWorkbook;  sh: TsWorksheet;begin  wb :=
TsWorkbook.Create;  try    wb.Options := [boAutoCalc];    sh :=
wb.AddWorksheet('Test');    sh.WriteNumber(0, 0, 2.345678, nfFixed,
3);      // cell A1: 3 decimals    sh.WriteNumber(1, 0, 5349.342863,
nfFixedTh, 3); // cell A2: 3 decimals with thousand separator   
sh.WriteNumber(2, 0, -2.345678, nfCustom, '0.000;(0.000)');  // cell
A3: negative value in parenthesis    sh.Writeformula(3, 0,
'sum(A1:A3)');    sh.WriteNumberFormat(3, 0, nfFixedTh, 3);        //
Format for formula cell: 3 decimals with th.sep.   
wb.WriteToFile('test.ods', true);  finally    wb.Free;  end;end.

----------------------------------------------------------------------
Jvan · 2021-05-07 19:51

Thanks.