QA/Dev Report: August 2024

General Activities

1. LibreOffice 24.8.0 was released on August 22
2. Olivier Hallot (TDF) continued with improvements to Calc function help pages, added help pages for Sidebar settings and graphics export via command line, improved help pages for Writer Status Bar, Calc’s Similarity Search and database ranges, updated menu item paths in Help, did lots of Help cleanups, added some extended tooltips, improved the dialog for easy conditional formatting in Calc and removed a misleading Restore Default button from Sidebar Settings
3. Alain Romedenne improved help for BASIC’s If statement and added unit tests for IF THEN statements in BASIC and VBA
4. Pierre F. made two dozen improvements to help, in areas such as Calc functions, word count, change tracking, BASIC, regular expressions, AutoRecovery and backup, and freezing of rows and columns in Calc
5. Dione Maddern added a help page for Quick Find Sidebar deck, updated the help for Writing Aids, reworked help pages for Navigator and Navigation toolbar and updated the instructions for enabling remote control in Impress Remote user guide
6. Adolfo Jayme Barrientos updated help pages about digital signatures after UI changes
7. Laurent Balland did cleanups in Resume Writer template and Beehive, Blue Curve, DNA, Blueprint Plans, Focus, Inspiration, Light, DNA, Midnightblue, Piano, Portfolio, and Progress Impress templates
8. Miklós Vajna (Collabora) made it faster to open DOCX files with many shapes and sections, and headers/footers activated, fixed a layout loop in a certain DOCX file with a complex full-page group shape, fixed losing paragraph styles with many numberings in DOCX export and made Writer layouting smarter, improving performance in LOKit
9. Sven Göthel, Skyler Grey, Hubert Figuière, Andras Timar, Michael Meeks and Áron Budea (Collabora) worked on LOKit used by Collabora Online. Michael also optimised loading times by reducing the frequency of progress bar updates
10. Jaume Pujantell (Collabora) implemented handling of firstHeaderRow attibute in XLSX pivot tables and fixed a crash seen when editing text in shapes in Collabora Online



11. Tomaž Vajngerl (Collabora) worked on the new histogram chart type
12. Julien Nabet fixed an issue preventing deletion of MySQL/MariaDB tables with spaces in their names and did some code cleanups
13. Xisco Faulí (TDF) fixed a PDF export crash, improved the contrast accessibility check and did many dependency updates
14. Michael Stahl (allotropia) improved some automated tests, fixed issues with hidden sections, made HTML pasting more robust when dealing with placeholder fields in Writer, fixed a wrapping issue with long index entries, simplified the code for JPEG quality levels in PDF export and made UA PDFs compatible with Adobe Acrobat Pro’s accessibility checker
15. Mike Kaganski (Collabora) worked around a bug in MS Access ODBC 64-bit driver preventing database table editing, fixed an issue in Insert Special Character dialog related to changing the font selection and made it possible to filter characters in the dialog by Unicode value, fixed an issue with Calc’s EXACT function when working in array context, improved stability by preventing the closing of a document while it is being layouted in the background, made anti-aliasing code more robust on Windows in the context of bitmap export, made the BASIC With statement implementation behave correctly, fixed an issue with BASIC for loop evaluation in VBA support mode, made it possible to deselect all tables in Base by clicking outside of the table list, fixed an issue with some Writer tables showing as collapsed, fixed some issues in the Unicode notation toggle command (Alt+X) and fixed a pasting issue related to document themes. He also fixed many crashes and did code cleanups
16. Caolán McNamara (Collabora) fixed an issue with not being able to rotate the page when printing labels on Linux, fixed embedded formulas not being shown completely when in edit mode and fixed an issue blocking chart data range editing. He also fixed many issues found by static analysers and fuzzers
17. Stephan Bergmann (allotropia) worked on WASM build, enabling WebDAV use
18. Noel Grandin (Collabora) improved loading time for DOCX files with lots of headers and footers and optimised the handling of Writer bookmarks
19. Justin Luth (Collabora) did many improvements to the handling of OOXML layoutInCell property controlling VML shape behaviour in tables, fixed an issue with inherited styles not updating after font size change in Writer, fixed incorrect object anchoring in DOC export and fixed a crash related to undoing header activation
20. Michael Weghorn (TDF) fixed detecting the default printer on Linux, worked on handling accessible object attributes, fixed an issue with font attributes in form control properties, fixed license text getting selected when installing an extension with certain Linux UIs, implemented support for reading whole documents from top to bottom in NVDA screen reader, made dark mode detection more robust in Qt/KDE UIs and worked on using native widgets in Qt UIs
21. Balázs Varga (allotropia) fixed an auto-fitted shape size issue in PPTX import and implemented support for uniform Glow effect for text in shapes



22. Patrick Luby improved the look of the active cell indicator in Calc on macOS, made the Tabbed UI centered on macOS and fixed a couple of crashes
23. Jim Raykowski fixed a visual glitch in the Animation Sidebar deck of Impress, made it possible to jump to a heading by pressing Enter in a read-only Table of Contents in Writer, made word count information of headings outline content show in Navigator tooltips, made it possible to delete all content of a content type via the Navigator (except headings), made the initially selected tracked change in Manage Changes dialog be the current or next one in the document, fixed a mouse wheel focus issue in the Sidebar and made it so the source paths of linked libraries are shown in Macro Organizer
24. Sarper Akdemir (allotropia) continued improving the UX of the encryption dialog
25. Armin Le Grand (allotropia/Collabora) worked on a renovation of graphics rendering with Cairo library
26. Oliver Specht (CIB) fixed an issue with tables having rows with “At least” height setting in imported Microsoft formats
27. Heiko Tietze (TDF) made comment background colours customisable in Writer, Impress and Draw, made it possible to toggle the display mode of the most recent documents list between current module and all modules, made it possible to customise the colours of non-printable characters and improved the luminance calculation for automatic colour setting alongside dark mode colour improvements
28. László Németh made it possible to adjust hyphenation settings via the Sidebar
29. Ilmari Lauhakangas (TDF) did some Python code cleanups, improved a build error message, unified API docs a bit and did some help page cleanups
30. Christian Lohmaier (TDF) worked on Windows Subsystem for Linux build improvements
31. Pranam Lashkari (Collabora) made it quicker to add new conditional formatting rules via the Manage dialog, implemented loading of comment author names from XLSX files and improved dark mode handling for text box content



32. Thorsten Behrens (allotropia) switched the MAR-based auto-updater to be on by default
33. Eike Rathke (Red Hat) made the Calc function search in the Sidebar more robust and made custom Add-In function names imported from OOXML be handled properly
34. Jonathan Clark (TDF) made numbering formats with repeated characters more accurate, fixed several issues related to diacritics and kashida characters, fixed incorrect output after editing Ruby base text, worked on reducing visible jittering when laying out right-aligned text and fixed an issue with RTL as-character anchored textbox positioning
35. Regina Henschel fixed a display scaling issue affecting crop markers on Windows
36. Tibor Nagy (allotropia) fixed a “Stack empty” error in tagged PDF export
37. Adam Seskunas worked on the GSoC project to port Java tests to C++
38. Ritobroto Mukherjee worked on the GSoC project to implement cross platform .NET bindings for UNO API
39. Devansh Varshney worked on the GSoC project for adding histogram charts
40. Ahmed Hamed worked on the GSoC project for improving the Functions Sidebar deck in Calc
41. Sahil Gautam worked on the GSoC project to implement themes
42. Rafael Lima made tooltips wrap properly in Qt-based UIs, fixed a layout issue when resizing the Comments Sidebar deck and improved the look of the active cell indicator in Calc
43. Hossein Nourikhah (TDF) worked on Windows Subsystem for Linux build improvements
44. Kira Tubo improved the grouping of styles in the Sidebar
45. Moritz Duge (allotropia) continued improving the UI of certificate handling and digital signing
46. Bayram Çiçek (Collabora) continued working on Excel Power Query round trip support
47. Jean-Pierre Ledure worked on the ScriptForge library
48. Vladislav Tarakanov finalised the support of audio files in PPT/X files
49. Kurt Nordback improved the alignment of pie-of-pie and bar-of-pie chart data labels and took the first steps in adding support for invertIfNegative in bar and bubble charts
50. Gülşah Köse (Collabora) added a command to invert document background colour to be used in Collabora Online
51. David Gilbert made it so PDF import makes use of clip paths
52. René Engelhard (Debian) fixed a build issue affecting armhf platform
53. Andreas Heinisch made it so Calc’s Manage names dialog checks, if a formula is a valid print range
54. Per99 made it so the user can choose which animation settings to use via accessibility options (related to hypersensitivity)

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

436 bugs, 53 of which are enhancements, have been reported by 258 people.

Top 10 Reporters

1. Eyal Rozenberg ( 26 )
2. Mike Kaganski ( 19 )
3. Regina Henschel ( 12 )
4. Buovjaga ( 10 )
5. Justin L ( 8 )
6. Heiko Tietze ( 7 )
7. fpy ( 7 )
8. Jeff Fortin Tam ( 7 )
9. peter josvai ( 5 )
10. Gabor Kelemen (allotropia) ( 5 )

Triaged Bugs

424 bugs have been triaged by 67 people.

Top 10 Triagers

1. Buovjaga ( 92 )
2. m_a_riosv ( 38 )
3. Heiko Tietze ( 34 )
4. Mike Kaganski ( 23 )
5. raal ( 21 )
6. V Stuart Foote ( 19 )
7. ady ( 18 )
8. Dieter ( 17 )
9. Julien Nabet ( 13 )
10. Michael Weghorn ( 11 )

Resolution of resolved bugs

475 bugs have been set to RESOLVED.

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

Fixed Bugs

213 bugs have been fixed by 45 people.

Top 10 Fixers

1. Mike Kaganski ( 21 )
2. Pierre F ( 16 )
3. Justin Luth ( 15 )
4. Caolán McNamara ( 13 )
5. Michael Weghorn ( 11 )
6. Heiko Tietze ( 10 )
7. Jonathan Clark ( 9 )
8. Olivier Hallot ( 6 )
9. Jim Raykowski ( 6 )
10. Miklos Vajna ( 6 )

List of critical bugs fixed

1. tdf#162589 LibreOffice doesn’t start on Windows (erorr messages about nss3.dll and nspr4.dll) ( Thanks to Xisco Fauli )

List of high severity bugs fixed

1. tdf#148367 EDITING MS Access through 64-bit ODBC doesn’t work and returns an Invalid Bookmark error ( Thanks to Mike Kaganski )
2. tdf#157851 FILEOPEN XLSX “Author” information about notes is not read ( Thanks to Pranam Lashkari )
3. tdf#161139 FILEOPEN DOCX SaxException when opening specific file ( Thanks to Justin Luth )
4. tdf#161705 LO crashes with undo/redo of page numbering wizard’s created bookmarks ( Thanks to Justin Luth )
5. tdf#161725 Add option to toggle module-specific file types in Recent Documents (MRU) menu ( Thanks to Heiko Tietze )
6. tdf#161741 LO crashes with undo/redo of new header + some other change ( Thanks to Justin Luth )
7. tdf#162065 can’t clone “format” of a shape anymore ( Thanks to Oliver Specht )
8. tdf#162586 Crash after exporting an odt document to pdf ( Thanks to Xisco Fauli )
9. tdf#61242 Customise comments background color in Writer ( Thanks to Heiko Tietze )
10. tdf#68274 provide better update mechanism — Mozilla ARchive (mar) based incrementals on all supported platforms ( Thanks to Thorsten Behrens )

List of crashes fixed

1. tdf#140061 Crash swlo!sw::WriterMultiListener::StartListening ( Thanks to Patrick Luby )
2. tdf#155459 Point to the relevant section of Privacy Policy from the Options->LibreOffice->General help, “Send crash reports to The Document Foundation” section ( Thanks to Ilmari Lauhakangas )
3. tdf#161705 LO crashes with undo/redo of page numbering wizard’s created bookmarks ( Thanks to Justin Luth )
4. tdf#161741 LO crashes with undo/redo of new header + some other change ( Thanks to Justin Luth )
5. tdf#162004 [CRASH] Enabling the Notes Pane and closing the document will crash LibreOffice ( Thanks to Noel Grandin )
6. tdf#162264 Crash when pressing “select outline format” on sidebar ( Thanks to Patrick Luby )
7. tdf#162351 Firebird: Changing primary key to autovalue leads to crash of whole LO (KDE only) ( Thanks to Michael Weghorn )
8. tdf#162370 Saving a particular document with too many styles to DOCX crashes ( Thanks to Mike Kaganski )
9. tdf#162398 Crash when copy-pasting HTML content from Writer in attached document ( Thanks to Mike Kaganski )
10. tdf#162480 Insert->Text from File crashes Writer for files with text box anchored to table cells other than A1 ( Thanks to Mike Kaganski )
11. tdf#162555 Crash adding current drawing to the Gallery ( Thanks to Mike Kaganski )
12. tdf#162586 Crash after exporting an odt document to pdf ( Thanks to Xisco Fauli )

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

1. tdf#101611 pdfimport filter does not honor page cropping (masking) as set in a PDF document, resulting pages in LO document are oversize (comment 4) ( Thanks to Dr. David Alan Gilbert )
2. tdf#102265 Help for Impress Format menu needs to have four submenus created and linked to the help page ( Thanks to Olivier Hallot )
3. tdf#108034 FILESAVE ODT->DOC/X Template Resume moves sections-inside-column outside of the column. ( Thanks to Laurent Balland )
4. tdf#108813 FILEOPEN pdf import creates unwanted rectangles ( Thanks to Dr. David Alan Gilbert )
5. tdf#111816 Cannot find special character if does not know character name but number ( Thanks to Mike Kaganski )
6. tdf#112932 Pressing enter in read-only Table of Content doesnt jump to heading ( Thanks to Jim Raykowski )
7. tdf#115884 PDF signing should mention it only works with x509 certificates ( Thanks to Adolfo Jayme Barrientos )
8. tdf#120748 Using the mouse wheel to change tabs in the sidebar tab bar leaves the key input focus in a control that is not visible ( Thanks to Jim Raykowski )
9. tdf#121398 Powers of negative numbers highly inconsistent ( Thanks to Pierre F )
10. tdf#123527 Insert / special Character not correctly rebuilding font chart to match selected font and search string ( Thanks to Mike Kaganski )
11. tdf#127338 Freeze and Split Cancel Each Other ( Thanks to Pierre F )
12. tdf#127610 NB Tabbed View Not Centered (macOS) ( Thanks to Patrick Luby )
13. tdf#128595 Document difference for words and characters and spaces when copying and pasting text ( Thanks to Pierre F )
14. tdf#129492 [LOCALHELP] Need good example of use for similarity search ( Thanks to Olivier Hallot )
15. tdf#131140 [PATCH] Add a negative number to the example of NPV. ( Thanks to Pierre F )
16. tdf#132064 “With” statement likely evaluates its argument on each unqualified member access ( Thanks to Mike Kaganski )
17. tdf#134791 UI: Options dialog window is too small in width and height, cuts off fields but is not scrollable ( Thanks to Samuel Mehrbrodt )
18. tdf#134896 No documentation about proper conversion of system file names into URLs in Calc ( Thanks to Pierre F )
19. tdf#61242 Customise comments background color in Writer ( Thanks to Heiko Tietze )
20. tdf#62799 Word count counts dashes as words – update Help for Word Count additional separators ( Thanks to Pierre F )
21. tdf#68274 provide better update mechanism — Mozilla ARchive (mar) based incrementals on all supported platforms ( Thanks to Thorsten Behrens )
22. tdf#80054 Enhancement request: Add option to allow user to select color of non-printing characters ( Thanks to Heiko Tietze )
23. tdf#91632 msword has some strange “layout in table cell” behaviour ( Thanks to Justin Luth )
24. tdf#91739 nvda can not read documents from top to bottom. ( Thanks to Michael Weghorn )

WORKSFORME bugs

56 bugs have been retested by 24 people.

Top 10 testers

1. Buovjaga ( 24 )
2. Telesto ( 4 )
3. Dieter ( 3 )
4. BogdanB ( 3 )
5. raal ( 3 )
6. Stéphane Guillou (stragu) ( 3 )
7. jcsanz ( 2 )
8. m_a_riosv ( 2 )
9. Michael Weghorn ( 1 )
10. Hal Miller ( 1 )

DUPLICATED bugs

81 bugs have been duplicated by 28 people.

Top 10 testers

1. Buovjaga ( 23 )
2. V Stuart Foote ( 9 )
3. Eyal Rozenberg ( 4 )
4. Mike Kaganski ( 4 )
5. Michael Weghorn ( 3 )
6. Heiko Tietze ( 3 )
7. Dieter ( 3 )
8. Regina Henschel ( 3 )
9. Rafael Lima ( 3 )
10. Xisco Faulí ( 3 )

Verified bug fixes

33 bugs have been verified by 14 people.

Top 10 Verifiers

1. Buovjaga ( 8 )
2. Michael Weghorn ( 6 )
3. Gerald Pfeifer ( 4 )
4. Julien Nabet ( 4 )
5. Xisco Faulí ( 2 )
6. Adolfo Jayme Barrientos ( 1 )
7. V Stuart Foote ( 1 )
8. raal ( 1 )
9. Hossein ( 1 )
10. Timur ( 1 )

Categorized Bugs

852 bugs have been categorized with a metabug by 33 people.

Top 10 Categorizers

1. Eyal Rozenberg ( 541 )
2. BogdanB ( 55 )
3. Roman Kuznetsov ( 45 )
4. Justin L ( 39 )
5. Heiko Tietze ( 22 )
6. Dieter ( 19 )
7. V Stuart Foote ( 19 )
8. Jeff Fortin Tam ( 16 )
9. Michael Weghorn ( 12 )
10. Buovjaga ( 10 )

Regression Bugs

60 bugs have been set as regressions by 17 people.

Top 10

1. Buovjaga ( 19 )
2. raal ( 9 )
3. m_a_riosv ( 6 )
4. ady ( 5 )
5. Xisco Faulí ( 4 )
6. Robert Großkopf ( 3 )
7. David ( 2 )
8. Roman Kuznetsov ( 2 )
9. Telesto ( 2 )
10. László Németh ( 1 )

Bisected Bugs

59 bugs have been bisected by 10 people.

Top 10 Bisecters

1. Buovjaga ( 35 )
2. raal ( 10 )
3. Xisco Faulí ( 6 )
4. Steve271 ( 2 )
5. László Németh ( 1 )
6. Mike Kaganski ( 1 )
7. Justin L ( 1 )
8. gladys ( 1 )
9. Hossein ( 1 )
10. Michael Weghorn ( 1 )

Evolution of Unconfirmed Bugs

Check the current list of unconfirmed bugs here

Evolution of Open Regressions

Check the current list of open regressions here

Evolution of Open bibisectRequests

Check the current list of open bibisectrequests here

Evolution of Highest Priority Bugs

Check the current list of highest priority bugs here

Evolution of High Priority Bugs

Check the current list of high priority bugs here

Thank you all for making Libreoffice rock!
Join us and help to keep LibreOffice super reliable!
Check the Get Involved page out now!