Welcoming the audience and briefly explaining what TDF and the LibreOffice project is to those that are new to the conference.

Welcome Address by Conference Organizers

Open Source in EdTech

Keynote of Minister for Research, Higher Education and of Digitalisation

In this talk we will explore why Passbolt decided to choose open source as a business model, how it benefited its market fit and growth, as well as what were Passbolt initial mistakes and lessons learnt while growing from 0 to half a million daily users.

Presenting the FOSS group within the university Technology Transfer Office

The Ministry of the Economy is pleased to announce the establishment of the firs Open Source Programme Office (OSPO) in Luxembourg within the House of Cybersecurity. The Luxembourg House of Cybersecurity (LHC) has been leading by example in producing cyber security tooling with OSI compliant licences for more than a decade. Thanks to their experience in using and creating Open Source software they will be a source of inspiration and support for the organisations that will want to follow their path in Luxembourg as well as opening opportunities for cooperation with many international OSPOs.

A brief introduction to the growing importance of free/open source at the European Commission.

ODF, the document standard

The history of Free Software in the French public administration can be told by drawing a timeline that we can call “From LibreOffice to La Suite”. Back in the 2000s, some pioneers in the French administration experimented with StarOffice, then OpenOffice, then convinced their hierarchy to deploy OpenOffice/LibreOffice massively, even publishing an official build adapted to the needs of French ministries. The free software policy was then reinforced in various ways, two of which were the launch of the BlueHats movement in 2018 and the creation of an Open Source Programme Office in 2021. Now DINUM is focusing on putting open source at the heart of “La Suite”, its digital workplace for civil servants, working closely with other European member states such as Germany. Of course, history is not linear and new things do not completely replace old ones: where are we now? Who is using LibreOffice? Who is using La Suite? How do these two stories fit into the larger story of Free Software in the French public sector?

Collabora keynote

"Public Money? Public Code!", Device Neutrality, Router Freedom, Free Your Android, assistance with licensing questions, Youth Hacking 4 Freedom, and a tale of software, skateboards, and raspberry ice cream. These are some of the activities by the Free Software Foundation Europe (FSFE), which has been working since 2001 to empower users to control technology. The talk will give an overview of FSFE's work for software freedom as an independent organisation and how you can contribute.

We need smart software solutions to advance in the digital transformation of our society towards a better world for everybody. We also want these software solutions to be ethical and sustainable. But we can't wait to find professional programmers to build them.

In this talk, we'll discover BESSER, an intelligent low-code/no-code lab you can use to create and deploy in the cloud your own smart and unbiased applications.

BESSER is a cutting edge research project released as open source and open to contributions from anyone interested in building a common infrastructure for a better software future for all.

This talk will present the improvements made in 2024 to the solver used in LibreOffice Calc, focusing on the new features developed as well as compatibility with Microsoft Office. Emphasis will be given on the proposition of a new UNO API that makes it easier to develop macros that use solver functionality. The talk will also discuss strategies to integrate major solver engines such as Gurobi and CPLEX into LibreOffice.

The LMDDC has the mission to offer educational professionals in Luxembourg free access to software tools for creating diverse educational content. At the upcoming event, project manager Pierre de La Celle will officially launch the skilltech.tools platform and illustrate its key features via selected use cases. All the software tools on skilltech.tools comply with standards and are open-source, either developed in-house by the LMDDC or hosted on LMDDC servers in Luxembourg.

ESC call, a conference edition.

The Open Source Ecosystem Enabler (OSEE), supported by ITU, the United Nations Development Programme and the European Union will help countries strengthen open source ecosystems by providing technical support, practical guidance and frameworks, and training.

Fourteen years ago, we established CIRCL, a national-level CERT under the NIS Directive, with a commitment to an open-source strategy from the outset. Over the past 14 years, we have grown from managing small projects to maintaining 17 different open-source initiatives in the cybersecurity field, including the MISP Project, AIL Project, and many others. Throughout this journey, we've gained invaluable insights—both positive and negative. Our experiences span community management, engaging open-source contributors, navigating supply chain distribution, marketing open-source solutions, software licensing, engineering robust software, and ensuring long-term project maintenance. This presentation will share the lessons we've learned and how they have shaped our approach to cybersecurity and open source.

From the public administration for the public administration: OpenCoDE, hosted by the Centre for Digital Sovereignty (ZenDiS), is Germany's nationwide platform where federal, state, and local government agencies can discover, build, and share open-source software. The ultimate goal of OpenCoDE is to establish an infrastructure that encourages the adoption of sustainable open source solutions within the public sector. A crucial aspect of achieving this goal is implementing a secure software development life cycle (SDLC), and Open CoDE offers an ideal environment for developing secure applications. One such application is openDesk, ZenDiS’ integrated suite designed for collaborative office tasks within the public sector. It incorporates proven open-source tools and makes its source code publicly available via OpenCoDE, demonstrating how Open CoDE supports the development of secure and dependable applications.

Luxchat4Gov, developed by Luxembourg's Ministry of Digitalisation together with Lu-CIX, is a secure messaging platform tailored for the public sector, emphasizing digital sovereignty and interoperability. Built on the open-source Matrix protocol, Luxchat4Gov ensures encrypted, end-to-end communications hosted within national data centers, guaranteeing that all data remains under Luxembourgish jurisdiction. This approach not only enhances security but also provides full control over governmental communications.

This presentation will highlight how Luxchat4Gov leverages the Matrix protocol to ensure seamless interoperability between systems, while maintaining stringent data security. By adopting this platform, Luxembourg sets a precedent for achieving digital autonomy while fostering an interconnected and secure communication environment across government entities, and the national Luxchat ecosystem.

Monarc is a tool and method based on ISO 27005 that evolved from the XLS sheets to a fully independent environment for risks management and the method steps of ISO 27005 are optimised.
The tool is open source and free to use.
It has a rich community of users thanks to the projects of the ecosystem that allow to share information and adopt Monarc to the specific needs of organisations.

The Role of OSPOs in the Open Source Ecosystem

Attention spans have been declining for years and this has become a real challenge for public speakers and teachers trying to keep their audiences engaged. Find out how Claper, with its open source model, can help energise any presentation.

Here I discuss recent improvements to the extension that provides AI chat bot inside LibreOffice.

Introduce new Calc functions, XLookup, XMatch, Sort, SortBy, Filter, Unique, Sequence, RandArray, Let (lambda) functions

I would like to organise a workshop to educate interested Free Software advocates on how to convince decision-makers of the Public Money? Public Code! demand.

SERIMA is an Open Source tool being developed by the Luxembourgish Institute for Regulations that will help in handling NIS2 compliance.

The government of Schleswig-Holstein had decided, to go for the Open Document Format as standard and migrate their IT working places to Open Source and LibreOffice in specific. This is about why, what and how to do so.

SnT OSPO

LIST presents a public leaderboard based on open source software that comprehensively assesses and benchmarks Large Language Models (LLMs) according to a set of seven social biases such as Ageism, LGBTIQ+phobia, Political bias, Racism, Religious bias, Sexism and Xenophobia. The initiative aims to raise awareness about the implicit social bias embedded in LLMs, and foster advances in trustworthy AI and the alignment to recent regulations in order to guardrail the societal impacts of both proprietary and open source AI.

Embracing Open Source: a Strategic Path for Public Universities

In this session, I will explain the use of vector search functionality in LibreOffice. Vector search is a technique widely used in modern data retrieval systems, enabling the search of high-dimensional data by analyzing the similarity between vectors. Users can perform advanced searches on large datasets. This enhancement will be particularly beneficial for users working with extensive documents in Writer and Calc, providing a more powerful method for data analysis.

In a landscape where cyber threats continue to grow in volume, many organizations using Linux systems still lack effective tools for robust security monitoring. Kunai is a threat hunting and detection tool specifically designed to address this gap. This talk will provide a high-level overview of Kunai’s development, key features, and practical applications, demonstrating how it enables organizations of any size to better understand and respond to potential threats. We will emphasize the open-source aspects of the tool, including its pluggability with existing OSS (Open Source Software). Whether you're in IT or simply interested in cybersecurity, this session will provide valuable insights into how Kunai is reshaping threat detection and security monitoring on Linux systems.

This presentation explores the Danish OS2 (https://www.os2.eu/in-english) initiative that have successfully united 84% of all Danish municipalities in a collaborative effort to digitalise public services using open source solutions. The presentation will delve into the challenges faced, the strategies employed, and the results achieved through this nationwide open source collaboration.

By showcasing this model of inter-municipal collaboration, we aim to inspire similar initiatives and highlight the innovative and transformative power of open source in modernising government services.

When institutions and companies are seeking neutrality in their work, could OpenSource be right vehicle for that?

Threading improvements in Calc. Removing threading choke points from calc's parallel calculations. SvNumberFormatter, intrusive_ptr gotcha, FormulaToken reference counting

From the public administration for the public administration: openCode, hosted by the Centre for Digital Sovereignty (ZenDiS), is Germany's nationwide platform where federal, state, and local government agencies can discover, build, and share open-source software. The ultimate goal of openCode is to establish an infrastructure that encourages the adoption of sustainable open source solutions within the public sector. A crucial aspect of achieving this goal is implementing a secure software development life cycle (SDLC), and openCode offers an ideal environment for developing secure applications. One such application is openDesk, ZenDiS’ integrated suite designed for collaborative office tasks within the public sector. It incorporates proven open-source tools and makes its source code publicly available via openCode, demonstrating how openCode supports the development of secure and dependable applications.

Come and hear about some of the challenges and successes of building an open-source business around LibreOffice from Collabora Productivity's perspective. Engage with some of the various types of
open source business strategies that I've work with through my career. Hear about some of the
approaches that I've seen in action and their strengths & weaknesses.

Hear a little about the state of open source business around LibreOffice and some ideas about how the ecosystem of companies that contribute significant work back to the project can be strengthened
and grown.

Academia in its main missions of teaching and research is both a user and a producer of open source software, open educational resources and open access literature. But what are the risks that come with this openness? In this talk, we are going to cover the challenges and opportunities of open * in academia, while presenting some projects created at the University of Luxembourg.

Open Source activities within the Czech Republic are well established since nineties, the connection to the public sector and academia is booming in recent years and newly established Czech OSPO in here to connect, help and support anyone interested in this topic. The short presentation will talk about the creation and way forward for the Czech National OSPO Initiative and Brno Open Source Declaration.

Open Source and Open Standards for Digital Sovereignty

LibreOffice supports different languages and language groups, including
those languages written from right to left: Arabic, Farsi, Hebrew and
even N'ko and others.

It is somewhat of a tradition, once every few LOCons, for members of the
right-to-left LO online language-communities to describe the state of
LibreOffice' RTL language support, as perceived by users and QA
contributors rather than project developers.

This session will:

• Relate aspects of the usage experience of writers of RTL languages;
• Survey significant changes since the last state-of-RTL session - organizationally and code-wise;
• Illustrate outstanding "pain points" for RTL language users;
• suggest and re-emphasize avenues of future development effort for fundamental improvemtn in the support for these languages.

MISP, the open source threat information sharing platform has been facilitating secure threat intel exchanges for various communities ranging from multi national military alliances all the way to SMEs for over a decade now. Take a gander at the various issues we're trying to tackle and how it can help you join sharing communities and automate your detection and prevention using your peers' and network's data.

In an increasingly complex world, addressing societal challenges requires innovative approaches and effective resource utilisation. By leveraging open data, open source software, and the role of OSPOs, we can create a more efficient environment for problem-solving. This presentation will reflect on current practices in Sweden, highlight successful collaborations, and provide insights on how we can collectively achieve more with limited resources.

The European Commission's Open Source Observatory (OSOR) has released a new report offering a qualitative analysis of open source policies across 15 European and non-European countries. This research highlights the increasing importance of open source technologies in the public sector, particularly in enhancing digital sovereignty, data privacy, and control over digital infrastructures. The report emphasises the role of cities, regions, and municipalities in driving open source adoption, as well as the emergence of innovative national policy mechanisms such as Open Source Programme Offices (OSPOs). International initiatives are also influencing national strategies, promoting concepts like Digital Public Goods and Digital Commons. This report marks a significant evolution in open source policy, reflecting a shift towards comprehensive and inclusive digital governance.

In 2016, the "Open & Linux Desk" (Sportello Open & Linux) was already active in Bolzano (South Tirol, Italy), managed by the LugBZ group. With the arrival of the Covid-19 lockdown in March 2020, the desk became active in responding to the needs of distance learning, collecting and donating used PCs to students and families. The idea was born to create a laboratory to collect, clean, repair and install the donated PCs, in collaboration with the School Authorities. The "SchoolSwap" project was launched, with the aim of providing sustainable PCs (with the FUSS Linux operating system) on free loan to students. In the summer of 2020, a first web platform was activated to centrally manage PC requests, donations and support from the "Desk". A late version was activated using osTicket. Overall, from March 2020 to December 2023, over 850 PCs with FUSS9, FUSS10 and FUSS11 Debian-based operating systems were prepared and donated. The project aimed to bridge the "digital divide" and provide students at home with the same digital tools used at school, promoting digital sovereignty and circular economy.

The annual Google Summer of Code students' panel workshop - successful students & their mentors present their achievements on-stage.

Computer attacks occur in a constantly changing environment. To meet these challenges, it is necessary to implement a global approach to risk management within the organization.

LibreOffice has various CJK features. They sometimes break, should be reported and resolved by CJK users. In this talk, I will introduce some reported and fixed CJK bugs in the past year, some not fixed CJK bugs, explain the current state of the JA community and our future challenges. And I'll also talk about plans for next year's Asia Conference.

After being under the radar for decades, open source is now well identified by the regulators worldwide. New European Regulations such as the Cyber Resilience Act (or others like the AI Act and the Data Act) include open source in their scope and will enter into force in the coming years.
From individual maintainers to well established OSPOs in large companies, the open source ecosystem at large has to tackle the new challenges of compliance with these new regulations.
In this talk, Enzo Ribagnac will present the challenges and highlight the actions taken by the Open Regulatory Compliance Working Group initiated by the Eclipse Foundation to unite key stakeholders across the ecosystem—including industry leaders, small and medium enterprises, open source foundations, and maintainers. In this initiative, all the stakeholders collaborate to work on best practices and standards for compliance.

The LuCySe4RE project aims to enhance cybersecurity services for the research and education community by referring to state-of-the-art open-source tools. The project provides a a Security Operations Centre (SOC)-like framework that helps improve security maturity within the organisations.

Vulnerability Lookup streamlines the correlation of vulnerabilities from multiple sources, independent of vulnerability IDs, and enhances the management of Coordinated Vulnerability Disclosure (CVD). It also serves as a collaborative platform, allowing users to comment on security advisories and create vulnerability bundles. Developed by CIRCL within the scope of the NIS2 directive, this open-source project aims to improve the efficiency and transparency of vulnerability management. This talk will explore the origins of the project, the challenges faced in coordinated vulnerability disclosure, and how Vulnerability Lookup addresses these challenges.

LibreOffice Technology

This workshop will introduce Netbox, an infrastructure documentation tool, that can be used to document IT infrastructures of any size, from a simple homeoffice to a large multinational.

Future of digital typography is already in Writer

The Free Upgrade for a digitally Sustainable School (FUSS) project has been a groundbreaking initiative in South Tyrol, Italy. Since 2005 16,000 students and around 2.000 teachers have benefited from the adoption of open-source software in their educational institutions. This seminar will showcase how the project has successfully delivered high-quality teaching and learning experiences while promoting digital sustainability. We will explore how the FUSS project has enabled schools to reduce costs, increase efficiency, and improve digital literacy among students and teachers. Leveraging open-source software, the project has created a collaborative ecosystem that fosters innovation, flexibility and community engagement by setting a nationwide example of how software should be acquired by public schools with a focus on sharing and reuse in full compliance with the principle "Public Money? Public Code!"

ODF TC: how the standard is managed and maintained

We present Metamorphic Security Testing (MST), a testing automation approach that integrates test input generation strategies inspired by mutational fuzzing and automatically detects vulnerabilities by verifying general relations that should always hold between the outputs produced with valid and mutated inputs. It enables engineers to specify metamorphic relations (MRs) that capture how to modify a valid input as an attacker would do and specify the relation between the outputs of the valid and modified input. We developed a framework that integrates an Eclipse plugin to specify MRs and automatically tests the system. Further, we defined a catalogue of 76 system-agnostic MRs for Web systems that can discover 45% of the vulnerability types concerning the violations of MITRE security design principles. Our empirical results show that MST can detect 85% of the vulnerabilities in Joomla and Jenkins with few false alarms. Ongoing research includes the automated generation of MRs from specification documents by leveraging large language models.

Closing Address

The Luxembourg Centre for Educational Testing (LUCET) seeks to determine if Luxembourg schools are achieving their educational goals. This research unit of the University of Luxembourg conducts standardized tests with thousands of students each year to objectively assess key skills, academic performance and teaching quality. The online assessment system for these tests is delivered on a SUSE Linux Enterprise Server (SLES) cluster. In conjunction with SUSE Manager and the SUSE Linux Enterprise High Availability Extension, LUCET achieves highly efficient, secure and reliable operation of this critical application. SUSE Linux Enterprise (SLE) Micro not only allows them to deploy edge solutions very efficiently but also provides the capability to roll out the assessment system as a mobile solution in schools.

Presenter: Xisco Faulí
LibreOffice uses Bugzilla to track the software bugs. In this session, various things around bug reporting and triaging will be discussed. Students will have the time to have experience of reporting and triaging bugs in Bugzilla.

The tool that will be introduced in the first workshop enables video hosting/live streaming for education players. Like YouTube and Vimeo, this tool makes it easy to broadcast videos, as well as generating subtitle automatically. Video hosting has become central to the digital learning strategy of training organisations, and having a tool that is sovereign, without advertising or tracking, has been a recurring demand. skilltech.tube was created to meet this demand.

This talk gives an update on the ODF Standard and one of its reference implementations of the ODF Toolkit.

LibreOffice Math is one of the LibreOffice application tools that functions to type mathematical formulas in detail. LibreOffice Math provides a number of operators, functions, and formatting to help in forming formulas. The use of LibreOffice Math in writing international Scientific Papers is very much needed.
My experience in writing formulas using LibreOffice Math needs to be known for beginners who are just learning to use LibreOffice Math. I will explain the steps so that it can be easily used by beginners who want to use LibreOffice Math. One of the conveniences is that it can be reused to be modified according to the needs in writing papers or other things.

Having a fast application that serves users is crucial in giving LibreOffice users a good experience, and make them happy. Here I discuss efforts to maintain LibreOffice performance, and make it better.

Learn about the new password-based ODF package encryption that is enabled by default since LibreOffice 24.8 and will be standardized in upcoming ODF 1.5.

The tool that will be introduced in the second workshop is designed to create immersive tours for education professionals. This tool makes it easy to create interactive and informative tours using 360° photos.

Git basics

What's not to like there?

A tool for conversion and simple text markup called VML "Vishia Markup Language" is shown. The VML is simple and powerful to fulfill the requirements of texts mapped to the LibreOffice content.xml format. Only indirect formatting is supported, as is usual for commercial (technical) documents.
Working directly in LibreOffice for wysiwig and in parallel in VML plain text with current translation has some advantages in the workflow, which will be shown.

The tool that will be introduced in the third workshop is Claper, a new tool for creating interactive presentations. Like Wooclap, Kahoot and Slido, Claper can be used to create engaging presentations that are interactive with the audience in real time. Through skilltech.tools, Claper is available free of charge to all those involved in education in Luxembourg.

Presenter: Xisco Faulí
In this session, basics of code review is discussed. Students will be able to work with the LibreOffice Gerrit. Also, the importance of clean code, and the role and the process of code review will be discussed.

Present an overview of semantic changes in that important area of the office

LibreOffice has introduced some new functions in Calc in version 24.8, including the XLOOKUP function. The talk reports on the work to standardize XLOOKUP in ODF and shows the use of the function with some examples.

This talk about Conditions (If, Sumif and Countif) in Python programming and LibreOffice. I will talk about If, countif and sumif applied in Python programming and in LibreOffice Calc. Theory of If, Sumif and Countif with 3 examples from easy to harder ones will be delivered using both of them.
There is If in both of them but Sumif and countif commands only available in LibreOffice Calc while Python programming will use other techniques to obtain same result with Countif and Sumif. In Python programming , data retrieved from Ods file, same with LibreOffice Calc. Pandas is used in Python programming to read the Ods file. Text editor used in Python programming is Pycharm.

Complex office workflows can now be build for the web using the new JavaScript API for UNO. LibreOffice can be integrated into webpages as widget or used as library in the background. And everything runs locally in the browser using WASM, prividing top speed and assisting data protection.

With LibreOffice 24.8 notes are now available as a collapsible pane under the slide in Normal view. Let's talk about the how was the implementation process, and the problems along the way.

In this session, it will be discussed how to get into the complex problems with problem solving techniques. These ideas will be useful when dealing with the large code base of LibreOffice that has evolved for many years.

The rise of digital technologies and tools has given rise to new threats, particularly affecting teenagers because of their hyper-connectedness. It has therefore become essential to equip young people with cybersecurity skills. This fourth and last workshop invites you to discover an educational game developed by the LMDDC and WIDE ANDCO with the support of the Fond National de la Recherche and available on the skilltech.tools platform. This game will help your pupils (aged 13 to 16) to develop the knowledge and reflexes they need to surf online safely.

Where we came from, and what's in stock for the LibreOffice WebAssembly port

How LOWA gets away with being a mostly-Linux app running in the browser.

Improving interoperability with OOXML format may seem like an uphill battle, but there is quite a lot of improvement. I'd like to stop here and appreciate all the great work done since the last conference and the previous edition of this talk.

During this workshop, you will learn how to use the various tools from the
OpenSSH suite. We will start with a presentation of the problems that are solved
by OpenSSH, then we will dive into the details of its most important and useful
features.
Among the topics covered, we will discuss about remote host authentication,
password and public key client authentication, key generation, local and remote
port forwarding, forward and reverse SOCKS proxying, X11 forwarding, jumphosts, connection to legacy systems, and more.

Hands-on exercises will be proposed throughout the exploration of the tool suite
using real-life scenarios. There will be space for questions and discussion.

This workshop is intended for beginners who wants to improve their practical
knowledge and experience with OpenSSH.

Basic networking and Linux shell knowledge are required in order to follow this
workshop. Each participant will need a Linux machine (on which they have root access)
with Docker pre-installed and Internet access.

This session is dedicated to building LibreOffice from the sources. For this session, preparations are needed to speed up the process as downloading and compiling can be time consuming. For example, having source code and requirements downloaded, or preparing virtual machines with the prerequisites and LibreOffice source code can speed up the build process.

Come hear about the work that has been done over the last year to improve Collabora Online, based on the LibreOffice core. Hear about new features and functionality both in core and online, and how these
intersect to deliver browser-based editing goodness.

Hear details about many of the performance improvements we've made, about entirely novel feature such as background save, as well as where we have brought more of the functionality of the LibreOffice core to the browser. Hear about our new reporting & form generation APIs to automate document building over a simple REST API, and much more.

The new SORT, SORTBY and FILTER functions will be introduced and demonstrated in practice. In some exercises you will explore the use of these functions.

In this talk I'll share some results from my investigation on the viability of using ODF as an interoperability tool under real world conditions.

Report about the state and progress of the CairoSDPR.

How to save users from overwhelming dialogs with a lot of details, but convey the same information more simply. In this case, it is about conditional formatting dialog.

In my lightning talk, I will present the following enhancements and improvements made to dark mode:

• Automatic Font Color Adjustments: Improved visibility with automatic font color settings that adapt correctly to dark mode.
• Text Drawing Boxes: Fixed issues where text drawing boxes did not update with new auto-color choices.
• Theme Toggling: Refined the switching between light and dark modes, ensuring smooth transitions in Calc and applying similar improvements in Writer.
• Default Background Colors: Implemented default background colors for outliners to ensure consistent appearance when toggling themes.
• New Features: Added the "Invert Document Background Color" command for better control over document display.
• Bug Fixes: Addressed issues such as black preview measurements on dark backgrounds and improved overall dark mode support.

A short heads-up on the new, automatic Windows update mechanism.

I will talk about the PDF accessibility improvements in Calc.

In this presentation I talk about how we extended the annotations (notes, comments) in LibreOffice Draw to support PDF annotations.

LibreOffice was always capable of hosting endnotes on one or more separate
Writer pages at the end of the document, as opposed to footnotes, which appear
on the same page as the anchor itself. Word has a third mode: continuous
endnotes appear directly at the end of the body text, inline. This case was
not supported for Writer for a long time, then a first version was added in
2019. While this version did work for simple cases, it had trouble with
scaling to multi-page endnotes. This year's section version is based on
sections, which scales much better. Come and see how this work is implemented,
where are the still rough edges and how you can help.

Introduce new individually formattable characters in Chart Titles

Workshop about all things related to MSO interoperability.

STYLEREF, a field that references content by its style, has been in the power-user toolkit of other office suites since before I was born. LibreOffice, however, has always missed out. Documents with STYLEREF already didn't update it. Adding new STYLEREF fields was impossible.

Around a year ago, I implemented the STYLEREF field, bringing better compatibility with documents created elsewhere and, of course, the use cases it enables. In this talk, I'll go over STYLEREF fields, where you might use them, and a quick run-down of how I implemented them.

This talk will show the recent improvements done to privacy (how to remove personal information from your documents) & new tools for power users (expert config improvements)

The graphical programming of embedded software is usually very closely tied to specific tools. Once you have chosen one tool, it is difficult to switch to another, and it is also difficult to exchange ideas with other people using a different tool, and it is also difficult to maintain software after many years. In contrast, you can use any text editor to edit source code programs, you just need to have the right compiler tools, which are often readily available.
To work in the same way for graphical programming, I have developed a translator and drawing functionality approach that uses LibreOffice draw. The tool reads the content.xml and translates it into a suitable target language (usually C/++).

Take a look into the development of the new UNO bindings for .NET 8, with cross-platform support and latest .NET syntax, bringing the power of the entire LibreOffice suite to .NET developers. This lightning talk will cover the architecture, technical hurdles, and the future of .NET-UNO integration within LibreOffice.

Long ago, OpenOffice implemented an image-layout option to "Follow Text Flow" in order to allow interoperable with Microsoft's "Layout in Table Cell". Many interoperability import improvements have been made for 25.2.

Placeholder slot, for packaging lots of lightning talks (even some from speakers recruited on the spot) in one place

In this session, the structure and modules of LibreOffice code is discussed. An overview of some of the most important modules are provided. The goal is to provide an overview of the code and its architecture to gain better understanding of the huge code base of LibreOffice. This section is helpful for the next sessions which need some basic understanding of the overall LibreOffice code architecture and modules.

Introduction to new Writer 24.8 and 25.2 features developed for a market-leader German travel book publisher

Come hear about a tool that can help you to migrate Windows native apps that require Microsoft Office and use OLE integration to embed and re-use Word or Excel. See how we can use this to trace what APIs are used by a windows application, and then to transparently replace these.

Hear about the limitations and opportunities for improvement here, as well as why this is does not ship by default in LibreOffice currently.

LibreOffice was able to display curve-based multi-line fontwork text, but the text palcement was good only on the base line.
It has now been improved by calculating separate curves for separate lines, and some issues have been fixed.
Come and see how this is implemented, what math is behind the curve calculation and the text placement.
What were the challenges, and what still needs to be solved. (there are some interesting impossible cases)
See how MS word handle them compared to Libreoffice.

This talk will give an overview of general principles and guidelines for digital accessibility and will cover some of the recent accessibility improvements in LibreOffice.

Presenter: Olivier Hallot
In this session, the documentation for software, and its role in software development is discussed.

Looking at the state of the ODF ecosystem & standard

LibreOffice Asia Conference 2024 was held during August 2-4 in Taipei. Besides talk sessions, there are a few other events. This talk gives a simple walk-through of the whole events.

Presenter: Prof. Dr. Rafael Lima, Alain Romedenne
In this session, one only needs a working installation of LibreOffice. Two different scripting language are suggested in this path: Basic and Python.

After my lightning talk in Almeria, it's time to talk about during those five years in France, from the current tender with professionals to the next one.

How public money led to better, more secure, and more feature-full public code in LibreOffice land.

The purpose of the possibility of whistleblowing is not that for the Code of Conduct issues, it is different. What it is, why and how it is in place for The Document Foundation will be shown in the talk. It also clearifies the roles of involved entities in such a serious process and how anonymity is handled. It will leave time for questions and answers.