LibreOffice QA Blog

General Activities

1. LibreOffice 7.4.5 was announced on January 26
2. Rafael Lima continued polishing dark mode support, made the BASIC code editor warn in case of read-only modules and dialogs and made it possible to toggle the display of section boundaries independent from text boundaries in Writer. He also added a help page for Calc’s STYLE function and improved and expanded ScriptForge help
3. Adolfo Jayme Barrientos made many smaller string improvements both in help and in the UI
4. Olivier Hallot (TDF) added a guide to help for Content Controls, updated menu item paths and added help pages for Translate command, page numbering wizard and reworked help pages about indexes
5. Stéphane Guillou (TDF) improved the help for paragraph styles
6. Miklós Vajna (Collabora) made XHTML export more robust, created plumbing for citation handling in Writer and expanded the XML layout dumping developer functionality. He also fixed crashes and several Writer regressions
7. Jean-Pierre Ledure worked on the ScriptForge library
8. Tünde Tóth (NISZ) fixed issues with oversized bounding boxes when editing embedded objects in PPTX or XLSX files and made it so linked OLE objects are retained upon PPTX export
9. Szymon Kłos, Pranam Lashkari, Mert Tumer, Ashod Nakashian, Andras Timar and Henry Castro (Collabora) worked on LOKit improvements. Szymon also corrected the exporting of symbol characters to DOCX. Andras added support for importing colours with transparency from HTML
10. Eike Rathke (Red Hat) fixed issues related to the Calc option “Use English function names” and Manage Changes dialog in Calc. He also corrected the help references for End and Shift+End keyboard shortcuts in Calc
11. Tomaž Vajngerl (Collabora) polished support for document themes, for example adding a dialog for changing the theme used in the document
12. Julien Nabet made many cleanups in autocorrect entries for different languages (together with Caolán), also adding a script to check for mistakes in the autocorrect definition files. He also fixed an issue with copying content in Base to a table without an auto value primary key and an issue with rendering text warp shapes in RTF files (together with Regina Henschel)
13. Jim Raykowski added an indicator for linked images in Navigator and made it possible to navigate by field starting from the last field
14. Andreas Heinisch made it so AutoText dialog proposes the name and shortcut for a new snippet based on currently selected text, made Calc sheet arrangement in the tab bar respect RTL settings and made CSV import dialog display RTL words in the expected order
15. László Németh made DOCX import of tables more relaxed in case of missing definitions, made it so hidden bookmarks don’t display markers in the document, fixed a WebDAV upload issue and fixed some crashes and regressions
16. Xisco Faulí (TDF) made over 20 additions and improvements to automated tests and fixed some crashes
17. Michael Stahl (allotropia) improved the DOCX and RTF compatibility with hidden paragraph breaks, made it so URLs are not hyphenated by default, improved DOCX and RTF compatibility with table of content styles and fixed issues with XForms form submission and selecting all when a hidden paragraph is at the start or end of a Writer document
18. Mike Kaganski (Collabora) fixed issues with list numbering and line height in DOCX files and a layout refresh issue after running certain macros. He also made many code cleanups and improvements to readability
19. Caolán McNamara (Red Hat) improved the accessibility of the Envelope dialog, worked on initial accessibility support for gtk4, continued polishing dark mode support and removed the arbitrary limit of thirty thousand words in dictionaries. He also made many other UI-related improvements and crash fixes
20. Stephan Bergmann (Red Hat) made many code and build-related cleanups, for example adding support for dynamic_cast on UNO proxy objects, simplifying accessibility code, refactoring many helper classes, removed some dead C++ UNO bridge implementations and fixed some deadlocks. He also made fixes to automated tests
21. Noel Grandin (Collabora) updated Skia to the latest version. He also made many code cleanups, for example fixing issues found by ThreadSanitizer, working toward the goal of converting VCL to use alpha instead of transparency in colours, simplifying code by using dynamic_cast instead of XUnoTunnel and reducing complexity in Impress and Draw code that uses UNO
22. Justin Luth (Collabora) added support for conditional text to DOC and RTF export, VBA macro buttons in XLSM files, Linked Cell property of checkboxes in XLSX files and FormField controls in BASIC and VBA. He also fixed issues with DOCX Merge Field Formatting, unnecessary highlighting of No List toolbar button, incorrect table cell heights in DOC and DOCX files and made big improvements to outline numbering
23. Heiko Tietze (TDF) improved the accessibility of status icons for colour blind people, made the Paragraph Style toolbar dropdown less cluttered and made several other UI improvements
24. Paris Oplopoios (Collabora) worked on Content Controls and DOCX compatibility with comment replies
25. Armin Le Grand (allotropia) made refactorings in graphics handling code, for example changing how graphical primitives are rendered with Direct2D
26. Taichi Haradaguchi updated some patches for external dependencies and updated curl
27. Tibor Nagy (NISZ) fixed incorrect scaling in shape backgrounds with PPTX export
28. Radhey Parekh fixed an issue with unwanted line breaks in imported text files and limited sheet insertion action in Calc to just the button instead of the whole tab bar
29. Arnaud Versini made some code cleanups
30. Tor Lillqvist (Collabora) worked on the WASM build
31. Chenxiong Qi ported many Java SDK examples to Python
32. Laurent Balland fixed issues in Calc number formats
33. Patrick Luby (NeoOffice) fixed issues related to Skia and improved stability on macOS
34. Attila Szűcs (Collabora) fixed PPTX import issues related to shape transparency, connectors and line breaks in Fontwork
35. Dennis Francis (Collabora) made PDF exporting more robust
36. Michael Weghorn worked on the Android build
37. Ilhan Yesil made it possible to set a background colour for listbox form controls
38. Vasily Melenchuk (CIB) fixed RTF import issues related to list numbering, indent in tables and table cell widths
39. Regina Henschel implemented conversion of WordArt to Fontwork upon DOCX import, started working on Fontwork DOCX export support and improved compatibility with DOCX document themes
40. Áron Budea (Collabora) fixed a regression affecting right-to-left UI
41. Wu Jiahuan (Loongson) fixed a test failure affecting loongarch64 UNO bridge
42. Winfried Donkers made MATCH, HLOOKUP and VLOOKUP Calc functions comply with the ODF specification
43. Gülşah Köse (Collabora) fixed a pie chart MS Office compatibility issue and made the Sidebar area property panel more intuitive
44. Fred Kruse made improvements that benefit the performance of the LanguageTool extension
45. Balázs Varga (allotropia) added formula support to Calc’s data validation feature
46. Colomban Wendling (Hypra) worked on accessibility tests
47. Kohei Yoshida added support for wrap-text and shrink-to-fit flags in Excel 2003 XML import, fixed a character encoding issue in Calc’s XML source feature and upgraded mdds and orcus libraries
48. Mark Hung worked on custom animation sound support for PPTX export
49. Hossein Nourikhah (TDF) improved the VCL workbench examples
50. Samuel Mehrbrodt (allotropia) converted dialogs warning about disabled macro functionality into infobars

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

501 bugs, 44 of which are enhancements, have been reported by 302 people.

Top 10 Reporters

1. Gabor Kelemen (allotropia) ( 26 )
2. BogdanB ( 23 )
3. Mike Kaganski ( 17 )
4. Telesto ( 14 )
5. Regina Henschel ( 13 )
6. Stéphane Guillou (stragu) ( 13 )
7. Xisco Faulí ( 13 )
8. sdc.blanco ( 9 )
9. Robert Großkopf ( 8 )
10. NISZ LibreOffice Team ( 6 )

Triaged Bugs

717 bugs have been triaged by 77 people.

Top 10 Triagers

1. Buovjaga ( 207 )
2. Stéphane Guillou (stragu) ( 136 )
3. Heiko Tietze ( 38 )
4. m.a.riosv ( 33 )
5. Julien Nabet ( 32 )
6. Telesto ( 26 )
7. Dieter ( 21 )
8. V Stuart Foote ( 21 )
9. Xisco Faulí ( 16 )
10. Mike Kaganski ( 15 )

Resolution of resolved bugs

541 bugs have been set to RESOLVED.

Check the following sections for more information about bugs resolved as FIXED, WORKSFORME and DUPLICATE.

Fixed Bugs

164 bugs have been fixed by 34 people.

Top 10 Fixers

1. Caolán McNamara ( 21 )
2. Michael Stahl ( 10 )
3. Heiko Tietze ( 8 )
4. Rafael Lima ( 8 )
5. Justin Luth ( 7 )
6. László Németh ( 6 )
7. Mike Kaganski ( 6 )
8. Andreas Heinisch ( 5 )
9. Patrick Luby ( 5 )
10. Noel Grandin ( 5 )

List of critical bugs fixed

1. tdf#153059 CRASH: Clicking on the header/footer button after scrolling ( Thanks to Caolán McNamara )

List of high severity bugs fixed

1. tdf#107625 Envelope dialog: Make dialog more a11y friendly ( Thanks to Caolán McNamara )
2. tdf#146248 Crash at undo header swlo!sw::XTextRangeToSwPaM+0x5f9: ( Thanks to László Németh )
3. tdf#147342 [macOS] UI Scale not working on non HighDPI external display when using Skia and a laptop with Retina display (HighDPI) ( Thanks to Patrick Luby )
4. tdf#150380 Calc crash when clicking on the title of the Border Color toolbar popdown ( Thanks to Noel Grandin )
5. tdf#152245 Crash with copy-paste from Calc to Writer table with tracked changes ( Thanks to László Németh )
6. tdf#152710 CRASH: importing ooo84576-1.odt, crashtest; corrupt document structure ( Thanks to Michael Stahl )
7. tdf#152950 Calc sort crashes after changing from default language to a different one ( Thanks to Caolán McNamara )
8. tdf#152964 Crash on undo deletion of table with track changes enabled ( Thanks to László Németh )
9. tdf#153003 Copying a query and pasting as table in same database impossible ( Thanks to Julien Nabet )
10. tdf#153161 FILESAVE: Data cannot save successfully if I open an old presentation, add some text in it, save it and close it. ( Thanks to Mike Kaganski )
11. tdf#42437 Enable the macOS press-and-hold functionality for special character input (é, ñ, etc.) ( Thanks to Patrick Luby )
12. tdf#45147 right-to-left words appear in the wrong order in the CSV import dialog ( Thanks to Andreas Heinisch )

List of crashes fixed

1. tdf#146248 Crash at undo header swlo!sw::XTextRangeToSwPaM+0x5f9: ( Thanks to László Németh )
2. tdf#148453 LibreOffice crashes/hangs when macOS onscreen keyboard is enabled (Arm64) M1 ( Thanks to Patrick Luby )
3. tdf#150380 Calc crash when clicking on the title of the Border Color toolbar popdown ( Thanks to Noel Grandin )
4. tdf#150819 CRASH & assert after a few paste and undo (Assertion failed: (abs(rNode.GetIndex() – pMoveText->pDestNode->GetIndex()) == SwNodeOffset(1)), function SwClientNotify, file txtfrm.cxx, line 2135) ( Thanks to Noel Grandin )
5. tdf#152245 Crash with copy-paste from Calc to Writer table with tracked changes ( Thanks to László Németh )
6. tdf#152404 Crash in Writer when using Japanese Hiragana input method and shortcut Ctrl+Alt+C to insert a new comment while there is uncommitted text ( Thanks to Caolán McNamara )
7. tdf#152710 CRASH: importing ooo84576-1.odt, crashtest; corrupt document structure ( Thanks to Michael Stahl )
8. tdf#152950 Calc sort crashes after changing from default language to a different one ( Thanks to Caolán McNamara )
9. tdf#152964 Crash on undo deletion of table with track changes enabled ( Thanks to László Németh )
10. tdf#153059 CRASH: Clicking on the header/footer button after scrolling ( Thanks to Caolán McNamara )
11. tdf#153116 CRASH when removing text box from drawing object (GTK3) ( Thanks to Caolán McNamara )
12. tdf#153154 changing instance structure in XML Forms document causes crash ( Thanks to Xisco Fauli )
13. tdf#153220 CRASH: Clicking on Border and background after undoing header insertion ( Thanks to Caolán McNamara )

List of old bugs ( more than 4 years old ) fixed

1. tdf#100584 With an RTL sheet, make added sheets RTL as well ( Thanks to Andreas Heinisch )
2. tdf#101731 Rename gradient ‘border’ label to something more meaningful ( Thanks to Stéphane Guillou )
3. tdf#106731 No indication macro is read-only ( Thanks to Rafael Lima )
4. tdf#107625 Envelope dialog: Make dialog more a11y friendly ( Thanks to Caolán McNamara )
5. tdf#112417 UI – Insert Sheet called when clicking anywhere on the footer ( Thanks to Radhey Parekh )
6. tdf#113439 [UX] Add a Show/hide entry in context menu of layers tabs in Draw ( Thanks to Heiko Tietze )
7. tdf#114537 Filesave: Export ConditionalText field to DOC ( Thanks to Justin Luth )
8. tdf#114973 Ctrl+A and Select All don’t work

General Activities

1. Rafael Lima continued polishing dark mode features and improved scrolling and zooming in the Basic code editor. He also improved help for ScriptForge
2. Adolfo Jayme Barrientos updated the icons and colours in Help to match the new application icons
3. Alain Romedenne improved help pages on built-in file dialogs
4. Olivier Hallot (TDF) improved several extended tooltips and improved the help on cell references and cell addressing in Calc
5. Bogdan Buzea improved the quality of the applause audio clip found in the gallery and made many string fixes and improvements in help and in the UI code
6. Ilmari Lauhakangas (TDF) dropped the unnecessary name attribute from link elements in help with support from Christian Lohmaier
7. Miklós Vajna (Collabora) added new commands .uno:GotoMark for jumping to a bookmark and .uno:UpdateBookmarks to update the content of a bookmark (helps especially with Zotero citations) and enhanced .uno:InsertBookmark and .uno:InsertField to allow specifying bookmark/refmark text. He also improved the Writer layout XML dump developer feature, improved the DOCX compatibility of paragraph marker formatting, fixed a layout issue related to bookmarks and fixed some Writer crashes.
8. Jean-Pierre Ledure worked on the ScriptForge library
9. Szymon Kłos, Andras Timar and Michael Meeks (Collabora) worked on LOKit improvements. Michael also fixed a macOS deadlock related to user input events
10. Henry Castro (Collabora) added a mail merge unit test and made some code cleanups
11. Eike Rathke (Red Hat) fixed an issue with date handling in Base, made it so line breaks are preserved in multi-line text when applying Formula to Value in Calc and fixed some crashes. He also improved the help for STYLE and INDEX Calc functions
12. Tomaž Vajngerl (Collabora) polished support for document themes, for example adding the ability for reading theme colours from OOXML
13. Julien Nabet fixed an issue with Base table UI, made Calc’s Paste Special dialog fully translatable, added an Nvidia GPU to Skia Vulkan denylist and fixed some crashes
14. Jim Raykowski implemented a feature that highlights elements in a Writer document when selecting or hovering over their counterparts in the Navigator. He also made several other improvements to the Navigator, such as making it possible to delete references through it
15. Andreas Heinisch made it so AutoText no longer inserts an additional empty paragraph, made bibliography entries appear sorted by identifier in Insert Bibliography dialog and improved the behaviour of input fields with a length restriction
16. László Németh improved LibreLogo rendering speed and made it support more character formatting features. He also made it possible to check the spelling of hyperlinks, fixed an issue with comments disappearing from corrected misspelled words, added two options to spell checking dealing with compound words and fixed some regressions
17. Xisco Faulí (TDF) continued refactoring automated tests, getting rid of much code duplication and created several new tests. He also improved the script used for downloading documents from online forums and fixed several crashes
18. Michael Stahl (allotropia) continued improving the compliance of exported PDFs with Universal Accessibility standard, made DOCX export of bold attributes more robust and fixed some regressions
19. Mike Kaganski (Collabora) made the code for setting property values safer, improved the new Math Sidebar panel, improved Visual Studio debugging experience, added support for hyphen-minus in style IDs. He also made many code cleanups and improvements to readability
20. Caolán McNamara (Red Hat) continued polishing dark mode support, improved the opening performance of Application Colors option view, made it so localised font names match UI language instead of system locale, made text layouting more robust, added a button to remove all document events and made it possible to discover the causes of event-bound macro warnings through an infobar, made Statusbar in Writer show tooltips for sections and tables, made Calc’s sheet navigation and insertion buttons show tooltips and improved the Romanian AutoCorrect file. He also made many other UI-related improvements and crash fixes
21. Stephan Bergmann (Red Hat) improved the debugging experience of unit tests. He also adapted the code to compiler changes and made many code and build-related cleanups as well as test fixes
22. Noel Grandin (Collabora) improved the performance of SUMPRODUCT(IF..) in Calc and fixed an API usage issue with some chart UNO objects not advertising their types properly. He also made many code cleanups and general optimisations
23. Justin Luth (Collabora) worked on VBA ContentControls support, improved the DOCX roundtripping of content controls, improved the indentation of list styles and made font and highlight colour toolbar buttons work in comments
24. Paris Oplopoios (Collabora) added support for hidden status of range filter buttons in XLSX files, improved XLSX compatibility of charts and DOCX compatibility of content controls and made saving Writer documents with macros to Microsoft format conform to the DOCM file type requirement. He also improved Writer’s Accessibility checker
25. Chris Sherlock made some code cleanups in vcl
26. Maxim Monastirsky improved the handling of Draw table styles, for example making pasting action behave more intuitively
27. Khaled Hosny (Alif Type) removed the bundled Source Serif/Sans/Code Pro, Kacst Book/Office fonts due to various issues, separated stylistics sets and character variants in the Font Features dialog, fixed the calculation of ascenders and descenders of some fonts upon PDF export, worked around an issue with strike out formatting of text using Liberation Serif font, improved the handling of different script types in various text previews and fixed an issue with gaps appearing after Kashida. He also made many renovations in font-related code
28. Armin Le Grand (allotropia) improved the appearance of the blur effect with shadows and made refactorings in graphics handling code
29. Taichi Haradaguchi upgraded some dependencies
30. Daniel Lohmann made it so the presenter screen displayed as a normal window can also be shown on a single monitor
31. Tibor Nagy (NISZ) fixed issues with tiled image sizes being reset in the Area tab, incorrect 3D shape properties in PPTX export and tiled background images in PPTX import
32. Christian Lohmaier (TDF) made huge optimisations to the build performance of help and made many other build-related optimisations such as avoiding needless rebuilding of icon and gallery themes
33. Kevin Suo fixed PDF import issues with Asian font settings not being loaded correctly and ligatures in RTL text being reversed incorrectly
34. Thorsten Behrens (allotropia) made some build-related improvements and fixed a Writer unit test
35. Arnaud Versini made some code cleanups
36. Nick Wingate (Collabora) worked on the JavaScript dialog code used by Collabora Online
37. Tor Lillqvist (Collabora) worked on the WASM build
38. Chenxiong Qi ported many Java SDK examples to Python
39. Tünde Tóth (NISZ) fixed an issue with charts getting lost upon DOCX export
40. Galdam Jitsu replaced application and mime type icons with newly designed ones
41. Patrick Luby (NeoOffice) fixed many macOS issues, including a printing issue with the Skia graphics engine and crashes and hangs. He also implemented support for the macOS press-and-hold functionality for special character input and made the macOS installation process faster by switching from bzip2 to lzfse compression in the .dmg file
42. Tarcísio Ladeia de Oliveira fixed some unit test issues
43. Aurimas Fišeras made some cleanups in configure.ac
44. Povilas Kanapickas implemented support for touchpad zoom gestures
45. Đoàn Trần Công Danh made a Boost 1.81.0 compatibility fix
46. Attila Szűcs (Collabora) fixed conditional border colour not being exported to XLSX
47. Dennis Francis (Collabora) made PDFium-based import of PDF files more robust
48. Roman Kuznetsov added Duplicate Page command to Draw’s page pane context menu
49. Michael Weghorn fixed a KDE UI issue in the BASIC Dialog Editor and worked the Android build
50. Ilhan Yesil fixed an issue with the size of wizard pages created using the UNO API
51. Vasily Melenchuk (CIB) made handling of invalid styles in RTF files more robust and implemented checking of Windows Security Zones to determine macro security level
52. Brett T. Warden (Intel) made the SVG conversion method of QR codes compatible with the latest library version

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

437 bugs, 53 of which are enhancements, have been reported by 260 people.

Top 10 Reporters

1. BogdanB ( 35 )
2. Eyal Rozenberg ( 22 )
3. Mike Kaganski ( 16 )
4. Stéphane Guillou (stragu) ( 15 )
5. Rafael Lima ( 8 )
6. rferraro ( 8 )
7. steve ( 7 )
8. Robert Großkopf ( 6 )
9. خالد حسني ( 6 )
10. Telesto ( 6 )

Triaged Bugs

583 bugs have been triaged by 65 people.

Top 10 Triagers

1. Buovjaga ( 147 )
2. Stéphane Guillou (stragu) ( 89 )
3. Dieter ( 42 )
4. m.a.riosv ( 37 )
5. Heiko Tietze ( 26 )
6. Alex Thurgood ( 22 )
7. V Stuart Foote ( 22 )
8. خالد حسني ( 19 )
9. Mike Kaganski ( 17 )
10. Julien Nabet ( 17 )

Resolution of resolved bugs

534 bugs have been set to RESOLVED.

Check the following sections for more information about bugs resolved as FIXED, WORKSFORME and DUPLICATE.

Fixed Bugs

146 bugs have been fixed by 31 people.

Top 10 Fixers

1. Caolán McNamara ( 27 )
2. Khaled Hosny ( 9 )
3. Bogdan B ( 8 )
4. Patrick Luby ( 8 )
5. László Németh ( 7 )
6. Rafael Lima ( 6 )
7. Tünde Tóth ( 5 )
8. Julien Nabet ( 5 )
9. Michael Stahl ( 5 )
10. Tibor Nagy ( 5 )

List of high severity bugs fixed

1. tdf#142147 File->Save As: “Save with password” is deselected by default for password-protected documents ( Thanks to Justin Luth )
2. tdf#146842 All pages are empty/white when printing (skia, macOS only) ( Thanks to Patrick Luby )
3. tdf#146875 Writer: ToC Index updating hangs ( Thanks to Michael Stahl )
4. tdf#151842 Font “Base size” reverts to sm config default of 12pt after reloading any formula (OLE object and standalone document) ( Thanks to Xisco Fauli )
5. tdf#151894 FILEOPEN a Base Document with customized event for open a startform by “open document” LO stuck ( Thanks to Stephan Bergmann )
6. tdf#152434 FILEOPEN:PPTX: Images not displayed ( Thanks to Tibor Nagy )
7. tdf#152520 Crash: if macro uses module TITLE_CASE or SENTENCE_CASE in Transliteration module ( Thanks to Julien Nabet )
8. tdf#152606 Crash if I open the specified pptx file ( Thanks to Julien Nabet )
9. tdf#152717 DDE linking in calc is broken since 7.4.3 RC1 ( Thanks to Mike Kaganski )
10. tdf#42437 Enable the macOS press-and-hold functionality for special character input (é, ñ, etc.) ( Thanks to Patrick Luby )

List of crashes fixed

1. tdf#145843 Incidental Crash on macOS with skia raster (STR comment 8) ( Thanks to Patrick Luby )
2. tdf#146765 Base Form – crash when scrolling in dual form & “data as table” display (macOS Arm) ( Thanks to Patrick Luby )
3. tdf#152495 crash when closing ruby (phonetic guide) dialog with escape (gtk3) ( Thanks to Caolán McNamara )
4. tdf#152520 Crash: if macro uses module TITLE_CASE or SENTENCE_CASE in Transliteration module ( Thanks to Julien Nabet )
5. tdf#152606 Crash if I open the specified pptx file ( Thanks to Julien Nabet )
6. tdf#82115 Repeatable crash/hang entering Japanese into a Writer comment on OSX ( see comment 4 ) ( Thanks to Patrick Luby )

List of performance issues fixed

1. tdf#105575 Slow rendering when using a Logo command ( Thanks to László Németh )
2. tdf#152301 slow opening of Options > Application Colors ( Thanks to Caolán McNamara )

List of old bugs ( more than 4 years old ) fixed

1. tdf#105575 Slow rendering when using a Logo command ( Thanks to László Németh )
2. tdf#120190 Data “Formula to Value” don’t preserve line break with multi-line text value ( Thanks to Eike Rathke )
3. tdf#121297 LO Impress: “JPG Quality” overlapping with “Reduce image resolution” in Presentation Minimizer Wizard in some GTK3 ( Thanks to Caolán McNamara )
4. tdf#42437 Enable the macOS press-and-hold functionality for special character input (é, ñ, etc.) ( Thanks to Patrick Luby )
5. tdf#45949 SPELL check does not work for words with hyperlink ( Thanks to László Németh )
6. tdf#53023 AutoText (text only) embeds extra carriage return ( Thanks to Andreas Heinisch )
7. tdf#65535 Correcting a misspelled word with a comment in the middle erases the comment (see comment 38) ( Thanks to László Németh )
8. tdf#82115 Repeatable crash/hang entering Japanese into a Writer comment on OSX ( see comment 4 ) ( Thanks to

LibreOffice 7.5 will be released as final at the beginning of February, 2023 ( Check the Release Plan ) being LibreOffice 7.5 Beta1 the second pre-release since the development of version 7.5 started in mid June, 2022. Since the previous release, LibreOffice 7.5 Alpha1, 353 commits have been submitted to the code repository and 116 issues got fixed. Check the Release Notes to find the new features included in this version of LibreOffice.

LibreOffice 7.5 Beta1 can be downloaded for Linux, MacOS and Windows, and it can be installed alongside the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

For help, you can contact the QA Team directly in the QA IRC channel or via Matrix.

LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!

Happy testing!!

…

LibreOffice 7.5 will be released as final at the beginning of February, 2023 ( Check the Release Plan ) being LibreOffice 7.5 Alpha1 the first pre-release since the development of version 7.5 started in mid June, 2022. Since then, 4875 commits have been submitted to the code repository and more than 759 bugs were set to FIXED in Bugzilla. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.5 Alpha1 can be downloaded from here for Linux, MacOS and Windows, and it can be installed alongside the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

For help, you can contact the QA Team directly in the QA IRC channel or via Telegram.

LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!

Happy testing!!

…

General Activities

1. LibreOffice 7.3.6 was released on September 8
2. LibreOffice 7.4.1 was released on September 15
3. Rafael Lima added help for “Math baseline” option in Writer and improved the layout of Template Manager
4. Adolfo Jayme Barrientos improved the layout of the Page Style dialog and made some cleanups both in UI strings and Help
5. Alain Romedenne made Help updates on macro-related menus and dialogs
6. Olivier Hallot (TDF) reworked and enriched the Help pages for conditional formatting and made many Help cleanups
7. Laurent Balland fixed a formatting issue with the templates shipped with Impress, made documents created via Windows explorer be 0 bytes so they use the default template and created a UI test for Go to Sheet command
8. Miklós Vajna (Collabora) added PDF export support for content controls in Writer and implemented combo box control type. He also added support for video looping in PPTX files, fixed several HTML import and export issues and started adding Help pages for content controls
9. Jean-Pierre Ledure worked on the ScriptForge library
10. Tünde Tóth (NISZ) fixed a z-ordering issue with embedded OLE objects in PPTX files
11. Szymon Kłos, Ashod Nakashian and Henry Castro (Collabora) worked on LOKit improvements
12. Tor Lillqvist (Collabora) replaced outdated uses of symbol fonts with OpenSymbol, made iOS-related code cleanups and build fixes and made font substitution more robust
13. Szymon Kłos (Collabora) made Clone Formatting brush override old direct formatting instead of just appending new formatting. He also made it so the number format dialog always appears where expected
14. Eike Rathke (Red Hat) improved internationalisation support for constructed languages, fixed an issue with spreadsheet functions implemented as Add-In sometimes getting saved with their programmatic name in XLSX files, implemented better error checking for Calc’s conditional formatting expressions, made Calc’s Name Box dropdown immediately reflect changes to named ranges, fixed an issue with named ranges breaking when the original base-cell-address got deleted, fixed Add-In functions comparing matrix/array elements incorrectly, made it so Calc’s CELL() function is compatible with INDIRECT(), made INDIRECT() work with 16 thousand columns, fixed an issue with recalculating in Calc after sorting and made copying autofilters more robust. He also made some cleanups in Help
15. Tomaž Vajngerl (Collabora) continued polishing the chart data table feature and made some code cleanups
16. Julien Nabet made many optimisations by simplifying internal text replacement operations, fixed importing SVGZ files, added support for Kamenický and Mazovia encodings, fixed a crash with artistic image filtering, made the context menu entry for Conditional Formatting work intuitively and made cleanups
17. Jim Raykowski made search results available to screen readers again (together with Michael Weghorn), made search display the number of found matches, enriched the Customize dialog with tooltips for Assigned Commands and made many improvements to Navigator
18. Andreas Heinisch made it so the optional parameters of MsgBox are initialised with their default values, changed Calc’s optimal row/column height so it doesn’t change hidden status of targets and added support for VBA’s xlCellTypeConstants
19. László Németh added accessibility support for enabled bookmarks in Writer and improved the visual representation of bookmarks. He also continued improving change tracking
20. Xisco Faulí (TDF) made over 20 additions and improvements to automated tests, made the handling of SVG spacing more robust and fixed some crashes
21. Heiko Tietze (TDF) added a feature to filter recent documents in Start Center by module
22. Michael Stahl (allotropia) made Writer’s input field elements smarter regarding the insertion of further fields
23. Michael Weghorn improved Linux dark theme support and made many improvements to Windows and Linux accessibility
24. Mike Kaganski (Collabora) fixed many automated tests so they don’t fail on non-default DPI, made it so LibreOffice does not jump to the front after loading, if user had focused elsewhere, fixed regressions with command line PDF conversion and mailmerge docs starting with tables, added a workaround to a bug in Windows related to OLE objects, fixed an issue causing uneditable elements in non-default Writer templates, made it so installing Python extensions with spaces in their file names is possible, fixed a data loss issue concerning tables in shapes in headers and made handling long Windows paths more robust. He also fixed some Calc function examples in Help
25. Caolán McNamara (Red Hat) continued improving how fonts are used in automated tests, added final polish on text rendering changes in Linux, improved Windows and Linux dark theme support, made SVG icons render crisply with HiDPI, made page orientation consistent when navigating the preview in Print dialog and fixed an old issue with the Reset button in Customize Keyboard dialog not working. He also continued working on gtk3/4 UIs and fixed many crashes and issues found by Coverity and fuzzers
26. Stephan Bergmann (Red Hat) adapted the code to compiler changes and made many code and build-related cleanups as well as test fixes
27. Rizal Muttaqin revised the Sifr icon theme to follow GNOME’s Adwaita, which shares the same ancestral roots
28. Noel Grandin (Collabora) made Calc’s Conditional Formatting dialog able to handle large amounts of data without choking, improved the rendering performance of very large filled shapes and made Find and Replace able to handle very large Calc sheets. He also made many code cleanups, general optimisations and fixes for issues found by Coverity
29. Luboš Luňák (Collabora) made many cleanups and improvements in OpenCL code
30. Justin Luth fixed regressions in font size roundtrips with DOC files and lost tab characters in Calc cells, made handling of numbering character styles cleaner and fixed an issue with line breaks being ignored in Calc cell content
31. Paris Oplopoios submitted his final GSoC report and made cleanups to the graphics handling code
32. Chris Sherlock made code cleanups and improvements to readability
33. Maxim Monastirsky fixed a Notebookbar crash
34. Khaled Hosny (Alif Type) implemented PDF export support for the most common colour font technologies, fixed an issue with PDF export producing incorrect glyph outlines with CFF fonts, corrected the PDF export of certain OTF font names, fixed an issue with the rendering of coloured Arabic text in Writer with formatting marks enabled, removed redundant macOS dock icon menu for Recent Documents and removed the EmojiOne font and emoji controls as superseded by operating system level functionality. He also made many renovations in font-related code
35. Regina Henschel fixed an OOXML rotation issue and incorrect anchoring with top-to-bottom, right-to-left text in shapes in PPTX files
36. Samuel Mehrbrodt (allotropia) fixed importing document variables from RTF files and added file associations for iWork and PDF files to the Windows installer
37. Arnaud Versini made code cleanups
38. Povilas Kanapickas made cleanups in code related to gestures
39. Sarper Akdemir (Collabora) fixed multiple issues with image and object colours in PPTX files
40. Armin Le Grand (allotropia) fixed missing gradient rotation in rotated metafiles in Impress presentation mode and export, corrupted PDF export of circular gradients and fixed several graphics-related regressions
41. Chenxiong Qi fixed Calc Pivot Table filters restored incorrectly
42. Dante Doménech worked on MathML import and export code
43. Taichi Haradaguchi updated many dependencies and made code cleanups
44. Satya Kompella (OpenText) fixed incorrect automatic numbering in DOCX tables
45. René Engelhard (Debian) made build-related fixes and improvements
46. Tibor Nagy (NISZ) fixed lost underline in hyperlinks in PPTX import
47. Gábor Kelemen (allotropia) improved user profile migration details
48. Ilhan Yesil made it possible to change highlight background colour in certain form controls
49. Galdam Jitsu removed unused icon variants
50. Sam James (Gentoo) fixed building with Poppler 22.09.0
51. Björn Michaelsen did some refactoring in Writer code
52. Balázs Varga (allotropia) improved user profile migration details
53. Thorsten Behrens (allotropia) added an initial set of ODF feature test files for automated coverage testing

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

491 bugs, 83 of which are enhancements, have been reported by 279 people.

Top 10 Reporters

1. Eyal Rozenberg ( 22 )
2. Roman Kuznetsov ( 18 )
3. Telesto ( 15 )
4. Mike Kaganski ( 14 )
5. Regina Henschel ( 13 )
6. Tuomas Hietala ( 13 )
7. Rafael Lima ( 10 )
8. Kevin Suo ( 9 )
9. Xisco Faulí ( 9 )
10. Alex Thurgood ( 8 )

Triaged Bugs

533 bugs have been triaged by 73 people.

Top 10 Triagers

1. Timur ( 80 )
2. Rafael Lima ( 61 )
3. Heiko Tietze ( 35 )
4. raal ( 34 )
5. Julien Nabet ( 24 )
6. V Stuart Foote ( 23 )
7. Roman Kuznetsov ( 22 )
8. Mike Kaganski ( 22 )
9. Xisco Faulí ( 22 )
10. Dieter ( 21 )

Resolution of resolved bugs

571 bugs have been set to RESOLVED.

Check the following sections for more information about bugs resolved as FIXED, WORKSFORME and DUPLICATE.

Fixed Bugs

169 bugs have been fixed by 31 people.

Top 10 Fixers

1. Caolán McNamara ( 13 )
2. Mike Kaganski ( 12 )
3. Eike Rathke ( 12 )
4. Khaled Hosny ( 9 )
5. László Németh ( 9 )
6. Noel Grandin ( 9 )
7. Michael Weghorn ( 8 )
8. Justin Luth ( 7 )
9. Jim Raykowski ( 7 )
10. Julien Nabet ( 6 )

List of high severity bugs fixed

1. tdf#106959 MAILMERGE wrong if document starts with table when output saved as individual documents using MM toolbar ( Thanks to Mike Kaganski )
2. tdf#119039 Writer crash when I try to open 4-pages DOCX ( Thanks to Mike Kaganski )
3. tdf#129163 Memory leak in createEnumeration ( Thanks to Bjoern Michaelsen )
4. tdf#137341 UI font is not visible in Contextual Groups and Groupedbar Compact UIs when system dark mode is enabled ( Thanks to Michael Weghorn )
5. tdf#139511 Impress: Shrinking table by dragging bottom border up or top down not working anymore ( Thanks to Sarper Akdemir )
6. tdf#142631 Poor contrast on spellcheck in Linux dark mode ( Thanks to Caolán McNamara )
7. tdf#147507 Crash swlo!SwRedlineExtraData_FormatColl::Reject+0x1b6 (STR: comment 7) ( Thanks to László Németh )
8. tdf#150642 FILEOPEN DOCX Table structure destroyed if cell with vertical text direction exists ( Thanks to Mark Hung )
9. tdf#150647 Autofilter result is wrong when filtering (empty) records ( Thanks to Luboš Luňák )
10. tdf#150766 Incomplete recalculate ( Thanks to Eike Rathke )
11. tdf#150770 FILEOPEN: PPtX: Read error – Error reading file ( Thanks to Caolán McNamara )
12. tdf#150797 Can’t scroll with mouse in Print Preview from 7.5+ ( Thanks to Caolán McNamara )
13. tdf#150832 FILEOPEN: charts cannot be seen (only white boxes) ( Thanks to Xisco Fauli )
14. tdf#150845 CRASH: inserting a form ( Thanks to Noel Grandin )
15. tdf#150882 Toolbar icons are half-seen in Macro dialog in 7.5 with KF5 ( Thanks to Michael Weghorn )
16. tdf#151046 INDIRECT() with a loaded range name argument matching a (now 16k column) cell address uses cell reference instead. ( Thanks to Eike Rathke )
17. tdf#151182 Calc crash when cut-paste and drag cell ( Thanks to Luboš Luňák )
18. tdf#46733 Deleting columns in a table can delete several columns if any cells in that column are merged with other cells ( Thanks to Justin Luth )

List of crashes fixed

1. tdf#119039 Writer crash when I try to open 4-pages DOCX ( Thanks to Mike Kaganski )
2. tdf#147507 Crash swlo!SwRedlineExtraData_FormatColl::Reject+0x1b6 (STR: comment 7) ( Thanks to László Németh )
3. tdf#150845 CRASH: inserting a form ( Thanks to Noel Grandin )
4. tdf#150974 Writer crashes when starting with WollMux installed ( Thanks to Noel Grandin )
5. tdf#150987 CRASH: pasting content ( Thanks to Noel Grandin )
6. tdf#150992 CRASH: applying popart filter to an SVG image ( Thanks to Julien Nabet )
7. tdf#151039 Crash when exporting to PDF ( Thanks to Mike Kaganski )
8. tdf#151172 LibODev crashed if Grammalect extension activated ( Thanks to Maxim Monastirsky )
9. tdf#151182 Calc crash when cut-paste and drag cell ( Thanks to Luboš Luňák )
10. tdf#151187 Crash when exporting ODS file with Persian text to PDF ( Thanks to Caolán McNamara )

List of performance issues fixed

1. tdf#150749 Find and replace – replace all – 100% CPU ( Thanks to Noel Grandin )

List of old bugs ( more than 4 years old ) fixed

1. tdf#103829 FILESAVE: Tab characters lost in cell ( Thanks to Justin Luth )
2. tdf#103888 SVG: tspan element gets an additional horizontal spacing before and after ( Thanks to Xisco Fauli )
3. tdf#104403 Support multi-colored fonts using COLR/CPAL tables ( Thanks to Khaled Hosny )
4. tdf#106959