Open external file from LibreOffice with OpenOffice

[gp75]

Good evening, I need to open an .ods file from libreoffice with openoffice, I tried this way, but it doesn't work from libreoffice, from openoffice it works.
Same thing if from libreoffice I want to open a file with libreoffice. From openoffice to openoffice ok. from libreoffice to libreoffice ok, but I need it from libreoffice to openoffice.

Code: Select all

Sub ExampleShell
  Shell("C:\Program Files (x86)\OpenOffice 4\program\scalc.exe", 2, "C:\Users\Gp\Desktop\example.ods")
End Sub

[Zizi64]

but I need it from libreoffice to openoffice.

Why you need it? It is not a ggod idea to edit a document with different editor. The LibreOffice has a few new feature that will be embedded into the ODF documents, and - maybe - the AOO can not handle them. For example the "more than three conditions" for the conditional format function.

[gp75]

Thanks for the answer, let me explain better, I created a database with libreoffice full of macros that with openoffice some do not work (e.g. data fields ect) from this database I need to open and process a calc file full of different formulas and macros created years ago, if i open it with libreoffice many features go into error like obsolete macros and formulas. i should convert everything.

[Zizi64]

Please upload an ODF type sample file with the embedded macros.

[musikai]

Good evening, I need to open an .ods file from libreoffice with openoffice, I tried this way, but it doesn't work from libreoffice, from openoffice it works.
Same thing if from libreoffice I want to open a file with libreoffice. From openoffice to openoffice ok. from libreoffice to libreoffice ok, but I need it from libreoffice to openoffice.

Code: Select all

Sub ExampleShell
  Shell("C:\Program Files (x86)\OpenOffice 4\program\scalc.exe", 2, "C:\Users\Gp\Desktop\example.ods")
End Sub

I think you can't have LibreOffice and OpenOffice running at the same time. (even without code)

[RoryOF]

I think you can't have LibreOffice and OpenOffice running at the same time. (even without code)

I understand that it is possible: perhaps Villeroy will remind us how this can be done.

[musikai]

I just checked on Windows 7 32bit.
I have LO regular install and OO portable:
1.LO open, then start OO not possible.
2.OO open, then start LO is possible.

Or LO portable and OO portable:
In both directions not possible.

[robleyd]

Doesn't seem to be a problem running both simultaneously in my flavour of Linux.

[RoryOF]

If I remember correctly, the problem was with the installation of the desktop-integration: it complained that one file was already in use by the other and couldn't install its own version of that file. I think there will have to be, possibly setup manually, two sets of menu items, each set pointing to one or other of the versions.

[gp75]

I think you can't have LibreOffice and OpenOffice running at the same time. (even without code)

Without code works

Please upload an ODF type sample file with the embedded macros.

The file is complex I can't attach it, however I can convert macros, the problem is that it would take me a long time.

Doesn't seem to be a problem running both simultaneously in my flavour of Linux.

lo_aoo_together.png

Did you use the macro that I posted at the beginning?


thank you

[robleyd]

No - I just suggest that both AOO and LO can be run together in my environment at least.