DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

This forum is for eXpress++ general support.
Post Reply
Message
Author
Victorio
Posts: 620
Joined: Sun Jan 18, 2015 11:43 am
Location: Slovakia

DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

#1 Post by 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.

User avatar
Tom
Posts: 1165
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

#2 Post by 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.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

Victorio
Posts: 620
Joined: Sun Jan 18, 2015 11:43 am
Location: Slovakia

Re: DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

#3 Post by 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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

#4 Post by rdonnay »

I suggest that you use DC_WorkArea2Csv().

CSV files can be read by Excel and many other spreadsheet programs.
The eXpress train is coming - and it has more cars.

Victorio
Posts: 620
Joined: Sun Jan 18, 2015 11:43 am
Location: Slovakia

Re: DC_Workarea2Excel -> DC_Workarea2LibreOffice ?

#5 Post by Victorio »

csv can be good idea, i must try it.

Post Reply