topic qlik and openoffice in QlikView

qlik and openoffice

Wed, 22 Apr 2009 04:28:12 GMT

is it possible to use openoffice suite instead of office one, maintaining the same Qlik functionalities vs excel?

if yes, how?

thanks

qlik and openoffice

rwunderlich — Wed, 22 Apr 2009 05:23:17 GMT

The Export to Excel functions will work with OO as long as the *.xls file association is mapped to scalc.exe.

Macro scripts that actually manipulate the Excel object (which you may have seen on this forum) will not work without modification. OO uses a different API than Excel.

Bottom line: Native QV Excel functions will work with OO, custom macro code may not.

-ROb

qlik and openoffice

fedcas — Fri, 08 Oct 2010 11:57:11 GMT

Hi,

And the integration with powerpoint, is it possible also with Presentation?

qlik and openoffice

fedcas — Fri, 08 Oct 2010 12:00:06 GMT

Sorry not Presentation but Impress

qlik and openoffice

rwunderlich — Mon, 18 Oct 2010 19:39:27 GMT

Do you mean the drag and drop integration? I just tried it and it doesn't appear to work, but I didn't dig very deep. Perhaps someone else knows the answer.

-Rob

qlik and openoffice

Mon, 18 Oct 2010 20:28:34 GMT

All,

I don't have the "official" answer, but I know that OpenOffice is not a Microsoft product, so it does not take advantage of the OCX and integration APIs that Microsoft products have with QlikView...I'm fairly certain the drag and drop capability will not work.

qlik and openoffice

Fri, 02 Dec 2011 17:38:40 GMT

Hi, to export by macro a table/pivot to an openoffice/libreoffice calc i have used the usual vb script:"obj.ExportBiff "C:\.."" that use the microsoft excel dll.

So to have the same dll i have tried to install microsoft ExcelViewer (that it's license free) and so the macro works perfectly. After you can also open the file.xls in a open calc program as usual..

Hope to help you