Hi Milos, We basicly had the same problem. We still have a MS licence on our servers, but most of the workstations have LO installed.
Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com Watch our company movies on www.tvh.tv On 12 December 2013 15:30, Milos Sramek <[email protected]> wrote: > 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 <[email protected]> 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: [email protected] > > > > -- > To unsubscribe e-mail to: [email protected] > 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 -- **** DISCLAIMER **** http://www.tvh.com/newen2/emaildisclaimer/default.html "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- To unsubscribe e-mail to: [email protected] 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
