Collabora’s Talks at the LibreOffice Conference 2023 in Bucharest

Upcoming talks by Collabora at the LibreOffice Conference 2023

The LibreOffice Conference 2023 will take place from September 20 to September 23 in Bucharest. We are glad to be able to sponsor this event and to contribute a significant number of talks on various aspects of LibreOffice technology. Here is a list of talks by our team to consider for your conference schedule. Please don’t forget to check back after the event. We will be sharing the links to the slides and videos of the conference talks as soon as they are available.

Browse talks by day

To make it easy to navigate through the timetable, we sorted the talks chronologically. Please find the complete schedule, including track topics and more filters, on the conference website!

Thursday, 21 September 2023 🌅 (morning sessions)

Michael Meeks: Sponsor Keynote

21 September 23  12:00 – 12:30 EEST (UTC+3)  1 Room 1

Michael Meeks, Managing Director of Collabora Productivity, has a look at the latest developments in LibreOffice Technology from the perspective of the ecosystem.

See details  Save to calendar

Justin Luth: Using configuration extensions to automate preferred defaults

21 September 2023 15:30 – 16:00 EEST (UTC+3) Room 1

Justin Luth outlines the advantages and disadvantages, and showcases some simple examples and installation scrips on using configuration extensions to automate defaults.

See details  Save to calendar

Attila Szűcs: Zip64 support in LibreOffice

21 September 2023  16:00 – 16:30 EEST (UTC+3)  Room 1

As technology advances, documents will become larger and larger, and the original zip standard will no longer suffice, so Zip64 extensions have to be used in LibreOffice, to increase the limitations of zip.

See details  Save to calendar

Timur Gadžo: Tracking bugs in LibreOffice together …

21 September 2023  17:00 – 17:30 EEST (UTC+3)  Room 2

There are different paths that help provide quality assurance. Some are done by devs, some in TDF, some by ecosystem partners. Many paths lead to Gerrit. Here we are showing some examples of how Collabora and its partners are helping fix bugs in LibreOffice Technology.

See details  Save to calendar

Justin Luth: Avoiding regressions by hunting in QA unit test

21 September 23  17:50 – 18:00 EEST (UTC+3)  Room 2

Fixing bugs can be quite a challenge. Based on a complicated example, Justin Luth speaks about some lessons learned, shows how to avoid regressions. See details  Save to calendar

 

 

Friday, 22 September 2023 🌅 (morning sessions)

Miklos Vajna: Multi-page floating tables in Writer

22 September 2023  09:00 – 09:30 EEST (UTC+3)  Room 1

LibreOffice was capable of handling multi-page tables and floating tables in Writer already. But it was not possible to combine these two features to have a multi-page floating table, which is a frequently used feature in Word documents. Hear Miklos Vajna explain the challenges on implementing this functionality.

See details  Save to calendar

Caolán McNamara: Crashtesting, Fuzzing: 2023 report

22 September 2023  09:30 – 10:00 EEST (UTC+3)  Room 1

We process 812,729 documents in crashtesting, which takes 4 days per cycle. A report on the current crashtesting and fuzzing status.

See details  Save to calendar

Mike Kaganski: LanguageTool integration improvements and some other fixes

22 September 2023  10:30 – 11:00 EEST (UTC+3)  Room 1

In this talk, Mike Kaganski will describe some improvements & fixes he made to LibreOffice over the last year, including some recent changes to the native LanguageTool integration.

See details  Save to calendar

Tomaž “Quikee” Vajngerl: Document Themes

22 September 23  12:00 – 12:30 EEST (UTC+3)  Room 2

The document themes are a way to quickly, easily and consistently change the design of a document. Hear Tomaž “Quikee” Vajngerl talk on the possibility to add, change and preserve the themes of a document for Writer and Calc that is now available in LibreOffice 7.6.

See details  Save to calendar

 

 

Friday, 22 September 2023 🌇 (afternoon session)

Jaume Pujantell Traserra : PDF handling in LibreOffice

22 September 2023  15:30 – 16:00 EEST (UTC+3)  Room 2

LibreOffice needs to handle PDFs in various contexts: from inserting them inside a document, to converting them to ODG format or showing them with the experimental PDFium API. Hears Jaume Trassera’s talk on the strengths and pitfalls in different situations.

See details  Save to calendar

Szymon Kłos: Improvements in JSDialogs – LibreOfficeKit API for UI components

22 September 2023  17:20 – 17:30 EEST (UTC+3)  Room 1

JSDialogs is the framework for sharing UI components between LibreOffice and Collabora Online. Szymon Kłos explains their functionality and shows many of the optimizations and improvements it recently gained.

See details  Save to calendar

Henry Castro: Importing Excel conditional format

22 September 2023  17:30 – 17:35 EEST (UTC+3)  Room 1

Hear Henry Castro’s conditional format update on new properties and issues found (reading code) to import Excel conditional formats.

See details  Save to calendar

Justin Luth: Forms: keyboard navigation and VBA macro control

22 September 2023  17:40 – 17:45 EEST (UTC+3)  Room 1

In this presentation, Justin Luth outlines the three different types of form controls available in LibreOffice and talks about newly gained keyboard navigation and VBA macro access to form controls.

See details  Save to calendar

Paris Oplopoios: Per-view rendering improvements

22 September 2023  17:45 – 17:50 EEST (UTC+3)  Room 1

Learn about the improvements made on view separation based on different view options in scenarios where there can be multiple users with different view options.

See details  Save to calendar

Gökay Şatir: View-based accelerator configuration manager

22 September 2023  17:50 – 17:55 EEST (UTC+3)  Room 1

Hear Gökay Şatir‘s talk on the recently added support for language-specific shortcuts. When a document is being edited by multiple users, they can all use their languages’ shortcuts.

See details  Save to calendar

Saturday, 23 September 2023 (morning sessions) 🌅

Mike Dworski: The 3 layers of typo Correction: AutoCorrect, spellchecking, and grammar checking

23 September 2023  09:30 – 10:00 EEST (UTC+3)  Room 1

Were you ever frustrated by ducking AutoCorrect? Seeing red squiggles under misspelled words? Accidentally putting the wrong words inside your sentences? Learn how each layer tackles different types of errors, plus how to refine the dictionaries and tools that are already there!

See details  Save to calendar

Michael Meeks: An economic perspective on FLOSS & LibreOffice technology

23 September 2023  11:00 – 11:30 EEST (UTC+3)  1 Room 1

Hear Michael Meeks‘ talk and join the discussion around FLOSS business models as they related to LibreOffice technology, the ecosystem, and funding the future & success of LibreOffice.

See details  Save to calendar

Find out more about Collabora Office & Collabora Online


Collabora Productivity created Collabora Online, a powerful online office suite, which you can integrate into your own infrastructure. It prioritises your digital sovereignty and provides you with all the tools to keep your data secure, without compromising on features. Collabora provides a wide range of products, as well as consulting services for enterprises and governments. Powered by the largest team of certified LibreOffice engineers in the world, Collabora is a leading contributor to the LibreOffice technology community. Collabora Office for Desktop and Collabora Online provide a business-hardened office suite with long-term support. Collabora’s multi-platform policy is completed with Collabora Office for iOS, Android, and Chrome OS. Collabora Productivity is a division of Collabora, the global software consultancy dedicated to providing the benefits of Open Source to the commercial world, specializing in mobile, automotive and consumer electronics industries. For more information, follow us on Twitter, Mastodon, LinkedIn and YouTube.

Collabora Office 23.05 Unveils Exciting New Features, Empowering Users with Enhanced Productivity and Interoperability Features

The new Collabora Office 23.05 brings more features, improved performance and increased interoperability

Cambridge, August 7, 2023 – We are happy to announce the new major release of Collabora Office 23.05.

Collabora Office, for Linux, Windows and Mac, is the enterprise version of the world’s most popular open-source office productivity suite, LibreOffice. It is the foundation for new versions of our online collaborative office, Collabora Online, and also powers our apps for iOS, Android and Chrome OS.

The enterprise office suite provides businesses and professionals a richly featured, secure document creation environment with Long-Term Support (LTS) and bespoke development services backed by decades of experience.

Collabora Office’s new release includes new features targeting three key areas: accessibility, interoperability and usability. Below you will find an overview of the exciting new features and improvements that are available in Collabora Office 23.05 and where you can download it.

Accessibility Features

Accessibility features are created to provide comfort to all users, for example, those who prefer to use just a keyboard, those who cannot see the screen very well or those who have impairments.

Dark Mode

Dark Mode has seen over 40 bug fixes and improvements and further support for switching between dark and light mode manually.

To toggle dark mode on and off:

Along the top navigation bar select: Tools → Options

Collabora Office → View → Appearance Mode: “System”, “Light”, “Dark”
Toggle between light and dark mode

Interoperability Features

For some time, users and organizations have faced a major challenge when trying to find an alternative to Microsoft’s widely-used productivity suite: the issue of file compatibility and interoperability. These improvements continue to build on our already solid base of excellent interoperability and are fully compatible across both the desktop and online versions of Collabora Office.

Document Themes

Document themes are predefined formatting settings that you can apply to a whole document to easily change and re-purpose its appearance, add your own branding and give it a consistent feel. They usually include a combination of specific colours and fonts for heading, subheadings and body text. When the formatting is changed within the theme, it will change across all parts of the document following that formatting.
Themes also allows the user to choose between multiple default looks of objects when inserting and changing, which are derived from the current theme.

To apply a document theme:

Select on the top bar ‘Format → Theme’
Select the theme you’d like to apply
Press ‘Ok’

To create a document theme

Select on the top bar ‘Format → Theme → Add’

From here you can define colours for each part of your document.

Change and customise your Document Theme via a dialog box

Multi-page Floating Tables in Writer

This new feature is a combination of two existing capabilities. Multi-page tables and floating tables. Multi-page tables are tables than span their content over more than one page. Floating tables are tables inside a floating frame. This allows you to wrap text around them, which is particularly useful for brochures. Previously, it was not possible to combine these two features.

Floating frames used to work only on a single page. Now you can create floating tables that span across multiple pages. It improves interoperability with Microsoft’s OOXML format. It also significantly improves interoperability with tables that have been accidentally floated by users in Microsoft Office – often by just adjusting table sizing and positioning. This is frequently a problem in mis-designed Government forms – where tables are used for rendering borders, these should render and be editable with this update.

If you are interested in the complex technical challenges behind this feature, we encourage you to take a look into the series of posts by developer Miklos Vajna. There’s also a very insightful talk presented at COOL Days 2023 on YouTube. This feature is is still under active development, with some minor issues on specific use-cases to be ironed out, but you can make use of it in Collabora Office 23.05 now.

Multi-page Floating Tables in Collabora Office 23.05

Compact View of Pivot Tables

Pivot Tables are a flexible and powerful analysis tool for mixed data sets. Collabora Office can create and import Pivot Tables. The feature had first been introduced to in early 2021 together with numerous statistical tools. Meanwhile, the feature has seen further interoperability improvements. Collabora Office Calc is now able to preserve the more recent default compact Pivot Tables created in Excel. In addition to the more accurate visual representation, this improvement also avoids incorrect cell references.

Multi-Stop Gradients

Exciting improvements have been made to the under-the-hood renderer! Our rendering engine has been enhanced and can now handle even more complex gradients. You can now turn up the visual appeal of your document by incorporating multi-stop gradients into shapes, borders, and other elements. This update is essential for anyone who works with intricate graphics – bringing improvements and better interoperability for existing documents and making it easier to edit more complex designs and graphics.

Improved Frame Anchoring and Position

Collabora Office 23.05 includes improved compatibility with older document-framing descriptions including better positioning for frame handling, better support for combining/splitting frames and overlapping frames, fixes to some cases where parent styles were ignored, and fixes to avoid UI anchor changes that caused movement on the page.

64-bit Zip Support

The Zip64 standard extends numerous internal limitations in the XLSX and ODS formats used to compress documents. While the old zip limitations are enough for most practical user cases, documents with enormous amounts of content embedded could occasionally run into such limits. With support for Zip64 included in 23.05, editing and working with huge spreadsheets is now possible in Collabora Office. Zip64 also serves as a replacement – replacing the older standard for smaller files.

Zip64 support makes for exciting news for all, whether you’re a pro handling massive documents or a casual user who will surely benefit from the interoperability improvements! Everyone can expect improvements across the board.

Usability

Keyboard Navigation through Forms

You can use the tab key to circularly navigate through content controls and fieldmarks. The modern content controls have a tabIndex field, which allows for precise ordering of keyboard navigation. The tabIndex also allows a control to be skipped – which is useful to avoid getting stuck in rich text controls (since the tab key needs to insert a tab character in that case). Form developers can specify the tabIndex via the content control properties UI.

Navigate easily through forms using the tab key

Page Number Wizard

A wizard dialogue box has been added, combining inserting the required headers, footers, and page number fields into a single, easy to use, familiar dialog for users. This features all the common alignment options, support for a variety of languages, and a preview.

Simply select ‘Insert → Page Number...’

and you will see a dialogue box appear which enables you to customise the positioning, alignment and style of page numbers, along with a preview. There are a variety of supported languages available.

To remove page numbers, simply delete the page number in one of the footers and it will remove the page numbers on all pages.

Insert page numbers with the new Page Number Wizard

Other New Features

  • New ‘plain text’, ‘combo box’ and titles and tags options in Content Controls.
  • Added support to open multi image TIFF files.
  • Auto fitting text scaling algorithm has been changed so it works similar to MS Office.
  • Categorized link targets when linking to a presentation.

Community

Collabora has invested significantly in bringing a host of new features and functionality to this latest release and contributes a vast majority of the Collabora Office code. However, we want to acknowledge all of our friends and colleagues in the wider LibreOffice community who helped to contribute not only to this, but also to the underlying LibreOffice Technology upon which Collabora Office, CODE and Collabora Online are built.

All of our code is open source and available to the public on GitHub. Join the Collabora Online Community, take part in easy hacks and discussions in the forum.

Here are some new features contributed by the LibreOffice community.

Typographical Editing

New optional hyphenation settings are available to give rules for adjusting text flow. You can now limit hyphenation within paragraphs, set a minimum word length for hyphenation and opt to not hyphenate the last word of a paragraph.

This work was done by László Németh, NISZ.

Typographical Editing Options

Change Tracking in Numbered Lists

When making changes within numbered lists, the numbering has now been fixed to show actual and original numbers within the document.

Example of new change tracking in numbered lists

Table Style Design Support

You can now modify table styles and create new ones in Impress and Draw. Modified styles are saved into documents, and can be shared via templates. You can access this function by right-clicking on a design in the Table Design Sidebar panel.

This work was done by Maxim Monastirsky.

Table Design Options in the Sidebar

Other community wins include:

About Collabora Productivity

Collabora Productivity is a leading provider of innovative software solutions, catering to the needs of individuals and businesses worldwide. With a focus on usability, performance, and security, Collabora Office and Online empower users to accomplish their goals efficiently and effectively.

Collabora Office is the latest enterprise release of our desktop office suite based on LibreOffice Technology, for professional, mobile, and online use. Collabora Office 23.05 provides businesses and professionals with the best features, interoperability, LTS and L3 support. Collabora is privileged to work with so many great contributors to the LibreOffice project and appreciates all the outstanding work done by so many that is included into Collabora Office 23.05. Our annual release, contains code that was contributed to LibreOffice 7.4, 7.5 and 7.6. For a deep dive on all details and credits, please do take a look at the release notes.

It’s easy to migrate to Collabora Office 23.05 or try Collabora Office 23.05 for yourself! Just head to the Collabora Office page and request your demo today, or download on the Windows or Mac App store.

If you would like to help test out the very latest Collabora Office versions before official release, you can download the development snapshots.