Re: [libreoffice-users] MS Office ole automation

Hi,

thank you all for reaction. I see that this is not a trivial problem - 
we will search further.

best
Milos

Dňa 2013-12-11 15:07, Paul wrote / napísal(a):
> Hi,
>
> The OP said the system uses OLE automation, which requires MSO to be
> installed to work. Even though the created files can be imported into
> LO, I gather the OP wants to remove the dependency on MSO completely.
>
> As far as I know, this won't be possible at all; some sort of
> workaround will be required. It's been a while since I last looked at
> OLE and COM, and I can't remember all the differences between them, but
> I understand that the relevant OLE components (are they servers, like
> with COM? I forget.) are installed with MSO, and while LO may provide
> equivalents, I highly doubt they will be registered under the same
> names. Without the vendor agreeing to change the application, if this
> bit of code runs without MSO being installed it will produce errors.
>
> If it is possible to not run this code, it may be possible to make an
> alternate arrangement, like exporting the data from the database
> directly into csv, or some such arrangement.
>
> There might be ways to work around the problem, but you'd need to know
> a bit more about the system as a whole.
>
> Paul
>
>
>
> On Wed, 11 Dec 2013 08:38:07 -0500
> Jay Lozier <jslozier@gmail.com> wrote:
>
> > On 12/11/2013 06:56 AM, Milos Sramek wrote:
> > > Hi,
> > >
> > > a friend of mine has asked me for help. Their (small) company would
> > > like to get rid of dependency on Microsoft tools. The situation is:
> > > They have a company information system, which every now and then
> > > generates a spreadsheet table, which lands in MS Excel on some
> > > computer. For this MS Office ole automation is used. He has asked
> > > me, if it is somehow possible to redirect this to LibreOffice.
> > > Vendor if the information system has refused to support something
> > > like that (a small company fully dependent on MS).
> > >
> > > Is this somehow possible? Does anybody have experience with it?
> > >
> > > thanks
> > > Milos
> > Milos,
> >
> > I have a few of questions:
> >
> > What is the backend of the information system? There almost always is
> > a database present. Maybe it could configured to save the data in
> > another format - most likely csv/tsv. If you are very lucky it may
> > support export to ods.
> >
> > What Excel format are they using? If xls (most likely), directly
> > importing into Calc maybe the easiest solution. If the xlsx, it will
> > probably work but there are reports that xlsx files are more
> > problematic.
> >
> > How complex is the spreadsheet? If it is basically a data with at
> > most a few formulas and no outside links or internal links between
> > sheets then importing into Calc will be much less troublesome. I
> > doubt this is true.
> >
> > Are there any macros in the Excel spreadsheet? Though I doubt any are
> > present, this would be one area that would make using Calc very
> > difficult.
> >
> > Thinking about your question, I would install LO and try opening
> > several of the spreadsheets and see if problems occur. Calc does a
> > very good job of opening MSO formats.


--
email & jabber: sramek.milos@gmail.com


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted