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.

How to Manage Bibliographic Data With Zotero and Collabora Online

 

Collabora Online & Zotero

Zotero is an open-source reference management software allowing users to manage bibliographic data and related research materials. It allows users to share bibliography libraries and notes, choosing from different citation styles. Collabora Online can now browse all the existing records of one’s Zotero library, enabling users to insert, remove, and refresh references, citations, and notes or to automatically generate bibliographies. This makes Collabora Online an excellent solution for research and academia alike, as well as an ideal option when working with Zotero research assistant.

 

Setting-up Zotero for Collabora Online

Setting up Zotero for Collabora Online in Nextcloud

At the time of writing, the Zotero integration is available to Nextcloud users with installed Richdocuments (v7.1.0 and up). All that is required to use this feature is Collabora Online, Nextcloud with Nextcloud Office app (richdocuments) installed and a valid Zotero API Key. Zotero users can create or edit their API keys at zotero.org/settings/keys and then simply copy it into the respective field inside the office settings (Administration Settings > Office) of their Nextcloud instance. All private properties related to the user remain private at all times, while public properties remain accessible to other users and are handled separately.

Inserting Citation and Choosing Citation Style

Choosing the citation style before inserting a first citation with Zotero in Collabora Online

Place the cursor on the position in your Writer document where you would like to highlight a citation. In the “Reference” menu or tab – depending on which user interface you are using – choose “Add Citation”. If this is the first time a citation is added to the document, a style prompt will show up, allowing you to choose from numerous citations styles – for example, Chicago Manual of Style, MLA Style, ISO-690, APA Style, Oxford Style Guide and many more. Setting the citation style needs only be done once, the chosen citation style will be stored inside the document. The work to be cited can be chosen from a pop-up dialog including your personal and shared libraries on Zotero. Large libraries can be filtered using the search bar.

Adding Citation from the Zotero library in Collabora Online (Tabbed UI)
Choosing a work to cite from the Zotero library in Collabora Online
Select footnotes or endnotes in the preferred style

 

Refreshing Citations and Style

Refreshing citations from the Zotero library in Collabora Online

It’s a common workflow for authors to add a series of incomplete records to their library as a first step, and then adding additional metadata. Another common request is to be able to change the citation style for a document. This is important when submitting works for different publications, but also if for instance a citation style gets updated to a newer edition. Collabora Online allows these updates to be made easily.

Pressing the button “Refresh Citations” (or selecting the respective item inside the menu of the Compact View UI) fetches the updates from your Zotero library. A message at the button of the document keeps the user informed about the progress of this process. Updating the Citation Style is also straightforward. The option “Citation Preference” opens the above-mentioned Citation Style dialog, allowing users to switch styles for the whole document at any time.

 

Creating a Bibliography and Inserting Notes

Adding an auto-generated bibliography inside Collabora Online

The Zotero integration allows users to make a clear distinction between notes and citations in Collabora Online. Inserting a note works similar to inserting a citation. Choosing this option from the UI will open the dialog and grant access to the notes of the user’s Zotero library. Notes are quite flexible items that can include HTML, formatting and emojis.

A bibliography of the works cited in the document can be generated automatically with a simple click. It appears at the position where the cursor is located. Collabora generates only the pure bibliography without additional text or placeholders, so the heading can be added according to your preferences (index, glossary, bibliography).

 

Try it in Collabora Online or CODE

The Zotero integration has been introduced to Collabora Online with the release of Collabora Online 22.05.10 in February 2023. You can test the feature in our free demo. Tech enthusiasts may also like to test it inside an installation of CODE, the free Collabora Online Development Edition, intended for home users and Developers who would like to help to test the latest features first. Find all the instructions here.

 

 

Talks and Slides by Collabora Productivity at FOSDEM 2023

FOSDEM 2023 – The Talks and Slides from the Collabora Productivity Team

FOSDEM has returned to Brussels! It was great meeting again in person on Europe’s largest open-source conference for developers and tech-enthusiasts. We’d like to express our gratitude to the community, the organizing team and the many volunteers that made this happen. The Collabora team gave numerous talks, mainly on the LibreOffice Technology track. Missed a presentation? Would you like to dig deeper? Please find the links to the videos and to the downloads of the slides below. Would you like to discuss with us on some of the technical topics? Meet us in the forum or join the discussions on GitHub!

 

Michael Meeks

Collaboration and Content Management devroom

Collaborating with Collabora Online – How to re-use Collabora in your work or project

Collabora Online brings LibreOffice technology to the browser and integrates with a large number of different Open Source products. Come and hear from Michael Meeks how you can plug into new APIs we have for Grammar checking (with LanguageTool), Bibliography Management (with Zotero), and translation integration (with DeepL). Hear how an integration can work, and the new SDK samples to build on that we provide to make things easy for developers. Also catch a glimpse of the many improvements to the product that we’ve made to improve collaboration performance, interactivity, as well as core LibreOffice technology pieces around intereoperability and performance. Hear about our plans around off-line in the browser, and ask any questions you have. See details

Watch the talk!
Download the slides!

 

Pranam Lashkari

LibreOffice Technology devroom

Feature Locking and Feature Restriction – Integrator’s Way to Unlock Potential

In this talk, Pedro Silva presents Pranam Lashkari’s work on feature locking and restrictions in Collabora Online. Using such methods, integrators can control which features to deliver to which user or group. See details

Watch the talk!
Download the slides!

 

Miklos Vajna

LibreOffice Technology devroom

Writer Content Controls – What Happened in the Past Half Year

LibreOffice was capable of handling form filling in Writer for a while already. In the meantime, the competition introduced Structured Document Tags. Writer Content Controls are meant to perform a great handling of this third type of form filling. See Miklos Vajna‘s talk about what we have done to bring themes to LibreOffice, hear what still needs doing and find out how you can help. See details

Watch the talk!
Download the slides!

 

Sarper Akdemir

LibreOffice Technology devroom

An Interoperability Improvement in LibreOffice Impress Tables

Sarper Akdemir tells the story of an interoperability bug fixing adventure where the problem turned out to be deeper than it appeared at first glance, showcasing how there are multiple approaches to a single interoperability problem. See details

Watch the talk!
Download the slides!

Attila Szűcs

LibreOffice Technology devroom

Footnotes in Multi-column Sections

In this talk, Attila Szűcs showcased the fix a seemingly small bug, that became much more complex than expected, because of the differences between writer’s, and word’s multi-column footnote capabilities. See details

Watch the talk!
Download the slides!

 

Paris Oplopoios

LibreOffice Technology devroom

Supporting Old Proprietary Graphic Formats

Some proprietary graphic formats from the 90s like WMF are device dependent and hard to support. The standard is hard to navigate and implement. See how WMF bugs are debugged, fixed and tested. See details

Watch the talk!
Download the slides!

 

 

Michael Meeks

LibreOffice Technology devroom

Collabora Online Over Lockdown – How LibreOffice Technology in the Browser Got Better

Collabora Productivity’s CEO Michael Meeks showed how Collabora Online (COOL) has improved over the COVID-19 era, not only in core feature-function, but also in ease of access and deployment for everyone. See how we can deliver scalable, secure, on-premise editing of your documents with a simple, easy to deploy office for the free world. See details

Watch the talk!
Download the slides!

 

Szymon Kłos

LibreOffice Technology devroom

LibreOfficeKit – Bridge Between Your Application and LibreOffice

Szymon Kłos gave a short introduction into integrating LibreOffice using LibreOfficeKit with external software. He described the most important code pieces and showed, where to look for information. He also demonstrated how to add new features, which API we provide, and what can be done with tiled rendering. See details

Watch the talk!
Download the slides!

 

Pedro Pinto Silva

LibreOffice Technology devroom

Make Collabora Online Yours – Customize and Integrate it Everywhere

Collabora Online is quite flexible in the means that you can alter to your personal taste without the need to change other core components. Pedro Pinto Silva shows how to make Collabora Online yours. Discover all the shining new additions to the user interface and learn how to customize and integrate it everywhere. Also, have a look at Pedro Pinto’s recap blog post to learn more about his FOSDEM experience. See details

Watch the talk!
Download the slides!

 

Tor Lillqwist

LibreOffice Technology devroom

Collabora Online and WASM – Assembling Off-line Collabora Online with the Web

Tor Lillqvist‘s talk showcased a new approach to enabling browser deployment of rich office functionality – built on top of allotropia’s investment in enabling the core LibreOffice technology to compile to Web Assembly (WASM) – combined with the Collabora Online front-end. See how this can be used to provide a fall-back (non-collaborative) editing mode for when you lose network connectivity, and about the plans to re-synchronize documents on the return from such a tunnel. See details

Watch the talk!

Download the slides!

Read more about FOSDEM from the team:

 

 

About Collabora Online

Collabora Online 22.05 is our latest enterprise quality release. It’s suitable for large-scale deployment, and comes with SLA, enterprise support with signed security updates as well as interaction with product management, helping to direct our development priorities. Collabora Online integrates flawlessly into Nextcloud, ownCloud, Seafile, and many of the major file sync & share, groupware and hosting solutions. It’s ideal for organizations that want to collaborate on documents, without losing control over them or compromising on privacy. With the ability to host it on your own hardware or to integrate it into a trusted environment, Collabora Online is the ideal online office suite for digital sovereignty. Enterprises interested in using Collabora Online can check out our home page for more information on partner integrations and online demos. Hosting and Cloud businesses that wish to add Collabora Online to their product portfolio can become a partner. For any questions or tailored solutions, do not hesitate to contact hello@collaboraoffice.com.