Welcome to The Document Foundation Planet

This is a feed aggregator that collects what LibreOffice and Document Foundation contributors are writing in their respective blogs.

To have your blog added to this aggregator, please mail the website@global.libreoffice.org mailinglist or file a ticket in Redmine.


Wednesday
11 November, 2020


face

It’s time for another batch of presentations and workshops from the recent openSUSE + LibreOffice Conference 2020! You can see them in the YouTube playlist, and here are the individual videos (apologies for the not-perfect audio in some places):

Marketing and social media in LibreOffice (Mike Saunders):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

openSUSE + LibreOffice Conference 2020: Recruiting for LibreOffice globally and locally through volunteer platforms (Ilmari Lauhakangas):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

The history and pre-history of LibreOffice (Michael Meeks):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

LibreOffice oss-fuzz, crashtesting, coverity (Caolán McNamara):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

Faster Jail Creation with Bind-Mount (Ashod Nakashian):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

The ODF TC GitHub (Svante Schubert):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

LibreOffice in your browser – WebAssembly & other neat hacks to make that happen (Thorsten Behrens):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

The ODF Toolkit (Svante Schubert):

Please confirm that you want to play a YouTube video. By accepting, you will be accessing content from YouTube, a service provided by an external third party.

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.

 

Implementation Detail (Stephan Bergmann):

Please confirm that


Tuesday
10 November, 2020


face

LibreOffice 7.0, released in August 2020, includes new branding elements for the splash screen and other places, thanks Bayu Rizaldhan Rayes and the Design team. Now Barbara Tostes has made a 3D model for use in Blender, so if you want to make a video or animation about LibreOffice, check it out!

And indeed, if you make any kind of video or tutorial and want us to spread the word, join our marketing mailing list or Telegram channel and say hello. Also take a look at the Design community’s work too. We love having more ideas and feedback!


Monday
09 November, 2020


face

In Impress while importing a table, there could be some situation that we have to shrink or scale table to fit in area. We have to decide how to change row heights while fitting in area. There were a problematic case that when we have text in row. Bug report is here:

How it should look: Row heights are equal and images seems in their cell

 

How was it looking before the fix: First two rows are smaller and empty rows seems bigger than actual. Total table height is bigger tan actual.

 



 

 

 

How it looks after the fix:


 




Patch link is here: https://git.libreoffice.org/core/+/b7b05dd36403af50b20fe06cbf8a10d8defb28a9%5E%21


Want to start using this?

You can get a snapshot / demo of Collabora Office and try it out yourself right now: try unstable snapshot. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF’s next release too (7.1).


face

LibreOffice is way more than just an office suite – it’s a worldwide project and community where people share ideas, build up their skills, and have fun. Today we’re talking to Arnaud Mez, who’s part of the Francophone community and who’s spreading the word about LibreOffice and helping with design…

To start, tell us a bit about yourself!

I’m from the Republic of Congo (the one with Brazzaville as its capital city :-) ). I’m the owner of a small venture called Smarty TC, based in the town of Pointe Noire, the city I live in.

My everyday tasks and duties are exactly similar to my hobbies, as I constantly fight to stay focused on doing only what I love… So I do a lot of reading and listening to music, but beyond that I do a lot of research on the internet in order to keep an average but updated knowledge base. I did sport years ago… ;-) like Taekwondo until I reached the black belt level, and life just swallowed me up into the more exiting side: computers.

My favourite musicians are Joshua Aaron and Paul Wilbur, but I also love Hebraic and Japanese music as they have strong and deep cultural riches. I don’t play games on my PC now and stopped playing on consoles, but my favourite games ever are Need for Speed Carbon, and the Zelda series starting from Ocarina of Time.

What’s the situation like with LibreOffice and free software in Congo? Is it widely used, or are there challenges to adoption?

Well, I’d be modest and say we are still close to zero in terms of spreading the word everywhere in our country. The Republic of Congo is mostly influenced by almost 70% of what happens in France, with fewer real openings to proper technology, support etc. which makes things a bit more difficult.

The main challenges are having local people well-trained in FOSS and LibreOffice. The more people who get trained in a serious way and get accredited, the more FOSS and LibreOffice will spread – people here trust papers such as certificates more than everything, because they constantly think about getting employed, more than building up themselves and providing services.

There are some initiatives here touching on IT and computing, but they’re led by people leading the retail industry, and most of them think about selling what they believe will bring more money – so less about growing people, if you get my point.

I decided to start my business after five years of being jobless, because I believe this: we have to stand up if we want to build up local competences. The more we train people, the more we encourage openness, and the more meetups we arrange, the more we create exposure. (Yes, I do some other types of lucrative work in my ventures, but I don’t teach or train people to use Microsoft Office, or keep my focus on it.)

You’re part


Friday
06 November, 2020


face

General Activities

  1. LibreOffice 7.0.2.1 was released on October 8 and LibreOffice 7.0.3.1 on October 29
  2. Meanwhile, LibreOffice 7.1 Alpha 1 was released on October 30, being the first pre-release of LibreOffice 7.1
  3. The openSuse + LibreOffice Conference was run from October 15 – 17. You can find many interesting talks about QA and Development here
  4. Thorsten Behrens (CIB) made tab pages scrollable and fixed a couple of build issues
  5. Miklos Vajna (Collabora) improved handling of direct formatting with pasted ODT & RTF content, fixed an indentation issue with bulleted lists in RTF documents, did internal pdfium-related improvements, fixed a problem with accidentally opening a file twice, improved handling of page breaks with DOCX import
  6. Luboš Luňák (Collabora) continued polishing the Skia graphics engine integration, improved graphics handling in many areas and reduced CPU load during slideshow animations
  7. Stephan Bergmann (Red Hat) made many cleanups as well as build and test fixes
  8. Ayhan Yalçınsoy fixed misplaced master password dialog and made some UI tweaks
  9. Noel Grandin (Collabora) improved the UI linter script, made XML parsing faster in various areas, fixed printing of very large font sizes and made many code cleanups
  10. Caolán McNamara (Red Hat) fixed inputting Japanese characters in Header and Footer dialog, bumped the minimum version of gtk to 3.20.0, made it so Impress transition duration time is set in seconds instead of milliseconds, allowed inserting page breaks to page numbers beyond 9999, made mouse cursors more precise with gtk3 backend. He also continued the crucial user interface backend work and did many cleanups and crash fixes
  11. Xisco Faulí (TDF) added dozens of UI and cppunit tests and improved existing tests
  12. Jan-Marek Glogowski improved Windows Arm64 support, Linux dark theme support and added a focus indicator for flat buttons in KDE
  13. Andreas Kainz improved the alignment and positioning of Sidebar and Notebookbar elements
  14. Jim Raykowski made it so Draw/Impress slide/page previews update immediately after a renaming operation, made Sidebar treeviews actually display their tree lines with non-gtk3 backends and improved Navigator expanding behaviour
  15. Tomaž Vajngerl (Collabora) improved PDF annotation import support
  16. László Németh (NISZ) made many change tracking fixes
  17. Balázs Varga and Tünde Tóth (NISZ) fixed many OOXML chart issues
  18. Mark Hung fixed problems with converting between traditional and simplified Chinese in Calc
  19. Eike Rathke (Red Hat) fixed Calc number format comment handling and made it so Calc inline arrays and functions returning array/matrix propagate array mode to functions calling them, fixed generation of references depending on Calc formula syntax used, fixed displaying of numbers formatted as fraction, added the ability to refer to local names in another worksheet to Calc INDIRECT function and fixed missing sheet prefix for local-scoped sheets upon inserting named ranges
  20. Mike Kaganski (Collabora) made code cleanups and optimisations
  21. Tor Lillqvist (Collabora) worked on the iOS app, did code cleanups and added initial support for building LibreOffice on Windows Subsystem for Linux
  22. Leo Wang improved graphics rendering

Wednesday
04 November, 2020


face

Many companies, non-profits, schools and other organisations around the world have switched to LibreOffice to avoid vendor lock-in and get back full control over their data. The Eyüpsultan Municipality reported from their migration to Linux and LibreOffice in recent years, which started in 2015:

This was a big decision, and it wasn’t made lightly. Open source technologies provide an important opportunity for our country to have an independent and secure information infrastructure. There are uncertainties about future terms and costs of using licensed software that connects users to a particular brand ecosystem. The more connected to these technologies we are, the harder it is to switch to alternative products. The commercial nature of key companies, to say nothing of pricing and licensing policies, poses significant risks.

As Eyüpsultan Municipality, we aimed to reduce service costs as well as external technology dependencies by using open source software, including the Pardus GNU/Linux operating system. Pardus was developed by the Turkish government as a desktop Linux distribution focused on graphical users in office settings. We wanted a solution that gave us an independent developer and increased sustainability, flexibility, and fiscal savings. In this respect, we consider our migration project to be a social responsibility. We are trying to create awareness of this goal by pioneering the use of Pardus in public institutions throughout Turkey.

Initial steps

The migration team knew from the start that it would be a major undertaking. They made sure to communicate with all workers in the municipality about their plans, and began by running training sessions with LibreOffice in the first phase. Then:

After the trainings, administrators installed the open source LibreOffice software to replace the licensed Microsoft Office software on all client computers. This decision to train users before installing the software minimized the problems they experienced when migrating from familiar software (including the operating system).

We didn’t stop there, though. We let people settle in with LibreOffice for a year, and in 2016, we repeated the training on Linux and LibreOffice. Once users passed an exam at the end of the training, we installed Linux on their computers. We provided re-education to those who didn’t pass the exam and then installed Linux upon success. So, the migration of the operating system began!

Even after the training, the migration team didn’t stop communicating with users – they checked in regularly to see what the workers were struggling with, and helped to fix them. In all, the team regards regular training as the most most significant reason for its success.

Introducing open source to your organisation

So, what else did they learn, and what would they say to other organisations or companies considering LibreOffice, Linux and other free and open source software?

Open source software has many advantages, including flexibility, high performance, major savings on licensing fees, independence from any particular company, and compliance with open standards. The benefits of open source software are recognized all over the world, especially in the European


Friday
30 October, 2020


face

You know the LibreOffice community work hard on the LibreOffice 7.1 Christmas release. Did you know that LibreOffice has 7 different UI Layouts? With the next release, our uses will be informed after the installation. Thanks to Heiko for the new dialog.

As all users get informed about the different UI layouts don’t forget to write a bug report, that everybody will have the best Office Suite. If you like my work become a

downloads_wordmark_white_on_coral2x.jpg

face

The LibreOffice Quality Assurance ( QA ) Team is happy to announce LibreOffice 7.1 Alpha1 is ready for testing!

LibreOffice 7.1 will be released as final at the beginning of February, 2021 ( Check the Release Plan ) being LibreOffice 7.1 Alpha1 the first pre-release since the development of version 7.1 started at the end of May, 2020. Since then, 5374 commits have been submitted to the code repository and more than 1100 bugs were set to FIXED in Bugzilla. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.1 Alpha1 can be downloaded from here for Linux, MacOS and Windows, and it can be installed alongside the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

For help, you can contact the QA Team directly in the QA IRC channel or via Telegram.

LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!

Happy testing!!

Download it now!


Thursday
29 October, 2020


face

So, let's continue to dissect these nice presentation templates from our Indonesian community. Download the same template as in previous article. Open it in LibreOffice Impress and look at first slide:

 

Try click somewhere on slide in area with rectangles. You can select any from these rectangles include the largest grey rectangle that author used as background for all composition. Its all are just shapes! This is an absolutely wrong way when you create a presentation template!

First, user shouldn't have an opportunity to select any slide background elements. This will interfere with and distract him from creating the presentation. User should understand clear that he can change only heading text on first slide of his future presentation. 

And second problem with these many shapes is its size. Every shape is an different object with own parameters, like position on page/slide, z-order, weight and height, area color/gradient, etc. and therefore every shape has a not small size.

The best way here is to create a background for your slide in another graphic software, like LibreOffice Draw in our case (or GIMP or Inkscape). Note, your image should have the same size as your future presentation template, like 16:9 or 4:3, or A4. Then save that image as PNG with the best quality somewhere on your PC.

A next step is to set up your image as background for a slide. There are several methods for it. Simpliest method is follow: open a Properties section in Sidebar. Press a "Insert image" button. Find and select your image in "Set background image" dialog and press "Open" button there. Voila! You have a slide background (I used another image and I before deleted all these shapes just for visibility):