DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

[Victorio]

Hi Roger,

Is it very difficult modify DC_Workarea2Excel to create xls /xlsx documents with Libre Office ?
Some of my clients go out from MS Off to free Libreoffice, and now I can not use this function.

Victorio

Note :
I found alternate solution, only export DBF, and then open DBF in LibreOffice with
scalc.exe -o test.dbf
Only here I can not change headers to own names , scalc show database field names.
With DC_WorkArea2excel there works fine also with own field names.

[Tom]

Just save (a copy of) your table with ".xls" as extension. LibreOffice (and all other office suites that support xls) will open the DBF like if it is an excel worksheet.

DC_WorkArea2Excel uses the Active-X-component of Excel. As far as I know, the component in LO was different - anyway, they removed it in early 2017.

[Victorio]

Tom : this mean, that Activex component not work in actual version of Libreoffice ?
yes I can use direct DBF, but can not change headers for show table, and also other usualy function as fit fields .
thx

[rdonnay]

I suggest that you use DC_WorkArea2Csv().

CSV files can be read by Excel and many other spreadsheet programs.

[Victorio]

csv can be good idea, i must try it.