5 ms·

This looks interesting. I'm actually rather surprised at the lack of quality in most open source 'office' alternatives. I'm not sure why, but open/libreoffice i

by osrec 8y ago

This looks interesting. I'm actually rather surprised at the lack of quality in most open source 'office' alternatives. I'm not sure why, but open/libreoffice is almost unusable for heavy duty office work. Microsoft products are the clear winners if you require productivity and stability. I really hope that changes soon, because I feel it's a major factor that holds back widespread Linux adoption.

mindcrime 8y ago
I'm not sure why, but open/libreoffice is almost unusable for heavy duty office work. What do you define as "heavy duty office work"? What would make OpenOffice more suitable to you needs? Asking as an AOO contributor. I'm genuinely curious to know what you think the project is lacking or how it needs to be improved.
- osrec 8y ago
  Firstly, I would like to thank you for your work. Open office has served me very well during my school and university days. Since joining the world of work, I've struggled with the following: - Random crashes every couple of hours when files become large. Especially in Impress and Calc. - I do a lot of diagrams in OODraw. Sometimes I'll reopen the file to find arrows and connectors have moved. - The interface could be more intuitive. For example, the colour selector is limited and clunky, as is the gradients widget. Why can't we add any colour we like without going to the options menu? - Application speed is slow when files get large, especially Calc. I've even tried increasing memory per object. - Filtering and sorting in Calc not as fully featured or easy to use as Excel. - Conditional formatting not as easy to use. - Calc shortcuts not as easy to use as Excel (eg, I don't think there's an easy way to select a column without a mouse, or transpose a selection, or remove blanks etc etc). With Excel, I can pretty much achieve most things without touching a mouse (I'm an ex investment banker, and we get pretty familiar with the keys). OO seems to lack these critical shortcuts. - Poor documentation of OO scripting environment. It's tough to figure out how to automate simple things in Calc. This is not an exhaustive list, but it's all I can think of currently. Again, I am very supportive of the AOO/LO effort, but I wished it would start giving Microsoft more competition in the power user category. Thanks!
  - mindcrime 8y ago
    - I do a lot of diagrams in OODraw. Sometimes I'll reopen the file to find arrows and connectors have moved. Interesting. I use Draw a lot and haven't had that hit me yet. Any chance I could convince you to post something about this to the AOO mailing list, or open an issue in Jira about it? (that is, assuming there isn't already an issue for this). Poor documentation of OO scripting environment. It's tough to figure out how to automate simple things in Calc. Agreed. I just went through that exercise myself, when I was working on a thing at work to use the Jira API to query stories, and pull stuff into a spreadsheet for analysis. I was able to figure it out, but it wasn't easy. From what I've seen, the information is all there, but it's not necessarily organized / accessible enough. There's also not enough tutorial format stuff. Hopefully I can write up some stuff based on my recent experience and get it out there. but I wished it would start giving Microsoft more competition in the power user category. Same here. I have a laundry list of things I'd like to try and add to Calc to make it more powerful for complex analytics and what-not, but I am so busy on other projects I haven't had time to pursue those ideas much.
  - antt 8y ago
    > investment banker As someone who was a software engineer in a brokerage and had to deal with clients excel sheets: open/libre office not letting you do that is a feature. We would be given excel sheet that would depend on a specific version of Excel. We had sheets in the hundreds of megabytes. We had sheets that would take overnight to run. We had sheets with sheet dependencies. We had sheets that needed to be run in a specific order manually. We had sheets with 13,000 manually entered rows, each with 53 columns. These things, and I use the term thing since eldritch abominations does not convey the horror of using them, were responsible for investing hundreds of millions of dollars. The day excel dies is a day I will celebrate.
    - osrec 8y ago
      Yes, I too have seen those spreadsheets, but it's not Excel that's at fault, it's the users. I've taken XLS behemoths and trimmed them down to a fraction of their size and optimised sheets that ran overnight, to recalculate in seconds. I get what you're saying about Excel giving too much power in incapable hands, but I feel, for certain use cases, OO is too little power in even the most capable hands.
- sametmax 8y ago
  I use it almost exclusively. And it crashes. It crashes and loose your work. Regularly. I love that such product exists. I donate to libre office. But it's nowhere as reliable as msoffice. Any complex enought document will make it crash at some point. It's not even reproductible. You can't pinpoint the action that made it crash. Sometime you do the same other and other and it's fine. Then it destroy work and crush your soul.
sheetjs 8y ago
There's a ton of mindnumbing testing and grinding work that honestly no one really wants to do, involving bit-level accuracy in many cases. We (https://sheetjs.com/ https://sheetjs.com/) are attacking the file compatibility problem (our major open source project is https://github.com/sheetjs/js-xlsx https://github.com/sheetjs/js-xlsx, used in stencila's spreadsheet converters) and it is painfully obvious that OO/LO cuts corners at certain places. For example, the mathematics of Calc is intentionally bugged: > ignore the last two bits for many stuff to improve the user experience. https://bugs.documentfoundation.org/show_bug.cgi?id=83511 https://bugs.documentfoundation.org/show_bug.cgi?id=83511 A successful alternative to Microsoft Office has to start from a level of compatibility that no current developer in existing solutions has expressed interest in attaining.
- osrec 8y ago
  Interesting. In your experience, do you think heavy duty, in-browser office applications are now viable? I'm beginning to think they are, especially with the likes of web assembly becoming more ubiquitous.
- dorfsmay 8y ago
  > it is painfully obvious that OO/LO cuts corners at certain places. For example, the mathematics of Calc is intentionally bugged What about Gnumeric? My understanding is that the dev team (mainly Jody Goldberg really) have focused on accuracy. The gnumeric.org site has links to studies related to its accuracy.
- nokome 8y ago
  Just a quick word of thanks for SheetJs from a Stencila dev! All the "mindnumbing testing and grinding work that honestly no one really wants to do" is obvious and much appreciated. Your efforts are so important for the ensuring interoperability but are often not recognised because they are "in the backend".
- erAck 8y ago
  As you referenced that bug and there also gave an example involving fractions and =0.1+0.2 you would certainly also agree that the binary floating point representation of =0.1+0.2-0.3 is not 0.0, still Excel displays 0 as result (and so does Calc) instead of 5.551115123125783E-17 because users expect that. Your bit-level accuracy approach isn't as simple when it comes to user experience and Excel compatibility.
jk27277 8y ago
Try softmaker office
basiliskparty 8y ago
Not disagreeing with you, as everyone has different workflows etc. but my experience is really different. I've found LibreOffice entirely suitable for heavy duty work, completely fine. Microsoft products crash inexplicably on our systems too, and in fact, we have much weirder problems with corrupted instances and things than we've ever had when using LibreOffice. I also have serious problems with the Office UI, basically that the ribbon UI as it's implemented is inconsistent and incoherent, which is frustrating as hell. If you're going to have a ribbon/tab UI, make it consistent throughout, and don't have special exceptions for some functions. Having said that, I do think LibreOffice loses to Microsoft's edge in some areas of polish, like in implementing equations, and in drawing figures. Some of the UI with the drawing actions are much more intuitive in Office.

by osrec 8y ago

mindcrime 8y ago

I'm not sure why, but open/libreoffice is almost unusable for heavy duty office work. What do you define as "heavy duty office work"? What would make OpenOffice more suitable to you needs? Asking as an AOO contributor. I'm genuinely curious to know what you think the project is lacking or how it needs to be improved.

osrec 8y ago
Firstly, I would like to thank you for your work. Open office has served me very well during my school and university days. Since joining the world of work, I've struggled with the following: - Random crashes every couple of hours when files become large. Especially in Impress and Calc. - I do a lot of diagrams in OODraw. Sometimes I'll reopen the file to find arrows and connectors have moved. - The interface could be more intuitive. For example, the colour selector is limited and clunky, as is the gradients widget. Why can't we add any colour we like without going to the options menu? - Application speed is slow when files get large, especially Calc. I've even tried increasing memory per object. - Filtering and sorting in Calc not as fully featured or easy to use as Excel. - Conditional formatting not as easy to use. - Calc shortcuts not as easy to use as Excel (eg, I don't think there's an easy way to select a column without a mouse, or transpose a selection, or remove blanks etc etc). With Excel, I can pretty much achieve most things without touching a mouse (I'm an ex investment banker, and we get pretty familiar with the keys). OO seems to lack these critical shortcuts. - Poor documentation of OO scripting environment. It's tough to figure out how to automate simple things in Calc. This is not an exhaustive list, but it's all I can think of currently. Again, I am very supportive of the AOO/LO effort, but I wished it would start giving Microsoft more competition in the power user category. Thanks!
- mindcrime 8y ago
  - I do a lot of diagrams in OODraw. Sometimes I'll reopen the file to find arrows and connectors have moved. Interesting. I use Draw a lot and haven't had that hit me yet. Any chance I could convince you to post something about this to the AOO mailing list, or open an issue in Jira about it? (that is, assuming there isn't already an issue for this). Poor documentation of OO scripting environment. It's tough to figure out how to automate simple things in Calc. Agreed. I just went through that exercise myself, when I was working on a thing at work to use the Jira API to query stories, and pull stuff into a spreadsheet for analysis. I was able to figure it out, but it wasn't easy. From what I've seen, the information is all there, but it's not necessarily organized / accessible enough. There's also not enough tutorial format stuff. Hopefully I can write up some stuff based on my recent experience and get it out there. but I wished it would start giving Microsoft more competition in the power user category. Same here. I have a laundry list of things I'd like to try and add to Calc to make it more powerful for complex analytics and what-not, but I am so busy on other projects I haven't had time to pursue those ideas much.
- antt 8y ago
  > investment banker As someone who was a software engineer in a brokerage and had to deal with clients excel sheets: open/libre office not letting you do that is a feature. We would be given excel sheet that would depend on a specific version of Excel. We had sheets in the hundreds of megabytes. We had sheets that would take overnight to run. We had sheets with sheet dependencies. We had sheets that needed to be run in a specific order manually. We had sheets with 13,000 manually entered rows, each with 53 columns. These things, and I use the term thing since eldritch abominations does not convey the horror of using them, were responsible for investing hundreds of millions of dollars. The day excel dies is a day I will celebrate.
  - osrec 8y ago
    Yes, I too have seen those spreadsheets, but it's not Excel that's at fault, it's the users. I've taken XLS behemoths and trimmed them down to a fraction of their size and optimised sheets that ran overnight, to recalculate in seconds. I get what you're saying about Excel giving too much power in incapable hands, but I feel, for certain use cases, OO is too little power in even the most capable hands.
sametmax 8y ago
I use it almost exclusively. And it crashes. It crashes and loose your work. Regularly. I love that such product exists. I donate to libre office. But it's nowhere as reliable as msoffice. Any complex enought document will make it crash at some point. It's not even reproductible. You can't pinpoint the action that made it crash. Sometime you do the same other and other and it's fine. Then it destroy work and crush your soul.

sheetjs 8y ago

There's a ton of mindnumbing testing and grinding work that honestly no one really wants to do, involving bit-level accuracy in many cases. We (https://sheetjs.com/ https://sheetjs.com/) are attacking the file compatibility problem (our major open source project is https://github.com/sheetjs/js-xlsx https://github.com/sheetjs/js-xlsx, used in stencila's spreadsheet converters) and it is painfully obvious that OO/LO cuts corners at certain places. For example, the mathematics of Calc is intentionally bugged: > ignore the last two bits for many stuff to improve the user experience. https://bugs.documentfoundation.org/show_bug.cgi?id=83511 https://bugs.documentfoundation.org/show_bug.cgi?id=83511 A successful alternative to Microsoft Office has to start from a level of compatibility that no current developer in existing solutions has expressed interest in attaining.

osrec 8y ago
Interesting. In your experience, do you think heavy duty, in-browser office applications are now viable? I'm beginning to think they are, especially with the likes of web assembly becoming more ubiquitous.
dorfsmay 8y ago
> it is painfully obvious that OO/LO cuts corners at certain places. For example, the mathematics of Calc is intentionally bugged What about Gnumeric? My understanding is that the dev team (mainly Jody Goldberg really) have focused on accuracy. The gnumeric.org site has links to studies related to its accuracy.
nokome 8y ago
Just a quick word of thanks for SheetJs from a Stencila dev! All the "mindnumbing testing and grinding work that honestly no one really wants to do" is obvious and much appreciated. Your efforts are so important for the ensuring interoperability but are often not recognised because they are "in the backend".
erAck 8y ago
As you referenced that bug and there also gave an example involving fractions and =0.1+0.2 you would certainly also agree that the binary floating point representation of =0.1+0.2-0.3 is not 0.0, still Excel displays 0 as result (and so does Calc) instead of 5.551115123125783E-17 because users expect that. Your bit-level accuracy approach isn't as simple when it comes to user experience and Excel compatibility.

jk27277 8y ago

Try softmaker office

basiliskparty 8y ago

Not disagreeing with you, as everyone has different workflows etc. but my experience is really different. I've found LibreOffice entirely suitable for heavy duty work, completely fine. Microsoft products crash inexplicably on our systems too, and in fact, we have much weirder problems with corrupted instances and things than we've ever had when using LibreOffice. I also have serious problems with the Office UI, basically that the ribbon UI as it's implemented is inconsistent and incoherent, which is frustrating as hell. If you're going to have a ribbon/tab UI, make it consistent throughout, and don't have special exceptions for some functions. Having said that, I do think LibreOffice loses to Microsoft's edge in some areas of polish, like in implementing equations, and in drawing figures. Some of the UI with the drawing actions are much more intuitive in Office.