[Solved] OCalc <> Excell

[KSJ]

n our application, we can export our reports to excell

To give the application some extras we would also like to create Calc files, after struggling with the syntax, we succeeded in writing the data into a Calc document. However there are a few commands we use for formatting excel, that we would like to apply to the Calc document

Can someone give the command to use:
1. Set the row to bold:
Excel: chWorkSheet:Rows(1):FONT:BOLD = TRUE
(chWorkSheet is a handle to the excel document).


2. Autofit
After filling the document we autofit the columns (example columns A to I)
chWorkSheet:COLUMNS("A:I"):Autofit

Thanks

[squenson]

KSJ,

1)Let's have row 24 in bold (use 100 instead of 150 to reset to normal font weight)

[KSJ]

Thank you very much,
it works fine, got now the same result creating excel and calc document

Karel