It was not marked as a regression, nor a most-annoying bug. After seeing this – I noticed an existing bug for this: which (sadly) was incorrectly categorised. Hi there – thanks for your interesting blog if you have an issue like this it is almost always best to file a bug in bugzilla: so the issue can be sorted out. I’m afraid my employer needs are squared directly over MS Excel compatibility vs. I think that OpenOffice might have had a greater focus on MS Office document compatibility, while LibreOffice has focused on advancing features. Update: Here is discussion where LibreOffice users have known and tried work-arounds for the past six months. There is nothing stopping people from using both office suites when necessary to see which better renders specific documents.
And the bright side is that Apache OpenOffice is both still open source, and still free. I’d rather point to a LibreOffice victory, but the open source community has to acknowledge failures for them to be fixed. So in this case, the solution is to use OpenOffice. In this case, that is an insane waste of time, as there are hundreds of comments showing, poking through the hidden columns. The only solution I’ve found in LibreOffice discussions is to manually close each one. LibreOffice is making all comments visible by default. However, LibreOffice has a bug that has persisted for many months, whereas OpenOffice just works. I can open up this Excel document in either OpenOffice 3.4.1 or LibreOffice 3.6.1, and both are able to successfully hide the large number of columns I need hidden where Excel fails itself. I’ve spent some effort looking for a solution, but the only thing I found to work is opening in an open source office suite.
I need to hide 130 columns and Excel 2010 warns me “Cannot shift objects off sheet.” Prior Excel versions had the same problem. The surprising part is that MS Excel fails my needs even with working with its own. It is very complex to the point it would be better off in a database, but that’s beyond the scope of this post. So sadly, no one here contemplates a change from MS Office. My employer briefly flirted with OpenOffice around 2005, and supposedly it was really bad experiment, but I wasn’t there at the time. (3) It is more rapidly developing and releasing updates.īut at the same time, when I try to use them in a hard-core power user work environment, ideals go out the window and I use what works to keep my job. If you are like me, you prefer LibreOffice over (Apache) OpenOffice because (1) It has a better open source license. OpenOffice, Not Always Simple Octoat 4:02 pm | Posted in Operating Systems, Technology | 44 Comments
0 kommentar(er)
