moving to new version of MS Office

yes, I so agree.

Hi :slight_smile:

I am sick of people going on about MS Office all the time. People ask
for a list of reasons why LibreOffice should be considered but are
never going to listen to any of the reasons. [This started as a
letter to a work-colleague but i think i would get the sack if i sent
it.] Here are a few i've noticed ...

1. Each of the following versions/releases are quite different menus
from each other
2007, 2010, 2013 and then radically different for 365
All those are radically different from 2003 and prior. Prior to 2003
their menus were all quite similar but now the all new ribbon-bar
keeps changing quite a lot. The menus/ribbon-bar is so different
between each one that many, perhaps even most, people need re-training
between each one. People trained in 2010 often have trouble with
2007, 2013 and can't cope with 365. 'IT Training' organisations have
huge books about the different ways of doing things in each version.

People trained in 2010 who go on to get an office job might well find
they struggle to use whichever other version their new workplace uses.
Many of the people doing IT Training are not even looking for work
that would involve using desktop computers. They just need to learn
just enough to write a CV (which could be done using menus in their
own language in LibreOffice rather than first having to learn enough
English (US)).

2. Formats are slightly different. From 2010 they open documents
from other versions in "Compatibility Mode" but that doesn't always
work. Images get moved or corrupted. Paragraphs sometimes have
chunks that are a different font or size.

3. The macro programming language changes between each version so
that macros written for 2007 probably wont work in 2010. Sometimes
people have to buy a different version of MS Office than they already
have, purely to be able to run a particular macro.

One of the reasons the macro language keeps being changed is due to
it's vulnerability to attacks. Apparently it's fairly easy to add
extra code to a macro to execute code, insert trojans, open ports. MS
keep trying to make it safer and keep assuring us it is safe now but
then another attack reaches the news. Many places lock-down MS Office
so that it cannot open or use macros. To move to a newer version of
MS Office macros need to be re-written and that might cost time and
money.

By contrast LibreOffice;
1. keeps the same menu layout for each different version. They just
add new features into the existing menus. Retraining might be needed
1 time when people first move to LibreOffice. After that they need no
new training between different versions/releases.

2. The format stays the same between different versions of the
program. It is the same format used "natively" by many other programs
such as IBM Lotus Symphony, Google-docs, K.Office, Calligra and
others. Even MS Office 2013, and more recent, can open and use the
format which is an ISO format.

3. Macros can be written in proper programming languages such as C++
or Python but people can use a slightly different version of "Basic"
that is not so vulnerable. Macros are run slightly differently so
that they can't cause infections.

Often IT training organisations will put months into learning newer
versions of MS Office and Windows but not put any time into learning
LibreOffice and then grumble that LibreOffice is not identical to "MS
Office" (without stating which version of MS Office they expected it
to be similar to. They don't grumble about changes in MS Office and
don't expect it to be easy to change versions. Even so, one was able
to show me some neat tricks in LibreOffice, that i hadn't realised it
could do.

Getting into some petty details. LibreOffice;
1. produces better quality Pdfs more easily and gives more options
for them (such as loss-less compression instead of creating smudges)
2. handles images more smoothly
3. better quality documents faster and more easily
4. more secure and robust. Even if it does run into troubles it
doesn't affect other programs so much.
5. once it's open it's faster
6. works well on much lower spec machines
7. of the 4 main platforms (Windows, Mac, Linux, Bsd) MS office only
works on 1, occasionally 2. There wont be a Mac version of 2013.
LibreOffice works on all 4.
8. handles a much wider range of formats from other programs
including many MS ones that have been dropped by MS.
9. Relatively easily switches between different languages so that
non-English speakers can still use it. On Windows you have to
struggle to find an appropriate font and "regionalisation" but on
Ubuntu it loads the font when you load the language.
10. if you want changes you can program them or pay for someone
locally to do the programming. You do not have to sit back and just
hope 1 monolithic organisation takes notice of your own needs.
11. it's a LOT cheaper, especially for individual people (rather than
large companies who may end up employing programmers at a fraction the
cost license fees would have been)

Many companies, especially charities, can buy MS Office for bargain
discount special deals. When an individual person tries to buy MS
Office it can easily cost them over £100 and may be several hundred.
Individuals usually only get some of the programs and may need to buy
Publisher or other things separately.

Is it morally right for a charity to expect it's service-users to
spend so much more money than they need to and thus ensure the charity
can keep getting special discounts?

Regards from
Tom :slight_smile:

Hi Tom

Tom wrote

2. The format stays the same between different versions of the
program. It is the same format used "natively" by many other programs
such as IBM Lotus Symphony, Google-docs, K.Office, Calligra and
others. Even MS Office 2013, and more recent, can open and use the
format which is an ISO format.

Actually this is not true. The file extension is the same but the format has
been changing (that is why you have options to save to ODF 1.0, 1.1, 1.2 and
1.2 Extended)
If you try to open an ODF 1.2 Extended file more complex than simple text
with any other of those programs (even with some older versions of
LibreOffice) you will find some incompatibilities...

So, I agree with most of your points but this argument is shooting yourself
on the foot. ODF does share that problem with MS XML files: same extension,
different file structure.

The advantage is that you can always get the latest LibreOffice version for
free (unlike MS Office...)

Cheers,
Pedro

If you save your file in .doc 1997~2000 (or 1997~2003) every program will be
able to open it. Never use .docx.

--doug

Hi :slight_smile:
Thanks Pedro :slight_smile: I am looking for criticism and for other points so
that i can write a much shorter and less emotional list and maybe give
a link to the "White Paper" that someone has been writing
Regards from
Tom :slight_smile:

Libreoffice 4.2.0.0 (beta 1).
When I press F1 or "Help -> Help for LibreOffice" in the menu I get the online help (https://help.libreoffice.org/), not the inbuilt offline help. Any way to force the program to open offline help as in LO 4.1 or do I have to wait untill the next release of 4.2?
I have not the knowledge to built my own version of 4.2.
Running LO 4.2 on Windows 7. LO downloaded from http://www.libreoffice.org/download/pre-releases/
Kolbjoern

Den 29.11.2013 14:27, skreiv Tom Davies:

Hi :slight_smile:
Which language? It's possible that non-English(US) languages might
still be being translated. Even the English (US) one might possibly
not be completely ready yet = which would make it difficult to
translate! There is a carefully thought out process and series of
freezes for these things to ensure that everything is ready for the
proper release date but i just have no idea about the various teams
schedules for that. I thought they normally have it ready for the
betas but that wouldn't give them much time to do the work!

Thank you for answering, Tom.

Language Norwegian nynorsk (LANG=nn).
I am translating UI and help files to this language.
Later I'll download the English (original) version to give it a try. Perhaps tomorrow. (There is a life outside LO too).

On the other hand it might be that you just didn't download the 2nd
package? If you only downloaded the main installer then there should
be a 2nd download to get the help package. If you are using
non-English (US) then i think you have a 3rd package for the User
Interface?

As usual I downloaded the installation package (package no 1) using the default settings which placed the program in C:Programfiles (x86) -> LibreOfficeDev 4 folder. Second I installed the help packets nb, nn, and en-US (C:Programfiles (x86) -> LibreOfficeDev 4 -> help). I found no 3rd package.
I have not found the language files for UI in the LO folder. It looks like the languages is integrated in some way in all the program files. In other programs they usually are put in a separate share -> language folder or something like that, but not so in LO.

If you did download all the appropriate packages then you might have
installed them in the wrong order. The main installer should be first
and then the other 2 in any order you like (i think). With that sort
of thing i lose track of which to do first so i just redo the 1st one
after donig the others and that usually fixes it.

So, if you already have a download of the help package then just reinstall it.

As mentioned above, I think I installed LO correct. I installed the developer version just as previous versions. Normally I am doing my work using LO 4.1. Running 4.2 only for translation works.

As a try I even used the Windows solution for solving all problems: restarting the computer.
Kolbjoern

Hi :slight_smile:
Which language? It's possible that non-English(US) languages might
still be being translated. Even the English (US) one might possibly
not be completely ready yet = which would make it difficult to
translate! There is a carefully thought out process and series of
freezes for these things to ensure that everything is ready for the
proper release date but i just have no idea about the various teams
schedules for that. I thought they normally have it ready for the
betas but that wouldn't give them much time to do the work!

On the other hand it might be that you just didn't download the 2nd
package? If you only downloaded the main installer then there should
be a 2nd download to get the help package. If you are using
non-English (US) then i think you have a 3rd package for the User
Interface?

If you did download all the appropriate packages then you might have
installed them in the wrong order. The main installer should be first
and then the other 2 in any order you like (i think). With that sort
of thing i lose track of which to do first so i just redo the 1st one
after donig the others and that usually fixes it.

So, if you already have a download of the help package then just reinstall it.

Regards from
Tom :slight_smile:

And along those lines, is there still a person, or group that constructs:

* A Pan-Indian LibO DVD.

Hi Jonathon, not sure what you mean here. Are you saying that there WERE such dvds, or that somebody SHOULD do them?

>Many companies, especially charities, can buy MS Office for bargain
>discount special deals.

Microsoft's hypocracy in offering discounts for their software to
charitable organizations has been well documented for more than a
decade.

True: all NGOs should avoid making a mess with those donations, as I
too wrote here:

http://stop.zona-m.net/2010/10/note-to-all-ngos-please-dont-make-a-mess-with-microsoft-donations/

Of course, answering to the earlier poster, not Jonathon:

>Is it morally right for a charity to expect it's service-users to
>spend so much more money than they need to and thus ensure the
>charity can keep getting special discounts?

*Big* charities often have the problems that Jonathon said. Very small
organizations, instead, need to spend zero time/money on
maintaining/re-learning the software they have to use, because it
would be all resources subtracted to working in the streets with the
people they assist. That's why they stick to proprietary software in
general, not just MSO.

   Marco

Hi :slight_smile:
Rebooting solves many problem and not just in Windows. It's even
helped me in Gnu&Linux once or twice.

With the Windows version of LibreOffice you don't get the 3rd download
because that 3rd one is included in the main installer. I think that
to change the UI in Windows go to
Tools - Options - Languages - "Language Settings"
and change the top box to whichever language. In Gnu&Linux it only
offers the ones you have deliberately downloaded as the 3rd package
but in Windows you get the choice of all of them automatically. For
Windows you can choose to download LibreOffice in any language but
then use the route i described to switch to any other language (well,
almost any language)

Have you tried asking on the L10n mailing list to see what they
suggest? It sounds like they are more likely to have experience with
this sort of issue. I thought they translate the online help and then
someone packages that for them?

Also i thought you have to have the UI in a language in order for
LibreOffice to offer that language in the in-built help? So if you
have the UI set to English (US) then it will be looking for the en-us
help package, fail to find it locally and therefore jump online for
you. Except that you do have the en-us one so i don't know why it's
not finding that :frowning: Anyway, try changing to the correct Norwegian one
(not the other Norwegian one! (there are 2 aren't there)) and then
hopefully the help should work
Regards from
Tom :slight_smile:

Hi Doug, all

doug-2 wrote

If you save your file in .doc 1997~2000 (or 1997~2003) every program will
be
able to open it. Never use .docx.

Actually this is not true either. Saving as doc (but especially in docx) in
LO sometimes produces a document that opens correctly in LO but can not be
opened in MS Office (OR the MS warning message *wording* might lead the user
to think that it can't/shouldn't be opened).

In any case, regardless of who is to be blamed, there is a "digital divide"
that prevents MS and LO users to communicate...

IMHO the only way to change this is to send ODF files and ask the users at
the other end to install a free ODF compatible software (LO or other) since
it is costless, while refusing to do so means that on your end you would
have to *buy* a software license from MS...

Cheers,
Pedro

"Pedro":

...a free ODF compatible software (LO or other)

That's nonsense. There is the only one ODF software: OpenOffice and its clones. The entire format is built around the single application from a single vendor.

​Not «clones», Urmas, but forks. LO is not identical to OO, as we who use
it know....

Henri​

The ODF is an ISO format with the full specification published for anyone to use or implement. It is a recognized international standard. It use or lack of use by vendors (MS specifically) is another issue. If any national government wanted to force the issue they could mandate that default format(s) for any software is the appropriate international standard(s) for that type of file. If enough national governments mandate this then MS will change their tune and "enthusiastically" support the ODF standard.

Open, recognized standards, derived from one group or company's internal specifications are not that uncommon. The Material Safety Data Sheet specifications used by many governmental mandated safety programs was originally developed by Dow Chemical for their own internal use. Many US OSHA safety standards are actually industry standards adopted without change from the original (US) industry group best practices and some of these standards may have their origin in one company's practices.

Hi!

I noticed earlier that there was a brief mention of incompatability between libreoffice files and microsoft office files. This is a major problem that has been going on for years and it is a major stumbling block to achieving the libreoffice goal "to eliminate the digital divide in society by giving everyone access to office productivity tools free of charge to enable them to participate as full citizens in the 21st century"

This issue has existed for years. Importing files from microsoft office to libreoffice corrupts the files and documents. This should have been fixed by somehow cleaning the imported document, even if it meant some loss of formatting, during the import process. If the above goal is to be taken seriously, this needs to be one of the highest priorities. Period.

Phil Troy

"M. Fioretti" wrote:

And along those lines, is there still a person, or group that constructs:

* A Pan-Indian LibO DVD.

Hi Jonathon, not sure what you mean here. Are you saying that there

WERE such dvds, or that somebody SHOULD do them?

Back in the days of OOo, they were such DVDs.

jonathon

Urmas wrote:

There is the only one ODF software: OpenOffice and its clones.

a) The common base for the various OOo clones might be as recent as OOo 1.1.3, but I suspect it is several versions earlier.

b) There are office suites that are not deroved from either OOo or MSO that fully implement ODF specifications and criteria.

The entire format is built around the single application from a single vendor.

There is a reference implementation for the ODF file format.

There are two major, and a dozen or so minor variations of how that standard is to be implemented.

jonathon

"tk":

b) There are office suites that are not deroved from either OOo or MSO that fully implement ODF specifications and criteria.

And those are... right, none.

There is a reference implementation for the ODF file format.

And it is called...

Den 30.11.2013 14:07, skreiv Tom Davies:

Hi :slight_smile:
Rebooting solves many problem and not just in Windows. It's even
helped me in Gnu&Linux once or twice.

:slight_smile:

With the Windows version of LibreOffice you don't get the 3rd download
because that 3rd one is included in the main installer. I think that
to change the UI in Windows go to
Tools - Options - Languages - "Language Settings"
and change the top box to whichever language. In Gnu&Linux it only
offers the ones you have deliberately downloaded as the 3rd package
but in Windows you get the choice of all of them automatically. For
Windows you can choose to download LibreOffice in any language but
then use the route i described to switch to any other language (well,
almost any language)

Well, using default installation for Windows (both in 4.1 and 4.2) only the two versions of Norwegian (yes, you are right, only 5 mill. people but two quite similar written languages;-) ) are installed as User Interface languages. The locale settings and default language for documents contains "all" languages.
When installing using the customized menu I am able to select languages of UI.
I do have help files for nb, nn, en-US, and some others installed. Whatever language I choose the local help files are not found and the online help opens instead.

As this error occurs only in the 4.2 version perhaps it is a bug, at least in the Windows version. Perhaps I should wait until the next version or perhaps give the l10n@global.libreoffice.org list you mentioned a try the next time I am translating LO. As for most others, this is a spare time job for me too.

Thank you a lot.
Kolbjoern

M. Fioretti wrote:

*Big* charities often have the problems that Jonathon said. Very small
organizations, instead, need to spend zero time/money on
maintaining/re-learning the software they have to use, because it
would be all resources subtracted to working in the streets with the
people they assist. That's why they stick to proprietary software in
general, not just MSO.

You've just described why it's better to move from older versions of MS
Office to LO or OO than to have to learn how to use the ribbon etc.

Urmas wrote:

b) There are office suites that are not deroved from either OOo or MSO

that fully implement ODF specifications and criteria

And those are...

Koffice, for one.

right, none.

Are those fifteen office suites that are listed as supporting ODF, in the wikipedia article "Comparison of Office Suites" figments of the imagination?

Or maybe all of the software listed in the Wikipedia article "OpenDocument Software" is also a figment of the imagination.

Note in passing that both lists omits the CJKV office suites, as well those from ex-comblcok countries.

There is a reference implementation for the ODF file format.
And it is called...

Technically, Apache OpenOffice, but arguably, also LibreOffice.

jonathon