Go Back   Team-BHP > Around the Corner > Shifting gears > Gadgets, Computers & Software


Reply
 
Thread Tools Search this Thread
Old 2nd August 2015, 18:30   #1
Distinguished - BHPian
 
sgiitk's Avatar
 
Join Date: Dec 2007
Location: Kanpur
Posts: 7,042
Thanked: 3,586 Times
Default Experience with LibreOffice or Open Office?

I am thinking from switching from Microsoft Office to LibreOffice. Any experience (I guess the Linux aficionados are using it a lot), esp as compared to MS Office. I guess file compatibility will be near total.
sgiitk is offline   Reply With Quote
Old 2nd August 2015, 18:40   #2
Team-BHP Support
 
tsk1979's Avatar
 
Join Date: Feb 2005
Location: New Delhi
Posts: 22,851
Thanked: 15,406 Times
Default re: Experience with LibreOffice or Open Office?

Quote:
Originally Posted by sgiitk View Post
I am thinking from switching from Microsoft Office to LibreOffice. Any experience (I guess the Linux aficionados are using it a lot), esp as compared to MS Office. I guess file compatibility will be near total.
File compatibility is almost perfect. The things where I have seen issues are

1. Latest powerpoint presentations, esp with animation and funky stuff
2. EXCEL spreadsheets with complex macros and graphs
3. In word documents, the formatting changes. So a 20 page document may become 21 page.
tsk1979 is offline   Reply With Quote
Old 2nd August 2015, 20:48   #3
Distinguished - BHPian
 
sgiitk's Avatar
 
Join Date: Dec 2007
Location: Kanpur
Posts: 7,042
Thanked: 3,586 Times
Default re: Experience with LibreOffice or Open Office?

Quote:
Originally Posted by tsk1979 View Post
File compatibility is almost perfect. The things where I have seen issues are

1. Latest powerpoint presentations, esp with animation and funky stuff
2. EXCEL spreadsheets with complex macros and graphs
3. In word documents, the formatting changes. So a 20 page document may become 21 page.
Thanks for the encouragement:
1. I rarely do ppt now, after retirement. Even earlier I used to keep them simple.
2. I do not use embedded graphs or write macros. In fact I do not know how to write macros! I hope it can handle Income Tax forms. In the worst case I can go to the Java format. In any case ITR4 (needed for my son) is only in Java. The rest of us are on ITR2A or ITR2.
3. Pretty normal issue. Such things happen if there are printer changes as well. One has to check in any case to ensure proper page breaks. Maybe minor font variations.
Incidentally, I have switched to Garamond from Times (New) Roman as my default font, as it being lighter, is supposed to save about 10-15% toner.

Last edited by sgiitk : 2nd August 2015 at 20:49.
sgiitk is offline   Reply With Quote
Old 2nd August 2015, 22:09   #4
Team-BHP Support
 
tsk1979's Avatar
 
Join Date: Feb 2005
Location: New Delhi
Posts: 22,851
Thanked: 15,406 Times
Default re: Experience with LibreOffice or Open Office?

Quote:
Originally Posted by sgiitk View Post
Thanks for the encouragement:

2. I do not use embedded graphs or write macros. In fact I do not know how to write macros! I hope it can handle Income Tax forms. In the worst case I can go to the Java format. In any case ITR4 (needed for my son) is only in Java. The rest of us are on ITR2A or ITR2.
IT cannot handle ITR forms. That I am sure. You have to do Java
tsk1979 is offline   Reply With Quote
Old 2nd August 2015, 22:10   #5
BHPian
 
sephiroth's Avatar
 
Join Date: Jul 2015
Location: Thane
Posts: 30
Thanked: 26 Times
Default re: Experience with LibreOffice or Open Office?

Quote:
Originally Posted by sgiitk View Post
I am thinking from switching from Microsoft Office to LibreOffice. Any experience (I guess the Linux aficionados are using it a lot), esp as compared to MS Office. I guess file compatibility will be near total.
Apart from the already mentioned points regarding macros and formatting, I also found some formulas non-compliant. As in some formulas created in a spreadsheet in MS Office may not necessarily work in Libre Office.

Quote:
Originally Posted by sgiitk View Post
I do not use embedded graphs or write macros. In fact I do not know how to write macros! I hope it can handle Income Tax forms. In the worst case I can go to the Java format. In any case ITR4 (needed for my son) is only in Java. The rest of us are on ITR2A or ITR2.
Specific to ITR-2, I believe (unfortunately) you may still need to rely on MS Office. The IT forms come with macros which you need to enable to fill them up.
Some if not most government websites still presume the whole nation uses windows and internet explorer, and fail to provide 100% compliant software and websites for other platforms.


On a separte note, have you considered any web office counterparts (google docs etc)?

Pros:
- Auto-save.
- Access anywhere (requires internet)
- Protection from loss in case of hard drive failures.
- New features get auto-updates rather than you having to install patches or newer versions.
- I found the slides (power-point counterpart) more feature rich and convinient.

Cons:
- Requires internet almost always (I say always since offline edits are in the pipeline for most such suites)
- Copy+Paste of content is not the same (hyperlinks are not copied etc)
- A bit of a learning curve to get used to these.
sephiroth is offline   Reply With Quote
Old 3rd August 2015, 13:38   #6
Senior - BHPian
 
alpha1's Avatar
 
Join Date: Apr 2007
Location: P00NA
Posts: 1,613
Thanked: 949 Times
Default re: Experience with LibreOffice or Open Office?

I use Libreoffice at home on Windows as well as Ubuntu partitions.
I haven't faced any real issue except sometimes in case of macro laden files.
Need to check the IT returns file that you have spoken about now.
alpha1 is offline   Reply With Quote
Old 7th August 2015, 12:53   #7
BHPian
 
RocketRaccoon's Avatar
 
Join Date: Feb 2015
Location: Gurgaon, HR
Posts: 106
Thanked: 138 Times
Default Re: Experience with LibreOffice or Open Office?

Quote:
Originally Posted by sgiitk View Post
I am thinking from switching from Microsoft Office to LibreOffice. Any experience (I guess the Linux aficionados are using it a lot), esp as compared to MS Office. I guess file compatibility will be near total.
File compatibly is not an issue. You might face some issues with fonts and formatting if you use Linux as base installs usually don't have the MS fonts package (you can get them through your package management). If you are using Windows you wont face the above issue. Again, if you are using Windows and don't mind using the cloud for your needs why not give Google Drive a go ? It has most features that you would need for everyday use (unless you plan heavy spreadsheet use with macros etc) with extensive documentation, you can use scripts too and everything is linked to your Gmail so it's easy to share documents.
RocketRaccoon is offline   Reply With Quote
Old 7th August 2015, 14:01   #8
Senior - BHPian
 
abhibh's Avatar
 
Join Date: Sep 2005
Location: Back in the HOOD near you!
Posts: 2,767
Thanked: 33 Times
Default Re: Experience with LibreOffice or Open Office?

I have a paid version of Office 2007 and have been using it for years. Have shifted to OpenOffice and other alternatives while I was using Ubuntu.

IMHO if you already have a legit working copy of MS Office I don't really see the need to shift. The 2007 version works like charm on Windows 10, no issues whatsoever.
abhibh is offline   Reply With Quote
Old 7th August 2015, 14:51   #9
Distinguished - BHPian
 
phamilyman's Avatar
 
Join Date: Jul 2007
Location: Gurgaon
Posts: 5,581
Thanked: 3,242 Times
Default Re: Experience with LibreOffice or Open Office?

Quote:
Originally Posted by abhibh View Post
I have a paid version of Office 2007 and have been using it for years. Have shifted to OpenOffice and other alternatives while I was using Ubuntu.

IMHO if you already have a legit working copy of MS Office I don't really see the need to shift. The 2007 version works like charm on Windows 10, no issues whatsoever.
Agree with abhibh. I tried doing my relatives ITR on OO two years back and it just won't work.

The ITR2 excel have extensive ActiveX calculations which are optimized for 32 bit windows. It doesnt even work on Excel 2010 64 bit.

If things are working fine - DONT change it. IMNSHO Office is now super stable. New features post 2010 have added little value for the aam aadmi end user. If all you need to do is excel and little bit of documents, don't change! Don't fix what ain't broke.

Last edited by phamilyman : 7th August 2015 at 14:53.
phamilyman is offline   Reply With Quote
Old 7th August 2015, 20:12   #10
BHPian
 
Join Date: Apr 2014
Location: Kolkata
Posts: 287
Thanked: 436 Times
Default Re: Experience with LibreOffice or Open Office?

I have no experience with LibreOffice but tried several times to use OpenOffice (on which LibreOffice is based) at home during 2009-10 - the 'new' MS Office 2007 with the ribbon was not to my liking.

While it was ok for plain letters and notes, larger and more complex files such as appraisal reports, information memorandums and pleadings containing attachments, images, textboxes, different fonts etc. would invariably show up mis-formated when switching to MS Word and vice-versa. In professional terms it was unusable.

Given how complex and sophisticated MS Office has become I would not recommend any product based on OpenOffice as a viable substitute unless you work in isolation.
Kumar R is offline   Reply With Quote
Old 16th August 2015, 10:17   #11
Senior - BHPian
 
deepclutch's Avatar
 
Join Date: Oct 2008
Location: Muvattupuzha
Posts: 1,119
Thanked: 108 Times
Default Re: Experience with LibreOffice or Open Office?

Though my use of LibreOffice is minimum, my experience is slight mess up of font size/space and tables. There is Kingsoft Office/WPS-Office which is still in beta, but has good compatibility with MS Office. Besides, if you have a licensed MS Office copy, Wine with PlayOnLinux or Crossover can get Office installed fine.
deepclutch is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which home/office AC (air conditioner) to buy ? adityapd Gadgets, Computers & Software 5486 18th August 2017 19:54
My Experience with Office Transportation & Hospitalisation selfdrive Street Experiences 155 10th December 2016 20:59
BMW Experience Tour, 2015 - Registrations open! sarathlal The Indian Car Scene 2 26th June 2015 16:27
Open open open Sesame!! VJ_MAVRICK Shifting gears 12 10th January 2008 15:24


All times are GMT +5.5. The time now is 03:51.

Copyright 2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks