QA/Dev Report: September 2021

General Activities

1. LibreOffice 7.2.1 was released on September 16
2. LibreOffice 7.1.6 was released on September 9
3. Allotropia published a couple of blogposts about their recent work on master documents and ODF 1.3 transition
4. Alain Romedenne improved the Help content for the ScriptForge library
5. Adolfo Jayme Barrientos improved the accuracy of some Help texts and made some smaller fixes
6. Rafael Lima created a guide about Calc macros for formatting cell borders, improved the Help pages for Slide master, Calc AutoCorrect and document encryption.
7. Steve Fanning improved the help for EUROCONVERT and CONVERT_OOO Calc functions
8. Olivier Hallot (TDF) added Help pages for Accessibility Check Tool, ProtectFields and ProtectBookmarks, improved the pages for GPG signing and Database Advanced Settings, added examples for using Calc functions in macros and updated many menu item references.
9. Ilmari Lauhakangas (TDF) replaced Help’s index filtering JS library with a more performant one
10. Jean-Pierre Ledure worked on the ScriptForge library
11. Ross Johnson improved paragraph keyboard navigation in Writer and fixed a problem with the grouping of Help index filter results
12. Juan C. Sanz implemented connecting to a Firebird server (still missing UI)
13. Natalia Gavrilova made Calc’s focus rectangle use the highlight colour rather than the default font colour
14. Aleksei Nikiforov (basealt) fixed a Linux crash related to SVG icon themes
15. Pierre Marty (Linagora) fixed an Impress autolayout issue
16. Tor Lillqvist (Collabora) worked on the iOS version
17. Daniel Arato (NISZ) fixed issues with footers in XLSX export and custom shapes in DOCX export
18. Jim Raykowski completed the work on Navigator focus tracking for all content types while greatly improving its performance and improved the Outline folding feature
19. Tibor Nagy (NISZ) added support for hyperlinks in images in PPTX import
20. Vasily Melenchuk (CIB) added line thickness presets for borders and fixed a couple of DOCX import hyperlink issues
21. Gábor Kelemen (NISZ) fixed a regression in Mail Merge email output ranges
22. Michael Stahl (allotropia) fixed an issue of spelling dialog in Impress messing up text formatting in shapes and made several crash fixes
23. Regina Henschel fixed an issue with line object rotation in XLSX export
24. Samuel Mehrbrodt (allotropia) improved the Calc colour filter feature
25. Áron Budea (Collabora) fixed a crash caused by a performance improvement
26. Julien Nabet made emoji toolbar button work on Windows, fixed a regression in Calc’s standard filter with gtk3 UI, improved the behaviour of Base’s Direct SQL dialog and fixed the percentage display in the Check for Updates dialog
27. Jan-Marek Glogowski (allotropia) made internal directory handling and Windows-specific printing related code more robust
28. Rizal Muttaqin updated Sukapura and Colibre icon themes
29. Ilhan Yesil made internal hyperlinks in spreadsheets work in the Android app
30. Tomaž Vajngerl (Collabora) continued working on the new searching and indexing feature
31. Hossein Nourikhah (TDF) fixed a font size problem in WMF graphics and added preliminary support for Visual Studio 2022 for building on Windows
32. László Németh (NISZ) improved the coverage of change tracking, adding paragraph style tracking and making table tracking more complete
33. Stephan Bergmann (Red Hat) made many code and build-related cleanups
34. Chris Sherlock continued VCL refactoring work
35. Michael Weghorn made many improvements to Windows and Qt 5 accessibility and added a Qt 6 VCL plugin
36. Eike Rathke (Red Hat) fixed several Calc regressions related to number formats, date patterns, sorting and filtering. He also improved date pattern recognition robustness and made out-of-bounds dates show an #FMT error
37. Justin Luth (SIL) improved the DOC/DOCX support for multi-level list attributes in paragraph styles and made Writer table row height optimisation more robust
38. Mike Kaganski (Collabora) introduced per-process lock directories for Firebird to allow running multiple LibreOffice Base instances with Firebird embedded databases. He also fixed other Firebird issues like crashes, a LIST function issue and path issues. He also made many code cleanups and optimisations
39. Luboš Luňák (Collabora) improved the backtrace functionality (code debugging), improved the performance of Calc’s COUNTIF function and made many code and build-related cleanups
40. Andreas Heinisch added support for case-insensitive operations for non-ASCII characters in the VBA Collection object, made it so missing optional parameters in Basic code are handled properly, improved handling of CSV files in UTF-8 with BOM format, made it possible to set cell font colour from VBA macros and improved VBA error messaging
41. Tünde Tóth (NISZ) fixed handling of password protection in XLSX and DOCX files
42. Xisco Faulí (TDF) made a couple of dozen additions and improvements to automated tests
43. Balázs Varga (NISZ) fixed losing images and shapes in charts upon OOXML export and made it possible to save ranges in a single Mail Merge document
44. Attila Bakos (NISZ) added support for text in grouped shapes
45. Caolán McNamara (Red Hat) improved robustness of Sidebar minimum widths, fixed issues with fonts in Base table views, content of Base Tablecontrols being invisible in PDF export, Windows spell checking underlines rendered with a black background and continued implementing the new GTK4 backend. He also made many cleanups and crash fixes
46. Heiko Tietze (TDF) made it so Application colour Field Shading is respected with dark backgrounds, added colour palettes to integrated providing of additions, improved Calc’s Paste Special dialog and made it possible to access Writer table formula editing via context menu
47. Miklos Vajna (Collabora) added support for ODT import and export of multi-level list paragraph style attributes, improved Writer layout XML dump (debugging feature), added support for linked character styles in Writer (including DOCX support), fixed unwanted shadow blurring in imported PPTX files, fixed image frame anchor type changing upon DOCX export and undo not restoring image anchor position
48. Noel Grandin (Collabora) made it faster to load large Writer tables, insert large charts and export PDFs, optimised the parallel loading of spreadsheets and made many code cleanups and smaller optimisations

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

591 bugs, 67 of which are enhancements, have been reported by 331 people.

Top 10 Reporters

1. NISZ LibreOffice Team ( 41 )
2. Telesto ( 38 )
3. Mike Kaganski ( 18 )
4. elias estatistics ( 11 )
5. flywire ( 9 )
6. Elmar ( 8 )
7. John ( 8 )
8. medmedin2014 ( 7 )
9. Rafael Lima ( 7 )
10. Luke Kendall ( 6 )

Triaged Bugs

571 bugs have been triaged by 88 people.

Top 10 Triagers

1. Heiko Tietze ( 52 )
2. Xisco Faulí ( 52 )
3. Roman Kuznetsov ( 50 )
4. Dieter ( 43 )
5. Timur ( 42 )
6. Buovjaga ( 39 )
7. m.a.riosv ( 28 )
8. Julien Nabet ( 27 )
9. Mike Kaganski ( 26 )
10. Telesto ( 16 )

Resolution of resolved bugs

589 bugs have been set to RESOLVED.

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

Fixed Bugs

186 bugs have been fixed by 43 people.

Top 10 Fixers

1. Caolán McNamara ( 18 )
2. Eike Rathke ( 8 )
3. Andreas Heinisch ( 8 )
4. Mike Kaganski ( 7 )
5. László Németh ( 7 )
6. Heiko Tietze ( 6 )
7. Balazs Varga ( 6 )
8. Julien Nabet ( 5 )
9. Noel Grandin ( 5 )
10. Miklos Vajna ( 5 )

List of critical bugs fixed

1. tdf#144132 Crash when insert formula object in Writer ( Thanks to Noel Grandin )
2. tdf#144184 Calc disables header/footer or looses footer content when saves a spreadsheet ( Thanks to Daniel Arato (NISZ) )
3. tdf#144740 Criteria query (COUNTIF(), MATCH() et al) for numeric values broken considering number formats ( Thanks to Eike Rathke )

List of high severity bugs fixed

1. tdf#143854 FILESAVE: Empty bullet added when saving from PPT to ODP ( Thanks to Xisco Fauli )
2. tdf#144106 FILEOPEN: LibreOffice crashes on opening CSV file with “Trim spaces” option enabled ( Thanks to Stephan Bergmann )
3. tdf#144155 CALC Row operations over 100 times slower in 7.2 compared to 7.1 ( Thanks to Xisco Fauli )
4. tdf#144209 Result with “Precision as shown” with custom string+General number format becomes 0 ( Thanks to Eike Rathke )
5. tdf#144249 Deleting 10.000 rows column in a spreadsheet: 15 sec with 4.1| 10 sec up to 300+ sec with 6.2| 130 sec with 7.3 ( Thanks to Luboš Luňák )
6. tdf#144729 Crash when trying to modify a style (gtk3 only) ( Thanks to Caolán McNamara )

List of crashes fixed

1. tdf#117842 Firebird: Enabling connection pooling for firebird:sdbc driver crashes Libo when creating connection to data engine ( Thanks to Mike Kaganski )
2. tdf#140951 Base crashes as soon as I start an ‘Abfrage’ (Windows) ( Thanks to Julien Nabet )
3. tdf#144106 FILEOPEN: LibreOffice crashes on opening CSV file with “Trim spaces” option enabled ( Thanks to Stephan Bergmann )
4. tdf#144132 Crash when insert formula object in Writer ( Thanks to Noel Grandin )
5. tdf#144135 Calc causes repeatable fatal crash when I attempted to sort columns ( Thanks to Eike Rathke )
6. tdf#144139 LO crashes when trying to print a form ( Thanks to Caolán McNamara )
7. tdf#144193 CRASH: importing document (gtk3) ( Thanks to Noel Grandin )
8. tdf#144304 CRASH: Selecting all and cutting in specific document / Inserting section ( Thanks to Aron Budea )
9. tdf#144340 A query against an embedded FB database fails, and then crashed program on close on Windows ( Thanks to Mike Kaganski )
10. tdf#144376 Crash when triggering twice “Protected cells can not be modified” (reproducible) ( Thanks to Caolán McNamara )
11. tdf#144564 CRASH When reloading mail merge documents ( Thanks to Caolán McNamara )
12. tdf#144598 Crash in: SkRect::round() ( Thanks to Luboš Luňák )
13. tdf#144624 LibreOffice with “gen” UI backend crashes on Linux of SVG icon theme is default ( Thanks to Aleksei Nikiforov )
14. tdf#144729 Crash when trying to modify a style (gtk3 only) ( Thanks to Caolán McNamara )

List of performance issues fixed

1. tdf#125892 Time to export a certain PDF increased with in 10 fold (previously 30 seconds (6.0) now 5 minutes (6.4) ( Thanks to Noel Grandin )
2. tdf#143268 Slow response in document with many tables after Table tree is expanded in Navigator ( Thanks to Jim Raykowski )
3. tdf#144155 CALC Row operations over 100 times slower in 7.2 compared to 7.1 ( Thanks to Xisco Fauli )
4. tdf#144249 Deleting 10.000 rows column in a spreadsheet: 15 sec with 4.1| 10 sec up to 300+ sec with 6.2| 130 sec with 7.3 ( Thanks to Luboš Luňák )

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

1. tdf#100777 Bind Ctrl+Up/Down to uno:GoToStartStartOfPara/EndOfPara (instead of next/prev. paragraph) ( Thanks to Ross Johnson )
2. tdf#105689 Emoji toolbar button (bug 100100 emoji.json implementation) not functional on Windows ( Thanks to Julien Nabet )
3. tdf#35129 Form spin button doesn’t expose ROLE_SPIN_BUTTON to AT-SPI ( Thanks to Michael Weghorn )
4. tdf#39828 Writer table not calculating correctly if Tracked Changes shown ( Thanks to László Németh )
5. tdf#45525 TABLES, Problem on adjust selected Row or Column to equal space ( Thanks to Justin Luth )
6. tdf#50421 UI: “Check for Updates” menu leads to an unusable dialog (shows “%PERCENT%”) ( Thanks to Julien Nabet )
7. tdf#73139 PRINTING: Content of Tablecontrols isn’t printed, when the whole Fonts are default (black) text color ( Thanks to Caolán McNamara )
8. tdf#88163 [WMF] FILEOPEN Wrong size of fonts ( Thanks to Hossein )
9. tdf#89383 Writer: Read-only passwords on OOXML files are not working ( Thanks to Tünde Tóth )
10. tdf#95378 Navigator does not select/highlight names of images, objects, tables etc that get focus, also not with Content View activated ( Thanks to Jim Raykowski )

WORKSFORME bugs

69 bugs have been retested by 36 people.

Top 10 testers

1. Roman Kuznetsov ( 10 )
2. Buovjaga ( 9 )
3. Dieter ( 5 )
4. Telesto ( 4 )
5. Julien Nabet ( 4 )
6. Xisco Faulí ( 3 )
7. Heiko Tietze ( 3 )
8. Alex Thurgood ( 2 )
9. Elmar ( 2 )
10. Samuel Mehrbrodt (allotropia) ( 2 )

DUPLICATED bugs

154 bugs have been duplicated by 37 people.

Top 10 testers

1. Timur ( 27 )
2. Xisco Faulí ( 17 )
3. Buovjaga ( 16 )
4. NISZ LibreOffice Team ( 12 )
5. m.a.riosv ( 10 )
6. Heiko Tietze ( 7 )
7. Mike Kaganski ( 7 )
8. Telesto ( 6 )
9. Jan-Marek Glogowski ( 5 )
10. Ming Hua ( 5 )

Verified bug fixes

80 bugs have been verified by 24 people.

Top 10 Verifiers

1. NISZ LibreOffice Team ( 20 )
2. Buovjaga ( 10 )
3. stragu ( 7 )
4. Xisco Faulí ( 6 )
5. Thorsten Behrens (CIB) ( 4 )
6. Roman Kuznetsov ( 4 )
7. V Stuart Foote ( 3 )
8. Dieter ( 3 )
9. BogdanB ( 3 )
10. Aron Budea ( 2 )

Categorized Bugs

220 bugs have been categorized with a metabug by 25 people.

Top 10 Categorizers

1. Roman Kuznetsov ( 39 )
2. Dieter ( 28 )
3. Heiko Tietze ( 26 )
4. NISZ LibreOffice Team ( 23 )
5. Timur ( 18 )
6. Buovjaga ( 16 )
7. Aron Budea ( 11 )
8. Jan-Marek Glogowski ( 7 )
9. stragu ( 7 )
10. Rizal Muttaqin ( 7 )

Regression Bugs

69 bugs have been set as regressions by 25 people.

Top 10

1. Timur ( 10 )
2. Telesto ( 9 )
3. Buovjaga ( 6 )
4. Roman Kuznetsov ( 6 )
5. Xisco Faulí ( 5 )
6. Mike Kaganski ( 4 )
7. Aron Budea ( 3 )
8. Alex Thurgood ( 3 )
9. NISZ LibreOffice Team ( 3 )
10. raal ( 2 )

Bisected Bugs

59 bugs have been bisected by 15 people.

Top 10 Bisecters

1. Timur ( 14 )
2. raal ( 7 )
3. Aron Budea ( 5 )
4. Buovjaga ( 4 )
5. Henrik Palomäki ( 4 )
6. NISZ LibreOffice Team ( 4 )
7. Roman Kuznetsov ( 4 )
8. Xisco Faulí ( 4 )
9. Justin L ( 3 )
10. Telesto ( 3 )

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!