LibreOffice: Advent Tip #22

form

LibreOffice has several hidden gems, ignored by the majority of the users. One of these gems is the creation of editable PDF forms, which is a rather comprehensive feature and not a simple tip (but after 20 days, even the most basic user is now a skilled LibreOffice user…).

I will try to summarize the feature, which is explained in brief in this short tutorial (PDF) and in detail in a chapter of the LibreOffice Writer Guide (PDF).

Starting from an empty Writer document, and activating the Form Control and (optionally) the Form Design Toolbars, the user can access a number of tools to design a complete form (text fields, option buttons, check boxes, etcetera, each one with a large number of options), which at the end can be saved as a PDF standard form compatible with all PDF readers.

This feature is extremely useful for public administrations and enterprises, and replaces – adding value – printed forms, as a PDF form can be easily filled in by any user.

Behind the scenes at TDF: NLP/L10n

_SDS5526LibOCon in Aarhus, Denmark, has been a really nice meeting especially for the L10n/NLP communities with a large workshop on the day before the opening of the conference. Even the whole afternoon was too short to discuss all the topics we had on the agenda. Around 40 persons from all over the world were attending the meeting. We have shared experiences and feedback, Christian has explained the new workflow with master and how branching is managed, and discussed some Pootle enhancements as well as other enhancements on coordination.

At the end of the meeting we discussed a specific issue with accelerators that are broken in some languages and specifically in languages using complex script layouts. This has led Niklas Johansson to develop a tool that detects duplicate use of accelerator keys in menus. This tool is of great help for all of us, translators, but also for our users and even more when accessibility matters. Thanks so much Niklas for this!

If you missed the conference, you’ll find all the videos of the talks on the TDF channel [1], there has been a whole track about localization, migrations and marketing. Italo has also organized marketing workshops dedicated to NLPs.

As a direct consequence of this meeting, we have opened a NLP channel on IRC, still too quiet in my opinion, don’t hesitate to join us and say hello! on Freenode #libreoffice-NLP, we will be happy to meet you there.

This meeting has also encouraged the Native Language projects to give more feedback on what they are doing locally, so far we have news about events in Korea, Turkey, Albania, India, Singapour, Sri Lanka… ans still feedback from the very active communities in Japan and in Italy where a first hackfest has been organized.

In more details, the Turkish community has participated to the DevFest in Istambul, giving an introduction on LibreOffice developments. I’d like to highlight the work done by Kader Tarlan who has written almost 50 new tests for MozTrap, and is currently working on porting java tests to python, a big big thank you to her!

The L10n community has extended its translations to some part of the tools we are using and has provided translations for Redmine and Ask in a very timely manner. I’m very happy to see the reactivity of our project especially during the translation sprint of the next version, namely the LibreOffice 5.1 release. This release has had a lot of changes in its off line help, it’s a very good thing (thanks a lot to Lera Goncharuk and Olivier Hallot!) but that means also a bunch of work for the localizers. Chandrakant Dhutadmal, representing the Centre for Development of Advanced Computing, has took the lead on several Indian languages in Pootle and will try to revive their localization, that’s a really nice initiative, thanks also to him.

I wish to all a happy holiday period and see you next year!

[1] https://www.youtube.com/channel/UCQAClQkZEm2rkWvU5bvCAXQ

LibreOffice: Advent Tip #21

Extensions — LibreOffice ExtensionsLibreOffice offers a large number of dictionaries for spell checking documents and presentations. They are available from the Extensions website, and can be searched by using one of the pre-configured selections (as shown in the picture).

Dictionaries can be recognized by the OXT file extension.

Once downloaded, dictionaries must be installed with the Extensions Manager (menu Tools > Extensions Manager). There is a PDF guide available to walk users through the entire process.

Behind the scenes at TDF: marketing and PR

italovignoli-cheersMarketing and PR at TDF are a very demanding task, as we are covering the entire world from a single point in Europe. It is a challenging role, and also a very rewarding one (because we continue to increase the project visibility with each announcement, and this is a testament to the quality of the software).

During the last six months, we have worked at two major announcements: the finalization of LibreOffice 5.0 announcement, which has been a success under any point of view, and has raised the visibility of LibreOffice over the other free office suites, and the preparatory work for the announcement of LibreOffice 5.1, which will be finalized in early February 2016.

In between, we have had the Aarhus Conference – with a number of community related announcements – and the 1,000th developer joining the project since 2010, a significant achievement for a project which until 2010 was considered one of the most difficult to contribute to, because of the size and the characteristics of the source code.

In July, we prepared the announcement, planned for August 5, 2015. Apart from drafting the usual press release, we developed a “road to LibreOffice 5.0” text and visual to underline the importance of our time based release schedule, and the key features of every previous major release.

In addition, a couple of weeks before the announcement, we started poking top editors for a pre-release conference call, to provide additional information to the people interested in offering some insights. Conference calls were scheduled both the week before the announcement and on the Monday and Tuesday before our Wednesday, August 5, announcement.

We organized two group conference calls, and one publisher specific conference call. On the day of the announcement, LibreOffice 5.0 received a large coverage, with a corresponding spike in donations and downloads. All in all, the launch of LibreOffice 5.0 was the most successful ever.

In September, we supported the LibreOffice Conference in Aarhus with the traditional “state of the project” presentation, plus several community related announcements (sent as press releases after the end of the conference).

In October, it was business as usual, i.e. the usual flow of LibreOffice releases updating the LibreOffice 4.4 “still” branch and the LibreOffice 5.0 “fresh” family. Each new release confirmed the uptake of donations, which have increased since the announcement of LibreOffice 5.0. This is probably also due to the growth of the awareness, based on a large number of articles in the media.

In November, we have started planning the LibreOffice 5.1 announcement, scheduled for early February 2016. The challenge is to outperform what we have achieved with the announcement of LibreOffice 5.0, which was a success. In order to improve results, we have planned a number of actions starting from December, when the first Release Candidate will be available.

In addition, we plan to produce several documents to describe LibreOffice 5.1 to specific user clusters, such as enterprises and individual users (which represent the majority of our users). Later on, we will try to add a document targeted to schools, where LibreOffice is rather popular.

To reach a wider media audience, we have also started to add other journalists to our mailing lists, and to purge the existing mailing lists from outdated or wrong addresses.

We have a total of over 13,000 journalists in our global and local mailing lists, which are becoming more accurate after the distribution of each press release. All people covering LibreOffice are cherry picked and added to a specific mailing list, which is becoming the core of our press release distribution system.

Stay tuned, exciting marketing times ahead of us.

LibreOffice: Advent Tip #20

noun_7771LibreOffice is the best free office suite ever, and is available thanks to the combined effort of a large global community, which is also providing professional and volunteer support to LibreOffice users.

LibreOffice enterprise users can obtain professional support services from certified developers (Level 3 Support for feature development or bug/regression fixes), certified migration professionals (project management for migrations or large deployments), and certified trainers (basic, intermediate or advanced trainings).

LibreOffice individual users can get volunteer support from community members, through different channels: the most popular are mailing lists and the Ask LibreOffice website.

LibreOffice: Advent Tip #19

donations.ods - LibreOffice Calc_006 donations.ods - LibreOffice Calc_007

LibreOffice Calc allows to show quite easily the top 10 values in a spreadsheet column with the AutoFilter function, which is activated with the menu Data > Filter > AutoFilter (image on the left). Once active, the function shows a down arrow in the first cell of each column, which opens a drop down menu with different options (image on the right). The third option from the top, after Sort Ascending and Sort Descending, is Top 10 (values).