13 Dec 2023

LibreOffice 24.2 Beta1 is available for testing

LibreOffice 24.2 – with a new year.month versioning scheme – will be released as final at the beginning of February, 2024 ( Check the Release Plan ) being LibreOffice 24.2 Beta1 the second pre-release since the development of version 24.2 started in mid June, 2023. Since the previous release, LibreOffice 24.2 Alpha1, 425 commits have been submitted to the code repository and 137 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 24.2 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!!

Download it now!

6 Dec 2023

QA/Dev Report: November 2023

General Activities

  1. LibreOffice 7.5.8 was released on November 2
  2. LibreOffice 7.6.3 was released on November 23
  3. Olivier Hallot (TDF) updated menu item paths in Help pages and updated and restructured dozens of help pages
  4. Rafael Lima updated ScriptForge help
  5. Stanislav Horacek updated menu item paths in Help pages alongside other corrections
  6. Ilmari Lauhakangas (TDF) updated Help pages after UI string changes
  7. Gábor Kelemen (allotropia) did code cleanups in the area of unused config keys and includes
  8. Laurent Balland extended ODF to allow lowercase for exponent characters and blank expontent digits and did many fixes in Impress templates
  9. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer. He also did code cleanups and build fixes
  10. Jean-Pierre Ledure worked on the ScriptForge library
  11. Szymon Kłos, Michael Meeks and Marco Cecchetti (Collabora) worked on LOKit used by Collabora Online
  12. Henry Castro (Collabora) made Calc’s background colour autofiltering more robust and added an automated test for PPTX master slides
  13. Attila Szűcs (Collabora) improved FontWork text placement
  14. Skyler Grey (Collabora) continued polishing STYLEREF field support for DOCX compatibility
  15. Eike Rathke (Red Hat) made several improvements to date & time functions and calculations in Calc
  16. Tomaž Vajngerl (Collabora) wrote automated tests in preparation for OOXML header/footer import refactoring
  17. Julien Nabet simplified Hyperlink dialog after FTP support removal, fixed crashes and did many code cleanups
  18. Andreas Heinisch made Hyperlink and Edit Index dialogs remember their changed settings and fixed non-working Reset to Parent button in Paragraph Style dialog
  19. László Németh continued polishing change tracking of case cycling, fixed gtk popup listbox positions in Sidebar under X11, made it so lost linked graphics are shown in Accessibility Checker, fixed lost character background of non-breaking spaces and added support for smart justify found in DOCX files
  20. Xisco Faulí (TDF) did some automated test additions and cleanups
  21. Michael Stahl (allotropia) removed support for FTP, reduced the file size of exported tagged PDFs, made curl use OpenSSL on Linux after a version upgrade removed support for NSS, fixed an issue with disappearing paragraphs before tables in RTF documents, implemented support for \spltpgpar in RTF import (page breaks) and fixed Delete Undo/Redo of bookmark positions
  22. Mike Kaganski (Collabora) made command line arguments accept Windows \\?\ path prefixes, improved the Visual Studio IDE integration, improved the handling of macros in signed documents, fixed Excel’s Range.Find and Range.Replace wildcard recognition, added the ability to detect a broken ZIP package (document container), did some improvements to remote use of LanguageTool and made document repair more robust. He also made some clarifications in Help pages as well as many code cleanups and build fixes
  23. Caolán McNamara (Collabora) optimised the speed of calendar conversions in Calc and made font handling on Linux more robust. He also did code cleanups and optimisations and fixed issues found by code analysers
  24. Stephan Bergmann (allotropia) did many code cleanups, for example in the area of strings and adapted the code to compiler changes
  25. Noel Grandin (Collabora) optimised the speed of spellchecking code and made UI tests easier to debug. He also did many code cleanups and optimisations, for example simplifying the drawing of gradients and creating a Clang plugin that looks for fields on objects that can be local variables
  26. Justin Luth (Collabora) fixed modifying hyperlinks in form controls and made mouse click targeting of hyperlinks in shapes more robust
  27. Heiko Tietze (TDF) made Start Center use system colours and made Quick Find and Find and Replace dialogs use a better icon
  28. Michael Weghorn (TDF) fixed accessibility issues in areas such as button toggling, Spelling dialog and radio buttons. He also did many updates to the LibreOffice Android Viewer, for example making it support Android system theme, resulting in a re-release in Google Play Store
  29. Balázs Varga (allotropia) continued working on proper indications for locked down items in Options
  30. Patrick Luby (NeoOffice) fixed many graphics and UI rendering glitches and improved the scrolling performance on macOS
  31. Jim Raykowski improved Navigator performance, fixed an issue with unwanted direct formatting being applied from Character Properties dialog, fixed an issue with Draw layer visibility settings, made it so sections can be shown as an expandable/collapsible hierarchy in the Writer Navigator and made it possible to protect and hide sections via Navigator
  32. Sarper Akdemir (allotropia) added a password policy and strength meter to Save with Password dialog
  33. Christian Lohmaier (TDF) fixed opening PDF files in the macOS appstore version and improved the MSI packaging code
  34. Chris Sherlock refactored text rendering code
  35. Regina Henschel implemented support for importing Wordprocessing Canvas, wpc:wpc element in DOCX files
  36. Sahil Gautam implemented highlighting the current row and column in spreadsheets
  37. Irgaliev Amin made the buttons in Impress navigation bar scalable
  38. Paris Oplopoios (Collabora) made rendering of conditional formats more robust and made chart background colour match with document colour
  39. Frank Steiner enabled using medium/full font hinting even with subpixel positioning on Linux
  40. Gökay Şatır (Collabora) improved localised keyboard shortcuts
  41. Khushi Gautam modernised the “Flowchart Alternate Process” shape to use circular corner rounding in all sizes
  42. Vasily Melenchuk (CIB) made exported RTF files leaner by dropping unnecessary fallback images for shapes
  43. Samuel Mehrbrodt (allotropia) moved various Impress options to more intuitive places, made it so expert configuration items show descriptions, added proper editing support for numbers in expert config and made lists editable in expert config
  44. Venetia Furtado made it so the Extensions button in Start Center leads to a reasonable URL even from translated interfaces
  45. Thorsten Behrens (allotropia) did code and build cleanups that improve build reproducibility
  46. Armin Le Grand (allotropia) continued with the rework of handling attributes and properties
  47. Oliver Specht (CIB) fixed an issue preventing pasting hyperlinks from PowerPoint to Impress and Draw by adding a new paste option: Simple HTML, implemented handling of paragraph attributes in RTF import and fixed an issue with disappearing footnotes after applying spelling corrections
  48. Matt K fixed an issue with Find and Replace applying the font attributes of the first character in the ‘find’ match to the entire replaced string, added AutoCorrect support for italic and strikethrough, fixed an off-by-one error in AutoCorrect with Track Changes active and made it so empty UNO listeners are not allowed, making macro code stabler
  49. Hossein Nourikhah (TDF) improved and expanded SDK example code and buildability
  50. Gülşah Köse (Collabora) worked on jsdialog used by Collabora Online

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

454 bugs, 63 of which are enhancements, have been reported by 279 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 54 )
  2. Stéphane Guillou (stragu) ( 13 )
  3. Mike Kaganski ( 12 )
  4. Eyal Rozenberg ( 9 )
  5. Jérôme ( 9 )
  6. Kira Tubo ( 8 )
  7. Timur ( 6 )
  8. László Németh ( 5 )
  9. Regina Henschel ( 5 )
  10. David García ( 5 )

Triaged Bugs

482 bugs have been triaged by 71 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 131 )
  2. Buovjaga ( 60 )
  3. m.a.riosv ( 39 )
  4. Heiko Tietze ( 32 )
  5. raal ( 22 )
  6. Mike Kaganski ( 18 )
  7. Julien Nabet ( 17 )
  8. Michael Weghorn ( 16 )
  9. Xisco Faulí ( 13 )
  10. Dieter ( 10 )

Resolution of resolved bugs

479 bugs have been set to RESOLVED.

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

Fixed Bugs

168 bugs have been fixed by 32 people.

Top 10 Fixers

  1. Balazs Varga ( 34 )
  2. Noel Grandin ( 9 )
  3. Mike Kaganski ( 8 )
  4. Michael Weghorn ( 7 )
  5. László Németh ( 6 )
  6. Michael Stahl ( 6 )
  7. Laurent Balland ( 5 )
  8. Andreas Heinisch ( 4 )
  9. Patrick Luby ( 4 )
  10. Jim Raykowski ( 4 )

List of high severity bugs fixed

  1. tdf#158341 FILEOPEN DOCX Endless loop on opening file ( Thanks to Miklos Vajna )

List of crashes fixed

  1. tdf#127547 Freeze/crash in Microsoft Print to PDF dialog when trying to paste (Ctrl-V) a filename in the ‘Save Print Output As’ dialog ( Thanks to Noel Grandin )
  2. tdf#158169 Crash when using multiple Views ( Thanks to Armin Le Grand (allotropia) )
  3. tdf#158171 Crash when double-clicking DeepL translation dialog OK button ( Thanks to Julien Nabet )
  4. tdf#158224 EDITING CRASH Cannot convert bitmap to polygons ( Thanks to Noel Grandin )
  5. tdf#158345 Opening Hyperlink dialog leads to crash ( Thanks to Julien Nabet )
  6. tdf#158459 Crash copying a range with tracked changes to clipboard ( Thanks to Mike Kaganski )

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

  1. tdf#104288 FILESAVE RTF: File size increases with factor 5 after re-saving a certain RTF-document ( Thanks to Vasily Melenchuk )
  2. tdf#108318 Copying a hyperlink into a textbox messes up its frame target ( Thanks to Justin Luth )
  3. tdf#112131 Unable to modify hyperlink target in document ( Thanks to Justin Luth )
  4. tdf#112661 NSAccessibility – RecentFiles button missing accessibility action support equivalent to click/tap inputs. ( Thanks to Michael Weghorn )
  5. tdf#112662 NSAccessibility – Templates button in StartCenter missing accessibility action support equivalent to click/tap inputs. ( Thanks to Michael Weghorn )
  6. tdf#115871 “Reset to Parent” button in Paragraph Style dialog does not revert to parent values for any of the controls in the Outline & List tab ( Thanks to Andreas Heinisch )
  7. tdf#119908 FILEOPEN: DOCX: Layout differences with justified paragraph. MS 2013 introduced a new “smart justify” that can shrink as well as expand. ( Thanks to László Németh )
  8. tdf#125580 Slightly off value when adding date plus time values ( Thanks to Eike Rathke )
  9. tdf#127498 TIMEVALUE() sometimes returns a slightly less or greater than expected value ( Thanks to Eike Rathke )
  10. tdf#127547 Freeze/crash in Microsoft Print to PDF dialog when trying to paste (Ctrl-V) a filename in the ‘Save Print Output As’ dialog ( Thanks to Noel Grandin )
  11. tdf#96401 FILEOPEN: DOCX – Specific file reported as corrupted (openable in MSO but not in other programs because of unzip error, backslash “\” as filename separator) ( Thanks to Mike Kaganski )

WORKSFORME bugs

50 bugs have been retested by 28 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 11 )
  2. Buovjaga ( 6 )
  3. Dieter ( 5 )
  4. Julien Nabet ( 3 )
  5. Timur ( 2 )
  6. BogdanB ( 2 )
  7. Rainer Bielefeld Retired ( 2 )
  8. Steven Casey ( 1 )
  9. ikjt ( 1 )
  10. Heiko Tietze ( 1 )

DUPLICATED bugs

121 bugs have been duplicated by 29 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 55 )
  2. Buovjaga ( 14 )
  3. Gabor Kelemen (allotropia) ( 9 )
  4. m.a.riosv ( 6 )
  5. Mike Kaganski ( 5 )
  6. Timur ( 4 )
  7. V Stuart Foote ( 4 )
  8. raal ( 3 )
  9. Justin L ( 2 )
  10. Xisco Faulí ( 2 )

Verified bug fixes

33 bugs have been verified by 8 people.

Top 10 Verifiers

  1. Dieter ( 11 )
  2. Stéphane Guillou (stragu) ( 11 )
  3. Gabor Kelemen (allotropia) ( 4 )
  4. BogdanB ( 2 )
  5. Gerald Pfeifer ( 2 )
  6. Buovjaga ( 1 )
  7. Timur ( 1 )
  8. Julien Nabet ( 1 )

 
 

Categorized Bugs

341 bugs have been categorized with a metabug by 26 people.

Top 10 Categorizers

  1. Stéphane Guillou (stragu) ( 137 )
  2. BogdanB ( 61 )
  3. Buovjaga ( 21 )
  4. Heiko Tietze ( 20 )
  5. Xisco Faulí ( 16 )
  6. Dieter ( 13 )
  7. Eyal Rozenberg ( 12 )
  8. Gabor Kelemen (allotropia) ( 11 )
  9. Jérôme ( 11 )
  10. László Németh ( 9 )

Regression Bugs

50 bugs have been set as regressions by 16 people.

Top 10

  1. Stéphane Guillou (stragu) ( 14 )
  2. m.a.riosv ( 7 )
  3. Xisco Faulí ( 5 )
  4. Gabor Kelemen (allotropia) ( 4 )
  5. Buovjaga ( 4 )
  6. raal ( 3 )
  7. Kira Tubo ( 2 )
  8. ady ( 2 )
  9. Sophie Sipasseuth ( 2 )
  10. W Cole ( 1 )

Bisected Bugs

39 bugs have been bisected by 10 people.

Top 10 Bisecters

  1. Stéphane Guillou (stragu) ( 13 )
  2. Buovjaga ( 6 )
  3. raal ( 6 )
  4. Xisco Faulí ( 5 )
  5. Kira Tubo ( 2 )
  6. BogdanB ( 2 )
  7. Gabor Kelemen (allotropia) ( 2 )
  8. Timur
30 Nov 2023

LibreOffice 24.2 Alpha1 is available for testing

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

LibreOffice 24.2 Alpha1 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!!

Download it now!

22 Nov 2023

QA/Dev Report: October 2023

General Activities

  1. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions and updated and restructured dozens of help pages
  2. Rafael Lima added support for hidden named ranges in Calc, fixed named ranges associated to sheets being lost upon XLSX export and made it so renaming a sheet updates ranges in solver models
  3. Bogdan Buzea made some UI string improvements
  4. Seth Chaiklin updated help after UI label change related to outline levels
  5. Stanislav Horacek improved the help for Firebird wizard
  6. Ilmari Lauhakangas (TDF) added a method to automated test for dealing with DPI variance, improved Search Commands result presentation, updated help after UI string changes and improved the accessibility of help navigation
  7. Alain Romedenne updated ScriptForge help
  8. Bartosz Kosiorek added handling for invalid records in Windows Metafile graphics
  9. Gábor Kelemen (allotropia) did code cleanups in the area of includes, created a script to find unused config groups/keys and improved some UI strings
  10. Laurent Balland did code cleanups
  11. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Szymon Kłos (Collabora) worked on LOKit and jsdialog used by Collabora Online. He also worked on the simple conditional formatting dialog created by Paris Oplopoios
  14. Henry Castro (Collabora) worked on LOKit used by Collabora Online. He also improved the Python UI test system, fixed an issue with unused master slides not being imported from PPTX files and made handling of bidirectional text in Calc cells more robust
  15. Pranam Lashkari (Collabora) worked on LOKit and jsdialog used by Collabora Online
  16. Ashod Nakashian, Marco Cecchetti and Andras Timar (Collabora) worked on LOKit used by Collabora Online
  17. Pedro Silva worked on jsdialog used by Collabora Online
  18. Jaume Pujantell (Collabora) worked on Microsoft Office compatibility improvements in the area of content controls
  19. Attila Szűcs (Collabora) worked on LOKit used by Collabora Online. He also improved change tracking in Writer
  20. Skyler Grey (Collabora) worked on jsdialog used by Collabora Online and improved DOCX compatibility by adding full support for STYLEREF fields
  21. Eike Rathke (Red Hat) made date functions in Calc more robust and improved error propagation in Calc formulas
  22. Tomaž Vajngerl (Collabora) wrote some unit tests for Writer and did code cleanups
  23. Julien Nabet made it possible to use ProjectionMode and ShadeMode for extruded custom shapes via BASIC macros and did code cleanups
  24. Andreas Heinisch made the Slide/Page pane in Impress/Draw have the expected title when in Master view and made it possible to create new master slides in the Slide pane by pressing Enter
  25. László Németh improved change tracking of case cycling and made exported DOCX files compatible with Microsoft Office’s default paragraph justification algorithm
  26. Xisco Faulí (TDF) did a couple of dozen additions and changes to automated tests, fixed a Calc crash and added UNO commands for variable date/time fields
  27. Michael Stahl (allotropia) made many improvements and fixes to the export of accessible PDFs
  28. Mike Kaganski (Collabora) made exported HTML tables cleaner, fixed pasting sometimes losing wrapping information in Writer on Windows, added an option to avoid converting some fields into text during mail merge, added a PreserveSpaces option to HTML/ReqIF export that changes the handling of paragraphs with leading/trailing spaces or multiple sequential spaces, added a ExportFormulasAsPDF option to ReqIF export, fixed “Fit to page” printing option, fixed an issue with formula positions in printing and PDF export and made PDF importing more robust with “trailers”
  29. Caolán McNamara (Collabora) fixed many crashes, did code cleanups and optimisations and fixed issues found by code analysers
  30. Stephan Bergmann (Red Hat) started making heavy use of C++20 features in the area of text strings and made several fixes to automated tests
  31. Noel Grandin (Collabora) improved the performance of Calc UI and documents with lots of images and made automated UI tests more robust. He also did many code cleanups and optimisations, for example simplifying error reporting while making it easier for developers to debug problems
  32. Justin Luth (Collabora) made many improvements to Notebookbar UIs
  33. Heiko Tietze (TDF) improved the notification feedback for not found search keys and made the Security tab of the PDF export dialog behave more intuitively
  34. Michael Weghorn (TDF) fixed accessibility issues in areas such as status bar, spelling errors and text attributes. He also bumped Java build baseline from JDK 9 to 17 and did some cleanups and improvements related to Qt/Kf5 UI
  35. Balázs Varga (allotropia) added a UI to control personal information to be removed upon saving documents and a config option for building with or without unnecessary template files and started working on proper indications for locked down items in Options
  36. Patrick Luby (NeoOffice) fixed crashes and many issues related to UI and graphics rendering on macOS
  37. Jim Raykowski improved the accessibility checker, added UNO commands for style spotlight and made many improvements to Navigator
  38. Taichi Haradaguchi made it so bz2 module is included in the Python shipped with LibreOffice, updated several dependencies and did cleanups in makefiles
  39. Sarper Akdemir (allotropia) started working on a password strength meter
  40. Kohei Yoshida upgraded liborcus and added support for conditional loading of Apache Parquet files into Calc
  41. Christian Lohmaier (TDF) did build-related improvements and fixes
  42. Chris Sherlock refactored text and graphics rendering code
  43. Regina Henschel improved Microsoft Office compatibility regarding shape objects and made it so Connector dialog allows negative values for Line Skew
  44. Sahil Gautam added an automated test and did code cleanups
  45. Li Yang added an automated test
  46. Mihai Vasiliu fixed an issue causing Master Slides sidebar to open with zero width
  47. Omkar Acharekar added several automated tests
  48. Martin Gube made it so comments in Writer are kept when spell correction replaces a word
  49. Matthew Kogan made comparison of changed paragraph numbering optional
  50. Irgaliev Amin made it so the option to show slide pane in Impress is retained across sessions
  51. Mert Tumer (Collabora) made an optimisation to LanguageTool locale loading
  52. Paris Oplopoios (Collabora) added an easy to use conditional formatting menu to Calc

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

456 bugs, 66 of which are enhancements, have been reported by 279 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 37 )
  2. Eyal Rozenberg ( 20 )
  3. Xisco Faulí ( 20 )
  4. Regina Henschel ( 10 )
  5. Mike Kaganski ( 10 )
  6. Gerald Pfeifer ( 8 )
  7. Stéphane Guillou (stragu) ( 7 )
  8. Tracey ( 7 )
  9. Robert Großkopf ( 6 )
  10. peter josvai ( 5 )

Triaged Bugs

639 bugs have been triaged by 71 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 184 )
  2. Buovjaga ( 90 )
  3. m.a.riosv ( 54 )
  4. Heiko Tietze ( 43 )
  5. Xisco Faulí ( 34 )
  6. Dieter ( 29 )
  7. raal ( 20 )
  8. Mike Kaganski ( 19 )
  9. Kira Tubo ( 14 )
  10. Julien Nabet ( 12 )

Resolution of resolved bugs

604 bugs have been set to RESOLVED.

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

Fixed Bugs

166 bugs have been fixed by 30 people.

Top 10 Fixers

  1. Balazs Varga ( 18 )
  2. Patrick Luby ( 10 )
  3. Justin Luth ( 10 )
  4. Mike Kaganski ( 9 )
  5. Miklos Vajna ( 9 )
  6. Noel Grandin ( 9 )
  7. Michael Weghorn ( 8 )
  8. Caolán McNamara ( 8 )
  9. Jim Raykowski ( 7 )
  10. Michael Stahl ( 6 )

List of high severity bugs fixed

  1. tdf#152571 Very slow save (macOS, ARM) ( Thanks to Noel Grandin )
  2. tdf#156685 Default font color in tables is white over white background (font color should be black) ( Thanks to Heiko Tietze )
  3. tdf#157132 LibreOffice 7.6.0 copying of formulas in writer table – relative distance of cells in formula not preserved after copying to other lines ( Thanks to Xisco Fauli )
  4. tdf#157515 Crash on clicking Reset when modifying Background presentation style (gtk3) ( Thanks to Caolán McNamara )
  5. tdf#157613 Crash – Database Form – editing size of grid control causes hang requiring forced kill – SKIA raster rendering on (by default) ( Thanks to Patrick Luby )
  6. tdf#157680 Impress export corrupted pdf on MacOS ( Thanks to Patrick Luby )

List of crashes fixed

  1. tdf#101376 Wordcount Beanshell macro execution causes crash ( Thanks to Patrick Luby )
  2. tdf#154142 Crash in: SfxUndoManager::SetMaxUndoActionCount(unsigned __int64) ( Thanks to Caolán McNamara )
  3. tdf#157182 Crashes when exporting a certain presentation as PDF in Archival format PDF/A-1b ( Thanks to Michael Stahl )
  4. tdf#157515 Crash on clicking Reset when modifying Background presentation style (gtk3) ( Thanks to Caolán McNamara )
  5. tdf#157613 Crash – Database Form – editing size of grid control causes hang requiring forced kill – SKIA raster rendering on (by default) ( Thanks to Patrick Luby )
  6. tdf#157849 EDITING: crash on “Set Character Spacing” with custom value when hitting Enter (GTK3) ( Thanks to Caolán McNamara )

List of performance issues fixed

  1. tdf#157590 HANG: opening file with floating table ( Thanks to Miklos Vajna )

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#101376 Wordcount Beanshell macro execution causes crash ( Thanks to Patrick Luby )
  3. tdf#101970 [PACKAGING] Make default templates installation optional ( Thanks to Balazs Varga )
  4. tdf#106057 General input/output error loading pdf file (because of multiple trailers which is valid per PDF specification) ( Thanks to Mike Kaganski )
  5. tdf#111737 Not possible to create / add a new Master Slide with pressing Enter in slides/pages pane ( Thanks to Andreas Heinisch )
  6. tdf#116412 Bundled python fails to import bz2 on Windows ( Thanks to Taichi Haradaguchi )
  7. tdf#126449 Tables in DOC document are overlapping (one floating multipage table-in-table-in-table) ( Thanks to Miklos Vajna )
  8. tdf#127038 Tabbed toolbar: Unnecessary uno::InsertField redundancy in the “References” option group ( Thanks to Justin Luth )
  9. tdf#42787 Functionality request for Writer: Add deleting of Sections using the Delete function inside of the Navigator ( Thanks to Jim Raykowski )
  10. tdf#87638 Slide Pane should be titled ‘Master Slides’ when in master view ( Thanks to Andreas Heinisch )
  11. tdf#99822 FILEOPEN: Floating table objects in tables horizontal position relative to margin is wrong in Writer ( Thanks to Miklos Vajna )

WORKSFORME bugs

81 bugs have been retested by 34 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 15 )
  2. Buovjaga ( 13 )
  3. Timur ( 6 )
  4. Kira Tubo ( 6 )
  5. Dieter ( 5 )
  6. Alex Thurgood ( 4 )
  7. Heiko Tietze ( 4 )
  8. BogdanB ( 3 )
  9. Xisco Faulí ( 2 )
  10. libreofficebugs ( 2 )

DUPLICATED bugs

172 bugs have been duplicated by 27 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 83 )
  2. Buovjaga ( 24 )
  3. Heiko Tietze ( 11 )
  4. Mike Kaganski ( 9 )
  5. m.a.riosv ( 8 )
  6. V Stuart Foote ( 5 )
  7. Dieter ( 3 )
  8. raal ( 3 )
  9. Kira Tubo ( 3 )
  10. Justin L ( 2 )

Verified bug fixes

41 bugs have been verified by 13 people.

Top 10 Verifiers

  1. BogdanB ( 9 )
  2. Stéphane Guillou (stragu) ( 6 )
  3. Gerald Pfeifer ( 6 )
  4. Alex Thurgood ( 5 )
  5. Buovjaga ( 5 )
  6. Xisco Faulí ( 3 )
  7. Julien Nabet ( 1 )
  8. Roman Kuznetsov ( 1 )
  9. steve ( 1 )
  10. sdc.blanco ( 1 )

Categorized Bugs

558 bugs have been categorized with a metabug by 29 people.

Top 10 Categorizers

  1. BogdanB ( 241 )
  2. Stéphane Guillou (stragu) ( 180 )
  3. Eyal Rozenberg ( 27 )
  4. Dieter ( 14 )
  5. Heiko Tietze ( 13 )
  6. Buovjaga ( 12 )
  7. Roman Kuznetsov ( 11 )
  8. Gabor Kelemen (allotropia) ( 8 )
  9. Aron Budea ( 8 )
  10. Michael Weghorn ( 8 )

Regression Bugs

95 bugs have been set as regressions by 16 people.

Top 10

  1. Stéphane Guillou (stragu) ( 23 )
  2. Xisco Faulí ( 23 )
  3. Kira Tubo ( 11 )
  4. BogdanB ( 8 )
  5. raal ( 7 )
  6. Buovjaga ( 6 )
  7. Mike Kaganski ( 3 )
  8. Alex Thurgood ( 3 )
  9. m.a.riosv ( 2 )
  10. Gabor Kelemen (allotropia) ( 2 )

Bisected Bugs

85 bugs have been bisected by 11 people.

Top 10 Bisecters

  1. Xisco
30 Oct 2023

QA weekly focus: SVG

This week, we are kicking off a continuing “QA Weekly Focus” to attract attention to certain topics and areas.

For this first week, let’s look into issues related to our SVG support.

SVG stands for “Scalable Vector Graphics“, a widespread, open vector format and standard. It has become the most used vector format on the web, and it is for example used as the default format in Inkscape, the open source vector graphics editor.

LibreOffice supports importing and exporting SVGs in various places, and these issues are tracked in 3 meta bugs:

  • 88278: SVG import image filter (all modules)
  • 111450: SVG fileSave filter (Draw/Impress)
  • 156066: SVG filters

In recent months, the SVG topic got a fair amount of attention, in particular thanks to Xisco Fauli’s work on the import filter (see illustration).

Our friends at Inkscape have also recently voiced their interest in improving interoperability with LibreOffice (see Inkscape’s post on Mastodon).

So let’s keep the momentum going, test how well SVG files are handled by LibreOffice, and review existing reports! They might need to be clarified, consolidated, or even closed because of all the recent improvements.

The list of bugs to review is in this collaborative pad. You can join IRC to chat with the QA team, and ask questions.

Thanks everyone for your contributions!…

6 Oct 2023

QA/Dev Report: September 2023

General Activities

  1. LibreOffice 7.5.6 and LibreOffice 7.5.7 were announced on September 14 and September 26 respectively
  2. LibreOffice 7.6.1 and LibreOffice 7.6.2 were announced on September 7 and September 26 respectively
  3. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, added a help page for editing styles, improved the help page for accessibility checker, added or updated help for commands found in Writer’s Table, Styles and Form menu as well as Tools menu for all applications
  4. Stéphane Guillou (TDF) added help for Impress’s Use Background fill and made some help cleanups
  5. Rafael Lima added search functionality to the Calc Functions sidebar
  6. Bogdan Buzea improved help for vertical positioning
  7. Seth Chaiklin changed some UI strings to be more clear and updated help pages accordingly
  8. Bartosz Kosiorek added Poisson distribution to help on Calc’s Random Number Generator
  9. Gábor Kelemen (allotropia) dropped HTML Export wizard help pages, improved the layout of Area dialog and did code cleanups in the area of includes
  10. Laurent Balland improved the Impress template Growing Liberty
  11. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Szymon Kłos (Collabora) worked on LOKit and jsdialog used by Collabora Online. He also optimised the performance of data filtering in combination with conditional formats in Calc and fixed an issue with text-decoration property in exported SVGs
  14. Henry Castro and Skyler Grey (Collabora) worked on LOKit used by Collabora Online. Henry also improved Calc’s RTF filter and did fixes and improvements to database connectivity
  15. Áron Budea (Collabora) did some code cleanups
  16. Eike Rathke (Red Hat) improved the accuracy of Calc’s SUM() with mixed formula and value cells
  17. Tomaž Vajngerl (Collabora) continued polishing support for document themes. He also fixed an issue with importing row styles in XLSX spreadsheets and did some optimisations and code cleanups
  18. Julien Nabet fixed an off-by-one error in saving colour themes, made it possible to replace events set for objects, fixed an issue with changing database links while keeping original registered names and fixed a couple of database regressions. He also fixed many crashes
  19. Andreas Heinisch polished the pinned items feature and fixed an off-by-one error in navigating fields with GoToNextPlacemarker command
  20. László Németh improved Writer change tracking related to tables
  21. Xisco Faulí (TDF) dropped the HTML export wizard, improved and added automated test, did some SVG handling improvements and fixed an accessibility crash
  22. Michael Stahl (allotropia) fixed a hang with exporting accessible/tagged PDFs and optimised the size of exported tagged PDFs
  23. Mike Kaganski (Collabora) fixed issues with incorrectly imported DOCX plain text content control properties and LibreOffice Portable not starting from long paths. He also made it so the read-only attributes of directories on Windows are ignored as is the normal behaviour on the platform
  24. Caolán McNamara (Collabora) made it so SVG export of slides shows a progress indicator, improved the security of untrusted documents in relation to OLE objects and improved the speed of importing PDFs. He also did code cleanups and fixed issues found by code analysers
  25. Stephan Bergmann (Red Hat) raised the build baseline to C++20 alongside many tweaks and fixes that it required
  26. Noel Grandin (Collabora) improved the performance of selecting and dragging complex group objects and improved the stability of LibreOffice’s test suites by disabling unreliable tests. He also did many code cleanups and optimisations
  27. Justin Luth (Collabora) fixed an issue with unreliable display of shape properties and made it so unchangeable options are disabled in PDF export dialog
  28. Heiko Tietze (TDF) improved the Writer Compatibility options dialog and made activating overwrite mode for the first time display a notification
  29. Michael Weghorn (TDF) fixed accessibility issues in areas such as dialogs using multi-line edit controls, font colour toolbar item, search in options, print dialog, selection handling in macros and Calc’s SUMIF function. He also made the kf5 and qt6 UIs automatically use dark icon themes and dark document background colours when the system is in dark mode and made preparations for switching from JDK 9 to 17
  30. Balázs Varga (allotropia) improved the accessibility checker
  31. Samuel Mehrbrodt (allotropia) implemented importing slide background fill from PPT files and improved the accessibility checker
  32. Khaled Hosny (TDF) implemented support for right-to-left layout in Formula Editor while also polishing the Math visual editing feature and enabling it by default, made it possible to change Math font, added support for Arabic math expressions, made Tools -> Special Character work in Math and made it so symbols in Math Symbols Catalogue are rendered using document settings. He also updated Noto font versions and fixed saving of localized Italic Greek symbols and missing background colour in style preview
  33. Patrick Luby (NeoOffice) fixed some transparency to alpha rework fallout, fixed issues related to Skia graphics engine and PDF export of documents with embedded PDFs on macOS
  34. Jim Raykowski polished the Style Spotlight feature, improved the master document navigator context menu and expanded Navigator’s feature for bringing items to attention in the document when hovering over them
  35. Bayram Çiçek polished the search feature in Options dialog
  36. Hossein Nourikhah (TDF) made Calc’s Ctrl+End view jump behave better and ported some Developer’s Guide examples to Python and BASIC
  37. Arnaud Versini did some code cleanups
  38. Taichi Haradaguchi updated several dependencies
  39. Björn Michaelsen did some code cleanups
  40. Sarper Akdemir (allotropia) worked on adding XMP, Adobe PDF Schema and Dublin Core metadata support to PDF export, fixed PPTX issues with table shadows and image transparency and added JavaScript UNO bindings for WASM with Embind
  41. Kohei Yoshida upgraded liborcus to 0.19.0
  42. Armin Le Grand (allotropia) continued with the rework of handling attributes and properties
  43. Dan Horák (Fedora) fixed build and test issues related to powerpc64 and s390x architectures
  44. Gökay Şatır (Collabora) made it so authors can reply to their own comments in Writer
  45. Dennis Francis (Collabora) implemented sort by selection in Pivot Tables in non-manual mode
  46. Dung Saga made Search Commands also look for submenu names
  47. Darshan Upadhyay (Collabora) added an option to autoformat bulleted lists after space
  48. Christian Lohmaier (TDF) raised the Linux runtime baseline to RHEL 8 or CentOS 8 and comparable and build baseline to GCC 12 or Clang 12 with libstdc++ 8.5

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

483 bugs, 67 of which are enhancements, have been reported by 319 people.

Top 10 Reporters

  1. Eyal Rozenberg ( 22 )
  2. Stéphane Guillou (stragu) ( 12 )
  3. Regina Henschel ( 10 )
  4. Xisco Faulí ( 9 )
  5. Jim Avera ( 8 )
  6. Gabor Kelemen (allotropia) ( 8 )
  7. Mike Kaganski ( 8 )
  8. Samuel Mehrbrodt (allotropia) ( 8 )
  9. Jeff Fortin Tam ( 8 )
  10. peter josvai ( 5 )

Triaged Bugs

590 bugs have been triaged by 74 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 142 )
  2. Buovjaga ( 96 )
  3. m.a.riosv ( 66 )
  4. Heiko Tietze ( 41 )
  5. Xisco Faulí ( 34 )
  6. Julien Nabet ( 24 )
  7. Dieter ( 16 )
  8. Mike Kaganski ( 14 )
  9. Michael Weghorn ( 13 )
  10. Kira Tubo ( 11 )

Resolution of resolved bugs

507 bugs have been set to RESOLVED.

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

Fixed Bugs

161 bugs have been fixed by 35 people.

Top 10 Fixers

  1. Julien Nabet ( 13 )
  2. Khaled Hosny ( 10 )
  3. Michael Weghorn ( 9 )
  4. Miklos Vajna ( 7 )
  5. Caolán McNamara ( 7 )
  6. Xisco Fauli ( 6 )
  7. László Németh ( 6 )
  8. Samuel Mehrbrodt ( 5 )
  9. Patrick Luby ( 5 )
  10. Heiko Tietze ( 4 )

List of high severity bugs fixed

  1. tdf#156894 kf5/qt6: Dark system themes don’t automatically enable corresponding dark icon themes ( Thanks to Michael Weghorn )
  2. tdf#157115 crash on inserting chart (gtk3): Assertion `m_pBody != NULL’ failed ( Thanks to Noel Grandin )
  3. tdf#157174 LibreOffice crashes when clicking “Print Preview” ( Thanks to Julien Nabet )
  4. tdf#157231 webp 0-day CVE-2023-4863 affects LO ( Thanks to Caolán McNamara )
  5. tdf#157260 Test connection is not using the port specified in connection string for PostgreSQL using 5432 instead ( Thanks to Julien Nabet )
  6. tdf#157288 During Table editing, right click on a field doesn’t show “Primary Key” for other fields than those already primary key ( Thanks to Julien Nabet )
  7. tdf#157312 Current cell highlight doesn’t update with skia hardware rendering on macOS ( Thanks to Patrick Luby )

List of crashes fixed

  1. tdf#156126 Crash when using gpl color palette in debug build ( Thanks to Julien Nabet )
  2. tdf#156683 Crash in: comphelper::AccessibleEventNotifier::revokeClientNotifyDisposing(unsigned int, com::sun::star::uno::Reference const&) ( Thanks to Michael Weghorn )
  3. tdf#156958 Crash in: (anonymous namespace)::TabBarEdit::LinkStubImplEndEditHdl(void*, void*) when renaming layer ( Thanks to Julien Nabet )
  4. tdf#157085 CRASH: fixing accessibility check of deleted image ( Thanks to Samuel Mehrbrodt )
  5. tdf#157088 qt6: Crash on exit after using font color toolbox item with Orca running ( Thanks to Michael Weghorn )
  6. tdf#157092 Using search feature in options dialog causes crash when NVDA is running ( Thanks to Michael Weghorn )
  7. tdf#157096 CRASH: removing everything in document ( Thanks to Michael Stahl )
  8. tdf#157115 crash on inserting chart (gtk3): Assertion `m_pBody != NULL’ failed ( Thanks to Noel Grandin )
  9. tdf#157131 CRASH: after pasting all and undoing ( Thanks to Michael Stahl )
  10. tdf#157160 [CRASH] New “Search” field in Options dialog crashes all the time ( Thanks to Michael Weghorn )
  11. tdf#157174 LibreOffice crashes when clicking “Print Preview” ( Thanks to Julien Nabet )
  12. tdf#157266 Crash when trying to use new Filter feature on Tools → Options ( Thanks to Bayram Çiçek )
  13. tdf#157277 CRASH Writer crashing when hiding Sidebar and using Navigator to go to bookmark ( Thanks to Julien Nabet )
  14. tdf#157299 Calc crashes when accessing cells containing a sumif formula with NVDA ( Thanks to Michael Weghorn )
  15. tdf#157304 Macro: Retrieving selected text in FocusIn event for column crashes LO ( Thanks to Michael Weghorn )

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

  1. tdf#105303 Drop html export wizard ( Thanks to Xisco Fauli )
  2. tdf#106663 GoToNextPlacemarker skips placeholder after header ( Thanks to Andreas Heinisch )
  3. tdf#111705 Allowing Arabic mathematical expressions ( Thanks to Khaled Hosny )
  4. tdf#122718 Sidebar Functions panel misses search like Function Wizard ( Thanks to Rafael Lima )
  5. tdf#124591 Update Noto Fonts to latest releases ( Thanks to Khaled Hosny )
  6. tdf#32418 Add an “insert symbol” to Math ( Thanks to Khaled Hosny )
  7. tdf#48083 FILEOPEN PPT: Slide Background Fill is none instead of slide color (PPTX fixed in 5.2) ( Thanks to Samuel Mehrbrodt )
  8. tdf#49895 Add a “search” field in (non-advanced) Options dialog ( Thanks to Bayram Çiçek )
  9. tdf#55160 Fileopen: docx layout not imported correctly – support for nested floating tables ( Thanks to Miklos Vajna )
  10. tdf#62174 Italic Greek symbols (iGreek set) fails if UI Language is changed ( Thanks to Khaled Hosny )
  11. tdf#85263 same shortcuts for Company and Cancel in “Tools/Options/User Data” ( Thanks to Gabor Kelemen )
  12. tdf#88744 Visual formula editor does not use system clipboard ( Thanks to Khaled Hosny )
  13. tdf#97710 SVG import cant fill overlapped polyline ( Thanks to Xisco Fauli )

WORKSFORME bugs

80 bugs have been retested by 25 people.

Top 10 testers

  1. Buovjaga ( 17 )
  2. Stéphane Guillou (stragu) ( 13 )
  3. Kira Tubo ( 13 )
  4. Faisal ( 4 )
  5. m.a.riosv ( 4 )
  6. Julien Nabet ( 4 )
  7. Xisco Faulí ( 3 )
  8. Mihai Vasiliu ( 3 )
  9. Dieter ( 2 )
  10. Telesto ( 2 )

DUPLICATED bugs

132 bugs have been duplicated by 31 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 42 )
  2. Buovjaga ( 16 )
  3. Heiko Tietze ( 9 )
  4. Mike Kaganski ( 9 )
  5. m.a.riosv ( 8 )
  6. Gabor Kelemen (allotropia) ( 4 )
  7. Justin L ( 4 )
  8. Dieter ( 4 )
  9. Xisco Faulí ( 4 )
  10. Kira Tubo ( 3 )

Verified bug fixes

48 bugs have been verified by 12 people.

Top 10 Verifiers

  1. Stéphane Guillou (stragu) ( 22 )
  2. BogdanB ( 11 )
  3. Xisco Faulí ( 4 )
  4. Michael Weghorn ( 2 )
  5. Gerald Pfeifer ( 2 )
  6. Rizal Muttaqin ( 1 )
28 Sep 2023

A community resolving issues collaboratively

Resolving issues and bringing improvements to LibreOffice is usually the result of team work – a team often made up of people who have never met each other!

As a Free / Open Source project, LibreOffice has contributors in the space of translation, documentation, development, design… and Quality Assurance (QA) from around the globe. Some might have contributed for decades, others just reported a bug for the first time yesterday.

Let’s have a look at three stories in which issues were identified, triaged and resolved in different ways, but always through a combined effort.

Many hands make light work

Take for example bug 153790 on Bugzilla. At least six contributors were involved in its resolution:

  • Ruud reported an issue in sheet referencing in Calc formulas;
  • Stéphane confirmed the issue, provided more precise steps and let others know that the issue is a regression;
  • ady pinpointed more precisely in which version the issue started;
  • raal bibisected the issue to a precise commit by Eike – the issue started in version 7.4;
  • Eike provided a fix for version 7.5;
  • Finally, Xisco created a unit test so the issue does not reappear in the future.

Looking into an issue reveals another

Here’s another story split between three reports.

It all starts with an enhancement in how Tables of Figures can be populated, which was originally an issue in OOXML compatibility. Since LibreOffice 7.6, it is possible to make a Table of Figures track an extra paragraph style for a more customised result (and for improved DOCX support).

Susanne tested it, noticed duplicated entries in the Table of Figures, and reported a separate issue in bug 157200.

At the time of writing, the issue Susanne reported is still being discussed. However, while testing (and learning about the feature), Stéphane noticed a problem in how the dialog resets the Table of Figures to using the “Figures” category instead of “Illustrations”. Turns out this GTK-specific issue was a regression from when the dialog was heavily refactored back in LibreOffice 6.3, and lived on unreported for more than four years. Once it was described in bug 157223, Caolán fixed the regression… less than two hours after opening the report!

Enhancements… and their consequences

One final example in bug 156282.

Bathsheba reported an Outline Folding issue that makes its use more cumbersome in Writer: not being able to fold/unfold all headings at once in the Navigator. She also pointed out an associated frustration in not seeing the hidden headings in the Navigator. Jim, who designed the feature, offered a solution for both issues, including greying out the hidden headings in the Navigator instead of hiding them. Two birds with one stone!

Unfortunately, the patch introduced a nasty regression: a crash when using the Navigator, only happening with the GTK interface. Thankfully, Timur caught the issue only two days after it appeared, and it was therefore quickly fixed by Jim two more days after – before it could affect general users of LibreOffice releases.

Thank you all!

These are three examples among thousands of others that illustrate how improving LibreOffice is a combined effort.

All these success stories wouldn’t have unfolded, and resulted in fixes and new features, if it wasn’t for the users initiating them with a report. So thank you all for reporting issues, but also for triaging the reports, re-testing older ones, and contributing fixes! By combining our various skills and diverse perspectives, we can continue making LibreOffice better for everyone, building on its 38 years of history.

Join us to learn new skills and meet other QA contributors!…

7 Sep 2023

QA/Dev Report: August 2023

General Activities

  1. LibreOffice 7.6.0 was released on August 21
  2. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, updated help for command line PDF export and anchoring of images in Writer, improved help for Title Page and added extended tips to its dialog and added help pages for tooltips when dragging scrollbars and document themes
  3. Juan C. Sanz added Firebird’s DATEADD and DATEDIFF functions to the SQL parser
  4. Stéphane Guillou (TDF) updated help for PDF export regarding comments in margin
  5. Rafael Lima fixed issues with F1 help shortcut not working in some contexts, made the table toolbar hidden when Notebookbar is active and updated help for ScriptForge
  6. Seth Chaiklin updated help for AutoRecovery
  7. Laurent Balland extended ODF support to include reserved blank spaces in Calc custom number formats
  8. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer. He also made improvements to automated tests
  9. Jean-Pierre Ledure worked on the ScriptForge library
  10. Szymon Kłos (Collabora) worked on jsdialog used by Collabora Online
  11. Marco Cecchetti and Attila Szűcs (Collabora) worked on LOKit used by Collabora Online. Attila also added an Excel compatibility option to limit the creation of hyperlinks to only one per cell
  12. Áron Budea (Collabora) fixed a crash when parsing an XML with undeclared namespace
  13. Eike Rathke (Red Hat) made date/time arithmetic in Calc use rounding in order to work more intuitively with date and time functions
  14. Tomaž Vajngerl (Collabora) continued polishing support for document themes
  15. Julien Nabet fixed GTK3 Disabled menu items not being hidden in DontHideDisabledEntry = false mode and did some cleanups in code and in Help
  16. Andreas Heinisch made it so slides in Impress copied by Ctrl + drag and drop get unique names
  17. László Németh improved Writer change tracking related to tables
  18. Xisco Faulí (TDF) did many SVG handling and rendering improvements, fixed many crashes and made some changes and additions to automated tests
  19. Michael Stahl (allotropia) made floating tables in Writer more robust
  20. Mike Kaganski (Collabora) made it so truncated bookmark names are created to be unique thus preventing any problems with hyperlinking, fixed HTML export of nested tables at the beginning of a document, fixed an issue with missing cell padding in imported ReqIF tables, fixed PPTX import issues related to images and charts and fixed unwanted JRE errors popping up in macro contexts
  21. Caolán McNamara (Collabora) improved the performance of spreadsheets with lots of comments, implemented Small Caps in Impress and Draw and made the CJK typography-related “Enable char unit” option take effect only when the locale is a CJK one. He also fixed crashes and issues found by code analysers
  22. Stephan Bergmann (Red Hat) did many code, test and build-related cleanups
  23. Noel Grandin (Collabora) added a new Clang plugin to look for methods in the code where there is no need to guard access to the field, because the field is never modified and another plugin to warn against using the ‘operator bool’ conversion of std::optional, fixed a tricky Report Builder crash and started making it clearer in the code what kind of coordinate system is being handled and therefore to help the compilers find inconsistencies. He also did many code cleanups and optimisations
  24. Justin Luth (Collabora) fixed an issue causing line numbering to be lost in DOCX export and made many improvements and bug fixes related to AutoRecovery
  25. Heiko Tietze (TDF) made it possible to copy formulas by copying cells even when Show Formula is active
  26. Tibor Nagy (NISZ) fixed an issue with repainting sparklines in Calc after updating data
  27. Paris Oplopoios finished the GSoC project for implementing APNG (Animated PNG) support. He also fixed a text wrapping issue affecting XLSX export
  28. Baole Fang finished the GSoC project for selecting tests to run on Gerrit patches based on machine learning
  29. Dipam Turkar finished the GSoC project for converting Writer’s Java UNO API tests to C++
  30. Ahmed Gamal Eltokhy finished the GSoC project for improving PGP/GPG encryption support
  31. Bayram Çiçek finished the GSoC project for adding a search field into Options
  32. Michael Weghorn (TDF) fixed accessibility issues in areas such as popups and grid controls
  33. Balázs Varga (allotropia) worked on the accessibility Sidebar panel and added support for XLSX files encrypted with SHA-384
  34. Samuel Mehrbrodt (allotropia) disabled automatic slide advancement in Impress when moving backwards and fixed textbox indentation issues affecting PPTX export
  35. Czeber László Ádám (NISZ) fixed an issue causing lost hyperlinks when merging its cell with an empty cell and made mouse focusing into centered or right-aligned Calc cells more robust
  36. Khaled Hosny (TDF) improved the speed of populating the font list on systems that use FontConfig, fixed math rendering in elements dock with RTL UI, made it so English symbol names are always accepted in math, worked around an Adobe Acrobat bug with Type 3 fonts and unusual UPEM, added the ability to change math font in Math and fixed reading math font settings from file
  37. Patrick Luby (NeoOffice) fixed PDF export of bitmap color fonts, fixed a gradient drawing issue in slideshows and fixed many issues resulting from last month’s graphics code overhaul changing transparency to alpha
  38. Jim Raykowski made Shift+Tab behave as expected in Sidebar, made keyboard navigation skip over disabled Sidebar tabs and improved the Insert Special Character toolbar button so it displays character info in tooltips and a label
  39. Hossein Nourikhah (TDF) fixed a problem with using ccache when building on Windows and fixed RTL numbers changing to LTR upon DOCX export
  40. Arnaud Versini did some code cleanups
  41. Taichi Haradaguchi updated some dependencies
  42. Colomban Wendling (Hypra) polished the gtk3 accessibility test implementation
  43. Regina Henschel improved the “mouse as pen” feature in Impress, so the result is easier to manipulate later, made it possible to save and load themes in Draw and not only Impress
  44. Matt K made it so the –cat and –script-cat command line options inform the user they should close other running LibreOffice processes, if they are present
  45. Björn Michaelsen refactored Writer code a bit
  46. Sarper Akdemir (allotropia) improved the Clone Formatting feature, for example making it context aware (paragraph properties are applied when the selection contains a whole paragraph or there’s no selection at all)
  47. Kohei Yoshida added support for rich-text string import via orcus interface
  48. Armin Le Grand (allotropia) made performance improvements in fundamental code features related to handling attributes and properties
  49. Thorsten Behrens (allotropia) fixed an issue resulting from last month’s graphics code overhaul changing transparency to alpha
  50. Jun Nogata fixed CJK and CTL font style in Impress templates and added Japanese template to the Localization category
  51. Andrea Rosetti added a reset function to Crop dialog
  52. Denis Sorotnik made it so navigating through Calc sheet tabs using the keyboard now cycles from the last sheet to the first
  53. Henry Castro (Collabora) fixed a formula selection issue affecting merged Calc cells

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

478 bugs, 59 of which are enhancements, have been reported by 274 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 26 )
  2. Gerald Pfeifer ( 20 )
  3. Rafael Lima ( 18 )
  4. Eyal Rozenberg ( 15 )
  5. Hossein ( 13 )
  6. Telesto ( 11 )
  7. Regina Henschel ( 10 )
  8. Stéphane Guillou (stragu) ( 8 )
  9. Xisco Faulí ( 7 )
  10. Mike Kaganski ( 6 )

Triaged Bugs

471 bugs have been triaged by 78 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 82 )
  2. m.a.riosv ( 56 )
  3. Buovjaga ( 44 )
  4. Julien Nabet ( 31 )
  5. Heiko Tietze ( 28 )
  6. Gabor Kelemen (allotropia) ( 21 )
  7. Mike Kaganski ( 15 )
  8. Dieter ( 14 )
  9. Regina Henschel ( 13 )
  10. Xisco Faulí ( 11 )

Resolution of resolved bugs

603 bugs have been set to RESOLVED.

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

Fixed Bugs

215 bugs have been fixed by 35 people.

Top 10 Fixers

  1. Michael Stahl ( 20 )
  2. Balazs Varga ( 18 )
  3. Xisco Fauli ( 14 )
  4. Noel Grandin ( 13 )
  5. Khaled Hosny ( 10 )
  6. Patrick Luby ( 10 )
  7. Miklos Vajna ( 9 )
  8. Mike Kaganski ( 7 )
  9. László Németh ( 7 )
  10. Michael Weghorn ( 6 )

List of high severity bugs fixed

  1. tdf#100894 FILEOPEN FILESAVE IMPORT Conditional formatting: xls file with a lot of Conditional formatting freeze Calc when opening Styles sidebar ( Thanks to Noel Grandin )
  2. tdf#101174 Allow changing Formula Editor math font ( Thanks to Khaled Hosny )
  3. tdf#128437 FILEOPEN: Cell in table is displayed on next page ( Thanks to Michael Stahl )
  4. tdf#139164 Always default to ‘whole document’ in Print and PDF export dialogs ( Thanks to Khaled Hosny )
  5. tdf#142694 Writer stops responding with busy CPU after opening this document ( Thanks to Michael Stahl )
  6. tdf#144072 LibreofficeBase crashed when 2 fields selected in report builder from different sections and width is adjusted 2nd time ( Thanks to Noel Grandin )
  7. tdf#156209 Font size increases when copying from cell in edit mode and pasting into another in non-edit mode ( Thanks to Noel Grandin )
  8. tdf#156306 tagged PDF export of odt document runs in a loop (hangs) ( Thanks to Michael Stahl )
  9. tdf#156508 Blur shadow is solid in edit and presentation mode ( Thanks to Patrick Luby )
  10. tdf#156514 Check spelling red underlines are gone (but spell checking still works) ( Thanks to Noel Grandin )
  11. tdf#156525 Save as > HTML loses drawing object as invalid gif ( Thanks to Noel Grandin )
  12. tdf#156546 Writer freezes/hangs at redo inserting a table ( Thanks to Michael Stahl )
  13. tdf#156551 Texttables – Writer not responding anymore ( Thanks to Michael Stahl )
  14. tdf#156721 Crash if cursor in Basic IDE is in a macro from a document and that document is closed ( Thanks to Noel Grandin )
  15. tdf#156978 Crash on load of ODT with headings/ToC if Navigator open ( Thanks to Jim Raykowski )

List of crashes fixed

  1. tdf#144072 LibreofficeBase crashed when 2 fields selected in report builder from different sections and width is adjusted 2nd time ( Thanks to Noel Grandin )
  2. tdf#145743 Embedded file crash master document ( Thanks to Michael Stahl )
  3. tdf#147938 Crash in: msvcp140.dll ( Thanks to Michael Stahl )
  4. tdf#150137 Crash when parsing an XML with undeclared namespace ( Thanks to Aron Budea )
  5. tdf#151866 Crash swlo!SwFrame::GetPrevSctLeaf+0x52d: on CTRL+X ( Thanks to Michael Stahl )
  6. tdf#156589 CRASH: inserting page break ( Thanks to Miklos Vajna )
  7. tdf#156595 LO crash when deleting a table row in a row with a hidden deleted table column at the beginning. ( Thanks to László Németh )
  8. tdf#156721 Crash if cursor in Basic IDE is in a macro from a document and that document is closed ( Thanks to Noel Grandin )
  9. tdf#156783 LO crash selecting table with the whole document and changing table border ( Thanks to László Németh )
  10. tdf#156967 CALC: Basic: CSV import macro crashes Calc 7.6.0.3 (worked fine in 7.5) ( Thanks to Noel Grandin )
  11. tdf#156978 Crash on load of ODT with headings/ToC if Navigator open ( Thanks to Jim Raykowski )

List of performance issues fixed

  1. tdf#114192 Call psp::PrintFontManager::analyzeFontFile font scan only when needed ( Thanks to Khaled Hosny )
  2. tdf#142694 Writer stops responding with busy CPU after opening this document ( Thanks to Michael Stahl )
  3. tdf#156551 Texttables – Writer not responding anymore ( Thanks to Michael Stahl )

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

  1. tdf#100894 FILEOPEN FILESAVE IMPORT Conditional formatting: xls file with a lot of Conditional formatting freeze Calc when opening Styles sidebar ( Thanks to Noel Grandin )
  2. tdf#101174 Allow changing Formula Editor math font ( Thanks to Khaled Hosny )
  3. tdf#101886 Border line style control not a11y accessible ( Thanks to Michael Weghorn )
  4. tdf#101895 Paragraph dialog units shown as “ch” and “lines” when “Enable char unit” is enabled by default ( Thanks to Caolán McNamara )
  5. tdf#103480 EDITING: Hyperlink deleted when merging cells (if not in the first cell) ( Thanks to Czeber László Ádám )
  6. tdf#103706 Alternate Clone Formatting scope ( Thanks to Sarper Akdemir )
  7. tdf#104918 LibreOffice
10 Aug 2023

QA/Dev Report: July 2023

General Activities

  1. LibreOffice 7.5.5 was released on July 20
  2. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, added an example on how to get user data from registry with BASIC, added help pages for document themes and Calc drawing styles and fixed a JavaScript issue related to displaying different embedded help content depending on the operating system
  3. Stanislav Horáček improved the help for Sort command in Writer
  4. Juan C. Sanz added a new help section for direct connections to PostgreSQL databases
  5. Nay Catina Dia-Schneebeli added a help page for the new Style Spotlight feature
  6. Stéphane Guillou (TDF) improved help pages for hyphenation, Outline Folding and labels
  7. Rafael Lima fixed issues with F1 help shortcut not working in some contexts and fixed incorrect menu positions with KDE Frameworks 5 UI. He also updated help for ScriptForge, improved help on setting PYTHONPATH and did a lot of fixes in help bookmarks that connect something in the UI to a relevant help target
  8. Seth Chaiklin added help for the new “Place backup in same folder as document” option and added a tip of the day entry about Search Commands
  9. Laurent Balland added optional detection of numbers in scientific notation to HTML paste
  10. Alain Romedenne updated help for ScriptForge
  11. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer and added initial help for it
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Szymon Kłos, Áron Budea, Marco Cecchetti and Pranam Lashkari (Collabora) worked on LOKit and/or jsdialog used by Collabora Online. Szymon also made it so when inserting internal links in Impress the dialog will not mix master slides with regular ones and Áron fixed a Skia gradient transparency regression
  14. Eike Rathke (Red Hat) made it so ROW() and COLUMN() in array mode return a scalar value instead of a single element matrix and added code to deal with bad XLSX files generated by QuickBooks
  15. Tomaž Vajngerl (Collabora) continued polishing support for document themes
  16. Julien Nabet made many code cleanups and simplifications
  17. Andreas Heinisch made it so hiding a slide in Impress can be undone, made indexes of tables support Ctrl-clicking items for navigation and made it so inserting a hyperlink pre-fills the URL field, if the clipboard contains a URL. He also improved the help for CDbl and Csng BASIC functions
  18. László Németh improved Writer change tracking related to tables
  19. Xisco Faulí (TDF) did many SVG handling and rendering improvements, fixed many crashes and made some changes and additions to automated tests
  20. Michael Stahl (allotropia) made lots of improvements to the Universal Accessibility PDF export support, added support for decorative flags for objects, fixed an issue with frame styles not exporting properly in some cases and made it so setting comments to be in margin doesn’t cause link annotations to be lost in PDF export
  21. Mike Kaganski (Collabora) made it so paragraph autostyle is used to mimic Word’s table style in DOCX files, fixed the Writer scrollbar tooltip feature which had broken in multiple ways, prevented unwanted tabs from appearing sometimes in table of contents upon DOCX export, implemented “Legal” numbering style that forces all levels to use Arabic numerals to improve interoperability with Word, untangled configuration nodes related to AutoRecovery, made it so AutoRecovery interval is applied separately per document, fixed handling of WM_UNICHAR message on Windows and fixed handling of PDF page scaling factor after large pages. He also fixed many regressions and did many code cleanups and optimisations
  22. Caolán McNamara (Collabora) fixed an issue that caused Ctrl+Left to not always jump to the correct cell. He also fixed crashes and issues found by code analysers
  23. Stephan Bergmann (Red Hat) did many code, test and build-related cleanups, one focus area being preparation for more efficient handling of strings allowed by a newer build baseline
  24. Noel Grandin (Collabora) changed LibreOffice’s internal formats and data structures to work directly with alpha instead of transparency in images and graphics, so the code is in line with the representation found in image formats and APIs everywhere. He also did many code cleanups and optimisations
  25. Justin Luth (Collabora) brought back and fixed functionality to automatically save documents, which was disabled years ago due to an improper implementation. Alongside this rework, he made quality of life improvements to saving of AutoRecovery information as well. He also improved the NotebookBar UIs
  26. Heiko Tietze (TDF) made it so automatic text colour in Calc uses a better threshold for what is considered a dark background colour, made use of ScrollLock key for navigation configurable in Calc, made Writer’s Word Count dialog display the number of comments and made corrections to what is included in the display of Formatting Aids
  27. Tibor Nagy (NISZ) fixed several issues involving conditional formatting and merged cells
  28. Paris Oplopoios worked on the GSoC project for implementing APNG (Animated PNG) support. He also fixed an issue that caused inline page breaks to not be imported correctly from DOC files
  29. Baole Fang worked on the GSoC project for selecting tests to run on Gerrit patches based on machine learning. He also raised the limit of collected entries for Word Completion in Writer
  30. Dipam Turkar worked on the GSoC project for converting Writer’s Java UNO API tests to C++
  31. Ahmed Gamal Eltokhy worked on the GSoC project for improving PGP/GPG encryption support
  32. Bayram Çiçek worked on the GSoC project for adding a search field into Options
  33. Michael Weghorn (TDF) got a flying start as TDF’s new accessibility-focused developer, among other things fixing accessibility of Expert Configuration dialog and making it so the operating system setting to reduce or disable animations is obeyed with Windows, gtk3 and KDE Frameworks following Patrick Luby’s initial implementation on macOS
  34. Balázs Varga (allotropia) worked on the accessibility Sidebar panel, made it so disabled when they have no enabled submenus and fixed an issue causing Basic dialog contents to be invisible in preview mode with scrollbars enabled
  35. Samuel Mehrbrodt (allotropia) fixed an issue causing Writer comments in margin to not be exported to PDF when there was no comment on the first page
  36. Czeber László Ádám (NISZ) fixed Calc comments getting duplicated after row deletion and undo, removed a Print Preview limitation with bordered rows in Calc and made handling of whitespace in XLSX-imported formulas more robust
  37. Khaled Hosny (TDF) dropped PostScript printing support on Linux, fixed handling of automatic colour in case of overlines in PDF export, made DPI handling more robust in PDF export, fixed issues with thin spaces in Mongolian text, fixed rendering of RTL text in Impress letter-by-letter animations, made handling of superscript/subscript more robust in the context of mixed Western and CTL scripts, fixed a HarfBuzz issue involving graphite tables and glyph advances in fonts, improved the subpixel positioning of font glyphs, made it possible to insert the cursor in the middle of ligatures when editing text, made casemapping (UPPERCASE/lowercase etc.) more robust by using ICU more often, aligned special character names with Unicode names and fixed setting watermark font for CJK/CTL text. He also did many code cleanups
  38. Patrick Luby (NeoOffice) made LibreOffice respect macOS’s “Reduce animation” system setting to help users with visual hypersensitivity, added “Encrypt with GPG key” checkbox into macOS native save dialog, fixed rendering of semi-transparent SVG images in ODP files when using Skia for graphics rendering and fixed installation of language packs failing on macOS with Spotlight off
  39. Jaume Pujantell (Collabora) made selecting merged cells with keyboard shortcuts in Calc more robust
  40. Maxim Monastirsky fixed an issue causing incorrect rendering of transparent background colours in Impress/Draw in some cases and fixed setting font color from the toolbar dropdown in Report Builder
  41. Jim Raykowski improved Navigator’s drag and drop hyperlink creation functionality
  42. Christian Lohmaier (TDF) worked on raising the Linux build baseline to AlmaLinux 8
  43. Hossein Nourikhah (TDF) added a UI test for Calc truncated formula display
  44. Ashod Nakashian (Collabora) made it so the option for setting a password is disabled when saving plain text documents
  45. Arnaud Versini did many code cleanups
  46. Vladislav Tarakanov improved the rounding behaviour of scientific numbers in Calc
  47. Satya Kompella (OpenText) fixed an issue causing wanted paragraph spacing in the headers in DOC files
  48. Luigi Iucci (Collabora) made it so applying a style also applies its list level
  49. Taichi Haradaguchi updated many dependencies
  50. Colomban Wendling (Hypra) introduced AT-SPI2 tests for the GTK3 accessibility layer
  51. Regina Henschel fixed an issue with setting theme colours to text in shapes
  52. David Gilbert did many code cleanups
  53. Pierre Vacher added generic support for embedded databases of unknown type into the database wizard
  54. Sakura286 improved the riscv64 UNO bridge, fixing a test failure
  55. Wu Jiahuan improved the loongarch64 UNO bridge, fixing a test failure
  56. René Engelhard (Debian) made it so SSE is not used in Skia on 32-bit Linux distributions to allow building for them
  57. Matt K made it so pasting a table in Writer no longer inherits list formatting, disallowed non-numberic values in Navigator’s Go To control, made Calc’s Autosum a split button and made Fontwork dialog’s SameLetterHeights button more robust
  58. Svante Schubert fixed an issue with incorrect background colours in XHTML export
  59. Rico Tzschichholz (Ubuntu) made some code and build related cleanups
  60. Björn Michaelsen refactored Writer code a bit
  61. Gülşah Köse (Collabora) made it impossible to accidentally open multiple Theme Color Edit dialogs
  62. Sarper Akdemir (allotropia) fixed tooltip displaying over two monitors on Windows, tweaked the hit area for selecting textboxes in Impress and added a new expert configuration option DragThresholdPixels for Impress and Draw to define the number of pixels the cursor can move before dragging (with a higher default value than before), which will help avoid accidental dragging of text boxes
  63. Vasily Melenchuk (CIB) improved the importing of IF field from RTF and DOCX files
  64. Kohei Yoshida made the reference resolver available for orcus
  65. Rizal Muttaqin added icons for Page Number Wizard and synchronised the icons used for Insert Shape menu and Sidebar Shape deck

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

439 bugs, 65 of which are enhancements, have been reported by 254 people.

Top 10 Reporters

  1. Regina Henschel ( 16 )
  2. Eyal Rozenberg ( 13 )
  3. Stéphane Guillou (stragu) ( 12 )
  4. Mike Kaganski ( 12 )
  5. Rafael Lima ( 12 )
  6. Gabor Kelemen (allotropia) ( 12 )
  7. Telesto ( 10 )
  8. ksso ( 10 )
  9. Xisco Faulí ( 9 )
  10. Samuel Mehrbrodt (allotropia) ( 7 )

Triaged Bugs

461 bugs have been triaged by 73 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 126 )
  2. m.a.riosv ( 37 )
  3. Heiko Tietze ( 28 )
  4. Buovjaga ( 25 )
  5. Dieter ( 20 )
  6. Michael Weghorn ( 13 )
  7. ⁨خالد حسني⁩ ( 13 )
  8. Gabor Kelemen (allotropia) ( 12 )
  9. raal ( 11 )
  10. Roman Kuznetsov ( 10 )

Resolution of resolved bugs

551 bugs have been set to RESOLVED.

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

Fixed Bugs

208 bugs have been fixed by 43 people.

Top 10 Fixers

  1. Khaled Hosny ( 19 )
  2. Michael Stahl ( 18 )
  3. Balazs Varga ( 14 )
  4. Mike Kaganski ( 12 )
  5. Rafael Lima ( 10 )
  6. Justin Luth ( 10 )
  7. Xisco Fauli ( 10 )
  8. László Németh ( 6 )
  9. Heiko Tietze ( 5 )
  10. Andreas Heinisch ( 5 )

List of critical bugs fixed

  1. tdf#156286 Crash on right-click delete of selected cells in Calc ( Thanks to László Németh )

List of high severity bugs fixed

  1. tdf#125504 Notebookbar Tabbed / Compact Tabbed UI ParaStyle-controls/FontName-controls stop applying after a print preview ( Thanks to Justin Luth )
  2. tdf#144053 Installation of Language Pack fails on macOS with Spotlight off ( Thanks to Patrick Luby )
  3. tdf#154035 It is not possible to set tabs in Writer by clicking on the top ruler ( Thanks to Mike Kaganski )
  4. tdf#155125 “Encrypt with GPG key” option missing when using System File Dialog on macOS ( Thanks to Patrick Luby )
  5. tdf#156165 Writer resets previous paragraph’s style to body text if AutoCorrect is on ( Thanks to Baole Fang )
  6. tdf#52577 Right-hand part of vowel signs disappear when reordering
3 Aug 2023

LibreOffice 7.6 RC2 is available for testing

LibreOffice 7.6 will be released as final in mid-August 2023 (check the Release Plan), with LibreOffice 7.6 Release Candidate 2 (RC2) the forth pre-release since the development of version 7.6 started in mid December, 2022. Since the previous release, LibreOffice 7.6 RC 1, 100 commits have been submitted to the code repository and 62 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.6 RC2 can be downloaded for Linux, macOS and Windows, and it will replace 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!

Click the banner below to download and test – and thanks for testing!

Download it now!