LibreOffice 3.5 Released 205
First time accepted submitter wrldwzrd89 writes "The Document Foundation, the team behind the free and open-source office suite called LibreOffice, has released their latest and greatest version. As is typical with major releases of LibreOffice, there are significant new features making their debut in this version. The component with the biggest upgrade is Calc, which now has support for up to 10,000 sheets per workbook among its new features. Also noteworthy among the new features is support for importing Microsoft Visio files in Impress and Draw. The full feature list is available in a PDF hosted on Dropbox; LibreOffice itself can be downloaded here."
10000 sheets per workbook? (Score:5, Funny)
Re: (Score:2)
Haha, yeah.. had the same thought.
Was like when wikipedia came out saying the reason they were losing contributors was the editing interface was too complicated.
Although I have seen some terrifying excel workbooks .. maybe there are some corporations on the fence about open source, and the ability to have their entire employee management system contained in a spreadsheet was a sticking point.
Re:10000 sheets per workbook? (Score:5, Insightful)
I guess it's time for me to repeat my rant about people using spreadsheets to do work which properly belongs in a database.
It's really impossible to properly audit or verify a spreadsheet. They are so easy to corrupt with improper references and random data entry. Spreadsheets are only widespread because most office drones don't have a clue about proper data management. I shudder whenever I see someone using a spreadsheet to make important business decisions because I know there are errors in every non-trivial spreadsheet.
Re:10000 sheets per workbook? (Score:5, Insightful)
I think we see this use so prevalently because it’s quick and cheap. Most business-calculation type stuff revolves around taking tables of numbers, doing calculations, and producing other tables of numbers / graphs. Excel gives you most of that right out of the box. Throw in a little VBA and you can do in an hour what would take a month to do properly.
Even I’ll admit to using spreadsheets from time to time for things that really deserved a proper app.
Re: (Score:3)
Dude, I have seen people using Excel to write letters!
Re: (Score:3)
If all you know how to use is a hammer, then every problem looks like a nail.
Re:10000 sheets per workbook? (Score:5, Funny)
No kidding... I used to use a hammer to write letters, too. Then I learned how to use the nailgun. Bam!
Re: (Score:2)
Re: (Score:3)
It is free if you go into the post office still holding the nail gun. ;-)
Re: (Score:2)
Actually, it's several thousand dollars, and you have to mail it (well, not "it", but a maybe a postcard) from federal prison.
Re: (Score:2)
Re: (Score:2)
to be fair, I'd likely do the same thing. If only because I usually work in degrees and Excel thinks in radians, so I'd have to apply the correct conversion functions, something easy to do wrong.
Re: (Score:2)
Dude, I have seen people using Excel to write letters!
I've seen senior accountants use pocket calculators to sum columns of numbers in Excel.
Re: (Score:3)
Spreadsheets are only widespread because most office drones don't have a clue about proper data management. I shudder whenever I see someone using a spreadsheet to make important business decisions because I know there are errors in every non-trivial spreadsheet.
What do you define as non-trivial? I think a spreadsheet template which has been used a couple hundred times will have all but the most corner-case bugs worked out. As well, business decisions are made by humans, not machines. They rely on things not easily quantifible like customer service, past performance, future projections of costs, etc. Databases are also prone to data entry errors, design errors and the like. Just because you use a database does not mean it does not have to be tested throughly.
Re: (Score:3)
I agree that a spreadsheet which has been well used and tested will have most of the obvious bugs worked out of it. However, it can't really be shown to be free of errors in the same way database procedural logic can be tested. It is also easier to do proper data input checking on a database to avoid "loose nut behind the keyboard" problems. You are right, though, that you have to test everything. It's just much easier to do properly with a database.
Re: (Score:2)
Then you are the most at risk - you think the spreadsheet might actually yield reliable data when used by people who did not actually write it themselves.
While I don't say this is impossible, I have been known to bet on the lottery. The fact is that, unless you wrote the spreadsheet yourself (and often even then), its very hard to be sure what it is actually doing with your da
Re: (Score:2)
Blame the lack of easy use of Access.
I routinely wanted to share out a simple sheet, allowable for anyone to edit easily, but have always fallen flat on my face by the complexity of simple tasks.
Yes I'm a novice user, however like Excel, I can use Calc or any similar thing because the interface is similar and or easy to use. I cannot use a database and have people interface with it to updated it without having to create a form, create a web interface or other complex things which are beyond my ability.
Now,
Re:10000 sheets per workbook? (Score:5, Interesting)
Where I work, Access is forbidden. Not a copy in the corporation (8000 seats) except where they could not (yet) replace it with an Oracle app. The problem is that people muck up a user-controllable database in painful ways.
But full-blown corporate Oracle apps take this many hours of meetings of the user's time: 10 + analyst_hours * 0.2 + programmer_hours * 0.1.
That is, an app that takes four hours to explain to a programmer by the analyst and six hours for the programmer to write, test, debug and document, will take about 12 hours of meetings for the user. For a small database (say, two tables of information with several hundred records total, and a few more of column values containing 5-50 values each), that has 1-4 users, you will never, Never, NEVER reach the top of the "to do" pile.
So these needed apps pile up until somebody somewhat savvy person does something with a spreadsheet and maybe some VBA. I ended up doing our whole budget system ($200M spent per year, across about 230 line-items) with three Oracle tables hit on by an Excel pivot table and couple of spreadsheet pages that was a database entry forms in all but name.
It's in it's third year and we haven't lost any of the money yet.
Re: (Score:2)
It's really impossible to properly audit or verify a spreadsheet.
What you mean to say, surely, is that such tools are absent from popular shipping office software suites. In general, though, it's bloody damn easy to do change tracking on a an XML-based spreadsheet file format, at least as far as ODS format is concerned. You need to whip up some XSLT or use an XML parser and write a script using it, but calling it impossible is just silly.\
I do agree that pretty much all spreadsheet users don't have a clue about any of it because it's not exposed, thus may just as well n
Re: (Score:2)
Often there is sound business logic behind using (and abusing) spreadsheets where a database would be the technically better answer. Two cases come to mind immediately:
First, businesses often use spreadsheets to handle one-off situations where the cost of doing things properly by database cannot be justified. This works, if the strategy allows for the possibility of getting it wrong. A first estimate for the cost of taking on a job only needs to be close enough to decide whether it might be worthwhile to
Re:10000 sheets per workbook? (Score:5, Insightful)
Re: (Score:2)
Indeed.
Don't get me wrong, I agree wiki markup and the interface they built around it is just painful to use and needs to be cleaned up or completely replaced.. but I don't think it was driving people away (certainly not in any comparable way to the real problems).
Re: (Score:2)
Re:10000 sheets per workbook? (Score:4, Informative)
Re:10000 sheets per workbook? (Score:5, Informative)
Re: (Score:3)
Re: (Score:2)
10000 sheets per workbook? Yup, lack of sheets was exactly what was stopping me from using Calc.
Dang... And while I was waiting for 10,000 sheets my workbook has grown to 10,001 sheets...
New features (Score:5, Informative)
Visio .vsd import .msi Windows Installer - I understand that .msi is a big deal for corporate installs somehow.
Native PostgreSQL driver
Java 7 support
AES encryption
Anyway is it just me or is Libreoffice really really awesome. There seems like a tremendous amount of energy behind the project, and it's all headed in the right direction.
Re:New features (Score:4, Insightful)
Well, they're obviously moving much faster than openoffice did. The product looks very clean, opens fast, and is mostly enjoyable to use.
There's still a number of key combinations that Calc is missing (most noticeably ctrl-D to copy cell above), and the background color tool is still horribly designed (only contains colors too dark for use as a background, and it does not remember the last chosen color). It's simple stuff like this that keeps people on Excel.
Re:New features (Score:5, Insightful)
Open bugs with that feedback.
Re:New features (Score:4, Informative)
Open bugs with that feedback.
Done! Please subscribe to the bugs and leave comments so it is not just me saying "this would be nice".
Remember last background colour
https://bugs.freedesktop.org/show_bug.cgi?id=46069 [freedesktop.org]
Copy cell above
https://bugs.freedesktop.org/show_bug.cgi?id=46070 [freedesktop.org]
Re:New features (Score:5, Informative)
Many automation tools that push software out to hundreds/thousands of desktops at once only work with .msi files because you can do automated/silent installs. So yes, having a .msi installer is important in the enterprise world.
Re: (Score:3)
Some of the more flexible Deployment platforms can deploy just about anything, but a well designed MSI is far easier. That said I've come across many, many poorly designed MSIs, which are just as much hassle as anything else.
Re: (Score:3)
Yup, lack of sheets was exactly what was stopping me from using Calc.
This is a welcome addition, even if I've only needed the feature once ever; but recently. I'm implementing a new subsection for the office management software I wrote for a client. They have been storing all of their information for this new subsection in an Access database with 487 sheets. In order to get the data into PostgreSQL, I wanted to use Calc to load the database and then export it as tab-delimited text. Needless to say, that didn't work since LibreOffice didn't support enough sheets.
Worse, th
Re: (Score:2)
10000 sheets per workbook? Why some arbitrary high number? Why not 65535/6 or 4294967296 or 2^64 on 64-bit builds?
What exactly makes 10000 important?
Not that I've ever used more than 2 or 3 per file, but...
A. delete the contents of the cell - like it does (Score:2, Informative)
You've apparently not used LibreOffice, which actually gets this right - though certainly OpenOffice.org did not, backspace on the other hand pops up the dialog you hate ;-) c'est la vie.
DropBox? (Score:4, Insightful)
Re: (Score:3)
Particularly as those of us behind corporate firewalls can't get to Dropbox...
Re:DropBox? (Score:5, Informative)
http://www.libreoffice.org/download/3-5-new-features-and-fixes/ [libreoffice.org]
Re: (Score:2)
Thank you!
Re: (Score:3)
No problem. Can't imagine what the hell the submitter and editors were thinking. Business as usual for this place, I guess...
Re:DropBox? (Score:4, Funny)
Slashdot has a pretty thorough standards and practices manual, but it is unfortunately hosted on DropBox which is blocked on the Slashdot internal office network. No one's ever read it.
Re: (Score:2)
lmao
315ml (Score:4, Interesting)
importing Microsoft Visio files in Impress and Draw.
Somewhat off topic, but visio seems to be one of those killer apps for which there is still no decent open source solution.
There are a few options that kinda do what visio does (dia, kivio, umbrello etc..) but I’ve never seen anything that even comes close. It’s on of the list of things Microsoft did right (or more likely, whoever actually developed visio initially did right.. I seem to remember they bought it from someone).
And before anyone says “so go write one yourself” ... I actually tried (and failed). This isn’t an attack on the open source community, more just an interesting observation. Certain software just isn’t interesting enough and as such doesn’t seem to happen unless someone is being paid to write it.
Also... libreoffice is still a terrible name. Openoffice.org wasn’t great either.. but most people dropped the .org part and it sounded ok. “Libre” just doesn’t roll of the tongue well you feel like a tool saying it out loud. And "office" doesn't compliment it. The whole combination just doesn't work.
Re:315ml (Score:5, Interesting)
MS did buy Visio from someone else.. but they have also made alot of improvements over the years to it.
another missing open source solution is something to replace MS Project.
Re: (Score:2)
http://www.kde.org/applications/office/kplato/ [kde.org]
http://sourceforge.net/projects/openproj/ [sourceforge.net]
Re: (Score:2)
let me rephrase that.. MS Project + Project Server replacement
Re: (Score:3)
I recommend OpenProj: http://sourceforge.net/projects/openproj/ [sourceforge.net]
Re: (Score:2)
OpenProj is nice - the missing bit is the integration MS Project has with Project Server.
Re: (Score:2)
Due to licensing policies, I do not have Visio installed on my corporate desktop. I used in past for many purposes the OO Draw and I find it pretty OK for the diagrams and whatnot.
Many people also praise the Dia [dia-installer.de], though I have no personal experience with it. Specifically, several interns I knew actually complained that for the labs they needed to use the Visio, while Dia was much better tool for the job.
Re: (Score:2)
One missing feature is auto-save. Well, actually, the bug report was going to be "I clicked 'select colour' and the windows all just disappeared", or "i selected a shape, and the windows all just disappeared". Autosave might help until they sort that out :-)
Re: (Score:3)
Well, excel is also one, as is photoshop. Calc and GIMP make for very poor alternatives.
It's good to know that libreoffice folks are working on it though. One of the main reasons most companies cannot migrate off MS office is the fact that there is just no way to replace excel due to its superior functionality (and conversion problems).
10000 sheets per workbook? (Score:3, Funny)
Are those sheet double ply?
While, in the same time... (Score:4, Insightful)
Re:While, in the same time... (Score:5, Informative)
Libreoffice basically shed its skin and left openoffice behind in the dust.
The new features already put libreoffice ahead of openoffice, but I think the changes that were most significant were under the hood.
It has been going under a massive cleanup effort making it easier for new devs to contribute and for existing bugs to get squashed.
Re: (Score:2)
Maybe it has more future, but I've resorted to Kingsoft Office: http://www.kingsoftstore.com/kingsoft-office-freeware.html [kingsoftstore.com]
It doesn't have as many annoying bugs.
When I last tried LibreOffice, Writer was still very buggy and hung a lot for simple stuff like undoing after a step by step replace within selection (at least the step by step replace within selection finally works, it used to replace the entire selection with the replacement text! And that replace bug was present for years in OpenOffice, so yeah th
Re: (Score:2)
I've never heard of Kingsoft Office before. How is it?
I certainly hope it's better than it's website shows. http://www.kingsoftstore.com/windows/professional-office-difference.html [kingsoftstore.com]
That comparison is absolutely painful to read. The fact that they treat creating, viewing, editing, saving and printing to be separate and unique 'features' implies that the suite really doesn't do very much, so they have to pad their feature list with fluff to make it look good.
Not being able to make a title page or make adjus
Re: (Score:2)
OpenOffice.org is in version 3.3.0 and remarkably worse than LibreOffice. LibreOffice has way more future.
I agree, but I run OpenOffice Portable in Dropbox. LibreOffice is much larger, and OO does what I need it to.
How are the MS Office compatibilities? (Score:3)
Are they better than OpenOffice? I am waiting for LibreOffice to have better format compatibilities. V3.4.3 still didn't show my documents' formats correctly. :(
Visio import FTW (Score:5, Interesting)
Visio has long been one of the programs for which there is no satisfying substitute.
Is there a non-crossing line tool in Draw? :)
Re:Visio import FTW (Score:5, Interesting)
Visio has long been one of the programs for which there is no satisfying substitute.
Indeed. I run a windows VM just to use visio. There really is nothing decent out there (and use of dia for any length of time is bad for your sanity) that even comes close.
Re: (Score:2)
There's also OmniGraffle...
http://www.omnigroup.com/products/omnigraffle/ [omnigroup.com]
Re: (Score:2)
I didn't excplicitly say "open source" or "for linux" so that's fair.
For that matter, there's lots of proprietary options for windows and I assume mac. Just doesn't seem to be a decent open source one.
Probably like audocad.. making one is just such a pain in the ass, and not enough users want it, and can easily be run in a virtual machine when needed.. that we probably won't see a decent open source visio clone.
Re: (Score:2)
Try http://www.lucidchart.com/ [lucidchart.com]. Yeah, it's a webapp, but I've found it highly usable, and solves my diagramming needs. (In some cases much quicker and easier than Visio)
Re: (Score:2)
Kinda different areas of use...
If you are using visio for scientific modeling.. you have every right to be bitter!
Re: (Score:3)
Is there a non-crossing line tool in Draw? :)
I can't see one, but I've not used Draw before.
Inkscape has connectors, and a button to "Make connectors avoid selected objects". It works -- but I don't know if it would be reliable with real work (Visio, in my experience, isn't, and gets 90% of things OK, but then requires fiddly tuning to make a few odd connectors not overlap shapes).
Re: (Score:2)
Inkscape has connectors, and a button to "Make connectors avoid selected objects". It works -- but I don't know if it would be reliable with real work
As you say, since Visio isn't 100% either, it doesn't have to be perfect. If it's not suitable now it's an interface tweak away, most likely. I will give it a look, thank you.
Re: (Score:2)
Visio has long been one of the programs for which there is no satisfying substitute.
I don't know if it handles all of Visio's use-cases, but I've been using yEd Graph Editor [yworks.com] with great success for all my diagramming needs.
Re: (Score:2)
If it handles yours it almost certainly handles mine, I will check it out.
Re: (Score:3)
I beg to differ. I draw ALL my diagrams in gnome paint, and anyone who complains just doesn't understand art.
Unlike Mozilla... (Score:2)
As is typical with major releases of LibreOffice, there are significant new features making their debut in this version.
There's a Mozilla joke in there somewhere.
Anyone used its DB component? (Score:2)
Anyone used this suite's database component? Does it come anywhere near Microsoft's JET DB with the Access front end in functionality? I mean the ability to program "business logic" into the forms.
Re: (Score:2)
Unless it's moved on drastically from the days of OpenOffice.org, don't bother. Last time I checked, it was a third-rate clone of Access '97.
LibreOffice Base (Score:3)
Anyone used this suite's database component?
Daily. I actually use it as a middleware layer between our MRP database and some accounting functions I'm responsible for. I use ODBC to get at the tables and then do the actual analysis mostly in a spreadsheet with some custom queries in the Base part. It has worked extremely well, has been easy to use and hasn't cost us a penny in capital expenditures.
As a standalone database, I think Access is significantly better right now but as a way for your office suite to communicate with another database, Libre
Nicely done -- (Score:4, Interesting)
Of course, now we can expect to hear from all the naysayers who will predictably continue to declare LibreOffice a perpetual failure because they have some weird edge case of an MS Office document that didn't import perfectly...
Re: (Score:2)
Of course, now we can expect to hear from all the naysayers who will predictably continue to declare LibreOffice a perpetual failure because they have some weird edge case of an MS Office document that didn't import perfectly...
And if you do have such a document, then please get in contact with me so that we can file a bug and get it fixed:
http://dotancohen.com/eng/message.php [dotancohen.com]
Inability to print transparent layers in Draw (Score:2)
This bug was apparently introduced after 3.2 and is not present in later versions of open office. It's been several months and isn't fixed.
If you set shape to transparent, the drawing can be exported correctly to PDF but you can't print them- they become pointy-- the curviness of bezier curves is lost. This occurs on multiple printers and in both windows xp, windows 8, and at least some versions of Linux.
I would like to use Libreoffice but this is a non-starter. Looking forward to when it is fixed.
Re: (Score:2)
Have you filed a bug?
Re: (Score:2)
Yes with copious examples. I'm at work right now so I can't pull up the bug report.
But several others have reported it as well and provided examples.
Then it as flagged as having been entered before some change in procedures and so it had to be revalidated as real and the other users posted more examples.
It's reported under Draw. Think it may be in the 33000's but not sure.
Re: (Score:2)
That's all I needed to know. :)
-- your friendly bugtracker cop
Still no auto-update. (Score:3)
Re: (Score:2)
Re:Still no auto-update. (Score:4, Informative)
Re: (Score:3)
Re: (Score:2)
Not available in the repository yet (Score:2)
As you can see, I'm on Fedora Core 15. Is it available at other repositories?
"As is typical with major releases of LibreOffice" (Score:3)
Have there been enough major releases of LibreOffice to say what's "typical" of them?
Crashes before even starting on Win7 64-bit (Score:2)
On Windows 7 x86_64 it, unfortunately, crashes before even starting. This is highly unusual.
I'll be waiting for the point release.
Re: (Score:2)
Re: (Score:2)
(Not saying this is better than vanilla LO 3.5's
Re: (Score:3, Insightful)
even MS sucks at supporting its own formats between versions, so don't hold your breath hoping that LO people will reverse engineer all the obscure corner cases and quirks where things break.
Re: (Score:2)
This hasn't been true since Office 2003 or so. Every time I ask someone on Slashdot to give a specific example, it's about Office 95 or 97 document.
Most certainly, .docx - which has only been introduced in Office 2007 - can go back and forth without regressions in all Office versions that support it.
Re: (Score:3)
I've had more trouble with older (2003?) versions of Office reading DOCX files (with the plugin). I've gradually gone from trying MS Word first, to trying LO Writer first.
But it probably depends what your needs are. I generally don't need to care about the formatting being exactly the same.
Re:docx support? (Score:5, Informative)
The .docx support is good enough that I am writing a book in collaboration with MS Office users, including change tracking and comments, and they don't know that I'm using LibreOffice 3.4. If you find any bugs in .docx compatibility, you can contact me here and we will file bugs:
http://dotancohen.com/eng/message.php [dotancohen.com]
Thanks.
Re: (Score:2)
The .docx support for the Mac version of Office is what gives me the most trouble. I can send some of the problem documents if that is helpful.
Re:Here we go again (Score:5, Insightful)
Great, a major LO upgrade. That means I download it, install it, and see how many minutes it takes me before I hit a large enough Office compatibility snag that makes me delete it and swear off giving it another shot.
Instead of swearing it off, get in touch with me and we will file bugs. Sure, it might take a year or three until they are fixed, but most of them _do_ get fixed in LibreOffice. I would say that the last year in LO has closed more of my bugs than the past five years of OpenOffice.org, including one very critical bug that has been open for almost _ten_years_:
https://issues.apache.org/ooo/show_bug.cgi?id=5556 [apache.org]
Fixed in LO six months after filing:
https://bugs.freedesktop.org/show_bug.cgi?id=37978 [freedesktop.org]
You can contact me here, please have a file that demonstrates the issue handy or clear reproduction instructions:
http://dotancohen.com/eng/message.php [dotancohen.com]
Thanks.
Re: (Score:2)
I don't believe that the following are real people (otherwise, I'd have to kill myself to make the pain in my head stop) :
pj
dwheeler
ooo
jbfaure
You, Dotan Cohen, may be superhuman. You, Marc Sinclair, and Eike Rathke have made the world a better place.
Re: (Score:2)
I have to AOL this. I got so sick of that stupid bug I actually stopped using Calc for Gnumeric.
Re:Here we go again (Score:5, Insightful)
Office documents are fundamentally fragile.
In a text processing program the tiniest change to character spacing rules or line breaking rules or margin rules or image placement rules can radically change the way a document is rendered. So the only way to keep complete compatibility is to NEVER change any existing behaviour of the rendering engine. In a calculation program the tiniest change in formula imlementation can change the calculated results.
The problem with word processors and spreadsheets is they blur the line between input and output. The user is continuously looking at the output so the user thinks of the file as storing the output but what is really being stored is the input. So they load the file into a program with a slightly different engine and get surprised when the results of thier poorly formed (remember the user doesn't see the input so they don't see how horriblly unstructured it is) turn into a mess.
Frankly I find it damn impressive that OOo/Lo do as good a job of dealing with MS office documents as they do.
Re: (Score:2)