Community Member Monday: Sam Tuke

Over the last few years we’ve posted many LibreOffice contributor interviews on this blog. Today, we catch up with Sam Tuke who is a member of the marketing community and helps out with QA too…

Where do you live, and are you active on IRC/social media?

I live in Berlin, Germany. Originally I’m from Suffolk, England. I like Twitter and Mastodon for community news. For my business, which makes Free Software newsletter app phpList, I use Facebook and Telegram too.

In which areas of the LibreOffice project are you active?

The marketing team, and filing occasional bugs.

How did you get involved with LibreOffice?

While in high school I started a small business building computers for local people. They needed an office suite to come with their new PCs, and OpenOffice.org was the perfect fit. I’ve been a user and advocate ever since, following my friends to LibreOffice when it was established.

Later on I became a full time Free Software developer, and after that a campaigner. From 2014 I worked on marketing LibreOffice-related products at Collabora. It was an exiting time and I had the opportunity to announce LibreOffice for Android and LibreOffice Online.

What was your initial experience of contributing to LibreOffice like?

Much like other open source apps: find and use a complicated bug tracker to report an annoying problem. But I was encouraged by quick follow up by a friendly bug triager, and since then several issues that I reported have been fixed and released. Satisfying!

What does LibreOffice need most right now?

Marketing. It’s a brilliant software suite which offers great potential value to most people alive today, particularly when you consider the mobile and web-based products. Reaching all those people who stand to benefit from LibreOffice is hard work, but it’s worth doing. Italo Vignoli and Mike Saunders have been making strides in this direction, and that’s fantastic to see.

Also: focus. With so many different kinds of users out there, LibreOffice can suffer from being too powerful for it’s own good. LibreOffice has had the benefit of contributions from a variety of usability experts and professionals. There’s plenty more to do, but recent releases, and particularly LibreOffice 6.1 include gratifying improvements from Kendy, Heiko, Andreas and others, which I’m eager to see.

What tools do you use for your work?

Markdown everywhere: Gedit, Writer, Nextcloud notes, and Pandoc to convert between them. Sometimes I also use Thorsten’s odpdown to make presentations.

Calc handles internal financial reporting at the firm, with many charts, and a few arcane formulas which LibreOffice fortunately includes. Draw is great for quick colourful diagrams like server infrastructure and organisational charts.

What do you do when you’re not working on LibreOffice?

Since finishing a Master’s degree in spring I’ve become a mentor of startups in West Africa, and had time so speak at more Free Software conferences at home and abroad. In order to keep up with new interns at work I’ve also been reading textbooks on marketing and security – perfect for long sunny evenings in the park.

Thanks Sam! Stay tuned to the blog for more interviews. In the meantime, if you’re new to the LibreOffice project and want to help us make it even better, start here!

Taming LibreOffice 6.1’s New Help System

or… the Help must help.

LibreOffice 6.1 has been released and carries a refactored and improved new Help system, based on modern browser technologies. Let’s explore what this new help brought to LibreOffice.

The main driver of the new Help is our vision that the Help must help. When we look at the old help system from the perspective of a typical user, we realize quickly that the text and layout of the help pages don’t provide the best experience. So how can we improve the experience and help our users better? The diagnostic was straightforward: the LibreOffice Help system was tied to a very limited technology, so we had to unleash LibreOffice Help.

The approach was to look at the capabilities of modern browser technologies of 2018, and compare them to the aging help system that relied on 2000’s web standards. Until LibreOffice 6.1, the local help consisted of static description text, very few images, no multimedia and almost no easy support for evolution and improvements.

(more…)

The Document Foundation announces LibreOffice 6.1, a major release which shows the power of a large and diverse community of contributors

Berlin, August 8, 2018 – The Document Foundation announces LibreOffice 6.1, the second major release of the LibreOffice 6 family presented in January 2018, with a significant number of new and improved features:

  • Colibre, a new icon theme for Windows based on Microsoft’s icon design guidelines, which makes the office suite visually appealing for users coming from the Microsoft environment;
  • A reworked image handling feature, which is significantly faster and smoother thanks to a new graphic manager and an improved image lifecycle, with some advantages also when loading documents in Microsoft proprietary formats;
  • The reorganization of Draw menus with the addition of a new Page menu, for better UX consistency across the different modules;
  • A major improvement for Base, only available in experimental mode: the old HSQLDB database engine has been deprecated, though still available, and the new Firebird database engine is now the default option (users are encouraged to migrate files using the migration assistant from HSQLDB to Firebird, or by exporting them to an external HSQLDB server);
  • Significant improvements in all modules of LibreOffice Online, with changes to the user interface to make it more appealing and consistent with the desktop version,
  • An improved EPUB export filter, in terms of link, table, image, font embedding and footnote support, with more options for customizing metadata;
  • Online Help pages have been enriched with text and example files to guide the users through features, and are now easier to localize.

LibreOffice 6.1’s new features have been developed by a large community of code contributors: 72% of commits are from developers employed by companies sitting in the Advisory Board like Collabora, Red Hat and CIB and by other contributors such as SIL and Pardus, and 28% are from individual volunteers.

In addition, there is a global community of individual volunteers taking care of other fundamental activities such as quality assurance, software localization, user interface design and user experience, editing of help system text and documentation, plus free software and open document standards advocacy at a local level.

A video summarizing the top new features of LibreOffice 6.1 is available on YouTube: https://www.youtube.com/watch?v=JvoCpnwGNFU.

Enterprise deployments

LibreOffice 6.1 represents the bleeding edge in term of features for open source office suites, and as such is targeted at technology enthusiasts, early adopters and power users.

For any enterprise class deployment, TDF maintains the more mature LibreOffice 6.0, which should be sourced from a company providing a Long Term Supported version of the suite (they are all members of TDF Advisory Board, and are listed here: http://www.documentfoundation.org/governance/advisory-board/).

Also, value-added services for migrations and trainings, to support enterprise class deployments in large organizations, should be sourced from certified professionals (list available here: http://www.libreoffice.org/get-help/professional-support/).

LibreOffice is deployed by large organizations in every continent. A list of some large or significant migrations announced in the media is available on the TDF wiki: https://wiki.documentfoundation.org/LibreOffice_Migrations.

Availability of LibreOffice 6.1

LibreOffice 6.1 is immediately available from the following link: https://www.libreoffice.org/download/. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.9. Builds of the latest LibreOffice Online source code are available as Docker images: https://hub.docker.com/r/libreoffice/online/.

LibreOffice Online is fundamentally a server service, and should be installed and configured by adding cloud storage and an SSL certificate. It might be considered an enabling technology for the cloud services offered by ISPs or the private cloud of enterprises and large organizations.

LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at https://www.libreoffice.org/donate.

LibreOffice 6.1 is built with document conversion libraries from the Document Liberation Project: https://www.documentliberation.org.

Press Kit

The press kit, with background documents – Hybrid PDF, opened from within LibreOffice can be edited as normal ODT files – and high-resolution images, is here: https://nextcloud.documentfoundation.org/s/3B8ZecMNMcWcxHy.


LibreOffice 6.1: a background on the user interface

For the last eight years, LibreOffice’s user interface guidelines have been inspired by a consistent end-user-driven and context-based approach (according to the available screen real estate, the application and the specific task), to provide the best mix between power (the level of control over features) and simplicity (the number of options available on the screen).

The Design Team at The Document Foundation has made several changes to the different icon styles for LibreOffice 6.1, to improve the visual appearance of the office suite and provide a more consistent look and feel with operating systems and desktop environments.

Colibre, a completely new icon style designed from scratch by the Austrian volunteer Andreas Kainz, is now the default on Windows. Colibre is entirely based on icon design guidelines from Microsoft, which means that the style uses the same color scheme as Microsoft Office and offers a consistent look and feel with the proprietary office suite. The design of each icon has been inspired by Breeze and Elementary.

Karasa Jaga, a new icon style originally created for Sundara OS and designed by the Indonesian volunteer Rizal Muttaqin, has also been added. Karasa Jaga, which means “feel the future” in the Sundanese language spoken in western Java, has been heavily inspired (and is derived) from the now discontinued Oxygen icon style.

Elementary is now the default icon style on Gnome-based desktop environments, while Sifr has replaced HiContrast as the default high contrast icon style.

Industrial and Oxygen have been removed because of missing maintenance and SVG support. All legacy icon styles are available as extensions.

In addition, the Notebookbar – which is still experimental – has been significantly improved and has been completed for Writer, while it is still work in progress for the other modules in the suite. The objective is to provide a solution as powerful and simple as the current default LibreOffice user interface, which is based on toolbars.

Looking forward, it looks like LibreOffice user interface – for which the source code is available on our repository at https://github.com/LibreOffice – has inspired the future evolution of some proprietary office suites, which in the last 10 years have chosen a different – and obviously obfuscated – approach.


Contributors to LibreOffice 6.1

LibreOffice 6.1 represents the global effort of a large and diverse community of enterprise-sponsored and volunteer contributors.

This is a list of the people who have contributed a new feature or an improvement to the software or the user interface, or a new localization.

Adolfo Jayme Barrientos
Andrea Gelmini
Andreas Kainz
Armin Le Grand, CIB
Ashod Nakashian, Collabora
Ayaspell
Belkacem Mohammed
Berend Ytsma
Caolán McNamara, Red Hat
DaeHyun Sung
Dennis Francis, Collabora
Dennis Roczek
Eike Rathke, Red Hat
Furkan Tokac
Gabor Kelemen
Gülşah Köse, Pardus
Heiko Tietze
Henry Castro, Collabora
Ilmari Lauhakangas
Jan Holešovský, Collabora
Joseph S. Maza
Kohei Yoshida
Kompilainenn
László Németh, FSF.hu
Lera Goncharuk
Luboš Luňák, Collabora
Marco Cecchetti, Collabora
Mark Hung
Maxim Monastirsky
Merzouk Ouchenem
Michael Meeks, Collabora
Michael Stahl, CIB
Michael Wolf
Mike Kaganski, Collabora
Miklos Vajna, Collabora
Muhammet Kara, Pardus
Nabil Semɛun
Nithin Kumar Padavu
Olivier Hallot, TDF
Pranav Kant, Collabora
Rizal Muttaqin
Samuel Mehrbrodt, CIB
Serge Krot, CIB
Slimane Amiri
Sophia Schröder
Stanislav Horáček
Stephan Bergmann, Red Hat
Szymon Kłos, Collabora
Tamás Bunth, Collabora
Tomaž Vajngerl, Collabora
Tor Lillqvist, Collabora
V. Stuart Foote
Yasin Bouklif
Yazid Bouhamam
Yousuf Philips
Xisco Faulí, TDF

Of course, the release of LibreOffice 6.1 has been possible thanks to the invaluable contributions of many other people, who have donated their time for user interface design and user experience improvements, localization in over 100 different languages, quality assurance, documentation and online help, and other product related activities, including marketing and communications.

In addition, many other people have supported end users on mailing lists, online resources and social media, answering questions and providing guidance to solve any kind of issue, from a simple download query to the most sophisticated pivot table questions.

LibreOffice 6.0 Writer Guide

LibreOffice Documentation Team has just released the LibreOffice 6.0 Writer Guide, with a general Introduction to LibreOffice Writer followed by the following chapters: Working with Text (basics), Working with Text (advanced), Formatting Text, Formatting Pages (basics), Formatting Pages (advanced), Print Export Email, Introduction to Styles, Working with Styles, Templates, Images & Graphics, Lists, Tables of Data, Mail Merge, TOCs Indexes Biblios, Master Documents, Fields, Forms, Spreadsheets Charts Objects, Setting Up Writer and Customizing Writer, for a total of 448 pages.

LibreOffice 6.0 Writer Guide is available from TDF Wiki as ODT and PDF, both the complete book and individual chapters, and from ODF Authors as ODT of individual chapters.

LibreOffice 6.0 Writer Guide is also available as a printed book from Lulu, by Friends of Open Document Inc., an Australia-based volunteer organisation with members around the world which will be using profits from the sale to benefit the LibreOffice community.

DBMS migration in LibreOffice

In 2017, The Document Foundation (TDF) launched four tenders aimed at improving LibreOffice in several strategic areas, and documenting the approach and work carried out, to foster sharing of knowledge and inclusion of the wider volunteer community.

One of the tenders was focused on the implementation of a HSQLDB binary format import in LibreOffice (https://blog.documentfoundation.org/blog/2017/05/04/tender-implement-hsqldb-binary-format-import-libreoffice-201705-03/), and after a careful evaluation by the Foundation’s Board of Directors – with the help of competent and independent volunteers – has been assigned to Collabora.

Tenders are funded by donations, and are supposed to improve LibreOffice in specific areas where the tasks are beyond the capabilities of independent volunteer developers, and also share the knowledge amongst the volunteer community to foster active participation in development and related tasks.

Collabora has developed a mechanism to import database files with high fidelity from the HSQLDB binary file format, used by many existing ODB files, by reading the Java serialization code, and writing a filter to import all data into LibreOffice Base. The objective was to remove the legacy Java/HSQLDB database and to simplify the move to Firebird.

Tamás Bunth, the Hungarian software engineer working at Collabora who has worked at the tender, has extensively reported about the progress and the results on his personal blog:

  1. DBMS migration in LibreOffice: Firebird and HSQLDB schema import
  2. DBMS migration in LibreOffice: HSQLDB binary import
  3. Final steps of LibreOffice database migration
  4. Database migration in LibreOffice: bug fixes and more

The feature is going to be released with LibreOffice 6.1, as an experimental one (to allow some further testing before being officially released with LibreOffice 6.2). So, to access it users have to flag the “enable experimental features” option in Tools > Options > LibreOffice > Advanced. If the option is not enabled, the embedded HSQLDB database engine remains the default for new Base files with LibreOffice 6.1, as in any previous version.

If experimental mode is enabled, the embedded Firebird database engine will not only be enabled but will also become the default, while the embedded HSQLDB database engine – although deprecated – will still be available as an alternative.

LibreOffice Base users are encouraged to migrate their database using the embedded HSQLDB to embedded Firebird new migration assistant (released with LibreOffice 6.1 as part of the tender), which is not using the HSQLDB database engine and will be available in LibreOffice releases even after the embedded HSQLDB support will be fully removed.

At the same time, LibreOffice Base users who want to stick with the HSQLDB database engine should start planning the migration of their database to an external HSQLDB server.

LibreOffice at OSCON in Portland

OSCON is the largest open source conference and exibition in the United States. The event has returned to Portland to celebrate its 20th anniversary on July 18/19, 2018, after a couple of years in Austin, Texas. The Document Foundation was given a free booth in the Non Profit Pavilion, and was represented by three enthusiastic volunteers – Robinson Tryon and Robin Haberman from the US, and Eric Bright from Canada – who had lots of good conversations with everyone from long-term users and supporters of LibreOffice, to those who were new to the whole concept of FOSS.

TDF participation at OSCON, as in other events, was possible thanks to our generous donors, who support the project development with their financial support.