Slashdot Mirror


Italian City To Dump OpenOffice For Microsoft After Four Years

An anonymous reader writes: Between 2011 and 2014, the municipality of Pesaro, Italy, trained up its 500 employees to use OpenOffice. However, last year the organization decided to switch back to Microsoft and use its cloud productivity suite Office 365. According to a report from Netics Observatory (Google translation of Italian original), the city administration will be able to save up to 80% of the software's total cost of ownership by going back. The savings are largely due to the significant and unexpected deployment costs. In particular, having to repaginate and tweak a number of documents due to a lack of compatibility between the proprietary and the open source systems translated into a considerable waste of time and productivity. The management estimates that every day roughly 300 employees had to spend up to 15 minutes each sorting out such issues.

37 of 316 comments (clear)

  1. Sounds like an ad by Anonymous Coward · · Score: 4, Insightful

    For some product

    1. Re:Sounds like an ad by ashshy · · Score: 4, Insightful

      Yup. Original source: news.microsoft.com

      --
      #o#
      O Moo.
    2. Re:Sounds like an ad by U2xhc2hkb3QgU3Vja3M · · Score: 4, Insightful

      Microsoft press release or not, it's something that's happening.

    3. Re:Sounds like an ad by thaylin · · Score: 5, Insightful

      It matters a lot. For example what is the price that MS gave on office for that city, did they give it to them for free now to do so? Then that would matter greatly.

      --
      When you cant win, ad hominem.
    4. Re:Sounds like an ad by U2xhc2hkb3QgU3Vja3M · · Score: 3, Interesting

      I didn't say that it didn't matter, I said that it was happening. The source of the news is irrelevant. You're right that the price of Office365 probably played a role but I'm not so sure it played a significant one. After all, Microsoft are competing against free.

    5. Re:Sounds like an ad by SJHillman · · Score: 4, Insightful

      The source of news is not irrelevant. Any source can be biased and can present, twist or omit facts that can greatly change the substance of the news.

    6. Re:Sounds like an ad by ZeroPly · · Score: 3, Informative

      "Free" is how they sell the change to the public. In reality, the open suites simply cannot compete with MS Office on the basis of features. I've used Linux since 1992, and have used Open Office and Libre Office at home for years. But some tasks which would be considered simple in Excel are impossible in Libre. For example, I can create a dashboard in Excel fairly easily, that pulls tickets from the helpdesk SQL database, and gives me a histogram of ages. I have found no way to do that in Libre.

      For home use, I would definitely recommend Libre for anyone who doesn't have a particular reason to choose MS Office. But businesses can easily paint themselves into a corner by getting rid of Access.

      --
      Support microSD: in a post 9/11 world, it is unwise to carry your data on media that you cannot comfortably swallow.
    7. Re: Sounds like an ad by Anonymous Coward · · Score: 5, Insightful

      Who the hell uses spreadsheets for ticket management..? Anyone who has the knowledge to do that should habe the knowledge why it's an awful idea.

    8. Re: Sounds like an ad by ender- · · Score: 5, Insightful

      It helps if you actually read the comment [Crazy idea on Slashdot I know]. They weren't using Excel for ticketing. They were using Excel to create a dashboard displaying information and metrics about tickets in their actual ticketing system, which while it may not be the optimal way to do that, doesn't strike me as that unreasonable.

    9. Re: Sounds like an ad by Captain+Splendid · · Score: 3, Insightful

      Which is fine, but if you're going to use such an edge case to make the claim that one suite of software is superior to the other, you're on thin ice.

      --
      Linux, you magnificent bastard, I read the fucking manual!
    10. Re:Sounds like an ad by LifesABeach · · Score: 4, Funny

      The source is relivent; consider Donald Trump telling you how to comb your hair.

    11. Re: Sounds like an ad by Feral+Nerd · · Score: 5, Insightful

      Which is fine, but if you're going to use such an edge case to make the claim that one suite of software is superior to the other, you're on thin ice.

      If that one edge case was his entire case against Liber Office you'd have a point, however he just cited it as a single example. I expect that when it comes to features in spreadsheet apps it's a bit like search engines. The searches that make or break a search engines is not the ability to return hits for not common searches like "america's got talent winners" it's being able to return results for a large set of rare and specific searches like: "ip67 rated bulkhead mounted sma connectors" or "new old stock 1965 mustang steering box". If you talk to people who use Excel extensively to analyze data you'll quickly find that the reason they find LibreOffice lacking is not because Libreoffice is lacking basic features, it is because the Libre Spreadsheet app is unable to perform a for a wide collection of really specific 'edge' tasks that Excel can either do out of the box or for which there exist well established and professionally maintained third party Excel expansion packages. All of that is simply down to Excel having been around longer and having many more users doing a wider variety of specialised tasks that Libreoffice Calc has had and for Libreoffice Calc that boils down to the fact that gaining market share will be a long and tedious up hill struggle.

    12. Re:Sounds like an ad by Lumpy · · Score: 4, Interesting

      Because microsoft gave them unlimited free use licenses for 5 years.

      And they will have the exact same problems, as Office 365 has huge incompatabilities with a lot of older word docs as well as spreadsheets, etc...

      It's a BS article trying to spin the fact that Microsoft caved in and gave the city a lot of free to ge tthem to switch back.

      --
      Do not look at laser with remaining good eye.
    13. Re:Sounds like an ad by dimeglio · · Score: 4, Insightful

      I expect there will be a number of such switcharoos from open source to closed source then back again. It all depends who is the CIO and how Microsoft has influenced their lives.

      --
      Views expressed do not necessarily reflect those of the author.
    14. Re: Sounds like an ad by turbidostato · · Score: 3, Informative

      "t's like saying you built a tractor powered by a Ferrari engine and it's not working as well as a custom built John Deere"

      Your problem. It was not a Ferrari what you were looking for, but a Lamborghini.

    15. Re: Sounds like an ad by KingMotley · · Score: 3, Informative

      Well, except that Excel has the ability to query not only SQL, but also Oracle, DB2, MariaDB, other Excel spreadsheets, web pages, and flat files. LibreOffice... None.

  2. Start open from the beginning by Anonymous Coward · · Score: 4, Insightful

    That is a message for new organizations to start with open standards from day 1. Otherwise you will get so dependent on proprietary standards that moving out of them may never be worth again.

    1. Re:Start open from the beginning by Spazmania · · Score: 4, Insightful

      Day 1 is long past. You have to deal with files from other folks outside the organization. Conversion back and forth between Microsoft and Open Office is glitchy and unfortunately everybody you deal with has a word, excel or powerpoint file to give you.

      --
      Moderating "-1, Disagree" is simple censorship. Have the guts to post your opinion.
    2. Re:Start open from the beginning by ClickOnThis · · Score: 3, Informative

      Day 1 is long past. You have to deal with files from other folks outside the organization. Conversion back and forth between Microsoft and Open Office is glitchy and unfortunately everybody you deal with has a word, excel or powerpoint file to give you.

      In my experience, transfer of a document from one copy of MS Office to another is not necessarily trouble-free. Sometimes MS Office isn't even compatible with itself.

      --
      If it weren't for deadlines, nothing would be late.
  3. Contrary to my experiences by LichtSpektren · · Score: 4, Insightful

    I am an editor of sorts. My coworkers all use MSWord 2010, and the formatting gets thrashed every time they pass a document around. Inevitably I am called to fix it, and do so by opening it in LibreOffice.

    Furthermore, I would argue that retraining everybody to Microsoft's cloud docs itself constitutes "a considerable waste of time and productivity", but I guess whoever in Pesaro's IT department that got under-the-table money disagrees.

    1. Re:Contrary to my experiences by minstrelmike · · Score: 5, Insightful

      And it seems like a press release because there is actually a 3rd enterprise option: Google Docs. I mean, if you're going to investigate solutions, actually look around.

    2. Re:Contrary to my experiences by Anonymous Coward · · Score: 3, Interesting

      Fuckin' I've worked in a LARGE governmental organization that made 2 format switches and you know what they have that most businesses don't?

      A shit ton of documents, dating back YEARS

      So you're not just dancing around with a version or three out of software X, you're plumbing the depths with garbage from 15+ years ago and god only knows what level of mess. I don't like Microsoft OR its formats but what costs actual money, taxpayer money, is having some manager somewhere tell you what you need to support and have it cost nothing to make the switch, by the way these documents need to be accessible to the public by the way these documents need to be accessible to law enforcement by the way by the way by the way

      After you throw enough cash in the money hole a dim light flickers to life that reads "married to a format 4 life" or several million dollars of up front investment beyond rollout / maintenance costs for your staff.

      THE MOST impacted area of migration to any document format are the documents, the people are transient and replaceable by comparison

      So for ppl who don't get why this is something to pay attention to (i.e. news) or don't get what the big problem is, work with a giant documentation warehouse full of various aging electronic formats

    3. Re:Contrary to my experiences by Camembert · · Score: 3, Insightful

      Mmmh as a non American city I would not want my data to be stored on American servers.

  4. Shocking: a hybrid solution was expensive by orasio · · Score: 5, Insightful

    From TFA:

    "We encountered several hurdles and dysfunctions around the use of specific features," Bruscoli says in the report. "What's more, due to the impossibility of replacing Access and partly Excel (various macros used on tens of files), we decided we had to keep a hybrid solution, using the two systems at the same time. This mix has been devastating," he adds.

    They didn't replace MSOffice in the first place, they had a hybrid solution, which was costly, due to compatibility issues. They should have been able to know that beforehand. msoffice doesn't play well with others, it doesn't even implement any standard format. If you absolutely need to use msoffice in some spots, you should forget about interoperating, and just use msoffice everywhere.

    1. Re:Shocking: a hybrid solution was expensive by known_coward_69 · · Score: 3, Informative

      you can open older versions with other programs, but if your spreadsheet has lots of macros, functions or is tied to SQL analysis or reporting services or some other big data server you might have issues if you switch. the basic parts of excel are a commodity. it's the nice features that some people need that are worth paying for like the ability to do data analysis at the desktop instead of asking someone to write a report in cognos or SQL or whatever

    2. Re:Shocking: a hybrid solution was expensive by Anonymous Coward · · Score: 3, Insightful

      This story should have been:

      Vendor lock-in is real, and it's very hard to shake off.

  5. The state is a lost cause by juanfgs · · Score: 3, Interesting

    I've worked on a state office migration project before, it's no surprise for me that this kind of efforts always end up with the same outcome. The thing is that migrating a state office is a painful process, and tends to generate discomfort on many people, from the office workers to the technical staff.

    Here in latin america we may have particular problems regarding that.

    Many office employees don't want to fully disclose their working environment because: oh surprise! they hardly do any work at all! They just sit there in their computer and complain when their favourite radio stream which uses proprietary technology from the 90's. I wonder how much of these "propietary files" were actually mail-forwarded .ppt/mp4 files and flash games.

    Technical staff has to be trained, and usually that doesn't go well, they are not cooperative and feel the migration process as a personal attack on their capacity and skills.

    It doesn't help either that internal politics get involved in the process when some office workers think they're being audited, and actively seek to shut down the migration process through political means (which they usually have way more experience than the guys doing the migration work).

    Overall the employees feel migration processes as a unnecessary burden, an attack to their perceived right to do what they please with the state's resources without answering anyone and a challenge to their competence. It also prevents high-ranking bureaucrats to get all those juicy commisions from propietary software vendor's.

  6. Re:Libre Office by TWX · · Score: 4, Interesting

    For some things it won't help.

    We use numerous highly-customized document templates that simply don't like anything except MS Office, and have occasionally had problems over the years even with MS Office and problems as features are tweaked by Microsoft.

    Part of the problem is that users that are extremely proficient with MS Office do not want to change, much like users that were extremely proficient with WordPerfect didn't want to change either.

    --
    Do not look into laser with remaining eye.
  7. Oh, the horror~~~ by DrYak · · Score: 4, Interesting

    Besides:

    Excel (various macros used on tens of files)

    Tens of files ? Oh my god that is sooooo many.... Hercules himself would be needed to sort through all of them.

    And from the /. summary:

    The management estimates that every day roughly 300 employees had to spend up to 15 minutes each sorting out such issues.

    15 minute per employee ? That's so horribly long, it's almost as long as their daily coffee pause! They have surely logged tons of overtime because of this! Unpaid overtime! The Italian economy is crumbling because of the daily 15minutes it takes to fix a malformet .docx import into OpenOffice.org !!!

    ~~~

    I can't decide if this is a disguised parody.
    Or if Microsoft have decided to advertise *how easy* it is to actually switch to even an out-dated alternative like OpenOffice.org (not to mention that LibreOffice.org is getting more development and much more bugfixes)

    15 minutes per day ? and 10 Excel file needing fixing ? Common, sound's like it's actually even easier than a major upgrade of MS Office itself.

    --
    "Sufficiently advanced satire is indistinguishable from reality." - [Tips: 1DrYakQDKCQ6y52z6QbnkxHXAocMZJE61o ]
  8. Open source is not always the best option by DidgetMaster · · Score: 5, Interesting

    Some people seem to be under the impression that free software is always a better choice than proprietary software. Some of the stuff released as open source software is garbage and there is often little or no incentive for those who wrote it to fix it. There is also a lot of good stuff out there with wide community support as well. I have used a lot of open source AND proprietary software and there is a lot of good and bad stuff in both camps. It is amazing to me how many people will spend many hours and extra training costs in order to get something working just so they don't have to spend $20 for a license to something else that works a lot better. If I find some really good software and the guys who built it want $50 from me for their efforts, I am happy to pay it. My time is worth something.

    1. Re:Open source is not always the best option by rbrander · · Score: 3, Interesting

      Since I was just posting about how Libre's higher-end stuff is poor compared to Excel, I should be joining you on this. But "PowerPivot" is high-end even for me. Only introduced for Excel2010 (my office doesn't have it yet), and restricted to certain versions of 2013, I have to wonder how big the user base is.

      I wrote my own VBA utility that lets me type an SQL statement and that sucks the results straight out of Oracle into a pivot table, plus has a bunch of buttons for doing stuff to the pivot table that take multiple menu moves without my add-in. (You can do this with menus, my addin just saves several steps - steps that most engineers around me would never learn in the first place).

      Fooling around on menus, I couldn't find any way in LibreOffice to bring the result of an SQL query directly into a pivot table; that's pretty bad right there. Once you're spending time on workarounds, you quickly overcome any cost advantage of the free software. For me. Now if only 1% of users need these differences between Excel and Calc to save dozens of hours per year, we could easily be outvoted by the folks who just need to manage a few tables of numbers and formulas.

  9. Pagination incompatibility? by 140Mandak262Jamuna · · Score: 3, Interesting
    MS-Word baked some incredible unscrutable cruft into its pagination and formatting. Its managers imagined WYSIWYG as the biggest feature over WordPerfect that had formatting codes. They took it to insane levels by changing the formatting when the printer is changed. Imagine that! Everytime the document is opened, if the printer has changed in the mean time it would repaginate. Later it killed WordPerfect by making every printer maker adopt to MS driver spec. Now the document is back in charge, telling the printer what to print. But the cruft that got baked into Ms-Word could not be backed out. Not easily, not without breaking its alleged allegiance to backward compatiblity.

    It is so bad, its alleged "open" "standard" OO-XML has binary cruft in the spec. The spec basically says "whatever the old MS-Word did with this binary is the standard". Even Microsoft is not able to come up with a reference implementation that does not depend the ability to execute the original MS-Word6 binary buried under several layers of emulation.

    This is the real way to build a cash cow. No one else can paginate the way old Ms-Word6 binary did. And if you inveigle your customers into incorporating that pagination as the essential part of their process, then you can laugh at them, tell them you are going to squeeze till they yelp, and they can do anything about it.

    --
    sed -e 's/Chuck Norris/Rajnikant/g' joke > fact
  10. They lost me at... by rbrander · · Score: 3, Interesting

    ...300 people @ 15 minutes a day, after it was 500 employees total in the organization. It's utter bullshit that 60% of the staff are involved in document production every day, much less so much that just the tweaking was 15 minutes.
    It's the exact smell of the bullshit I've seen for 25 years every time an IT department had already made a decision and made up numbers to justify it. Generally, they come up with the money number by working backwards and hope that nobody knows the internal workflows well enough to critique it. But this one fails when we only have one other number to work with, it's so over-the-top.
    Then I remembered that Italy is the place that proves Donald Trump really could win: Berlusconi is Trump mixed with Rupert Murdoch and won election. It's the second most corrupt country in western Europe after Greece.
    This switch was probably just bought and paid for.

  11. LibreOffice is fine for businesses by sjbe · · Score: 4, Informative

    The absence of a serious alternative to MS Access or easy/documemnted scripting [via macros] and VBA, as found in Excel is a non starter for me.

    There are plenty of alternatives to MS Access unless you have some peculiar requirement that it be shipped to you in an office suite. Kind of ridiculous that you think it should be a clone of MS Office. Personally I use Filemaker when I'm going with proprietary small databases but there are plenty of open source options too.

    As for macros LibreOffice Calc has fairly robust macro capability. It doesn't use VBA but so what? If you have tied yourself to Excel with a bunch of VBA scripts then you're probably stuck with Excel unless you want to do a lot of coding. Probably not good planning to hog tie yourself with proprietary technology but I know a lot of people do it with Excel+VBA.

    LibreOffce or Open Office just do not cut it!

    That's funny. I've standardized my company on LibreOffice and it works great for us. Been using it exclusively for 5 years now without problems. Not the right solution for everyone but it works great for us.

  12. The Prescience of John Locke by Sloppy · · Score: 5, Insightful

    In particular, having to repaginate and tweak a number of documents due to a lack of compatibility between the proprietary and the open source systems translated into a considerable waste of time and productivity. The management estimates that every day roughly 300 employees had to spend up to 15 minutes each sorting out such issues.

    This is unsurprising. As you may recall, in his "3rd Treatise on Government," John Locke wrote:

    Reader, thou has endured my discourse on how government shalle answer to the people, and I praise three for thy patience. Let us now broach the particulars of the responsibilities of government.

    Chief among these, is pagination.

    Take the state of significant size, Italy, as one example. While I can only hope that some day the grace of God shalle grant us sufficient meanes for pagination to no longer be one of man's undying labors, today in 1694 Italy has sixteen thousand workers who must tirelessly check page numbers. Yet our author can envision a future where a mere three hundred workers, paid from public coffers, have daily duties requiring precise pagination.

    If their tech is correctly compatible with their legacy uber-shitty database and proprietary spreadsheet, which are apparently not capable of writing standard-format files, this will take mere seconds. On the other hand, if their software cannot make sense of the undocumented inputs, our author can imagine this taking up to fifteen minutes per day. Yet whichever the case, at least three hundred of them will be relying on pagination every day. Even in the ultimate society with fully responsible government, it is the law of nature that we shall never go back to scrolls where nobody gives a fuck about page numbers.

    How he foresaw this, I cannot imagine. But you have to admit, he was right on target. Most people who are familiar with late 20th century technology would never even think of this, since in day-to-life you rarely care about pagination, or especially if your page breaks match someone else's -- indeed you probably only rarely think in terms of "pages" at all. Yet Locke had the distant objectivity, in order to see that pagination would some day return to being an important topic, worthy of peoples' -- nay, The People's -- attention.

    --
    As copyright owner of this comment, I authorize everyone to defeat any technological measure which limits access to it.
  13. protection money from the mafia by nazsco · · Score: 3, Insightful

    even the press release cannot mention a single good reason for it except "we have been conned in the past and now must pay the price... for pagination!"

  14. Little incompatibilities are a big concern by ErichTheRed · · Score: 4, Insightful

    I've been doing end user stuff for years, and Microsoft Office is a de facto standard. It's not because it's the absolute best product out there, but because compatibility needs to be maintained. Most -simple- documents and spreadsheets will open in one or the other. The problem comes when you get documents created with a Word template that someone got very creative with while building it. This happens a lot in engineering organizations, places that have document control/management systems, and yes, governments. Word has never had the easiest-to-decode formatting methods; that crown still goes to WordPerfect for the closed source world, and some law firms still use it today. Little stuff like page breaks, font kerning, and special positioning that don't matter in a simple document but matter a lot in a formal contract are sometimes very hard to find and fix in Word, for example.

    The reality is that even though the format sucks, everyone is used to it and works around the quirks. Is it right? No, but it happens. No one outside of scientific publication is going to advocate for regular users to write their documents in TeX for example, even though that's the perfect example of a completely open, known formatting standard.

    I think open source office suites are fine as long as you don't have crazy formatting needs and you don't have to share complex documents with too many Microsoft Office users. Otherwise, like the article says, users will waste time tweaking little things in their documents instead of doing productive work. If you're a small shop that has standardized on Linux, that's fine. One of the lifeblood things the company I work for does is respond to RFPs from governments. The standard response usually needs to be added to their crazily-formatted Word docs and Excel spreadsheets, and $deity help you if your use of LibreOffice is even thought of as the reason that a bid is rejected.