QA/Dev Report: February 2022

General Activities

1. LibreOffice 7.3 was released on February 2
2. FOSDEM took place February 5-6. Watch all the talks here
3. Alain Romedenne added a help page for CallByName Basic function and improved other Basic pages
4. Stanislav Horáček and Adolfo Jayme Barrientos made some Help cleanups
5. Rafael Lima and flywire improved the ScriptForge library help pages. Rafael also made the Manage changes sidebar panel non-experimental, created a command for duplicating sheets in Calc and fixed Search Commands deleting selected text instead of applying a command
6. Seth Chaiklin improved the help page for Template Manager
7. Olivier Hallot (TDF) added help pages for Calc’s Recalculate Hard and Formula to value and improved Help for indentation and some Calc functions
8. Renwa Hiwa and zhutyra fixed several security issues
9. Ilmari Lauhakangas (TDF) fixed an issue with the UI logger
10. Justin Luth (SIL) fixed some issues with Calc’s spelling context menu, Calc’s autofill and hidden/filtered cells, made Draw/Impress Find and replace more robust, made it so setting a border style in Writer adds borders, if there are none, fixed an issue with table layout when re-saving a DOC file and made Writer ruler tabstops respect spacing to contents in tables and frames. He also fixed many regressions
11. Tomaž Vajngerl (Collabora) improved VBA macro compatibility and improved the display of long labels in charts. He is also working on supporting sparklines in Calc
12. Dennis Francis (Collabora) worked on RTL support for LOKit
13. Gülşah Köse (Collabora) fixed issues with table borders in imported PPTX files
14. Noel Grandin (Collabora) made bitmap rotation faster and improved the loading speed of large charts. He also made many code cleanups
15. Caolán McNamara (Red Hat) fixed issues with seeking and stopping in the media player. He also fixed some crashes and many UI issues and continued working on the new gtk4 UI backend
16. Stephan Bergmann (Red Hat) fixed an issue with certain Unicode characters resulting in corrupted XLSX files, raised Linux Clang compiler baseline to 8.0.1 and macOS build baseline to Xcode 12.5 and macOS 11.0. He also made many code and build-related cleanups as well as test fixes
17. Szymon Kłos and Henry Castro (Collabora) worked on LOKit improvements
18. Michael Warner fixed Title Case formating occuring outside of a selection
19. Luboš Luňák (Collabora) improved the speed of Calc’s VLOOKUP function, fixed the orientation combobox in the print dialog, polished the handling of 1024+ columns in Calc and made many improvements to Calc’s document loading and general performance
20. Jens Carl converted a Java test to C++
21. Hossein Nourikhah (TDF) made some cleanups and wrote blog posts about development https://dev.blog.documentfoundation.org/2022/02/10/working-with-libreoffice-sdk-examples/ https://dev.blog.documentfoundation.org/2022/02/23/adding-a-new-uno-command/
22. Michael Meeks (Collabora) patched Boost library to improve handling of encodings
23. Marco Cecchetti (Collabora) made exported SVGs work better with Chrome browser
24. Gábor Kelemen (allotropia) made many code cleanups
25. Sarper Akdemir (Collabora) fixed incorrect shapes in slide footers in imported PPTX files and textboxes with newlines not preserving text size in exported PPTX files
26. Jan-Marek Glogowski (allotropia) continued working on the WebAssembly port
27. Christian Lohmaier (TDF) simplified some makefiles
28. Samuel Mehrbrodt (allotropia) fixed an issue with copying Calc ranges and created an extension to test the crashreporter setup
29. Michael Weghorn made many internal improvements to the Linux and Windows accessibility code
30. Vasily Melenchuk (CIB) fixed header/footer missing with DOCX export and margin not respected for lists with DOCX import
31. Eike Rathke (Red Hat) fixed pasting merged HTML table content into Calc and fixed an old annoyance, where copying and pasting a single cell from Calc to another application would append a newline
32. Kevin Suo improved the handling of font names and weights in PDF import and made Chinese and Japanese text use separate numbering styles
33. Andreas Heinisch fixed some Calc issues and made Calc’s .uno:EnterString handle embedded newlines
34. Rizal Muttaqin made many updates to all the icon themes
35. Tünde Tóth (NISZ) fixed PPTX import issues concerning image-filled shapes and font colour. He also fixed DOCX export of hatch fill
36. Tor Lillqvist (Collabora) made PDFs inserted as images sharper on macOS
37. Heiko Tietze (TDF) added an environment to skip showing save document dialog to help bug triagers. He also made many UI improvements
38. Attila Bakos (NISZ) continued polishing text in grouped shapes
39. Tibor Nagy (NISZ) fixed an issue with shape fill attributes in PPTX export
40. Armin Le Grand (allotropia) started working on Advanced Diagram support
41. Regina Henschel fixed unwanted frame borders in RTF export and improved lighting in extruded custom shapes
42. Jim Raykowski improved handling comments in the Navigator and made many internal improvements to Navigator code
43. Michael Stahl (allotropia) added a flat ODF cleanup script to help developers and fixed several Writer regressions
44. Julien Nabet continued improving database code, fixed a crash and made cleanups
45. Xisco Faulí (TDF) made over fifty improvements and additions to automated tests
46. Mike Kaganski (Collabora) improved the performance of Calc’s SUBSTITUTE function, added Dragonbox library for converting doubles to strings in an optimal way, optimised the internal string replacing code and made many cleanups
47. Miklos Vajna (Collabora) added further capabilities for exporting PDFs from the command line, added a way to preserve tab-based indentation in HTML export, continued working on colour themes in OOXML documents and made many cleanups. He also improved Word-style borders around pages, tables and paragaphs
48. Jean-Pierre Ledure worked on the ScriptForge library
49. László Németh continued improving change tracking of tables

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

599 bugs, 73 of which are enhancements, have been reported by 382 people.

Top 10 Reporters

1. Telesto ( 44 )
2. Mike Kaganski ( 15 )
3. NISZ LibreOffice Team ( 11 )
4. Anduril ( 11 )
5. Rafael Lima ( 10 )
6. Gabor Kelemen (allotropia) ( 9 )
7. Robert Großkopf ( 7 )
8. DErik ( 7 )
9. Rizal Muttaqin ( 6 )
10. Gerald Pfeifer ( 6 )

Triaged Bugs

596 bugs have been triaged by 89 people.

Top 10 Triagers

1. Dieter ( 74 )
2. Buovjaga ( 51 )
3. raal ( 47 )
4. eisa01 ( 42 )
5. Xisco Faulí ( 39 )
6. m.a.riosv ( 34 )
7. Heiko Tietze ( 32 )
8. Timur ( 32 )
9. Julien Nabet ( 26 )
10. Mike Kaganski ( 21 )

Resolution of resolved bugs

618 bugs have been set to RESOLVED.

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

Fixed Bugs

204 bugs have been fixed by 37 people.

Top 10 Fixers

1. Caolán McNamara ( 15 )
2. Justin Luth ( 14 )
3. Luboš Luňák ( 12 )
4. Eike Rathke ( 8 )
5. Rizal Muttaqin ( 8 )
6. Heiko Tietze ( 7 )
7. Julien Nabet ( 7 )
8. László Németh ( 7 )
9. Tünde Tóth ( 6 )
10. Michael Stahl ( 6 )

List of critical bugs fixed

1. tdf#145963 Slow typing with version 7.1 or above on Windows 11 ( Thanks to Luboš Luňák )

List of high severity bugs fixed

1. tdf#137920 Writer hung when inserting image larger than page ( Thanks to Miklos Vajna )
2. tdf#146462 Field Dialog: Not able to insert cross reference any more: the Insert > Cross Reference dialog shows no Table or Figure entries ( Thanks to Michael Stahl )
3. tdf#146597 Writer stops responding when a group of shapes is anchored to character ( Thanks to Attila Bakos (NISZ) )
4. tdf#146795 Calc crashes when pasting data into filtered cells (mdds) ( Thanks to Kohei Yoshida )
5. tdf#147298 Auto Calculate does not work on newly inserted columns in ods or xls formats ( Thanks to Kohei Yoshida )
6. tdf#147398 In Calc ver 7.3.0.3. =Sum covering a range of cells fails to adjust when additional values are added within the range ( Thanks to Eike Rathke )
7. tdf#147448 Freezes because of External link ( Thanks to Eike Rathke )

List of crashes fixed

1. tdf#135332 Crash: Scroll sidebar on Data Provider, which was opened by TAB UI ( Thanks to Luboš Luňák )
2. tdf#146622 Crash swlo!SwNodeIndex::SwNodeIndex+0x83: ( Thanks to László Németh )
3. tdf#146795 Calc crashes when pasting data into filtered cells (mdds) ( Thanks to Kohei Yoshida )
4. tdf#147006 CRASH: deleting content ( Thanks to Michael Stahl )
5. tdf#147008 CRASH: Inserting page break or newline ( Thanks to Michael Stahl )
6. tdf#147144 Writer crash after adding rectangle, add link and delete it ( Thanks to Julien Nabet )
7. tdf#147364 CRASH calling a DLL function returning a string in LibreOffice x64 on Windows ( Thanks to Mike Kaganski )
8. tdf#147394 Chart – Delete Legend: crash ( Thanks to Noel Grandin )
9. tdf#147451 Crash when click hyperlink to file ( Thanks to Luboš Luňák )

List of performance issues fixed

1. tdf#119083 Recalculation is slow with 90000 VLOOKUP ( Thanks to Luboš Luňák )
2. tdf#133749 Slow saving with “support for large sheets enabled” compared to normal ( Thanks to Luboš Luňák )
3. tdf#137571 Adding and modifying animations painfully slow ( Thanks to Caolán McNamara )
4. tdf#140893 XLSX: save is slow for sheet that has value in row 1048576 ( Thanks to Luboš Luňák )
5. tdf#144380 Experimental Features – Forever loop for Deleting all columns ( Thanks to Luboš Luňák )
6. tdf#145963 Slow typing with version 7.1 or above on Windows 11 ( Thanks to Luboš Luňák )
7. tdf#147109 Calc SUBSTITUTE function slows down disproportionately as text length increases. ( Thanks to Mike Kaganski )
8. tdf#147421 LibreOffice hangs if there are massively null-byte characters in csv file ( Thanks to Mike Kaganski )
9. tdf#81765 FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump ( Thanks to Luboš Luňák )

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

1. tdf#101179 Writer/Web: View > HTML Source mode toggles are awkward ( Thanks to Heiko Tietze )
2. tdf#103800 FILEOPEN PPTX: Dark red font opens as white in specific text box ( Thanks to Tünde Tóth )
3. tdf#104902 unable to display chr(10) or chr(13) in a cell in calc when inserted by a macro ( Thanks to Andreas Heinisch )
4. tdf#111733 Sidebar character spacing popup has wrong selection ( Thanks to Justin Luth )
5. tdf#112209 Opening PPTX with images behind masks shows these images incorrectly ( Thanks to Tünde Tóth )
6. tdf#113191 Add 21 and 42 in size list for CJK due to the typographic scale convention ( Thanks to Julien Nabet )
7. tdf#113785 On filtered list an autofill upwards erases data (steps in Comment 3) ( Thanks to Justin Luth )
8. tdf#34759 media player pauses when press progressbar (rewind music) ( Thanks to Caolán McNamara )
9. tdf#74577 Pasting a HTML table into Libreoffice Calc can jumble the table up. ( Thanks to Eike Rathke )
10. tdf#77803 Implement separate numbering styles for Chinese and Japanese (they’re similar, but not the same) ( Thanks to Kevin Suo )
11. tdf#79186 Re-saving DOC with table running over page end breaks layout (table header on 1st page; vertically aligned text influences cells on 2nd page; remainder on 3rd page) ( Thanks to Justin Luth )
12. tdf#81765 FILEOPEN: slow loading in minutes of .ods and .xlsx with >1000 of conditional formats, also dump ( Thanks to Luboš Luňák )
13. tdf#81894 No suggestion in the spelling contextual menu for auto-wrapped portion of the text ( Thanks to Justin Luth )
14. tdf#92960 Calc doesn’t merge cells correctly when pasting merged content from HTML ( Thanks to Eike Rathke )
15. tdf#95882 UI: Ruler tabstops don’t account for spacing to contents in table/frame ( Thanks to Justin Luth )

WORKSFORME bugs

82 bugs have been retested by 35 people.

Top 10 testers

1. Buovjaga ( 14 )
2. Dieter ( 7 )
3. eisa01 ( 6 )
4. Julien Nabet ( 6 )
5. Jean-Baptiste Faure ( 5 )
6. Justin L ( 4 )
7. Telesto ( 3 )
8. Roman Kuznetsov ( 3 )
9. raal ( 3 )
10. Robert Großkopf ( 2 )

DUPLICATED bugs

146 bugs have been duplicated by 34 people.

Top 10 testers

1. Timur ( 20 )
2. Buovjaga ( 14 )
3. Xisco Faulí ( 13 )
4. Gabor Kelemen (allotropia) ( 10 )
5. Heiko Tietze ( 9 )
6. Dieter ( 9 )
7. Justin L ( 8 )
8. eisa01 ( 7 )
9. m.a.riosv ( 6 )
10. Lubos Lunak ( 5 )

Verified bug fixes

41 bugs have been verified by 15 people.

Top 10 Verifiers

1. NISZ LibreOffice Team ( 10 )
2. BogdanB ( 6 )
3. Xisco Faulí ( 5 )
4. Timur ( 3 )
5. Heiko Tietze ( 3 )
6. Buovjaga ( 2 )
7. Gerald Pfeifer ( 2 )
8. Roman Kuznetsov ( 2 )
9. Kevin Suo ( 2 )
10. Thomas Lendo ( 1 )

Categorized Bugs

222 bugs have been categorized with a metabug by 35 people.

Top 10 Categorizers

1. Dieter ( 28 )
2. Eyal Rozenberg ( 24 )
3. Gabor Kelemen (allotropia) ( 17 )
4. Aron Budea ( 15 )
5. Roman Kuznetsov ( 14 )
6. Telesto ( 12 )
7. Heiko Tietze ( 11 )
8. Buovjaga ( 11 )
9. Rizal Muttaqin ( 11 )
10. Alain Romedenne ( 8 )

Regression Bugs

60 bugs have been set as regressions by 24 people.

Top 10

1. raal ( 10 )
2. Xisco Faulí ( 7 )
3. Telesto ( 7 )
4. Buovjaga ( 6 )
5. Timur ( 5 )
6. Robert Großkopf ( 3 )
7. Gerald Pfeifer ( 2 )
8. László Németh ( 2 )
9. Mike Kaganski ( 2 )
10. Eike Rathke ( 2 )

Bisected Bugs

44 bugs have been bisected by 10 people.

Top 10 Bisecters

1. raal ( 12 )
2. Aron Budea ( 7 )
3. Xisco Faulí ( 6 )
4. Timur ( 5 )
5. Gabor Kelemen (allotropia) ( 5 )
6. Buovjaga ( 4 )
7. Mike Kaganski ( 2 )
8. Terrence Enger ( 1 )
9. Roman Kuznetsov ( 1 )
10. Sarper Akdemir ( 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!