The Guia do Writer 7.1 is finally here.

Translation courtesy of Timothy Brennan Jr.

Brazilian computer users in general, the community of Brazilian free software users and supporters, and of LibreOffice in particular, have received quite the gift today: the Brazilian LibreOffice documentation team proudly announces the publication of the Guia do Writer 7.1, the most complete Writer word processor guide for the best free software office suite, the LibreOffice Community.

The Guia do Writer 7.1 is an extensive 570-page volume covering the most advanced text-editing techniques, from simple typing of a page to assembling multi-volume documents, including electronic forms, illustrations, tables, indexes and summaries, automation and export to numerous file formats.

The guide is the LibreOffice Brazilian documentation team’s contribution to the public. The team has used automatic translation followed by a thorough manual review correcting terms, drafting and stylistics of the Portuguese language, as well as proofreading. While rereading the content, the team is able to check the accuracy of the techniques described in the documentation and review the terminology used in the software, signaling to the LibreOffice translation team the inconsistencies found in the interface suggesting improvements in terms, changes in the vocabulary of the commands and correction of the software Help Pages. This feedback has served to make the LibreOffice interface even more robust, consistent and has helped consolidate its command terminology.

The Guia do Writer 7.1 is available in three formats: The traditional PDF with adjusted pagination for those who want to print the guide and bind it, the source file in Open Document Format (ODF) for free editing, and the installed online version on The Document Foundation’s servers for reading on tablets, your desktop browser and — of course — on mobile phones.

“The importance of the  Guia do Writer is enormous. I suggest reading it for all who need to produce professional documents, as well as using the guide for creating courses, video classes, and even material for public tenders” says Olivier Hallot, coordinator of LibreOffice’s global documentation. “We are working on the LibreOffice Community ‘s manual library to provide the most advanced user guides for all LibreOffice modules, and, other volumes are on the way.” added Olivier.

The Brazilian  LibreOffice Community documentation team is made up of volunteers from all over Brazil (and one person in Ireland) and has been dedicated to producing the reference material in Brazilian Portuguese. The team includes (name and state or country) Vera Cavalcante (São Paulo), Luciana Mota (Distrito Federal), Márcia Buffon Machado (Ireland), Jackson Cavalcanti Jr. (Pernambuco), Raul Pacheco da Silva (São Paulo), Timothy Brennan Jr (Rio Grande do Sul), Túlio Macedo (Distrito Federal), Diego Peres Marques (Rio de Janeiro), Rafael Lima (Santa Catarina) and Olivier Hallot (Rio de Janeiro).

The Brazilian Guia do Writer 7.1 can be downloaded at https://documentation.libreoffice.org/pt-br/portugues   along with other volumes for Impress, Calc, Math and the Beginner’s Guide.

The original Writer Guide 7.1 can be downloaded at https://documentation.libreoffice.org/en/english-documentation/

LibreOffice 7.2 Community is strong on interoperability

Over 60% of code commits for the brand new version of the best free and open source office suite are focused on interoperability with Microsoft’s proprietary file formats

Berlin, August 19, 2021 – LibreOffice 7.2 Community, the new major release of the volunteer-supported free office suite for desktop productivity, is available from https://www.libreoffice.org/download. Based on the LibreOffice Technology platform for personal productivity on desktop, mobile and cloud, it provides a large number of interoperability improvements with Microsoft’s proprietary file formats. In addition, LibreOffice 7.2 Community offers numerous performance improvements in handling large files, opening certain DOCX and XLSX files, managing font caching, and opening presentations and drawings that contain large images. There are also drawing speed improvements when using the Skia back-end that was introduced with LibreOffice 7.1.

LibreOffice 7.2 is now available natively for Apple Silicon, a series of processors designed by Apple and based on the ARM architecture. Because of the early phase of development on this specific platform, binaries are provided but should not be used for any critical purpose at this stage. Software will be available from the following page: https://download.documentfoundation.org/libreoffice/stable/7.2.0/mac/aarch64/.

LibreOffice and Interoperability

LibreOffice 7.2 Community adds a significant number of improvements to interoperability with legacy DOC files, and DOCX, XLSX and PPTX documents. Microsoft files are still based on the proprietary format deprecated by the ISO in April 2008, and not on the ISO approved standard, so they embed a large amount of hidden artificial complexity. This causes handling issues with LibreOffice, which defaults to a true open standard format (the OpenDocument Format).

The LibreOffice community is happy to have many talented developers who are tackling these issues.

Thanks to the focused development activity from volunteer and sponsored developers, LibreOffice 7.2 takes a significant step forward in terms of transparent interoperability, while maintaining many advantages in terms of resiliency, robustness and compliance with standards – to the benefit of enterprise and individual users.

LibreOffice offers the highest level of compatibility in the office suite market segment, starting with native support for the OpenDocument Format (ODF) – beating proprietary formats in the areas of security and robustness – to superior support for DOCX, XLSX and PPTX files. In addition, LibreOffice provides filters for a large number of legacy document formats, to return ownership and control to users.

LibreOffice 7.2 Community New Features [1]

LibreOffice 7.2 Community’s new features have been developed by 171 contributors: 70% of code commits are from 51 developers employed by three companies sitting in TDF’s Advisory Board – Collabora, Red Hat and allotropia – or other organizations (including The Document Foundation), and 30% are from 120 individual volunteers.

In addition, 232 volunteers have provided localizations in 151 languages. LibreOffice 7.2 Community is released in 119 different language versions, more than any other free or proprietary software, and as such can be used in the native language (L1) by over 5.4 billion people worldwide. In addition, over 2.3 billion people speak one of those 119 languages as their second language (L2).

GENERAL

• Popup list to search for menu commands
• Scrollable style picker in the NotebookBar
• Fontwork panel in the Sidebar
• New list view for the templates dialog
• Built-in “Xray”-like UNO object inspector

WRITER

• Background fills can cover whole pages, beyond margins
• Page styles can now have a gutter margin
• Mail merge shows a warning about nonexistent data sources
• RDF metadata in Style Inspector
• Custom color metadata field shadings

CALC

• Calc now can filter by color in AutoFilter
• HTML tables listed in the External Data dialogue now show captions
• “Fat cross” cursor available in the options
• Type can be selected in “Moving Average” trend lines

IMPRESS & DRAW

• New templates: Candy, Freshes, Grey Elegant, Growing Liberty, Yellow Idea
• Multiple columns now available in text boxes
• Direct access to the scaling factor via the status bar

A video summarizing the top new features in LibreOffice 7.2 Community is available on YouTube: https://www.youtube.com/watch?v=cWmURg_rM2o and PeerTube: https://peertube.opencloud.lu/videos/watch/d9413c81-a568-4a0e-b570-6200fc1d062c.

LibreOffice for Enterprises

For enterprise-class deployments, TDF strongly recommends the LibreOffice Enterprise family of applications from ecosystem partners – for desktop, mobile and cloud – with a large number of dedicated value-added features. These include long-term support options, professional assistance, personalized developments and other benefits such as SLA (Service Level Agreements): https://www.libreoffice.org/download/libreoffice-in-business/.

Despite this recommendation, an increasing number of enterprises are using the version supported by volunteers, instead of the version optimized for their needs and supported by the different ecosystem companies.

Over time, this represents a problem for the sustainability of the LibreOffice project, because it slows down the evolution of the project. In fact, every line of code developed by ecosystem companies for their enterprise customers is shared with the community on the master code repository, and improves the LibreOffice Technology platform.

Products based on LibreOffice Technology are available for major desktop operating systems (Windows, macOS, Linux and Chrome OS), for mobile platforms (Android and iOS), and for the cloud. Slowing down the development of the platform is hurting users at every level, and may ultimately lead to a stagnation of the LibreOffice project.

Migrations to LibreOffice

The Document Foundation has developed a Migration Protocol to support enterprises moving from proprietary office suites to LibreOffice, which is based on the deployment of an LTS version from the LibreOffice Enterprise family, plus migration consultancy and training sourced from certified professionals who offer CIOs and IT managers value-added solutions in line with proprietary offerings. Reference: https://www.libreoffice.org/get-help/professional-support/.

In fact, LibreOffice – thanks to its mature codebase, rich feature set, strong support for open standards, excellent compatibility and long-term support options from certified partners – represents the ideal solution for businesses that want to regain control of their data and free themselves from vendor lock-in.

Availability of LibreOffice 7.2 Community

LibreOffice 7.2 Community 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.12.

Change Logs: https://wiki.documentfoundation.org/Releases/7.2.0/RC1 (RC1), https://wiki.documentfoundation.org/Releases/7.2.0/RC2 (RC2), https://wiki.documentfoundation.org/Releases/7.2.0/RC3 (RC3).

LibreOffice Technology-based products for Android and iOS are listed here: https://www.libreoffice.org/download/android-and-ios/, while for App Stores and ChromeOS are listed here: https://www.libreoffice.org/download/libreoffice-from-microsoft-and-mac-app-stores/.

For users whose main objective is personal productivity, and therefore prefer a release that has undergone more testing and bug fixing over the new features, The Document Foundation maintains the LibreOffice 7.1 family, which includes some months of back-ported fixes. The current version is LibreOffice 7.1.5.

The Document Foundation does not provide technical support for users, although they can get it from volunteers on user mailing lists and the Ask LibreOffice website: https://ask.libreoffice.org.

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

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

[1] Release Notes: https://wiki.documentfoundation.org/ReleaseNotes/7.2.

Press Kit

Download link: https://nextcloud.documentfoundation.org/s/AgY6G3WAAtsCZrn.

Open Badges for awesome Czech documentation contributors!

LibreOffice’s documentation team is driven by volunteers around the world. Today, we want to say a special thanks to members of the Czech LibreOffice community, who’ve worked hard to translate and proof-read the software’s documentation.

So we’re sending out Open Badges – special, customised badges with embedded metadata, describing their achievements. The badges can be verified using an external service, and are a great way to show off contributions and use as proof of participation.

So, here are the badge recipients – we’re sending them out personally:

  • Translators: Petr Kuběj, Radomír Strnad and Zdenek Crhonek
  • Proof-readers: Petr Valach and Marcela Tomešová
  • Czech screenshots: Roman Toman
  • Git and OmegaT maintenance, machine translations, chapters cleaning and tools support: Miloš Šrámek

Huge thanks to all recipients – check your inbox for your badges!

Meanwhile, here’s a quick history of recent Czech guide translations:

Fixing an Interoperability Bug in LibreOffice: Missing Lines from DOCX (part 3/3)

By Hossein Nourikah, Developer Community Architect at The Document Foundation

In LibreOffice, interoperability is considered a very important aspect of the software. Today, LibreOffice can load and save various file formats from many different office applications from different companies across the world. But, bugs are inevitable parts of every software: there are situations where the application does not behave as it should, and a developer should take action and fix it, so that it will behave as it is expected by the user.

What if you encounter a bug in LibreOffice, and how does a developer fix the problem? In these series of articles, we discuss the steps needed to fix a bug. In the end, we will provide a test and make sure that the same problem does not happen in the future, again.

The article is presented in three parts:

  1. Understanding the Bugs and QA
  2. Developing a Bug Fix
  3. Writing the Tests and Finishing the Task

This is the third part.

3. Writing the Tests and Finishing the Task

So, if you have read the two previous parts on “Fixing an Interoperability Bug: Missing Lines in Save and Load” (part 1, part 2), this is the third and last part of these series. In this part, we discuss how to write a test, submit the patch to the Gerrit and try to get it incorporated into the LibreOffice code.

3.1. Writing a Test for the Regression

In order to make sure that this regression will not happen again, we should create test for every bug that is fixed. If we don’t do this, there is a big chance that this bug will occur again and again.

But how to start writing a test? The answer is that there are ~3000 tests available in sw/qa/extras/ folder, and there is a tiny document sw/qa/extras/README that describes them. These tests can be a basis for writing a new test. For example, test for tdf#91687 consist of these lines:

DECLARE_WW8EXPORT_TEST(testTdf91687, "tdf91687.doc")
{ // Exported Watermarks were resized
 uno::Reference xWatermark = getShape(1);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(5172), xWatermark->getSize().Height);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(18105), xWatermark->getSize().Width);
}

It uses a macro DECLARE_WW8EXPORT_TEST too, that checks some properties of the document after loading it, and then again after saving and reloading it. If some property is erroneously changed, the test will fail, and you will get noticed.
As you can see, the name of the test, and the name of the test document in which here is .doc file, come from the bug number.

The test for this regression should check for the position and size of the shapes, so there are similarities between the our desired test and the test above. But how can we find the properties of the elements of the document? The answer is the new UNO object inspection tool for the LibreOffice:

https://blog.documentfoundation.org/blog/2021/03/02/update-on-tender-for-a-built-in-uno-object-inspection-tool-in-libreoffice/

As can be seen in figure 1, the size for Shape7 which is the first vertical line, is visible on the right.

In previous versions, tools called XRAY or MRI were used for object inspection.

Figure 1. UNO object inspection tool for the LibreOffice

The completed test comes below. It takes Shape7, Shape8 and Shape9 which are the three vertical lines, and ensures that they have the same size in the first load, and after save and reload. Without the fix, some of these test fail, which are size checking for the first and last vertical lines. Their size was reduced to ~0, so it is justifiable that previously they were erroneously disappearing after save and reload. The test passes after applying the fix.

DECLARE_WW8EXPORT_TEST(testTdf123321, "shapes-line-ellipse.doc")
{
 // These are the 3 lines in which 1st and 3rd one were
 // disappearing before
 uno::Reference<drawing::XShape> l1 = getShape(7);
 uno::Reference<drawing::XShape> l2 = getShape(8);
 uno::Reference<drawing::XShape> l3 = getShape(9);
 // first line (smallest)
 // Fails without the fix: Expected: 423, Actual: 2
 CPPUNIT_ASSERT_EQUAL(sal_Int32(423), l1->getSize().Height);
 // Fails without the fix: Expected: 0, Actual: 2
 CPPUNIT_ASSERT_EQUAL(sal_Int32(0), l1->getSize().Width);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(7908), l1->getPosition().X);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(37), l1->getPosition().Y);
 // second line (larger)
 CPPUNIT_ASSERT_EQUAL(sal_Int32(2542), l2->getSize().Height);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(2), l2->getSize().Width);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(7916), l2->getPosition().X);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(289), l2->getPosition().Y);
 // third line (largest)
 // Fails without the fix: Expected: 7027, Actual: 2
 CPPUNIT_ASSERT_EQUAL(sal_Int32(7027), l3->getSize().Height);
 // Fails without the fix: Expected: 0, Actual: 2
 CPPUNIT_ASSERT_EQUAL(sal_Int32(0), l3->getSize().Width);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(7911), l3->getPosition().X);
 CPPUNIT_ASSERT_EQUAL(sal_Int32(231), l3->getPosition().Y);
}

As you can see, not all the tests fail without the fix, but they are in place to protect the correct load and save of the shapes in the future.

3.2. Cleaning up and Submitting the Changes

After we finished the fix, we commit the changes, and submit it to the LibreOffice Gerrit.

$ git add include/svx/svdopath.hxx svx/source/svdraw/svdopath.cxx sw/qa/extras/ww8export/data/shapes-line-ellipse.doc sw/qa/extras/ww8export/ww8export2.cxx

$git commit

Let’s see our latest commit:

$ git show --name-only

Author: Hossein <hossein@libreoffice.org>
Date:   Mon Jul 19 13:03:42 2021 +0200

    tdf#123321 Fix DOC/DOCX export bug which made some lines disappear
    
    * Fix the wrong calculation of SdrPathObj (line) extent while exporting
      to .doc and .docx formats. This resolves tdf#123321 which cause some
      lines to disappear after save and reload. This fix does not break
      tdf#91687
    * added tests to make sure this does not happen again, based on the
      .doc file provided in Bugzilla
    * Loading the bad exported file in MS Word is OK, but it does not work
      in LibreOffice, and some of the lines will be hidden. This needs
      additional work.
    
    The regression came from d72e0cadceb0b43928a9b4f18d75c9d5d30afdda
    
    Change-Id: Ic5a7af4d29df741204c50590728542e674ee9f91

include/svx/svdopath.hxx
svx/source/svdraw/svdopath.cxx
sw/qa/extras/ww8export/data/shapes-line-ellipse.doc
sw/qa/extras/ww8export/ww8export2.cxx

The actual commit information is lengthy, but for making it shorter, we only listed the name of the changed or new files. Then, we submit the patch:

$ ./logerrit submit master

This is with the assumption that we have successfully configured Gerrit before. One should set up Gerrit before doing this. A step-by-step manual is presented in The Document Foundation Wiki.

https://wiki.documentfoundation.org/Development/gerrit/setup

3.3 Getting the Submission Merged

Every submission to the Gerrit is reviewed by one or more developers, and is possibly gets merged into to the code after the submitter has done all the requested fixes and improvement. This is done by the decision one of the people with commit access. Commit access is granted to the developers who had a good record of contributions and are trusted to change the code base directly.

So, the code is reviewed in the Gerrit:

https://gerrit.libreoffice.org/c/core/+/119116

Every submitted code is built automatically by Jenkins in a process called CI (continues integration). If the build is successful, you will get a     Verified +1     from Jenkins.

If, for any reason, one of the builds for several platforms that is tested fails, you will get     Verified -1     from Jenkins. Then, you will have to fix the problem and re-submit again. Please note that there are situations that some tests fail because of the Jenkins problem itself. If that is the case, you should ask people in the #libreoffice-dev irc channel to invoke a resume for you, or try rebasing to initiate a rebuild.

The original submission (patch set 1) lacked the tests, so a test was requested. After doing the improvements, including a change in the title and uploading seven patch sets in total, it was given the   Code Review +2   from the reviewer. Here, Miklos Vajna from Collabora has done the reviews and merging.

Then, the proposed changes eventually got merged into the code by the reviewer with appropriate access. After that, everyone can pull the changes from Git:

https://git.libreoffice.org/core/+/bda4d7a7c3fcc259e023f568606be5dcba818db9

3.4 Marking the Bug as Fixed

After the commit is done, the journey ends with marking the bug as fixed. Looking at the other possible registrations of the symptoms at TDF Bugzilla, it turns out that another bug can be considered a duplicate of this one:

Bug 127296 – FILESAVE: DOC Rotated line loses rotation when saved

https://bugs.documentfoundation.org/show_bug.cgi?id=127296

It is reported in 2019-09-02, and it is newer than the one we have fixed. So, we can mark tdf#127296 as a duplicate of this one. After that, we can safely change the status of tdf#123321 to “RESOLVED FIXED”, and we’re done!

3.5 Want to Get Involved?

If you want to get involved in Libreoffice development, you can help in fixing the bugs. Looking at the statistics from TDF’s Bugzilla, we see that there is a total of ~12k open bugs, in which ~1.3k of them are regressions. Among them, around 1.1k are bibisected. They are more suitable for getting into, because the root of the problem is known to some extent.

You can go through the same process that was discussed in the series of articles here to fix the bugs and submit your patch, and if you had any questions, #libreoffice-dev is a good place to ask. Also, it is suggested that you join the LibreOffice development mailing list. See the instructions here.


Hossein Nourikhah is the Developer Community Architect at the The Document Foundation (TDF), the non-profit behind LibreOffice. If you need assistance getting started with LibreOffice development, you can get in touch with him:

E-Mail: hossein@libreoffice.org

IRC: hossein in the IRC channel #libreoffice-dev on the Libera.Chat network connect via webchat

Community Member Monday: Jessé Moreira

Love LibreOffice too? Want to help us spread the word about it, and other free and open source software (FOSS) projects? Then we appreciate your help! Everyone can raise awareness about the importance of FOSS and open standards, like the OpenDocument Format, LibreOffice’s native format.

For instance, Jessé Moreira from the Brazilian Portuguese LibreOffice community has created a set of tutorial videos. Here’s what he has to say:

Hello! I am a high school math teacher. I love LibreOffice and make videos demonstrating educational software applications. I have a channel that talks about libreoffice in Portuguese on Odysee and YouTube.
I intend to continue promoting LibreOffice by recording videos and contributing to the incredible project. Greetings from Brazil!

Thanks, Jessé! We have more videos created by other community members too. Recently, we talked to Harald Berger from the German community about how he makes his tutorials. To anyone reading this who also wants to contribute videos in their language, drop us a line and let’s work together!

And one more thing: Jessé recently became a Member of The Document Foundation, the non-profit entity behind LibreOffice. This means that he can help to steer the project and vote for the Board of Directors, amongst other things. All LibreOffice contributors are welcome to become Members and help us to keep doing awesome things:

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 importance of LinkedIn Pages for the LibreOffice Project

LinkedIn has reached the number of 750 million subscribers worldwide, and is now the best social media to support products, as it is used by almost 100% of enterprises (click on the above thumbnails to see the full image). The Document Foundation has launched the foundation and the LibreOffice LinkedIn pages a while ago, followed in late 2020 by the LibreOffice Enterprise LinkedIn page. These pages have grown organically during the years to reach respectively 1,169, 1.055 and 197 followers. It is now time to leverage the effective potential of these content resources for the growth of the project, especially in areas which are not directly related to the FOSS ecosystem.

We need the help of TDF and community members to grow the number of people subscribed to these pages, and to add contents about community activities, product development, migrations, large enterprise deployments, and the open document format. In general, community activities should be published on The Document Foundation page, product development and open document format news on the LibreOffice page, migrations and large enterprise deployments on the LibreOffice Enterprise page. We are happy to receive your content suggestions, and to put them online.

In addition, if you are not yet a LinkedIn member, you should create your own profile and link it to The Document Foundation and LibreOffice, as this will increase the relevance of the pages, and this will attract subscribers from other FOSS projects and also from outside FOSS projects.

The Document Foundation LinkedIn page
To go to the page and subscribe, click on the image
LibreOffice LinkedIn page
To go to the page and subscribe, click on the image
LibreOffice Enterprise LinkedIn page
To go to the page and subscribe, click on the image