4 ms·

> It breaks down when you are using something like Excel with complex macros/calculations. This is why most companies continue to use Microsoft products. It br

> It breaks down when you are using something like Excel with complex macros/calculations. This is why most companies continue to use Microsoft products. It breaks down because you need some serious backup in your organization (for example from the owner) to switch to something like LibreOffice. People got enough on their plate and changing their tools for (from their perspective) no apparent reason will get a lot of push back. I think technically LibreOffice is perfectly up to the task. Sure if your a statistician then maybe Spreadsheet won't work as well for you as an Excel replacement. But other then that...

nradov 7y ago
It doesn't matter how much backup you have in the organization if the product is missing essential functionality. LibreOffice just doesn't have everything that MS Office does. That doesn't matter for some businesses but for others it creates a total block.
- abnry 7y ago
  Yes, I would imagine given how long Office has been around, there are some people who have delved quite deep into the feature set and become dependent on it. It's hard to let go of one feature that you have come to rely on.
- cobbzilla 7y ago
  I have some pretty complex spreadsheets from Excel that I now run under LibreOffice without any problems. That said, while they do use some complex formulas, they don’t use any VBScript or other such madness. Complaining that your custom MSFT/VBScript stuff doesn’t work, so you can’t migrate — it sounds to me a bit like “We’re stuck on Oracle and can’t move to PostgreSQL because we decided to use a lot of Oracle magic stuff that doesn’t work anywhere else”. This is classic vendor lock-in, which I tend to view as a business risk best avoided. There really is no option except to recognize it as technical debt and find time to dig yourself out from it. When your only option for “Business Function X” limits you to a single vendor, fix that first.
  - marcinzm 7y ago
    Everything has risks and tradeoffs. Excel means that you can communicate with clients and vendors in their preferred tool, it means you can onboard new hires more quickly, it means you need less internal support staff, etc. Switching from Excel adds those things back in as risks for your business. Good business is about managing and understanding risks, and not about eliminating them at all costs.
    - cobbzilla 7y ago
      This is a very sane approach, and I agree wholeheartedly. But when the only thing holding you back and locking you in is your own company's internal vendor-specific tooling/infrastructure, the argument doesn't hold as much weight. fwiw, I have never received an Excel spreadsheet from a vendor/partner/customer that I could not open and work with in LibreOffice, re-export to Excel and send back to them.
      - immigrantsheep 7y ago
        I did because a lot of our clients and partners were non technical people using complex excel spreadsheets with macros and vba. And since Excel is the de facto standard, shouldn't Libre Office offer a 100% compatibility to whatever Excel has if it wants a piece of that market share? Also $150/year for something that does it all and just works it's really not much. The same reason why we don't ask how much Visual Studio Enterprise costs or IntelliJ products even if you have free alternatives.
  - bitwize 7y ago
    This sounds like an argument I would've made in my early twenties. I will now correct you in the way my elders corrected me: Oracle and Microsoft Office are global standards. The world uses them. Our civilization relies on them. If alternatives such as PostgreSQL and LibreOffice are not 100% compatible with these standards, they are lacking in functionality.
    - davidy123 7y ago
marcinzm 7y ago
>Sure if your a statistician then maybe Spreadsheet won't work as well for you as an Excel replacement. We had a client send us a questionnaire in an Excel document with macros to compute various things based on our answers. You underestimate just how many things are done in Excel across companies (ie: you can't even force both side to switch to Libreoffice) that you would, probably, write a quick webpage for.
AnIdiotOnTheNet 7y ago
> I think technically LibreOffice is perfectly up to the task. IT people really need to stop declaring this about FOSS products when it is regarding workflows they have no experience in.

nradov 7y ago

It doesn't matter how much backup you have in the organization if the product is missing essential functionality. LibreOffice just doesn't have everything that MS Office does. That doesn't matter for some businesses but for others it creates a total block.

abnry 7y ago
Yes, I would imagine given how long Office has been around, there are some people who have delved quite deep into the feature set and become dependent on it. It's hard to let go of one feature that you have come to rely on.
cobbzilla 7y ago
I have some pretty complex spreadsheets from Excel that I now run under LibreOffice without any problems. That said, while they do use some complex formulas, they don’t use any VBScript or other such madness. Complaining that your custom MSFT/VBScript stuff doesn’t work, so you can’t migrate — it sounds to me a bit like “We’re stuck on Oracle and can’t move to PostgreSQL because we decided to use a lot of Oracle magic stuff that doesn’t work anywhere else”. This is classic vendor lock-in, which I tend to view as a business risk best avoided. There really is no option except to recognize it as technical debt and find time to dig yourself out from it. When your only option for “Business Function X” limits you to a single vendor, fix that first.
- marcinzm 7y ago
  Everything has risks and tradeoffs. Excel means that you can communicate with clients and vendors in their preferred tool, it means you can onboard new hires more quickly, it means you need less internal support staff, etc. Switching from Excel adds those things back in as risks for your business. Good business is about managing and understanding risks, and not about eliminating them at all costs.
  - cobbzilla 7y ago
    This is a very sane approach, and I agree wholeheartedly. But when the only thing holding you back and locking you in is your own company's internal vendor-specific tooling/infrastructure, the argument doesn't hold as much weight. fwiw, I have never received an Excel spreadsheet from a vendor/partner/customer that I could not open and work with in LibreOffice, re-export to Excel and send back to them.
    - immigrantsheep 7y ago
      I did because a lot of our clients and partners were non technical people using complex excel spreadsheets with macros and vba. And since Excel is the de facto standard, shouldn't Libre Office offer a 100% compatibility to whatever Excel has if it wants a piece of that market share? Also $150/year for something that does it all and just works it's really not much. The same reason why we don't ask how much Visual Studio Enterprise costs or IntelliJ products even if you have free alternatives.
- bitwize 7y ago
  This sounds like an argument I would've made in my early twenties. I will now correct you in the way my elders corrected me: Oracle and Microsoft Office are global standards. The world uses them. Our civilization relies on them. If alternatives such as PostgreSQL and LibreOffice are not 100% compatible with these standards, they are lacking in functionality.
  - davidy123 7y ago

marcinzm 7y ago

>Sure if your a statistician then maybe Spreadsheet won't work as well for you as an Excel replacement. We had a client send us a questionnaire in an Excel document with macros to compute various things based on our answers. You underestimate just how many things are done in Excel across companies (ie: you can't even force both side to switch to Libreoffice) that you would, probably, write a quick webpage for.

AnIdiotOnTheNet 7y ago

> I think technically LibreOffice is perfectly up to the task. IT people really need to stop declaring this about FOSS products when it is regarding workflows they have no experience in.