To see our schedule with full functionality, like timezone conversion and personal scheduling, please enable JavaScript and go here.
12:00
12:00
30min
Opening Session, with welcome address by Lothar Becker
Italo Vignoli, Florian Effenberger, Lothar K. Becker

Welcome address by Lothar Becker, followed by conference outline and housekeeping instructions by Florian Effenberger and Italo Vignoli

f) Advocating, Promoting, Marketing LibreOffice
Room 1
12:30
12:30
30min
LibreOffice Technology, a FOSS platform for personal productivity
Italo Vignoli

LibreOffice was announced in 2010 as a desktop productivity software for Windows, macOS and Linux. From 2010 to 2020, it has evolved from a single desktop product to a technology platform supporting applications for the desktop, the cloud and mobile. All products share the same engine, which provides superior consistency. The goal of the presentation is to present the different stages of this evolution.

f) Advocating, Promoting, Marketing LibreOffice
Room 1
13:00
13:00
30min
Collabora Keynote
Michael Meeks

Sponsor's Keynote by Collabora Productivity's Michael Meeks

a) Development, APIs, Extensions, Future Technology
Room 1
14:00
14:00
30min
Announcement about LibreOffice Certification
Italo Vignoli

LibreOffice Certification was established in 2014, for Developers, Migration Professionals and Professional Trainers. We are now announcing the second generation of the project, with a stepped process for Migration Professionals and Professional Trainers, which are now supposed to go through the basic LibreOffice Certification by following online training to access the certification review. This is supposed to make it easy for people outside the project to get certified, even if at basic level, leaving the Professional level to people with more experience and skills. In addition, we will announce Professional Trainer Certification for single applications like Writer and Calc.

f) Advocating, Promoting, Marketing LibreOffice
Room 1
14:30
14:30
30min
allotropia Keynote
Thorsten Behrens

Sponsor's Keynote by allotropia's Thorsten Behrens

a) Development, APIs, Extensions, Future Technology
Room 1
15:00
15:00
30min
A new open source tool for managing applications: The new Membership Commitee's web-tool
Uwe Altmann, Dennis Roczek

To ease the work of TDFs Membership Committee (MC), we decided to develop a web based tool to conduct the whole process of getting a member (or renew the membership) of the TDF. This tool is available under a free license and may be useful also for others. The talk will showcase the tool and process supported, as well as the options to modify process' parameters.

Room 3
15:00
30min
I feel the need... The need for speed.....
Noel Grandin

Making LibreOffice faster is fun.... If you don't mind re-doing your code 7 times :-) Optimising is an exploratory journey.

Room 1
15:00
30min
State of CJK issues of LibreOffice, 2021 edition
Shinji Enoki

The LibreOffice project is aimed at multilingualism, as stated in The Document Foundation's "Our Values" of "Our Next Decade Manifesto" that anyone can translate so that everyone can use it in their mother tongue.

However, LibreOffice developers are mostly in Europe, and in order to use them conveniently in other languages, those who understand those languages need to solve the problem. LibreOffice's CJK and problems unique to the Japanese environment are various such as vertical writing, external characters, phonetic, currency and date notation.

Sometimes CJK regression bugs occur in the LibreOffice project. It is important to strengthen user's feedback loop approach. It is also important to find regression bugs by tests.

In this year's talk, As the first, I will analyze the bug database and introduce the trend. Secondly, introduce some reported and fixed CJK bugs in the past year. Thirdly, introduce some not fixed old CJK bugs.

Room 2
15:30
15:30
30min
Creating professional templates with LO Writer
Gabriele Ponzo

A brief panorama on how much important templates are and what can be done (and automated) inside them.

Room 3
15:30
90min
Getting Started with LibreOffice Development
Hossein Nourikhah

LibreOffice development starts with setting up a development environment. After that, you can do the development in your favorite IDE. In the next 90 minutes, I will provide everything you need to know to get started with LibreOffice development: from compiler installation to LODE (LibreOffice Development Environment) setup, in order to be able to build LibreOffice for yourself. Then we talk about some simple tasks from LibreOffice EasyHacks, and try to get our contribution merged into the LibreOffice code base by submitting it to gerrit, and doing the fixes requested by the reviewers.

a) Development, APIs, Extensions, Future Technology
Room 2
15:30
30min
The Crashreporter Service used by LibreOffice
Christian Lohmaier

The talk gives an overview of the individual pieces involved in the crashreporting tooling used by LibreOffice and how it can be used to increase the overall stablility of LibreOffice.

Room 1
16:00
16:00
30min
LibreOffice Calc Survey: User Characteristics, Usability, and Future Enhancements
Maria Berg, Heiko Tietze

In this presentation we will show the results of the 2021 LibreOffice Calc Usability Survey. The purpose of the survey was to learn more about LibreOffice Calc users and to understand where efforts to improve the software should be allocated.

d) Appealing Libreoffice: Ease of Use, Design and Accessibility
Room 3
16:00
20min
Some improvements for the SVG export filter
Marco Cecchetti

Latest improvements for the SVG export filters include the support for presentation with slide background represented by bitmaps. The slide background can also be made up of tiles where each tile is represented by a bitmap or a given pattern. The support for such kinds of backgrounds has been implemented in a resource safe way: minimizing both the exported file size and the impact on the browser rendering performance.

Room 1
16:30
16:30
30min
Improved document searching with LibreOffice
Tomaž Vajngerl

Searching for a phrase in multiple documents is not a new thing and many implementations exist, however such searching will usually only provide you if and roughly where in the documents a searched phrase exists. With Collabora Online and LibreOffice we can do better than this and in addition provide the search result in form of a thumbnail of the search location. In this way it is easier for the user to see the context, where the searched phrase is located. For example, if it is located in a table, shape, footer/header, or is it figure text or maybe "alt" text of an image.

Thanks to the sponsor of the work - NLnet Foundation, we are implementing this solution for Writer documents.

Room 1
16:30
60min
State of the Project and Marketing Plan Update
Italo Vignoli

Update about downloads, and about development, QA, localization and other community related numbers.

Room 3
17:00
17:00
30min
How to write your first test
Xisco Fauli

This talk will walk you through the process of writing your first LibreOffice unittest either with Python or with C++

Room 2
17:00
30min
Multi-column support in LibreOffice 7.2
Mike Kaganski

The new feature, its relevance, implementation status, and so on ...

Room 1
12:00
12:00
30min
A year of COOL ...
Cor Nouws

Come and hear all the improvements we have made during the last year
around bringing awesome LibreOffice Technology to the browser in the
form of Collabora Online.

Room 1
12:00
90min
Let's fix the personal data problem.
Björn Balazs

There will be no world without personal data. So let's shape the alternative. An alternative where we, the free software community bring in our experience, passion and beliefs to create a private world enjoying the benefits of big personal data. This is a call for cooperation.

d) Appealing Libreoffice: Ease of Use, Design and Accessibility
Room 3
12:00
30min
openSUSE maintenance, when several projects cooperates for making LibreOffice a solid productivity suite
Marina Latini

This presentation will describe two real cases where the synergy between different communities and companies resolved high visible issues on LibreOffice, making the fixes available to the whole LibreOffice Community.

After an introduction of what happens under the openSUSE maintenance umbrella, this presentation will focus on how volunteers, the TDF team and three different companies cooperated in identifying, triaging, fixing and testing a case of crash and one of dataloss on LibreOffice.

b) Quality Assurance
Room 2
12:30
12:30
30min
COOL performance
Michael Meeks

Collabora Online has a novel model that allows re-using the
LibreOffice code-base to provide rich collaborative editing. Recently
we have been been focusing our development on improving the 'feel' and
slickness of document editing as a key part of user experience. We
have also been working on improving editing performance with larger
numbers of concurrent active editors.

Come and hear about the things that we've found and fixed, both in
COOL and also in the LibreOffice core to improve interactivity and to
make collaborative editing fly.

Room 1
12:30
30min
Enhancing a spellcheck dictionary by Wikidata lexemes
Stanislav Horáček

The talk summarizes recent changes in development of Czech spellcheck dictionaries, with a focus on employing lexemes from Wikidata as a source of words for a new experimental dictionary. Apart from that, an update of the default dictionary and using a new public data set of words will be mentioned.

Room 2
13:00
13:00
30min
GraphQL Extension for LibreOffice
Koji Annoura

GraphQL is one of the API integration methods like REST.

When you are using Calc or Base, you can use GraphQL to retrieve and write data for more flexible input and output.

In this session, I would like to talk about how I implemented Extension, how it works, and what problems I have with it.

a) Development, APIs, Extensions, Future Technology
Room 1
13:00
5min
PPTX footer export & import interoperability
Sarper Akdemir

PPTX footer export & import interoperability

  1. What were the initial problems
    1. Footers imported as textboxes (not as Impress understands them)
    2. Footers don't get exported
  2. The fix
    1. If possible import footers as properties (as Impress understands them) if not fallback to the previous implementation
    2. Export footers
      • PPTX placeholder inheritance
      • lstStyles (on master placeholders)
      • Placeholder indexes (for slide placeholders)
    3. Better the datetime conversion
  3. What's left?
    1. Right now only for slides, not for notes/handouts
    2. Footer placeholders use the lstStyles but it could be expanded to all of the placeholders, (maybe for better interoperability)
Room 2
13:05
13:05
5min
Edit LibreOffice files directly from Nextcloud web interface
Samuel Mehrbrodt

This feature will introduce a new Nextcloud plugin which allows editing LibreOffice files directly from the Nextcloud Web Interface.

Room 2
13:10
13:10
5min
Color Filter in Calc
Samuel Mehrbrodt

Introducing the new color filter feature in LibreOffice Calc.

Room 2
13:30
13:30
20min
Gutter margin in Writer page styles
Miklos Vajna, Miklos Vajna

LibreOffice was capable handling various margins in Writer page styles
already. Be it top, bottom, left, right, inner, outer margins, all working. A
missing piece was support for the gutter margin, which is used when priting
for binding: additional space on the left or at the top, which is nominally
not part of the relevant margin. This means that the Writer document model is
capable of reading this information from DOCX files, render such files
correctly, saving them to ODF and supporting them at the various other layers
of the LibreOffice technology (UI, UNO API, etc). Come and see how this work
is implemented, where are the still rough edges and how you can help.

a) Development, APIs, Extensions, Future Technology
Room 1
13:30
30min
ODF Status Update 2021 Edition
Michael Stahl

Come to learn about the exciting world of standards development.

Room 2
13:30
30min
The challenge of Using LibreOffice & Building Local Community in Korea
DaeHyun Sung

In South Korea, Both OWPML and ODF are a Document format standard as a public sector. But, In South Korea's academic field, the public & private sector, It is still using HWP as a document standard. They are still made and distributed in .hwp format. I'm a Full-time worker(Developer) & University student in Korea. This year, I transferred to Korea National Open University, major in Chinese Language & Literature. As a university student, I talk about the inconvenience of using ODF when making documents in Korea. Also, I introduce the activities of the LibreOffice community since 2020 in Korea.

f) Advocating, Promoting, Marketing LibreOffice
Room 3
14:00
14:00
30min
Built-in "Xray" like UNO object inspector
Tomaž Vajngerl

When developing macros and extensions in LibreOffice it is very useful to have an object inspector. With that tool you inspect the object tree and the methods, properties and interfaces of individual objects to understand its structure. There are quite some different object inspectors available for LibreOffice as extension. Probably the best known is called “XrayTool”, but there were also others like MRI, which was build for a similar purpose and various other more simple object inspectors (for example one is provided as an code example in ODK).

As a tool like this is very valuable it makes sense that it would be provided out-of-the-box by LibreOffice without the need for the user to get it separately. Also the user could even be unaware the such a tool exists. For this reasons The Document Foundation (TDF) put up a tender to create a built-in Xray like UNO object inspector, which was awarded to Collabora and we are now in the process of implementing it.

Room 1
14:00
30min
There are no shortcuts to the magical world of technology (LPI)
Cesar Brod

Talk in English from LPI. Talk in English from LPI. Talk in English from LPI. Talk in English from LPI. Talk in English from LPI.

Room 3
14:00
30min
Update about ODF Advocacy
Italo Vignoli

The ODF Advocacy Open Project at OASIS has been temporarily frozen, for lack of interest from third parties. We are moving the project to TDF, with two main activities: promotion of the ODF Standard Document Format with presentations, and development of a comprehensive bibliography.

e) Open Document Format, Document Liberation and Interoperability
Room 2
15:00
15:00
30min
Getting the word out - to users and to potential contributors
Mike Saunders

How are we reaching out to new users? And how are we getting new contributors on board? This talk will explain all...

f) Advocating, Promoting, Marketing LibreOffice
Room 2
15:00
90min
How to debug Writer, forwards and backwards (Epsiode 2)
Michael Stahl

This is not an ordinary talk. This is going to be a screencast of using a debugger to find out why Writer crashes in Undo. State of the art tools will be used (i.e. rr+gdb). The intended audience is developers using C++.

Room 3
15:00
30min
Navigate easily through libreoffice code with Sourcetrail and Vscode
Regis Perdreau

Sometimes navigate in a large base of code is a pain. Use of Sourcetrail and Vscode IDE to navigate easily throught LibreOffice code. Demonstration, use case. Useful for beginner developer and occasional...

a) Development, APIs, Extensions, Future Technology
Room 1
15:30
15:30
30min
PDF annotations support
Tomaž Vajngerl

In Draw, a PDF document can be opened using the PDFium library for rendering, where each page in the Draw document contains an rendered image from the PDF. This mode is useful for viewing PDFs and allows for the best fidelity. With viewing, there is also a need to review and comment and this is where PDF annotations come in as adding the support for the PDF annotations and to support a review based workflow has been one of my recent task at Collabora Productivity.

Room 2
15:30
30min
Python scripts in LibreOffice Calc using the ScriptForge library
Rafael Lima

One of the most advanced uses of spreadsheets is automation by creating macros that perform tasks that go beyond the capabilities of regular functions. In LibreOffice, the main scripting language is Basic, but there is a trend in adopting Python to create user scripts. Starting with LibreOffice 7.2 the ScriptForge library will have Python support for most of its services and methods, which will make it easier for users to create Python scripts. The objective of this talk is twofold: first it will provide a brief overview of how to get started writing Python scripts that use the ScriptForge library and later the Calc service will be introduced, showcasing its main methods. Currently the Calc service has 30 methods and 11 properties that have been documented in the online Help. Hence, this talk seeks to promote ScriptForge and its capabilities among LibreOffice users to boost adoption.

a) Development, APIs, Extensions, Future Technology
Room 1
16:00
16:00
90min
GSoC pannel
Thorsten Behrens

GSoc final panel just to reserve some space for their usual demonstration

Room 2
16:00
30min
ScriptForge 7.2
Jean-Pierre Ledure

ScriptForge libraries build up an extensible collection of macro scripting resources for LibreOffice to be invoked from Basic macros or Python scripts.
Those libraries were integrated in LO 7.1 and upgraded in 7.2.

a) Development, APIs, Extensions, Future Technology
Room 1
16:30
16:30
30min
Expediting the Brazilian Portuguese Documentation Process.
Timothy Brennan

The Brazilian Portuguese team has developed a quicker process than former ones. With changes in the translation process, by using machine translation, creating a chat group, and finally a weekly one-hour online meeting, the Brazilian documentation team has been able to expedite the translation and publication process. This process will be expounded upon in hopes of being an inspiration and encouragement to many around the globe.

c) Localization, Documentation and Native Language Projects
Room 3
16:30
30min
LibreOffice SDK Examples Overhaul
Hossein Nourikhah

LibreOffice SDK is a tool that helps developers create applications that work with LibreOffice. On the other hand, setting up and running SDK needs external tools like GNU make, zip, cat and sed tools which are provided by Cygwin in Windows.
This talk is about using LibreOffice SDK with minimal set of dependencies, using modern build tools like cmake and qmake.

a) Development, APIs, Extensions, Future Technology
Room 1
17:00
17:00
30min
Converting LibreOffice Guides into Web Pages
Olivier Hallot

We present the results of porting the LibreOffice User Guides into web pages aiming to be accessible from a wider set of devices. The do's and dont's of word processing practices as well as the necessary tweaks in the resulting documents will be addressed.

c) Localization, Documentation and Native Language Projects
Room 3
17:00
30min
GTK4 Port
Caolán McNamara

Description of the current state of the GTK4 port.

a) Development, APIs, Extensions, Future Technology
Room 1
12:00
12:00
30min
LibreOffice in the browser, live and in color!
Thorsten Behrens

Following-up from FOSDEM and last year, this talk provides an update, and an actual working demo, of LibreOffice ported to WASM & running in the browser!

Room 1
12:30
12:30
20min
Building (and using) LibreOffice Online... again
Marco Marinello

Building LibreOffice Online became tricky... again. The talk will briefly go through Online functionalities, status quo, build procedure and integrations.

Room 1
12:30
30min
Security in a Nutshell with Linux Essentials (LPI)
Cesar Brod

Talk in Spanish by LPI. Talk in Spanish by LPI. Talk in Spanish by LPI. Talk in Spanish by LPI. Talk in Spanish by LPI.

Room 3
13:00
13:00
30min
Como se crean las certificaciones LPI desde Cero (LPI)
Cesar Brod, Juan Ibarra, Hernan Pachas

Talk in Spanish by LPI. Talk in Spanish by LPI. Talk in Spanish by LPI. Talk in Spanish by LPI. Talk in Spanish by LPI.

Room 3
13:00
15min
JSDialogs improvements over the past year
Szymon Kłos

JSDialogs is a LibreOffice component used to share UI elements with Collabora Online. Recent updates will be presented.

Room 1
13:30
13:30
60min
LibreOffice Community Survey - retrospective feedback
Jona Azizaj, Marina Latini

The community survey was designed to guide the Membership Committee (and not only) to improve the support to our members, identify the areas where a focused activity is needed and increase the community base.

Let’s discuss the aggregated results of the community survey – interpret and plan the action items based on the results we will get.

Room 1
13:30
30min
Unbundling the big ball of mud
Bjoern Michaelsen

In Writer, SwModify and SwClient have been used extensively as tool to attack a wide set of problems: for messaging, as weak pointers and for reference counting. The talk will show the progress in untangling this big ball of SwClients and SwModifies from the loose end and how it will help in the long run.

Room 2
14:00
14:00
30min
Open Source and Open Standards for Digital Sovereignty
Italo Vignoli

Open Source Software and Open Standards – especially document formats – are of key importance for the digital sovereignty strategies of individuals, companies, organisations and governments. Today, user-created content - and the ability to share it transparently - is in the hands of a few companies, which exploit the limited digital culture of users to their advantage. This situation can only be overcome by moving from proprietary to open source software and from proprietary to open standards.

e) Open Document Format, Document Liberation and Interoperability
Room 2
15:00
15:00
30min
A legendary bug reporter
Ilmari Lauhakangas

An examination of the work of a prolific LibreOffice bug reporter, Telesto. We will discover how much a single person is able to achieve through an activity usually seen as rather mundane.

f) Advocating, Promoting, Marketing LibreOffice
Room 1
15:30
15:30
30min
Introduction to TDF Membership
Muhammet Kara, Gabriele Ponzo

Members are a crucial part of The Document Foundation. Therefore, we welcome and value all contributions, be it in development, documentation, infrastructure, design, translation, quality assurance, or marketing. This session is for you if you are interested in learning why you should be a member and how the membership application works. We will also share about the role of the Membership Committee and what we are currently focused on.

Room 1
16:00
16:00
30min
LibreOffice: Improving the Project Sustainability
Italo Vignoli

LibreOffice was announced in 2010. After 10 years, it was necessary to review and update the strategy based on the evolution of the office suite market, to improve the sustainability model. Enterprises are not supporting the project as much as individual users. Over time, this can represent a threat for the sustainability of the project. We have changed our strategy to educate enterprises about the right approach to FOSS, by giving back to ensure the long term sustainability of the LibreOffice project.

f) Advocating, Promoting, Marketing LibreOffice
Room 1
16:30
16:30
30min
Q&A Session with BoD and MC
Italo Vignoli, Florian Effenberger, Lothar K. Becker, Marina Latini

Q&A Session with Board of Directors and Membership Committee

Room 1
17:00
17:00
30min
Closing Session, with closing address by Lothar Becker
Italo Vignoli, Lothar K. Becker, Florian Effenberger

Closing address by Lothar Becker, followed by announcement of upcoming conferences in 2022

f) Advocating, Promoting, Marketing LibreOffice
Room 1