Suggestions require about rolling out OpenOffice for a Bank

Discuss your migration story or project
Post Reply
usmanrl
Posts: 1
Joined: Mon Jun 13, 2022 11:36 pm

Suggestions require about rolling out OpenOffice for a Bank

Post by usmanrl »

Please share your experiences about using open office at enterprise level for end users, mostly branch users. This will replace existing MS Office 2016 along with Outlook. Would be grateful if you fellas can share and suggest the do's and don'ts.
Apache Open Office 4.1.12 for Win_x86
User avatar
RusselB
Moderator
Posts: 6599
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Suggestions require about rolling out Open Office for a Bank

Post by RusselB »

Personally I would not recommend Open Office for this project.
LibreOffice is a better suggestion due to it being more actively developed.
Your users will notice many differences between MS Office & LibreOffice.
Please note that neither OpenOffice nor LibreOffice have a mail component, which is what Outlook is used for.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
John_Ha
Volunteer
Posts: 9097
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Suggestions require about rolling out Open Office for a Bank

Post by John_Ha »

In my opinion as a long time user of AOO who recently migrated to LO, Apache OpenOffice is walking dead through lack of development and would be a poor choice.

LibreOffice is virtually identical to AOO (it forked from AOO v3) except it is under active development and is a much more sensible choice. Critical bugs which cause complete data loss in AOO have been fixed in LO. LO has better support for the modern .docx, .xlsx etc formats than AOO (AOO can partially read but not write them). LO has a vibrant set of organisations which can provide professional support to companies using LO.

Be sure to read [Tutorial] Differences between Microsoft and AOO/LO files for a description of differences and an idea of some of the problems you will face. Users are always recommended to save their work in any application's native file format (.odt for word processing) rather than in another vendor's file format (eg Microsoft's .doc or .docx for word processing) which could cause difficulties if you send documents to other organisations.

Run a trial in a small department of a few tens of users and see what issues arise.

Neither AOO nor LO has an Outlook (email) equivalent.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
User avatar
keme
Volunteer
Posts: 3575
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Suggestions require about rolling out Open Office for a Bank

Post by keme »

Not personal experience, but still an appropriate observation, I believe:

For bank and finance, I understand that there are multiple third party solutions in common use which integrate with Microsoft Office. Some of them may integrate via API (not mere file transfer), and in that situation the integration will not work properly if Word/Excel/Access are not present. Some solutions using file export/import will also yield inferior results when piped through non-MS applications.

I have seen a number of requests for integration to OpenOffice/LibreOffice which seemed to remain unresolved. This suggests to me that transfer is not trivial.

Make sure to review all your in-house system integration requirements! See the cost of workarounds in connection with what you save on licenses. There is of course a gain from using a truly open storage format of ODF instead of the hybrid open/proprietary OOXML "standard", but this gain is difficult to set a price tag on, so depending on your organization/culture it may be better to avoid that as a "selling point".
Last edited by keme on Tue Jun 14, 2022 10:01 am, edited 1 time in total.
User avatar
RoryOF
Moderator
Posts: 33646
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Suggestions require about rolling out Open Office for a Bank

Post by RoryOF »

For a professional use, in as important an organisation as a bank, I would not suggest using opensource software.
Apache OpenOffice 4.1.13 on Xubuntu 22.04.1 LTS and very infrequently on Win2K/XP
User avatar
Hagar Delest
Moderator
Posts: 30689
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Suggestions require about rolling out Open Office for a Bank

Post by Hagar Delest »

RoryOF wrote: Tue Jun 14, 2022 10:00 am For a professional use, in as important an organisation as a bank, I would not suggest using opensource software.
Well, many administrations around the world have done so already.
However, it means that you must know very well how your users use their current software and if the new software features meet those uses (especially if there are macros involved.
Switching to AOO/LO just for the cost of the license would be a poor choice leading to possible frustration, loss of productivity, loss of data...
You'll have to document compatibility with the external actors of your business and the training of your user base.
LibreOffice 7.2.6 on Xubuntu 22.04 and 7.2.6 portable on Windows 10
sveld
Posts: 18
Joined: Sat Dec 07, 2019 8:33 am
Location: The Netherlands

Re: Suggestions require about rolling out OpenOffice for a Bank

Post by sveld »

For commercial environments it may be important to use an enterprise supported open source solution, which are both build on LibreOffice, like "Collabora Office" or "LibreOffice powered by CIB". They bring a lot of expirience for such a migration process and can address pain points as you hit them.
A lot of info on migration and how/why's can be found at https://www.libreoffice.org/download/li ... -business/ and may be a good starting point.

So,
For a professional use, in as important an organisation as a bank, I would not suggest using opensource software.
Is nonsense as open source is used all over the place in IT, tough one would like to find support and pay for that convience just like one does/can do using closed source software.
LibreOffice 7.3.4.2 on Win10/Linux, Collabora Office App on IOS and Android, Collabora Office Online (CODE) with Nextcloud
User avatar
RoryOF
Moderator
Posts: 33646
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Suggestions require about rolling out OpenOffice for a Bank

Post by RoryOF »

I was thinking in terms of managing the money. Besides, a bank can afford to purchase a commercial and supported solution.
Apache OpenOffice 4.1.13 on Xubuntu 22.04.1 LTS and very infrequently on Win2K/XP
sveld
Posts: 18
Joined: Sat Dec 07, 2019 8:33 am
Location: The Netherlands

Re: Suggestions require about rolling out OpenOffice for a Bank

Post by sveld »

I was thinking in terms of managing the money. Besides, a bank can afford to purchase a commercial and supported solution.
That's why a fully supported LibreOffice Enterprise ready build is the better solution for such environment. Commercial here may be not the right word as you do not pay for the software as that is still open source. It's for the testing and support on the specific builds that you pay and that those come with long term support. The thing is not those companies do not have money to spend and cannot afford like Goole or MS Office, I suppose they look for the freedom (no lockin, flexibility, integration possibilities) of open source they want a long term investment in so a partner that can guide in implementation, integration, training and support is most helpfull to make such and project a success. Having no plan for sure such project is doomed to fail.
LibreOffice 7.3.4.2 on Win10/Linux, Collabora Office App on IOS and Android, Collabora Office Online (CODE) with Nextcloud
Post Reply