QA/Dev Report: May 2021

General Activities

1. LibreOffice 7.1.3 was released on May 6
2. LibreOffice 7.0.6 was released on May 13
3. The PowerPoint compatibility team reported on its recent work
4. Alain Romedenne and Rafael Lima improved the Help content for the ScriptForge library. Rafael Lima also documented the WeekDay Basic function and improved the help for Calc’s CONVERT function
5. Kevin Suo improved the Python script for generating the file filter table for Help. Kevin also fixed a font family problem in the Help CSS related to Simplified Chinese display on Linux
6. Steve Fanning made several improvements to Calc function Help pages.
7. Olivier Hallot (TDF) improved Help on Calc functions, databases and Calc’s autofilter
8. Eike Rathke (Red Hat) made Calc accept 123.45 fractional input on weird formats like 0″.” or 0″.”0, expanded NatNum12 modifier support for all day and month names and made it so Calc’s ROUND() function does not limit decimal digits
9. Jean-Pierre Ledure worked on the ScriptForge library
10. Caolán McNamara not only continued with GTK3 backend polishing, but took on a new large-scale project: a GTK4 backend! See here and here. He also made many cleanups and crash fixes
11. Noel Grandin (Collabora) started fixing memory leaks like an angry plumber. He also speeded up saving large ODS files, made a big refactoring as part of a longer-term goal of doing UI widget rendering only inside a top-level render- context and made many code cleanups and optimisations
12. Linus Heckemann made it so the code for opening links is more portable considering different *nix systems
13. Szabolcs Tóth (NISZ) fixed a case, where Calc autofilter item list would be lost after saving and reloading the spreadsheet
14. Vasily Melenchuk (CIB) fixed a DOCX import problem with list item indentation
15. Joshua Williams swapped comparison operators for static strings, so Basic macro code behaves logically
16. Muhammet Kara (Collabora) made it so experimental commands are hidden, when experimental mode is not active. He also fixed a crash in Additions when fetching bad JSON data
17. Thorsten Wagner polished the macOS window scaling implementation for Retina displays
18. Aritz Erkiaga fixed a problem with Stock Charts corrupting upon saving
19. Oleg Shchelykalnov added an option to respect hidden paragraphs, when exporting to plain text
20. Vert D fixed a problem with deleting categories in the Template Manager
21. Tünde Tóth (NISZ) fixed some Calc autofilter problems
22. Edward Lynch fixed Impress Grow/Shrink animation scaling
23. Bubli fixed hatch and bitmap lists being hidden in the Sidebar
24. Justin Luth (Collabora/SIL) fixed some DOCX/DOC numbered list problems and improved the character formatting dialog presentation of subscripts and superscripts
25. Georgy Litvinov fixed losing sections at the end of text inserted with the “Insert text from file” functionality in Writer
26. Sarabjot Singh added a thick cursor into Calc in the style of MS Excel and Gnumeric. The cursor is used when hovering over cells.
27. Baltasar changed the behaviour of adding commands to menus, so instead of an altert reporting of a duplicate command, the Add button becomes disabled
28. Matt K made it so multiple Tip-of-the-Day tips can be opened and the user can interact with the application without closing the tips. He also added new UI options when opening a locked or non-writeable document to allow the user to be notified when such a document becomes editable
29. Rizal Muttaqin made updates to Sukapura, elementary and Colibre icon themes
30. Maxim Monastirsky made it so Calc sets the font size for the default cell style when saving ODS files
31. Dennis Francis (Collabora) made many improvements to Calc’s autocompletion feature. The logic for presenting suggestions is now more user-friendly.
32. Regina Henschel fixed wrong scaling of shape groups and incorrect rotation of VML shapes in imported DOCX files
33. Arnaud versini made some code cleanups
34. Tibor Nagy and Attila Szűcs (NISZ) fixed unhiding grid lines in imported XLSX files and fixed lost column break in shapes in imported DOCX files with support from Justin Luth
35. Heiko Tietze (TDF) added a dark colour set in order to provide a dark theme leveraging the Application Colours feature
36. Jan-Marek Glogowski and Thorsten Behrens (allotropia) worked on the WASM build, now merged into master
37. Michael Weghorn made many improvements to the Android version with topics including stability, document view and inserting images
38. Mark Hung improved the rendering of vertical text
39. László Németh (NISZ) made many improvements to change tracking and made line style dropdowns display all of the styles in imported DOCX files
40. Bartosz Kosiorek made a whopping 16 improvements to EMF and WMF graphics support, inching closer to perfect support. Valek Filippov helped with the file analysis and testing.
41. Jim Raykowski made it so drawing objects selected in the document are highlighted in Navigator’s content navigation view. He also added shortcut keys for each Sidebar deck and improved the outline folding feature
42. Attila Bakos (NISZ) fixed z-ordering and positioning of shapes in imported DOCX files
43. Tibor Nagy (NISZ) fixed PPTX import/export problems related to slide names, internal hyperlinks and custom slide shows
44. Daniel Arato (NISZ) fixed DOCX exporting of hidden headers and DOCX importing of text wrapping in headers
45. Balázs Varga (NISZ) fixed several Calc autofilter issues
46. Mike Kaganski (Collabora) improved the handling of 0-byte files, made Calc CSV import properly handle the case of no string delimiter, improved the look of the new thick Calc cursor on Windows and made many code cleanups
47. Xisco Faulí (TDF) made over 50 improvements and additions to unit and UI tests
48. Chris Sherlock did some housecleaning in VCL
49. Dante Doménech finished the work on using Kahan summation algorithm in Calc in order to reduce the numerical error in the total of floating-point calculations. He also the Math formula input box zoomable
50. Roland Kurmann made many improvements to Calc transposed and special pasting
51. Andreas Heinisch made Basic respect case-insensitivity in find & replace, fixed a problem with sheet references not updating in charts when copying multiple sheets in Calc, fixed an issue with item selection properties not being updated in a Base form after selecting all, fixed 3D look listbox in Chart wizard not showing selected text, made macro import/export use UTF-8 with BOM and made it so externally linked tables in Calc get named based on their HTML caption element
52. Stephan Bergmann (Red Hat) made many code cleanups and continued improving compatibility with C++20
53. Miklos Vajna (Collabora) fixed handling of list labels and a bunch of other things in Writer XHTML export, fixed a problem with OLE object display areas, fixed a couple of crashes and made many code cleanups and optimisations
54. Samuel Mehrbrodt (allotropia) implemented the very popular request for filtering by colours in Calc
55. Gábor Kelemen (NISZ) made some improvements to dialogs, toolbars and Hungarian shortcuts
56. Gülşah Köse (Collabora) improved the new UNO object inspector, removed the warning of missing data sources upon load as the Mail Merge dialog also warns about it and fixed a PPTX export highlighting colour issue
57. Mert Tumer (Collabora) improved the table cell selection logic in Impress & Draw
58. Julien Nabet made many code cleanups and optimisations
59. Michael Stahl (allotropia) fixed some Writer layout crashes and infinite loops
60. Christian Lohmaier (TDF) fixed a build issue with recent Cygwin versions, improved the VS Code workspace template and started cleaning up the installer codebase
61. Tushar Kumar Rai made the StrConv VBA Function handle its third argument (LCID) and fixed related QA tests. He also fixed a Data Provider crash
62. Tomaž Vajngerl (Collabora) added a hecking awesome Heads-up Display type of search and made internal improvements to graphics handling code
63. Luboš Luňák (Collabora) made optimisations related to graphics rendering and bitmap loading and improved the Skia integration. He also made it possible to write canvas unit tests and added a bunch of tests

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

567 bugs, 57 of which are enhancements, have been reported by 323 people.

Top 10 Reporters

1. NISZ LibreOffice Team ( 38 )
2. Valek Filippov ( 31 )
3. Telesto ( 24 )
4. Regina Henschel ( 14 )
5. Xisco Faulí ( 12 )
6. Thorsten Wagner ( 10 )
7. Mike Kaganski ( 9 )
8. Rafael Lima ( 8 )
9. Nico ( 7 )
10. Heiko Tietze ( 7 )

Triaged Bugs

584 bugs have been triaged by 85 people.

Top 10 Triagers

1. Xisco Faulí ( 70 )
2. Timur ( 61 )
3. Heiko Tietze ( 50 )
4. Dieter ( 50 )
5. Roman Kuznetsov ( 36 )
6. V Stuart Foote ( 26 )
7. Julien Nabet ( 25 )
8. NISZ LibreOffice Team ( 20 )
9. Harshita Nag ( 20 )
10. Aron Budea ( 17 )

Resolution of resolved bugs

620 bugs have been set to RESOLVED.

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

Fixed Bugs

198 bugs have been fixed by 52 people.

Top 10 Fixers

1. Caolán McNamara ( 16 )
2. Bartosz Kosiorek ( 11 )
3. László Németh ( 9 )
4. Andreas Heinisch ( 7 )
5. Balazs Varga ( 7 )
6. Gülşah Köse ( 7 )
7. Eike Rathke ( 6 )
8. Noel Grandin ( 6 )
9. Tibor Nagy ( 5 )
10. Michael Weghorn ( 5 )

List of critical bugs fixed

1. tdf#142390 calc 7.2.0.0.a0+ >2021-05-19, no mouse cursor in cell area ( Thanks to Mike Kaganski )

List of high severity bugs fixed

1. tdf#138302 Restart of numbering is not saved when saving to DOC ( Thanks to Justin Luth )
2. tdf#141571 Base crashed on creation of user function ( Thanks to Noel Grandin )
3. tdf#141613 Crash: swlo!SwTableNode::DelFrames+0x27: ( Thanks to Daniel Arato (NISZ) )
4. tdf#141930 libreoffice math does not ask to save changes when closing ( Thanks to Caolán McNamara )
5. tdf#142040 CSV import broken in master ( Thanks to Noel Grandin )
6. tdf#142150 Application crashes when EDITING line end styles (arrows) ( Thanks to Caolán McNamara )
7. tdf#142255 Crash when trying to insert a shape ( Thanks to Noel Grandin )
8. tdf#142367 Writer crashes when opening docx (GTK3) ( Thanks to Noel Grandin )
9. tdf#142370 CRASH: Closing tip of the day ( GTK3 ) ( Thanks to Caolán McNamara )
10. tdf#142547 Crash when adding comment in a table in Writer ( Thanks to Noel Grandin )
11. tdf#54037 FILESAVE: Loss of internal hyperlinks in PPT/PPTX ( Thanks to Tibor Nagy )
12. tdf#76258 Filter by colors in Calc ( Thanks to Samuel Mehrbrodt )
13. tdf#91874 A Search by function or keyword over main menu– similar to SpotLight, Tell Me, or Ubuntu’s HUD but native for LO GUI ( Thanks to Tomaž Vajngerl )

List of crashes fixed

1. tdf#126226 CRASH: Adding comment to Track Change ( Thanks to László Németh )
2. tdf#136292 Additions: Bad JSON crashes LibreOffice ( Thanks to Muhammet Kara )
3. tdf#138855 Draw crashes if I use ALT+TAB to switch between two draw windows while the cursor focus is in a text box ( Thanks to Caolán McNamara )
4. tdf#139500 Crash mergedlo!EditUndo::GetComment+54 press undo inside table in impress ( Thanks to Miklos Vajna )
5. tdf#141307 Crash in: SvtBroadcaster::Add (probably a basic macro issue) ( Thanks to Bjoern Michaelsen )
6. tdf#141571 Base crashed on creation of user function ( Thanks to Noel Grandin )
7. tdf#141613 Crash: swlo!SwTableNode::DelFrames+0x27: ( Thanks to Daniel Arato (NISZ) )
8. tdf#141973 Calc crashes after F5 pressing when opened some file ( Thanks to Caolán McNamara )
9. tdf#142150 Application crashes when EDITING line end styles (arrows) ( Thanks to Caolán McNamara )
10. tdf#142255 Crash when trying to insert a shape ( Thanks to Noel Grandin )
11. tdf#142364 Crash when closing document after canceling chart wizard (Writer) ( Thanks to Caolán McNamara )
12. tdf#142367 Writer crashes when opening docx (GTK3) ( Thanks to Noel Grandin )
13. tdf#142370 CRASH: Closing tip of the day ( GTK3 ) ( Thanks to Caolán McNamara )
14. tdf#142467 Inserting series in Stock Chart Data Table crashes Writer (Fedora only?) ( Thanks to Stephan Bergmann )
15. tdf#142479 CRASH: pressing return key after opening arrow styles floating window ( Thanks to Caolán McNamara )
16. tdf#142547 Crash when adding comment in a table in Writer ( Thanks to Noel Grandin )

List of performance issues fixed

1. tdf#142080 FILEOPEN: DOCX: Hang after opening the file ( Thanks to Michael Stahl )
2. tdf#79049 FILEOPEN: OOXML Workbook file hangs when opening ( Thanks to Noel Grandin )

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

1. tdf#102255 UNO: Transpose Paste ( Thanks to scito )
2. tdf#103347 FILEOPEN: PPTX – Using the slide title as slide name has problems when multiple slides have the same title ( Thanks to Tibor Nagy )
3. tdf#104169 Change the mouse cursor icon when hovering the spreadsheet ( Thanks to Sarabjot Singh )
4. tdf#105650 Wrong text alignment with strikethrough within vertical writing ( Thanks to Mark Hung )
5. tdf#106370 Android: add ability to insert pictures ( Thanks to Michael Weghorn )
6. tdf#106893 Black area when closing bottom toolbar after a change ( Thanks to Michael Weghorn )
7. tdf#43175 EDITING: Sheet references not correctly updated in charts when copying multiple sheets in Calc ( Thanks to Andreas Heinisch )
8. tdf#53004 [WMF] FILEOPEN Black squares is missing after import WMF file created by LTspice ( Thanks to Bartosz Kosiorek )
9. tdf#54037 FILESAVE: Loss of internal hyperlinks in PPT/PPTX ( Thanks to Tibor Nagy )
10. tdf#55007 [EMF] FILEOPEN: Close circle instead of arch (exported by Catia v5) ( Thanks to Bartosz Kosiorek )
11. tdf#57351 Calc: “Insert columns” is not available in the context menu if an autofilter to hide rows is applied ( Thanks to Tünde Tóth )
12. tdf#60382 EDITING and TABLE: No changes tracked when deleting table rows and tables ( Thanks to László Németh )
13. tdf#68113 [UI] [Autofilter] Selecting “Not empty” unchecks all entries ( Thanks to Balazs Varga )
14. tdf#69635 FILESAVE: DOCX Export loses hidden ‘first’ and ‘even’ header & footer ( Thanks to Daniel Arato (NISZ) )
15. tdf#76258 Filter by colors in Calc ( Thanks to Samuel Mehrbrodt )
16. tdf#79049 FILEOPEN: OOXML Workbook file hangs when opening ( Thanks to Noel Grandin )
17. tdf#84502 Add shortcut keys to each Sidebar Tab to open its content panel(s) ( Thanks to Jim Raykowski )
18. tdf#90101 Add new UNO command for PasteLink ( Thanks to scito )
19. tdf#91874 A Search by function or keyword over main menu– similar to SpotLight, Tell Me, or Ubuntu’s HUD but native for LO GUI ( Thanks to Tomaž Vajngerl )
20. tdf#96061 Text background/highlighting color doesn’t reopen well in LO when exporting as PPTX (OK in MSO) ( Thanks to Gülşah Köse )
21. tdf#97066 listbox “select all: with CTRL+A does not update SelectedItems, SelectedValues, etc properties ( Thanks to Andreas Heinisch )

WORKSFORME bugs

78 bugs have been retested by 40 people.

Top 10 testers

1. Buovjaga ( 6 )
2. Timur ( 5 )
3. Xisco Faulí ( 5 )
4. Jean-Baptiste Faure ( 5 )
5. NISZ LibreOffice Team ( 4 )
6. Julien Nabet ( 4 )
7. Aron Budea ( 3 )
8. Dieter ( 3 )
9. Heiko Tietze ( 3 )
10. Roman Kuznetsov ( 3 )

DUPLICATED bugs

155 bugs have been duplicated by 36 people.

Top 10 testers

1. Timur ( 42 )
2. Xisco Faulí ( 12 )
3. Heiko Tietze ( 12 )
4. NISZ LibreOffice Team ( 11 )
5. Justin L ( 9 )
6. Julien Nabet ( 9 )
7. Attila Bakos (NISZ) ( 8 )
8. Mike Kaganski ( 6 )
9. V Stuart Foote ( 6 )
10. Aron Budea ( 4 )

Verified bug fixes

142 bugs have been verified by 16 people.

Top 10 Verifiers

1. BogdanB ( 55 )
2. Xisco Faulí ( 41 )
3. NISZ LibreOffice Team ( 15 )
4. Timur ( 6 )
5. Bartosz ( 4 )
6. Dieter ( 4 )
7. Buovjaga ( 3 )
8. Julien Nabet ( 3 )
9. Ming Hua ( 2 )
10. Aron Budea ( 2 )

Categorized Bugs

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

Top 10 Categorizers

1. NISZ LibreOffice Team ( 50 )
2. Dieter ( 46 )
3. Valek Filippov ( 34 )
4. Aron Budea ( 30 )
5. Roman Kuznetsov ( 28 )
6. Heiko Tietze ( 25 )
7. V Stuart Foote ( 22 )
8. Eyal Rozenberg ( 21 )
9. Jun Nogata ( 12 )
10. Roland Kurmann ( 9 )

Regression Bugs

63 bugs have been set as regressions by 22 people.

Top 10

1. Telesto ( 14 )
2. Xisco Faulí ( 11 )
3. Timur ( 8 )
4. Robert Großkopf ( 5 )
5. NISZ LibreOffice Team ( 3 )
6. Justin L ( 2 )
7. Aron Budea ( 2 )
8. raal ( 2 )
9. Roman Kuznetsov ( 2 )
10. Tyco72 ( 2 )

Bisected Bugs

49 bugs have been bisected by 10 people.

Top 10 Bisecters

1. Xisco Faulí ( 18 )
2. Timur ( 14 )
3. Aron Budea ( 6 )
4. Justin L ( 3 )
5. raal ( 3 )
6. pavlog ( 1 )
7. NISZ LibreOffice Team ( 1 )
8. Michael Weghorn ( 1 )
9. Roman Kuznetsov ( 1 )
10. Buovjaga ( 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!