QA/Dev Report: February 2024

General Activities

1. LibreOffice 7.6.5 was released on February 22
2. LibreOffice 24.2.1 was released on February 29
3. Olivier Hallot (TDF) added help content for Calc’s XLOOKUP and XMATCH functions, Navigate By in Find toolbar, Draw’s Shrink text on overflow and did many fixed and cleanups in Help
4. Rafael Lima made it so selected text in the BASIC editor is automatically inserted into the search bar, added a command for toggling code block commenting in BASIC IDE and fixed an issue where Duplicate Sheet command might create the sheet in the wrong file, if having two open files with the same name
5. Stanislav Horacek updated command paths in Help
6. Stéphane Guillou (TDF) updated command paths in Help
7. Alain Romedenne updated ScriptForge Help pages, updated Python shell script Help for macOS and improved Python example in SDK
8. Dione Maddern did many fixes and updates to Help pages, mostly fixing links
9. Gábor Kelemen (allotropia) made some cleanups in Help and in UI and UNO bridges code
10. Laurent Balland fixed an issue with skip empty cells option not working for the last column in Calc Text Import dialog, made it so custom number formats using the ? character replace trailing zeroes with figure spaces which have a width approximating a digit and removed unneeded thumbnail.png images from Wizard templates
11. Miklós Vajna (Collabora) added legal numbering support for DOC and RTF files, made Calc HTML import support data-sheets attributes, made Calc’s cell editing accept pasted HTML fragments, made DOCX content control handling more robust and continued polishing floating table support
12. Szymon Kłos, Gülşah Köse, Marco Cecchetti, Gökay Şatır, Pranam Lashkari, Michael Meeks and Méven Car (Collabora) worked on LOKit used by Collabora Online
13. Attila Szűcs (Collabora) fixed PPTX issues with multiline field wrapping and stacked text
14. Henry Castro (Collabora) tweaked Calc’s background colour filter to not extend transparent colours to empty cells and fixed an issue with Sidebar not displaying the full localised currency string for cell properties
15. Tomaž Vajngerl (Collabora) made it so the currencies used in a spreadsheet are put at the top of the currency pop-up list, made pivot table data cache handling smarter and improved the handling of XLS documents with unknown DRM encryption (mainly due to some Excel addons)
16. Julien Nabet fixed an issue where Data validation without error check allowed entering incorrect data, fixed LOWER not being supported in Base’s Query-GUI if condition was LIKE and fixed an issue with Calc Macro setting SearchWildcard to False changing SearchRegularExpression value. He also fixed some crashes
17. Andreas Heinisch made Calc’s Autofilter sorting and removing duplicates more robust and made it so a single click is enough to access options through Calc’s status bar
18. Xisco Faulí (TDF) made over a dozen additions and changes to automated tests, improved dark mode support of Writer comment UI, fixed an issue with Autofilter empty option, made SVG text baseline handling more intuitive, added support for in and result SVG filter attributes and fixed a crash
19. Michael Stahl (allotropia) added support for cropped images in RTF import, fixed an issue with unwanted formatting in DOCX numbered lists, fixed page style for even/odd section breaks in RTF/DOCX import and fixed a memory leak related to copying Writer content
20. Mike Kaganski (Collabora) made many improvements to repairing broken documents, implemented auto-accelerator feature on Windows, fixed an issue with PDF compliance, fixed an issue with vertical alignment of math formulas, fixed an issue preventing Select All in Writer from working when section at the start of document body was hidden, made the handling of temporary directories more robust, fixed an issue with unwanted wrapping in Calc and fixed crashes. He also restored a Boost library patch related to Windows locales, which was found to work around a Windows bug causing a hang after opening file dialogs
21. Caolán McNamara (Collabora) improved dark mode support for charts and optimised Calc’s performance. He also fixed crashes and many issues found by static analysers and fuzzers
22. Stephan Bergmann (allotropia) worked on WASM build. He also did many code cleanups and adapted the code to compiler changes
23. Noel Grandin (Collabora) dramatically improved the memory use when exporting a PDF with lots of small graphics and expanded mergedlibs build support. He also did many code cleanups
24. Justin Luth (Collabora) made many improvements to VML and DML graphics support and gradient support in Microsoft document formats, fixed an issue with unwanted optimal row height in XLSX import and made it so applied date/time language is detected in Impress’s insert header/footer dialog
25. Michael Weghorn (TDF) worked on bringing native Qt widgets to Qt/KDE UI, fixed clipboard issues affecting Qt-based UIs under Wayland on Linux, added support for module-specific window icons on Wayland and fixed accessibility issues in areas such as the Navigator and Calc’s rows and columns
26. Balázs Varga (allotropia) made the recently-added Calc XLOOKUP function implementation more robust, added Excel2021 function XMATCH to Calc and added a global config setting RecalcOptimalRowHeightMode for optimal row height recalculation when loading spreadsheets
27. Patrick Luby (NeoOffice) made many improvements to certificate management on macOS, worked around a nasty bug in Apple’s toolchain hampering debugging, fixed a performance issue related to font handling on macOS and fixed many macOS crashes
28. Jim Raykowski made Draw less jumpy when deleting pages, made “New style from selection” work in Impress and Draw, revamped Writer Navigator’s go to page spin control, made keyboard shortcuts work when focus is in toolbar in all UIs and improved the layout of the top toolbox of the Navigator
29. Sarper Akdemir (allotropia) added a panel that shows presenter notes in editing view in Impress
30. Regina Henschel fixed an issue with snap guides disappearing in Impress and Draw and took the first step in implementing 3D element support for PPTX import
31. Sahil Gautam added a selection locking feature to Calc’s Autofilter
32. Samuel Mehrbrodt (allotropia) tweaked highlighting in Navigator, so headings get highlighted instead of bookmarks residing in them, added an option to not write temporary file next to local file to provide a better experience with Samba network shares and made it possible to modify default bullet selection in Writer
33. Armin Le Grand (allotropia) implemented support for editing Impress slides during presentation and continued the rework of handling attributes and properties
34. Oliver Specht (CIB) fixed an issue where the paragraph end Pilcrow character changed to a different one, if a symbol font was used, fixed importing checkboxes from RTF files, fixed selection in Writer tables with split/merged cells, made special character dialog respect the recently used font, added Writer table sidebar controls to change table alignment and left/right spacing, made it possible to use Cycle Case when cursor is at the beginning or end of a word and not only inside it, improved compatibility with RTF tables, added support for paper tray settings in RTF and DOCX files, made it so Clone Formatting in Impress only applies paragraph attributes from and to fully selected paragraphs and made it so dash replacement autocorrection also works between sentences
35. Matt K fixed a couple of Writer crashes
36. Arnaud Versini did some code cleanups
37. Jaume Pujantell (Collabora) fixed an issue causing text in shapes to be lost when exporting Impress presentations to SVG and implemented reading simple solid fills from the fill styles list in a Visio file theme
38. Heiko Tietze (TDF) improved the look of Writer comments, made the Keep Ratio setting more intuitive in the Position and Size dialog and made infobar appearances uncluttered
39. Hossein Nourikhah (TDF) made the build configure error out, if a buggy Windows SDK version is found
40. Omkar Acharekar worked on bringing native Qt widgets to Qt/KDE UI as part of an Outreachy project
41. Tibor Nagy (allotropia) fixed an issue where the layout of content to be printed from Calc was not refreshed when changing the orientation
42. Kurt Nordback worked on adding a chart type for “pie-with-remainder-as-another-pie”
43. Taichi Haradaguchi updated some dependencies and fixed a link in Help
44. Juan C. Sanz made it so Firebird embedded databases get their data saved automatically regardless of whether or not the save button is pressed
45. Ashod Nakashian (Collabora) fixed corner-case issues with DOCX content controls and change tracking
46. Yiğit Akçay added a feature for enclosing selected text in parentheses/brackets or quotation marks in Writer
47. Vladislav Tarakanov fixed an issue with slideshow navigation bar, where double-clicking would advance three slides
48. Vasily Melenchuk (CIB) fixed an issue with field styles in RTF import
49. Áron Budea (Collabora) did some code cleanups
50. Hubert Figuière and Vivek Javiya (Collabora) worked on jsdialog used in Collabora Online
51. Akshay Warrier added a goto page/slide dialog for Impress and Draw
52. Kevin Ottens fixed backup copy creation for files on mounted Samba shares
53. David Gilbert fixed a PDF import performance issue involving tiling pattern fills
54. Po-Yen Huang fixed an issue with Calc’s ROUND function producing inconsistent results in some cases (co-authored with Franklin Weng and Firefly
55. Kohei Yoshida optimised Calc’s performance
56. Zeph Chai translated an ODK example from Java to Python

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

477 bugs, 55 of which are enhancements, have been reported by 313 people.

Top 10 Reporters

1. Gabor Kelemen (allotropia) ( 23 )
2. Mike Kaganski ( 11 )
3. lvm ( 11 )
4. Telesto ( 10 )
5. Rafael Lima ( 9 )
6. Xisco Faulí ( 9 )
7. Regina Henschel ( 8 )
8. Stéphane Guillou (stragu) ( 7 )
9. Adalbert Hanßen ( 7 )
10. Olivier Hallot ( 7 )

Triaged Bugs

458 bugs have been triaged by 79 people.

Top 10 Triagers

1. Stéphane Guillou (stragu) ( 86 )
2. Buovjaga ( 45 )
3. Heiko Tietze ( 29 )
4. Julien Nabet ( 29 )
5. V Stuart Foote ( 22 )
6. Mike Kaganski ( 21 )
7. ady ( 21 )
8. m_a_riosv ( 21 )
9. Xisco Faulí ( 21 )
10. Dieter ( 16 )

Resolution of resolved bugs

419 bugs have been set to RESOLVED.

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

Fixed Bugs

147 bugs have been fixed by 40 people.

Top 10 Fixers

1. Mike Kaganski ( 15 )
2. Xisco Fauli ( 9 )
3. Michael Stahl ( 8 )
4. Miklos Vajna ( 8 )
5. Oliver Specht ( 7 )
6. Noel Grandin ( 6 )
7. Olivier Hallot ( 6 )
8. Justin Luth ( 5 )
9. Patrick Luby ( 5 )
10. Heiko Tietze ( 5 )

List of critical bugs fixed

1. tdf#157135 LibreOffice 7.6 stalls/crashes under Windows 11 with Norwegian (Bokmål) locale when opening file dialog ( Thanks to Mike Kaganski )
2. tdf#159707 CRASH: Changing to edit mode ( Thanks to Julien Nabet )

List of high severity bugs fixed

1. tdf#126638 macOS: Can’t paste, copy, cut or ⌘A (select all) using keyboard shortcuts in Save-As field (workaround: comment 38) ( Thanks to Patrick Luby )
2. tdf#127293 Add XLOOKUP function in Calc ( Thanks to Balazs Varga )
3. tdf#149499 CRASH: inserting page break and undoing ( Thanks to Matt K )
4. tdf#156352 macOS: Save as > Encrypt with GPG key results in hang / crash ( Thanks to Caolán McNamara )
5. tdf#159302 Formula OLE in a line of text or its full height frame is now misaligned vertically, due to change of sm map units ( Thanks to Mike Kaganski )
6. tdf#159519 LibreOffice 24.2.0.3 (Windows 7) ODF files saved with passwords can be opened without any password ( Thanks to Michael Stahl )
7. tdf#159529 Excessive memory consumption in v24.2 ( Thanks to Patrick Luby )
8. tdf#159581 FILEOPEN XLSX 24.2: optimal row height from previous sheet may be applied to all future sheets ( Thanks to Justin Luth )
9. tdf#159743 German UI: Many not plausible Keyboard Shortcut Changes ( Thanks to Xisco Fauli )
10. tdf#54169 LibO doesn’t obey Windows OS setting “only show the accelerator underline when the Alt key is being pressed” ( Thanks to Mike Kaganski )
11. tdf#55004 backup copy fails when using share / samba (if nobrl cifs mount option not used) ( Thanks to Kevin Ottens )

List of crashes fixed

1. tdf#147731 Crash in SwFrameFormat::~SwFrameFormat() ( Thanks to Michael Stahl )
2. tdf#149499 CRASH: inserting page break and undoing ( Thanks to Matt K )
3. tdf#155710 Calc crashes every time when saving linked files on macOS ( Thanks to Patrick Luby )
4. tdf#156352 macOS: Save as > Encrypt with GPG key results in hang / crash ( Thanks to Caolán McNamara )
5. tdf#157042 [Linux only] Calc crashes when closed in rtl::str::release(_rtl_uString*) (steps in comment 27) ( Thanks to Xisco Fauli )
6. tdf#157135 LibreOffice 7.6 stalls/crashes under Windows 11 with Norwegian (Bokmål) locale when opening file dialog ( Thanks to Mike Kaganski )
7. tdf#158124 Holding down delete key doesn’t work and causes crash with Japanese – Romaji keyboard layout ( Thanks to Patrick Luby )
8. tdf#158360 [CRASH] LibreOffice crashes after editing, closing and trying to reopen DOCX file ( Thanks to Balazs Varga )
9. tdf#158801 CRASH: after pressing return a few times ( Thanks to Miklos Vajna )
10. tdf#159637 Crash in PlaceEditDialog::SelectType(bool) ( Thanks to Xisco Fauli )
11. tdf#159666 Crash when table and line object are selected at the same time ( Thanks to Noel Grandin )
12. tdf#159707 CRASH: Changing to edit mode ( Thanks to Julien Nabet )
13. tdf#159735 Crash when using APSO extension and closing LibreOffice ( Thanks to Michael Weghorn )
14. tdf#159816 Crash in drag-n-drop of multiple paragraphs with a bookmark ( Thanks to Mike Kaganski )
15. tdf#159908 LibreOffice crashes when using a constant as a loop variable in BASIC code, leading to data loss. ( Thanks to Mike Kaganski )

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

1. tdf#101313 Copy-paste a Table With Merged Cells from Writer to Calc: Cells Placed in Wrong Position (Wrong cell offsets) ( Thanks to Noel Grandin )
2. tdf#117118 Firebird: Saving of data should be done automatically ( Thanks to Juan c. Sanz )
3. tdf#125934 No application icon on Wayland with the qt5 / kf5 backend ( Thanks to Michael Weghorn )
4. tdf#126533 FILEOPEN/FILESAVE DOCX: bitmap background image not saved with document ( Thanks to Justin Luth )
5. tdf#126638 macOS: Can’t paste, copy, cut or ⌘A (select all) using keyboard shortcuts in Save-As field (workaround: comment 38) ( Thanks to Patrick Luby )
6. tdf#127293 Add XLOOKUP function in Calc ( Thanks to Balazs Varga )
7. tdf#128425 Add XMATCH function in Calc ( Thanks to Balazs Varga )
8. tdf#128787 UI: menu path Format – Styles – New style from selection does not work ( Thanks to Jim Raykowski )
9. tdf#129701 Skip empty cells option does not work for the last column in Calc Text Import dialog ( Thanks to Laurent Balland )
10. tdf#43848 selecting whole table with merged cells at certain position not possible with draging the mouse ( Thanks to Oliver Specht )
11. tdf#54169 LibO doesn’t obey Windows OS setting “only show the accelerator underline when the Alt key is being pressed” ( Thanks to Mike Kaganski )
12. tdf#55004 backup copy fails when using share / samba (if nobrl cifs mount option not used) ( Thanks to Kevin Ottens )
13. tdf#67347 FILEOPEN: MS .pptx Textbox with stacked text imported wrong size ( Thanks to Attila Szűcs )
14. tdf#91914 UI Double click needed on status bar in Calc to open dialog Page style and Navigator (unlike Writer; where one click is in use) ( Thanks to Andreas Heinisch )

WORKSFORME bugs

48 bugs have been retested by 22 people.

Top 10 testers

1. Buovjaga ( 9 )
2. Stéphane Guillou (stragu) ( 6 )
3. Telesto ( 6 )
4. Julien Nabet ( 4 )
5. Aron Budea ( 3 )
6. steve ( 2 )
7. Dione Maddern ( 2 )
8. Dieter ( 2 )
9. BogdanB ( 2 )
10. Andreas Heinisch ( 1 )

DUPLICATED bugs

117 bugs have been duplicated by 28 people.

Top 10 testers

1. Stéphane Guillou (stragu) ( 33 )
2. Buovjaga ( 12 )
3. Heiko Tietze ( 8 )
4. Mike Kaganski ( 6 )
5. V Stuart Foote ( 6 )
6. ady ( 5 )
7. Telesto ( 4 )
8. Patrick Luby (volunteer) ( 4 )
9. Regina Henschel ( 4 )
10. Rafael Lima ( 4 )

Verified bug fixes

39 bugs have been verified by 14 people.

Top 10 Verifiers

1. Stéphane Guillou (stragu) ( 11 )
2. steve ( 6 )
3. BogdanB ( 5 )
4. Xisco Faulí ( 4 )
5. Kevin Suo ( 2 )
6. V Stuart Foote ( 2 )
7. Rafael Lima ( 2 )
8. Buovjaga ( 1 )
9. Gerald Pfeifer ( 1 )
10. Michael Weghorn ( 1 )

Categorized Bugs

287 bugs have been categorized with a metabug by 30 people.

Top 10 Categorizers

1. Stéphane Guillou (stragu) ( 79 )
2. V Stuart Foote ( 30 )
3. BogdanB ( 28 )
4. Aron Budea ( 25 )
5. Rafael Lima ( 20 )
6. Heiko Tietze ( 13 )
7. Xisco Faulí ( 9 )
8. Dieter ( 8 )
9. Buovjaga ( 8 )
10. Gabor Kelemen (allotropia) ( 7 )

Regression Bugs

67 bugs have been set as regressions by 22 people.

Top 10

1. Stéphane Guillou (stragu) ( 16 )
2. Xisco Faulí ( 10 )
3. raal ( 7 )
4. Buovjaga ( 5 )
5. Telesto ( 5 )
6. Julien Nabet ( 3 )
7. m_a_riosv ( 3 )
8. Regina Henschel ( 2 )
9. Gabor Kelemen (allotropia) ( 2 )
10. ady ( 2 )

Bisected Bugs

60 bugs have been bisected by 12 people.

Top 10 Bisecters

1. raal ( 15 )
2. Stéphane Guillou (stragu) ( 11 )
3. Xisco Faulí ( 10 )
4. Kevin Suo ( 7 )
5. Aron Budea ( 5 )
6. Buovjaga ( 3 )
7. Telesto ( 2 )
8. Mike Kaganski ( 2 )
9. Gabor Kelemen (allotropia) ( 2 )
10. Justin L ( 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!