Skip to content

LibreOffice 4.4 should have been called 5.0, because it is that much better

Netrunner MAG did LibreOffice 4.4 review – Finally, it rocks and concludes with I have never quite expected this. In fact, LibreOffice 4.4 should have been called 5.0, because it is that much better.
All the little things I wanted are there. Check. Everything purrs like a kitten engorged on baby seal livers. Check. Awesomeness everything, and I am searching for more fanatic wording to convince you that you should abandon all and everything you’re doing and start testing LibreOffice. This is a monumental release, and I only have absolute praise. Well done.
Enough said. And thank you. Every user and everyone involved with the project. Thank you all for making LibreOffice that much better.

Happy Birthday TDF!

The Document Foundation: The Third Anniversary reads:
The Document Foundation has been incorporated on February 17, 2012. Today is the third anniversary, and this video is a testimonial of the activity of many members of the fantastic LibreOffice community in representation of thousands of volunteers and hundreds of developers. Thanks everyone for the wonderful journey.
and Italo Vignoli assembled this video of nice LibreOffice community shots:



Happy Birthday TDF!


I ♥ Free Software

I especially like this year's I ♥ Free Software contribution from The Document Foundation in the bug tracker they host for LibreOffice.

I ♥ Free Software from TDF
I ♥ Free Software from The Document Foundation

14 Years Freedom of Choice, 14 Years Choice of Freedom

Today we can celebrate an anniversary, on Friday 13 October 2000 Sun Microsystems published the OpenOffice.org source code. I won't say "Happy Birthday, OpenOffice.org" because OpenOffice.org as a project died in April 2011 when the company who bought Sun Microsystems gave it the final stab, and there is a well alive successor now. But the birth of OpenOffice.org marked a milestone in the history of office productivity software. It provided the freedom of choice to a wider audience of users, being available on several platforms it freed users from being dictated what productivity software to use. For many people, developers, quality engineers, translators, authors and users it also meant the choice of freedom, the choice to contribute to Free Software, the choice to change the software world even if just a little, line by line. And it triggered another birth, the birth of the OpenDocument Format for office applications, starting the standardization of office productivity file formats.

For me it also provided the freedom to be able to work like I work today, being employed by a great company that pays my bills while I work on this freedom is a privilege I much appreciate.

Thank you OpenOffice.org!


LibreOffice 4.3 new language tag feature: adding a BCP 47 language tag

In LibreOffice 4.3 the user will be able to specify an arbitrary valid BCP 47 language tag for text attribution.

In character attribution dialogs the language list box (of the Western text font if CJK or CTL are enabled) is now a combo box with an edit field where the user can specify a valid BCP 47 language tag to define a text language attribute if the language she wants to assign is not available from the selectable list. The input is checked against a copy of the IANA language-subtag-registry (transformed to XML), provided either with the liblangtag package of your OS distribution, or the liblangtag shipped with LibreOffice on systems that do not provide one. The internal registry file distributed with LibreOffice 4.3 consists of data as of 2014-04-10.

language tag combo box with sga-Ogam entered
The language tag combo box with sga-Ogam entered, a tag for Irish, Old (to 900) written in Ogham script.

 

For language tag details please see the For users section on the langtag.net web site.

And now jump to the release notes for more nifty features of LibreOffice 4.3 :-)

 

LibreOffice 4.3 new Calc feature: user selectable text conversion models

In LibreOffice 4.3 the user will be able to select how textual cell content shall be treated in arithmetic operations.

This setting determines how to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead.

Selectable under Tools → Options → LibreOffice Calc → Formula in Detailed calculation settingsCustomDetails from Conversion from text to number are:

Generate #VALUE! error
=1+"1" or =1+"x" give #VALUE!
Treat as zero
=1+"1" or =1+"x" give 1
Convert only unambiguous
=1+"1" gives 2, but =1+"1.000" or =1+"x" give #VALUE!
Convert also locale dependent
=1+"1.000" may be 2 or 1001 ... =1+"x" gives #VALUE!

For Generate #VALUE! error and Treat as zero, setting the Treat empty string as zero option is disabled and the option is aligned to these settings, for Convert only unambiguous and Convert also locale dependent the Treat empty string as zero option can be set independently.

When reading documents created by other spreadsheet applications or older versions of LibreOffice, and to interchange documents between different locales, the Convert only unambiguous with Treat empty string as zero = True setting is recommended, though LibreOffice so far acted as Convert also locale dependent with Treat empty string as zero = False, which is the reason that option is kept as default.

The best setting to create new documents that can be interpreted by all spreadsheet applications without on-the-fly string conversion is Generate #VALUE! error. With this option enabled possible data errors can be spotted early. Not having to convert strings during calculation is also faster, of course.

User selectable text conversion models in LibreOffice 4.3

 

Las Palmas hacker spaces

As flying to Gran Canaria for just two days is a waste of resources I stayed a little longer after the LibreOffice Hackfest at Las Palmas and enjoyed some enhanced coastal hacking conditions and hacker spaces ...

Working on Monday could be worse.
Working on Monday could be worse.

Working on Tuesday isn't bad either.
Working on Tuesday isn't bad either.

Björn had the same ideas about the waste of resources and a joyful working environment and so we met for a hotel balcony hacking afternoon:

Hotel Hacking with Björn. Work can be fun.
Hotel Hacking with Björn. Work can be fun.

 

Life is about the good things.

 

LibreOffice Hackfest at Las Palmas, Gran Canaria

Another retrospective..

On April 24 and 25 we had a LibreOffice Hackfest at Las Palmas, Gran Canaria at the Universidad de Las Palmas de Gran Canaria (ULPGC) in it's IT faculty building. Due to the geographical distance for some community members understandably a little bit less frequented than other hackfests in the past, but nevertheless of course great fun for the participants. And an even bigger opportunity to introduce LibreOffice and Free Software development to the local IT students, as the dean of the IT faculty Fran Santana was very enthusiastic about this event and helpfully provided rooms, equipment and personnel and invited interested students to attend our talks.

LibreOffice Hackfest Las Palmas 2014 flyer
Flyer with LibreOffice talks program and hackfest announcement.

On Thursday we had introductory talks with about 20-30 listeners. Not that many, but given that it was a week of exams not a bad number either, whoever took an exam on that day wasn't attending and whoever did not take an exam probably was reading for an examination instead ... in fact it was very quiet in the building.
All talks were streamed live and recorded and are available on YouTube as a 1h30 video. Thanks to Jorge Castellano of ULPGC.

I noticed some shyness in the audience.. how can we, as a large project, bridge the gap and attract young fellow hackers who aren't that experienced and maybe didn't get in contact with a Free Software project yet? Anyhow, four students showed up during the days, all were interested in how to contribute something in Python. Apparently Python is quite popular.. so there's room for writing API unit tests, contribute to server infrastructure and some.

There's a list of achievements in the wiki, but no less important is the community building process. I'd like to see more local events to spread the word and attract interested developers, especially C++ hackers of course who'd like to work on application code. The next LibreOffice Hackfest will be at Paris, on June 27-28.

Concentrated hacking atmosphere.
Concentrated hacking atmosphere.

Alberto Ruiz from Red Hat with the dean of the IT faculty at ULPGC and LibreOffice hackers.
Alberto Ruiz from Red Hat with Fran Santana, the dean of the IT faculty at ULPGC, and LibreOffice hackers.

A special Thank You goes to Alberto Ruiz from Red Hat, who himself studied at the very same university, and Fran Santana, the dean of the IT faculty at ULPGC, who both collaborated closely to make all this happen. Fran's dedication and commitment in hosting this hackfest made it a great success. And of course a Thank You to the city of Las Palmas for choosing and using LibreOffice, which triggered the initial idea of having a hackfest at Las Palmas and lead to a great stay. We should do this again :-)