QA/Dev Report: April 2021

General Activities

1. LibreOffice 7.1.2 was released on April 1st
2. Ilmari Lauhakangas (TDF) wrote a nice report about the progress done by the Macro Team in the last year
3. Stanislav Horacek updated some menu paths in Help.
4. Seth Chaiklin clarified the meaning of numbered paragraphs in Help.
5. Olivier Hallot (TDF) made 20 changes and additions to Help with topics including menus, Calc cell protection and direct formatting.
6. Jean-Pierre Ledure worked on the ScriptForge library
7. Alain Romedenne and Rafael Lima improved the Help content for the ScriptForge library. Rafel also made it so word wrapping in shapes is enabled by default in Impress and Draw.
8. Xisco Faulí (TDF) made about 30 improvements and additions to unit and UI tests, fixed some regression bugs and added an automated check for translation domains in .ui files
9. Rizal Muttaqin made updates to all icon themes
10. Jan-Marek Glogowski, Armin Le Grand and Thorsten Behrens (allotropia) worked on the WASM build in a feature branch
11. Tibor Nagy (NISZ) fixed losing internal hyperlinks upon PPTX import
12. Vert D improved renaming behaviour in the Template Manager
13. Tushar Kumar Rai fixed a Data Provider crash
14. Roland Kurmann fixed filtered/transpose paste in Calc while adding many new unit tests for the functionality, fixed copying multiple cells from a Calc column and pasting outside LibreOffice and made it so only the count of non-filtered rows will be shown in Calc’s status bar
15. Dante Doménech added some MathML structures and started making use of the Kahan summation algorithm in Calc in order to reduce the numerical error in the total of floating-point calculations
16. Ilhan Yesil made it so the tooltip of a button created by an extension in the Sidebar is refreshed immediately upon text changes
17. Áron Budea (Collabora) fixed a regression in the Modify DDE Link dialog layout
18. Attila Bakos (NISZ) fixed some Writer textbox crashes and regressions and fixed PPTX exporting of template textbox placeholders
19. Tünde Tóth (NISZ) fixed some issues with Calc filtering
20. Jeff Huang fixed a Writer regression in inserting lines with arrow/circle
21. Mark Hung fixed an undo-redo crash
22. Andreas Kainz improved the Notebookbar command logic and improved the layout of some dialogs
23. Aditya Pratap Singh made the image export dialog behaviour more intuitive
24. Luke Deller fixed an issue with Writer using 100% CPU while idle
25. Pedro Pinto Silva improved the macro selector and about dialog layouts
26. Bubli fixed some Impress animation issues
27. Heiko Tietze (TDF) made it so the location in file properties dialog is a hyperlink and improved the Style Inspector layout
28. Matej Kivader fixed the display of custom button text colour in Basic dialog designer
29. Gábor Kelemen (NISZ) made improvements in menu accelerators, buttons and Impress/Draw general options layout
30. Stephan Bergmann (Red Hat) made many code cleanups, replaced apache-commons-logging with java.util.logging.Logger in report builder and elsewhere, fixed unnecessary authentication prompt upon having sftp URIs in recent documents and improved compatibility with C++20
31. Hossein Noorikhah converted all the README files to consistent Markdown format while updating them in many places. He also fixed problems with the HTML generation solution for the READMEs
32. Luboš Luňák (Collabora) made optimisations related to graphics rendering and bitmap loading and improved the Skia integration
33. Armin Le Grand (allotropia) fixed vanishing form controls in edit mode or print preview and fixed a couple of linked OLE object issues
34. László Németh (NISZ) continued adding metadata display capabilities to the Style Inspector, added support for deleted images in change tracking, improved the change tracking UX and fixed a mail merge document counting off by one error
35. Michael Stahl (allotropia) fixed a z-order issue with floating objects, fixed missing images in imported DOCX header/footer, improved the performance of Writer word count and fixed some Writer crashes
36. Bayram Çiçek made it so MIME type icons are displayed in the recent documents menu list
37. Noel Grandin (Collabora) improved the speed of opening XLSX files with thousands of shape objects (with additional contributions by Caolán McNamara), improved the speed of opening XLSX files with massive amounts of row range style attributes and made many code cleanups and optimisations
38. Arnaud versini fixed a regression in breaking links to external images
39. Vasily Melenchuk (CIB) added unit tests for Basic dialog XML serialisation (none existed so far)
40. Andreas Heinisch added checks for valid range names and cell references inserted via API, made Calc range name definition errors show in a tooltip, taught UI tests how to check tooltip text, made Calc sorting respect “Include formats” option, made Calc’s IRR function accept an array as argument, limited the calculation of Pearson coefficient in Calc’s RSQ and PEARSON functions and improved the Calc Manage Names dialog
41. Thorsten Behrens (allotropia) added initial support for sccache builds on Windows
42. Regina Henschel fixed DOCX import of group or line with rotation
43. Bartosz Kosiorek implemented PAINTRGN record and complex clipping support for EMF graphics
44. Jan-Marek Glogowski (allotropia) fixed clipboard handling with Wayland + Qt as well as several other Qt/kf5 issues
45. Gülşah Köse (Collabora) fixed a mail merge issue where empty fields were returned
46. Tomoyuki Kubota helped Caolán with the UI backend work with a couple of patches
47. Tomaž Vajngerl (Collabora) made internal improvements to graphics handling code
48. Justin Luth (Collabora/SIL) fixed losing outline levels upon DOC export, fixed z-order issues with background shapes in DOC import, made DOCX export support russianUpper/russianLower numbering, fixed a DOC import layout issue related to MS Word’s excessively liberal design settings, fixed DOC/RTF export of fixed date and time fields, fixed dupliction of comments, fields and footnotes in DOCX export and fixed many DOC/DOCX import/export issues related to numbering
49. Michael Weghorn made many improvements to the Android version with topics including recent file display, file saving and PDF export
50. Tor Lillqvist (Collabora) worked on the iOS version and improved the event tracing API
51. Rounak Modi added his first unit test
52. Eike Rathke (Red Hat) overhauled VBA Range getFormula(R1C1) to make it work properly
53. Szymon Kłos (Collabora) added a Fontwork options panel into the Sidebar and made Impress collaborative editing more robust
54. Julien Nabet fixed regressions in image filters and made code cleanups and crash fixes
55. Miklos Vajna (Collabora) continued improving gutter margins (RTL) and made improvements to the bibliography feature (URL handling, page references). He also fixed issues with OLE object sizing in HTML export
56. Jim Raykowski improved the Outline folding feature, made crash fixes, added the ability to navigate by fields with the Navigate By control and added fields content type to Navigator
57. Samuel Mehrbrodt (allotropia) added a mechanism to selectively enable macros for document events
58. Matt K added a check for ODF file format associations on Windows upon startup and changed the Windows file dialog to run on the main thread to avoid crashes
59. Mike Kaganski (Collabora) improved the Calc tab bar look, made it so pasting RTF content does not wipe out document settings, added DOCX export/import of resolved comments as “done” and made code cleanups and optimisations, crash fixes and improvements to unit tests
60. Caolán McNamara fixed an infinite loop in spellchecking dialog layout, fixed an issue with duplicated and misplaced images in exported Archive/A-1b PDFs, made dragging hyperlinks in Writer with GTK3 backend work, continued on the last stretch of the massive UI backend work and made many cleanups and crash fixes

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

577 bugs, 71 of which are enhancements, have been reported by 362 people.

Top 10 Reporters

1. Xisco Faulí ( 24 )
2. NISZ LibreOffice Team ( 24 )
3. Telesto ( 24 )
4. Eyal Rozenberg ( 22 )
5. Regina Henschel ( 13 )
6. Olivier Hallot ( 8 )
7. Scito ( 6 )
8. Roman Kuznetsov ( 6 )
9. BDF ( 6 )
10. Rizal Muttaqin ( 6 )

Triaged Bugs

609 bugs have been triaged by 100 people.

Top 10 Triagers

1. Xisco Faulí ( 111 )
2. Heiko Tietze ( 56 )
3. Dieter ( 50 )
4. Buovjaga ( 49 )
5. Timur ( 33 )
6. Julien Nabet ( 22 )
7. Mike Kaganski ( 17 )
8. Roman Kuznetsov ( 16 )
9. raal ( 15 )
10. Olivier Hallot ( 15 )

Resolution of resolved bugs

617 bugs have been set to RESOLVED.

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

Fixed Bugs

207 bugs have been fixed by 47 people.

Top 10 Fixers

1. Caolán McNamara ( 23 )
2. Mike Kaganski ( 10 )
3. Andreas Heinisch ( 9 )
4. Olivier Hallot ( 9 )
5. Justin Luth ( 7 )
6. László Németh ( 7 )
7. scito ( 6 )
8. Miklos Vajna ( 6 )
9. Jan-Marek Glogowski ( 6 )
10. Attila Bakos (NISZ) ( 5 )

List of critical bugs fixed

1. tdf#106282 Crash in: windows.storage.dll when hitting cancel in file open dialog, when a file search is running ( Thanks to Matt K )
2. tdf#86321 EDITING, FORMATTING: diagram didn’t automatic update when change variable (steps in comment 28) ( Thanks to Xisco Fauli )

List of high severity bugs fixed

1. tdf#106195 Change docs to explain how to handle and remove direct formatting ( Thanks to Olivier Hallot )
2. tdf#132472 FILEOPEN PPTX Table text imported with white color ( Thanks to Xisco Fauli )
3. tdf#132901 Tools > Options > LibreOffice > Online update crashes if “online update” feature is not installed ( Thanks to Xisco Fauli )
4. tdf#138785 Empty frames after deleting an image and (auto-saving the file) (track changes involved) ( Thanks to Michael Stahl )
5. tdf#140639 It is not possible to work with an older document from LO 6.4 in new LO 7.0, slow perf ( Thanks to Caolán McNamara )
6. tdf#141345 new feature gutter-margin in LO7.2 produces unnecessary incompatibility with LO7.1 ( Thanks to Miklos Vajna )
7. tdf#141504 UI Images look ugly with 1-bit depth with QT5 backend ( Thanks to Jan-Marek Glogowski )
8. tdf#141703 EDITING Tab key no longer moves to next cell in Impress table ( Thanks to Samuel Mehrbrodt )

List of crashes fixed

1. tdf#106282 Crash in: windows.storage.dll when hitting cancel in file open dialog, when a file search is running ( Thanks to Matt K )
2. tdf#131634 Crash in sd::View::SdrEndTextEdit(bool) ( Thanks to Mark Hung )
3. tdf#132901 Tools > Options > LibreOffice > Online update crashes if “online update” feature is not installed ( Thanks to Xisco Fauli )
4. tdf#135997 SPECIAL CHARACTER DIALOG: Crash in: SvxCharacterMap::updateRecentCharControl() ( Thanks to Mike Kaganski )
5. tdf#141405 LO crashes when adding control in dialog editor ( Thanks to Jim Raykowski )
6. tdf#141499 Crash inserting hyperlink (fairly often) and cursor not starting in URL field ( Thanks to Caolán McNamara )
7. tdf#141511 CRASH: creating new document while navigator is displayed ( Thanks to Jim Raykowski )
8. tdf#141531 Android Viewer crashes trying to open mail merge file with unavailable data source ( Thanks to Michael Weghorn )
9. tdf#141537 UNO Object Inspector: Crash while inspecting file ( Thanks to Julien Nabet )
10. tdf#141547 CRASH: opening Standard Filter dialog ( Thanks to Mike Kaganski )
11. tdf#141557 DOCX file crashes when the anchor changed to_paragraph from as_char ( Thanks to Attila Bakos (NISZ) )
12. tdf#141689 Crash with trendline using moving average with 2 points and type central ( Thanks to Samuel Mehrbrodt )
13. tdf#141701 EDITING Crash when closing 3D View dialog of 3D chart ( Thanks to Noel Grandin )
14. tdf#141708 CRASH: closing document while navigator is open ( gen ) ( Thanks to Caolán McNamara )
15. tdf#141854 Crash in: mergedlo.dll ( Thanks to Caolán McNamara )
16. tdf#141887 Crash on closing Writer via window decoration (X) with unmodified document and active IM ( Thanks to Jan-Marek Glogowski )
17. tdf#141924 A specific file crashes with Style Inspector open, after deleting some text ( Thanks to Mike Kaganski )
18. tdf#141967 Crash when closing Asian Phonetic Guide (gtk3) ( Thanks to Caolán McNamara )

List of performance issues fixed

1. tdf#140639 It is not possible to work with an older document from LO 6.4 in new LO 7.0, slow perf ( Thanks to Caolán McNamara )
2. tdf#141416 [FILEOPEN] Excel file very long to open (more than one hour) ( Thanks to Xisco Fauli )
3. tdf#141556 Ongoing 100% CPU usage after opening document ( Thanks to Luke Deller )
4. tdf#45820 insanely slow wmf import (complex clipping and basegfx::tools::findCuts) ( Thanks to Bartosz Kosiorek )

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

1. tdf#100070 UKENR (Norwegian WEEKNUM function) gives wrong week numbers. ( Thanks to Andreas Heinisch )
2. tdf#101217 Setting the column width and height should not round the values causing compounding errors ( Thanks to Winston Min Tjong )
3. tdf#106195 Change docs to explain how to handle and remove direct formatting ( Thanks to Olivier Hallot )
4. tdf#106282 Crash in: windows.storage.dll when hitting cancel in file open dialog, when a file search is running ( Thanks to Matt K )
5. tdf#106944 Examples for Open statement do not work, because file in root of drive C: not possible in Windows ( Thanks to Rafael Lima )
6. tdf#107348 Pasting transpose of filtered data pastes unfiltered data ( Thanks to scito )
7. tdf#34902 [LOCALHELP] add help for printing a Selection in Draw and Impress ( Thanks to Olivier Hallot )
8. tdf#37281 emf file display yellow square instead of yelow circle ( Thanks to Bartosz Kosiorek )
9. tdf#45735 Automatic check at start-up whether LO is default program for ODF-file formats ( Thanks to Matt K )
10. tdf#45820 insanely slow wmf import (complex clipping and basegfx::tools::findCuts) ( Thanks to Bartosz Kosiorek )
11. tdf#45958 Only Copy Visible Cells (after a filter) doesn’t work when only unfiltered columns are selected ( Thanks to scito )
12. tdf#48025 EDITING AUTOFILTER: Autofilter settings stay with the column number when deleting columns ( Thanks to Tünde Tóth )
13. tdf#48551 UI: Custom Animation Effect Direction shall not read “From…” but “To…” in some cases ( Thanks to Katarina Behrens )
14. tdf#48916 FORMATTING: The clipping of EMF files are ignored. ( Thanks to Bartosz Kosiorek )
15. tdf#58585 IRR / MIRR functions should accept an array argument ( Thanks to Andreas Heinisch )
16. tdf#59463 EDITING: “Record/track changes”: image deletion isn’t recorded ( Thanks to László Németh )
17. tdf#78864 Not clear whether picture has been added or removed with record changes ( Thanks to László Németh )
18. tdf#81705 Export to DOC lost outline level ( Thanks to Justin Luth )
19. tdf#82211 Manage Names pop-up re-size re-sizes wrong element ( Thanks to Andreas Heinisch )
20. tdf#84517 UI: wrong number of selected rows in status bar when rows are filtered ( Thanks to scito )
21. tdf#86321 EDITING, FORMATTING: diagram didn’t automatic update when change variable (steps in comment 28) ( Thanks to Xisco Fauli )
22. tdf#93664 filter a list with merged cells does not work ( Thanks to Tünde Tóth )
23. tdf#94326 Chapter numbering (heading styles) not displaying numbering (DOC fileopen) ( Thanks to Justin Luth )
24. tdf#94962 The RSQ function returning values greater than one. ( Thanks to Andreas Heinisch )
25. tdf#95517 changes reset after show Settings ( Thanks to Michael Weghorn )
26. tdf#95554 Copy&paste of multiple cells in a column only copies the first cell ( Thanks to scito )
27. tdf#95615 Android: Changes in template lost ( Thanks to Michael Weghorn )
28. tdf#99991 UI: dialog Manage Names loses set individual size when Range Options is chosen ( Thanks to Andreas Heinisch )

WORKSFORME bugs

77 bugs have been retested by 34 people.

Top 10 testers

1. Buovjaga ( 11 )
2. Dieter ( 6 )
3. Xisco Faulí ( 6 )
4. Telesto ( 6 )
5. Heiko Tietze ( 5 )
6. Roman Kuznetsov ( 5 )
7. Andreas Heinisch ( 4 )
8. steve ( 4 )
9. Julien Nabet ( 2 )
10. Robert Großkopf ( 2 )

DUPLICATED bugs

147 bugs have been duplicated by 36 people.

Top 10 testers

1. Timur ( 25 )
2. Xisco Faulí ( 15 )
3. V Stuart Foote ( 14 )
4. Heiko Tietze ( 13 )
5. Justin L ( 8 )
6. Mike Kaganski ( 8 )
7. Dieter ( 7 )
8. Aron Budea ( 4 )
9. Jean-Baptiste Faure ( 4 )
10. NISZ LibreOffice Team ( 4 )

Verified bug fixes

91 bugs have been verified by 19 people.

Top 10 Verifiers

1. Xisco Faulí ( 32 )
2. Buovjaga ( 11 )
3. NISZ LibreOffice Team ( 11 )
4. baffclan ( 8 )
5. Julien Nabet ( 7 )
6. Dieter ( 4 )
7. Timur ( 3 )
8. Vera Blagoveschenskaya ( 2 )
9. Aron Budea ( 2 )
10. Heiko Tietze ( 2 )

Categorized Bugs

263 bugs have been categorized with a metabug by 40 people.

Top 10 Categorizers

1. Dieter ( 47 )
2. Roman Kuznetsov ( 42 )
3. Rizal Muttaqin ( 19 )
4. Aron Budea ( 18 )
5. NISZ LibreOffice Team ( 16 )
6. Heiko Tietze ( 14 )
7. Eyal Rozenberg ( 12 )
8. Olivier Hallot ( 9 )
9. Buovjaga ( 9 )
10. Gabor Kelemen ( 7 )

Regression Bugs

70 bugs have been set as regressions by 18 people.

Top 10

1. Xisco Faulí ( 28 )
2. Telesto ( 8 )
3. Timur ( 6 )
4. Aron Budea ( 5 )
5. Alex Thurgood ( 5 )
6. Buovjaga ( 3 )
7. Robert Großkopf ( 3 )
8. Roman Kuznetsov ( 2 )
9. raal ( 1 )
10. Justin L ( 1 )

Bisected Bugs

74 bugs have been bisected by 13 people.

Top 10 Bisecters

1. Xisco Faulí ( 35 )
2. Timur ( 12 )
3. Aron Budea ( 8 )
4. raal ( 7 )
5. Buovjaga ( 3 )
6. Raji ( 2 )
7. pavlog ( 1 )
8. Gabor Kelemen ( 1 )
9. Justin L ( 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!