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.
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.
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.
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.
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..
