Tender to finish transition of LibreOffice to ODF 1.3 (ODF 1.3 delta) (#202010-01)

The Document Foundation (TDF) is the charitable entity behind the world’s leading free/libre open source (FLOSS) office suite LibreOffice. We are looking for an individual or company to finish transition of LibreOffice to ODF 1.3 (ODF 1.3 delta). This tender builds on the previous ODF 1.3 tender and aims to implement additional features. The work has to be developed on LibreOffice master, so that it will be released in the next major version. The following required features (section A) need to be implemented: chart:data-label-series. Missing feature. It is needed for import from Excel. Relevant bugs in TDF’s Bugzilla: #94235, #133176 OASIS reference: OFFICE-2117 chart:regression-moving-type. Implementation of types “center” and “average-abscissa” is missing. It is needed for interoperability with Gnumeric. For this feature, there is existing code that can be extended. Relevant bug in TDF’s Bugzilla: #133423 OASIS reference: OFFICE-3959 <text:index-entry-link-start> and <text:index-entry-link-end> in user-index. The link marks exist, but the function itself is not implemented. For this feature, there is existing code that can be extended. Relevant bug in TDF’s Bugzilla: #121842 OASIS reference: OFFICE-3941 The following are desirable features (section B): draw:fill for background of pages. Attribute draw:background-size specifies whether a background fill covers the entire page or only

LibreOffice and Google Summer of Code 2020: The results

This year, LibreOffice was once again a mentoring organization in the Google Summer of Code (GSoC) a global programme focused on bringing more student developers into free and open source software development. We ran six projects – and all were finished successfully. Students and mentors enjoyed the time, and here we present some of the achievements, which should make their way into LibreOffice 7.1 in early February 2021! You can experiment with the new functionality by using daily builds and report any problems in our bug tracker. Styles Inspector for Writer by Shivam Kumar Singh Mentors: Tomaž Vajngerl, Mikhail Kaganskiy (Collabora) Dealing with styles and formatting in complex documents can become tedious, especially when you are working on something you did not create yourself. The Styles Inspector implemented by Shivam conveniently displays all the properties of the elements making up a document. It will surely become an essential tool for Writer experts. Learn more about the Styles Inspector in the final report. Additions – Tight integration of extensions by Yusuf Keten Mentor: Muhammet Kara (Collabora) Thanks to the work of Yusuf, users are now able to fetch extensions, templates and other resources as well as discover guide books without ever

TDF Annual Report 2019

The Annual Report of The Document Foundation for the year 2019 is now available in PDF format from TDF Nextcloud in two different versions: low resolution (6.4MB) and high resolution (53.2MB). The annual report is based on the German version presented to the authorities in April. The 54 page document has been entirely created with free open source software: written contents have obviously been developed with LibreOffice Writer (desktop) and collaboratively modified with LibreOffice Writer (online), charts have been created with LibreOffice Calc and prepared for publishing with LibreOffice Draw, drawings and tables have been developed or modified (from legacy PDF originals) with LibreOffice Draw, images have been prepared for publishing with GIMP, and the layout has been created with Scribus based on the existing templates. All pictures are licensed under the Creative Commons Attribution-Share Alike 4.0 License, courtesy of TDF Members from Albania, Brasil, Czech Republic, Germany, Italy, Japan, Nepal, Paraguay, Taiwan, Uganda and Turkey. Stock photos are CC0 by Pixabay. Lothar Becker, Chairman of TDF Board of Directors, has written in the welcome address: What we have achieved so far goes beyond the most optimistic forecasts of the project’s founders back in 2010. After ten years, the challenge

LibreOffice Tips & Tricks: Converting 4:3 Slides into 16:9 Slides

(clicking on the image will open a large view of the same) Today, the majority of screens and projectors is using the 16:9 aspect ratio, while in the past has been using the 4:3 aspect ratio. So, many people have a large number of slide decks based on the old 4:3 aspect ratio, which have to be converted to the new 16:9 aspect ratio. Using LibreOffice Impress in the right way, which means that all slides are based on a slide template, the conversion procedure is rather trivial, and this blog post provides a step by step tutorial. Of course, we start by opening the old 4:3 slide deck, and switching to the Slide Sorter view. We select all slides using the Edit > Select All menu command, and then we copy all slides using the Edit > Copy menu command.     To create the new 16:9 slide deck, we use the File > New > Templates… menu command. From the Templates window, which opens on top of the 4:3 slide deck, we select a 16:9 template. In this case, we will open the “tdf-greenliberation” template on the lower right corner of the Templates window.       The

openSUSE + LibreOffice Conference 2020 Will Take Place Online

Organizers of the openSUSE + LibreOffice Conference, along with the project’s boards, have made the decision to change the conference to an online conference. The uncertainty surrounding the COVID-19 pandemic and its effect on travel, conference planning, logistics and possibility for attendees to come to the event were reasons for shifting the event from a physical event to an online event. Shifting the conference online is good news and the organisers intend to provide a great conference that is filled with insightful talks, technical presentations and sessions dedicated for those who want to socialise during the event. Using a video conferencing tool, attendees will learn about new technologies in openSUSE and LibreOffice and have the chance to chat to developers and ask questions. Communities involved in marketing, design, QA and other topics will be able to meet online, catch up and exchange ideas. The Call for Papers (CfP) will remain open and people can continue to submit their talks until July 21. The submissions for the CfP will continue to take place on the Open Source Event Manager (OSEM) instance at https://events.opensuse.org. The collection of submissions will be organized in the OSEM tool, but the online event will take place

LibreOffice Macro Team: progress report

Macros help users to automate common tasks in LibreOffice. In September 2019 we announced a new team in our community to work on macro support. A progress report was published in November 2019, so let’s review everything that happened since then. If you are interested in contributing to the macro team (development, testing or documentation), we’d love to hear from you – please send an email to ilmari.lauhakangas@libreoffice.org and we’ll get in touch. Wiki docs Thanks to Nathan Ullberg, many wiki articles previously only available in French can now be read in English as well. Nathan also updated existing articles and created an article about manipulating LineShape objects in Impress. Detailed lists of his work can be found on his wiki user page. Alain Romedenne worked alongside Nathan with the macro articles and translations. He added LibreOffice Basic cheatsheets from Jean-François Nifenecker into the wiki and created a new article concerning input/output to screen with Python. Alain also started creating syntax diagrams for LibreOffice Basic. Code contributions from macro team members Andreas Heinisch: cInt function treats, as decimal Tab label too low within macro editor Typename function does not return the correct data type of a numeric constant Consider an