Video tutorials for LibreOffice Writer, Calc and Impress

On the LibreOffice subreddit, we became aware of some useful tutorial videos created by Steven Davids. These cover various components of the suite, and show how to achieve common tasks.

We asked Steven about how he chooses the topics for his videos, and how he makes them:

My video tutorials come to me – I do not go and look for them. If I have a problem, I search for a solution on the web. I always assume I am not unique, and that many other people had or have the same problem. If I do not find a solution or one that is readily available, I struggle my way out to a solution. Then I share that solution via video! Why video? Because it seems to me people are lazy to read and video illustrations are just easier to understand.

The videos are very low budget and homemade. There are no costs for the software since I use free public open-source programs for the screen recorder and video editor. There are many such programs, but OBS Studio and Shotcut serves me very well. I often use LibreOffice Presentation to assist in presenting the material. The hardware is also low cost. I already have a laptop and mobile phone so there are not extra costs there. A mid-range microphone from Samson is indispensable and basically the only additional cost.

Click here to view the playlist on YouTube!

The Document Foundation releases LibreOffice on Apple’s Mac App Store

Berlin, September 19, 2022 – The Document Foundation (TDF) announces the release of LibreOffice on Apple’s Mac App Store, to support end users who want to get all of their desktop software from Apple’s proprietary sales channel. So far, LibreOffice on the Mac App Store was released by Collabora. TDF will charge a convenience fee of €8.99, which will be invested to support development of the LibreOffice project.

TDF releasing on the Mac App Store is an evolution over the previous situation, which reflects the project’s new marketing strategy: The Document Foundation is focused on the release of the Community version, while ecosystem companies are focused on a value-added long-term supported versions targeted at enterprises. The distinction has the objective of educating organizations to support the FOSS project by choosing the LibreOffice version which has been optimized for deployments in production and is backed by professional services, and not the Community version generously supported by volunteers.

“We are grateful to Collabora for having supported LibreOffice on Apple’s Mac App Stores for quite a long time”, said Italo Vignoli, LibreOffice Marketing. The objective is to fulfill the needs of individual and enterprise users in a better way, although we know that the positive effects of the change will not be visible for some time. Educating enterprises about FOSS is not a trivial task and we have just started our journey in this direction”.

The Document Foundation will continue to provide LibreOffice for macOS for free from the LibreOffice website, which is the recommended source for all users.

LibreOffice packaged for the Mac App Store is based on the same source code, but does not include Java – because external dependencies are not allowed on the store – and therefore limits the functionalities of LibreOffice Base. The software is also supported by volunteers who donate their time to help users.

Link: https://apps.apple.com/us/app/libreoffice/id1630474372

LibreOffice 7.4.1 Community available for download

Berlin, September 15, 2022 – LibreOffice 7.4.1 Community, the first maintenance release of LibreOffice 7.4, the volunteer-supported office suite for personal productivity on the desktop, is immediately available from https://www.libreoffice.org/download for Windows (Intel and Arm processors), macOS (Apple M1 and Intel processors), and Linux.

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

Most Significant New Features of LibreOffice 7.4

GENERAL
• Support for WebP images and EMZ/WMZ files
• Help pages for the ScriptForge scripting library
• Search field for the Extension Manager
• Performance and compatibility improvements

WRITER
• Better change tracking in the footnote area
• Edited lists show original numbers in change tracking
• New typographic settings for hyphenation

CALC
• Support for 16,384 columns in spreadsheets
• Extra functions in drop-down AutoSum widget
• New menu item to search for sheet names

IMPRESS
• New support for document themes

A video summarizing the top new features of the LibreOffice 7.4 Community major release is available on YouTube: https://www.youtube.com/watch?v=PC8M4UzqpqE and PeerTube: https://peertube.opencloud.lu/w/myZUTCytN28kuxDa5VXNgh. A description of all new features is available in the Release Notes: https://wiki.documentfoundation.org/ReleaseNotes/7.4.

LibreOffice Technology Platform

Products based on the LibreOffice Technology platform – the transactional engine shared by all LibreOffice based products, which provides a rock solid solution with a high level of coherence and interoperability – are available for major desktop operating systems (Windows, macOS, Linux and Chrome OS), for mobile platforms (Android and iOS), and for the cloud.

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 and other benefits such as SLA (Service Level Agreements): https://www.libreoffice.org/download/libreoffice-in-business/. All code developed by ecosystem companies for enterprise customers is shared with the community and improves the LibreOffice Technology platform.

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

Availability of LibreOffice 7.4.1 Community

LibreOffice 7.4 Community is available from: https://www.libreoffice.org/download/. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.12. LibreOffice Technology-based products for Android and iOS are listed here: https://www.libreoffice.org/download/android-and-ios/.

For users who don’t need the latest features and prefer a release that has undergone more testing and bug fixing, The Document Foundation maintains the LibreOffice 7.3 family, which includes some months of back-ported fixes and is currently at version 7.3.6.

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 Conference 2022 Schedule

The schedule of the LibreOffice Conference 2022, to be held in Milan from September 29, to October 1st, has been published: https://events.documentfoundation.org/libreoffice-conference-2022/schedule/. Please check it on a regular basis, as changes will be reflected in real time, even during the conference.

The app for Android with the schedule (also in real time) is live on Google Play and F-Droid: https://play.google.com/store/apps/details?id=info.metadude.android.libreoffice.schedule and https://f-droid.org/packages/info.metadude.android.libreoffice.schedule.

 

The Latin American LibreOffice 2022 Conference was a success!

Female volunteering, interoperability, professional training, migration, Python based macro development and much more were highlighted themes at the event held at the Catholic University of Brasilia in the capital of Brazil.

Daniel A. Rodriguez writes:

The Latin American LibreOffice Conference gathered around 400 people, among them students and IT professionals, and was opened to the public on Thursday August 25th in a ceremony presided by Prof. Wesley Sepulvida, representing UCB, Lothar Becker (formerly on the Board of Directors of The Document Foundation) and Olivier Hallot representing the LibreOffice community.

The conference was organized entirely by volunteers, and followed up on the first event held in the city of Asunción in Paraguay in 2019. Brasilia was chosen to host the conference in 2022 because of its importance in the Latin American context and its excellent infrastructure. The lectures and workshops were given by members of the LibreOffice community from Italy, Spain, Mexico, Brazil and Argentina, on August 25 and 26 at the Catholic University of Brasília, on the Taguatinga campus.

Italo Vignoli (Italy – TDF) and Olivier Hallot (Brazil – TDF), founding members of The Document Foundation, opened the lectures, presenting the sustainability of free software projects and the history of LibreOffice in Brazil, respectively. At the end of the morning, the participants took the official photo of the event.

In the early afternoon, Daniel Rodriguez (Argentina – TDF / UNAU) spoke about the implementation of a version of LibreOffice Online at the Alto Uruguay National University in Argentina, and Rafael Silveira (Brazil) presented the migration project to LibreOffice at Nuclebrás Equipamentos Pesados (NUCLEP). Simultaneously, in the computer lab Henderson Matsuura Sanches (Brazil – TDF) gave a workshop with practical tips about how to do an End of Course Paper in LibreOffice.

Xisco Fauli (Spain – TDF) presented the testing procedure of LibreOffice, followed by Lothar Becker (Germany – TDF) who talked about entrepreneurship with free software. Roberto Salomon (Brazil – Chief architect for Latin America at SUSE) spoke about the future that opens up with the technological innovations that are arriving in Brazil. In the closing of the first day, Prof. Andre Lima (UCB) spoke about open source solutions for LGPD compliance. In the workshops, Rafael Lima (Brazil – TDF) led the work on python scripting with a full room.

On the second day, Gustavo Pacheco (Brazil – TDF) shared with the audience details about the importance of being careful when investing in cryptocurrencies and how LibreOffice can help in decision making. He was followed by Olivier Hallot who presented the different ways of documenting software projects. Tulio Macedo (Brazil – TDF) presented the challenges of more accessible documentation. Simultaneously, Xisco Fauli led the session on software bug identification and confirmation. At the same time, Felipe Marra, Rafael Osiro and Giovanni Favorim from UCB led a workshop on software versioning control with the git tool. Prof. Remis Balaniuk (UCB) gave an introductory workshop on python.

In the afternoon, Italo Vignoli spoke about digital sovereignty. Followed by Olivier Hallot who presented migration strategies between office suites. Eliane Domingos (Brazil – TDF) talked about female volunteering in the LibreOffice project. At the same time, Mauricio Baeza (Mexico – TDF) gave a workshop about creating extensions for LibreOffice. In parallel, Prof. Cleto Spotto (UCB) analyzed snippets of LibreOffice code in a C++ workshop.

Henderson Matsuura showed how to install and use Mendeley in Writer, followed by Olivier Hallot who covered first steps in developing code for LibreOffice. Jackson Junior (Brazil – TDF) presented his experiences in standardizing documents at the Secretariat of Environment and Urban Planning (SEMAPU) of Olinda, Pernambuco, and Prof. Cleto Spotto (UCB) conducted an introductory workshop on LibreOffice Math. Finally, Prof. Hially Vaguetti (UCB) showed how to make academic presentations in LibreOffice Impress.

The conference was closed by Prof. Wesley Sepulvida, who thanked The Document Foundation and the LibreOffice community for their presence. In return, Olivier Hallot thanked the Catholic University of Brasilia for its hospitality and the volunteers and speakers for their participation in this first face-to-face event after the pandemic.

Now we look forward to meeting more people at the LibreOffice Conference 2022 in Milan, at the end of this month!