22 Nov 2023

QA/Dev Report: October 2023

General Activities

  1. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions and updated and restructured dozens of help pages
  2. Rafael Lima added support for hidden named ranges in Calc, fixed named ranges associated to sheets being lost upon XLSX export and made it so renaming a sheet updates ranges in solver models
  3. Bogdan Buzea made some UI string improvements
  4. Seth Chaiklin updated help after UI label change related to outline levels
  5. Stanislav Horacek improved the help for Firebird wizard
  6. Ilmari Lauhakangas (TDF) added a method to automated test for dealing with DPI variance, improved Search Commands result presentation, updated help after UI string changes and improved the accessibility of help navigation
  7. Alain Romedenne updated ScriptForge help
  8. Bartosz Kosiorek added handling for invalid records in Windows Metafile graphics
  9. Gábor Kelemen (allotropia) did code cleanups in the area of includes, created a script to find unused config groups/keys and improved some UI strings
  10. Laurent Balland did code cleanups
  11. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Szymon Kłos (Collabora) worked on LOKit and jsdialog used by Collabora Online. He also worked on the simple conditional formatting dialog created by Paris Oplopoios
  14. Henry Castro (Collabora) worked on LOKit used by Collabora Online. He also improved the Python UI test system, fixed an issue with unused master slides not being imported from PPTX files and made handling of bidirectional text in Calc cells more robust
  15. Pranam Lashkari (Collabora) worked on LOKit and jsdialog used by Collabora Online
  16. Ashod Nakashian, Marco Cecchetti and Andras Timar (Collabora) worked on LOKit used by Collabora Online
  17. Pedro Silva worked on jsdialog used by Collabora Online
  18. Jaume Pujantell (Collabora) worked on Microsoft Office compatibility improvements in the area of content controls
  19. Attila Szűcs (Collabora) worked on LOKit used by Collabora Online. He also improved change tracking in Writer
  20. Skyler Grey (Collabora) worked on jsdialog used by Collabora Online and improved DOCX compatibility by adding full support for STYLEREF fields
  21. Eike Rathke (Red Hat) made date functions in Calc more robust and improved error propagation in Calc formulas
  22. Tomaž Vajngerl (Collabora) wrote some unit tests for Writer and did code cleanups
  23. Julien Nabet made it possible to use ProjectionMode and ShadeMode for extruded custom shapes via BASIC macros and did code cleanups
  24. Andreas Heinisch made the Slide/Page pane in Impress/Draw have the expected title when in Master view and made it possible to create new master slides in the Slide pane by pressing Enter
  25. László Németh improved change tracking of case cycling and made exported DOCX files compatible with Microsoft Office’s default paragraph justification algorithm
  26. Xisco Faulí (TDF) did a couple of dozen additions and changes to automated tests, fixed a Calc crash and added UNO commands for variable date/time fields
  27. Michael Stahl (allotropia) made many improvements and fixes to the export of accessible PDFs
  28. Mike Kaganski (Collabora) made exported HTML tables cleaner, fixed pasting sometimes losing wrapping information in Writer on Windows, added an option to avoid converting some fields into text during mail merge, added a PreserveSpaces option to HTML/ReqIF export that changes the handling of paragraphs with leading/trailing spaces or multiple sequential spaces, added a ExportFormulasAsPDF option to ReqIF export, fixed “Fit to page” printing option, fixed an issue with formula positions in printing and PDF export and made PDF importing more robust with “trailers”
  29. Caolán McNamara (Collabora) fixed many crashes, did code cleanups and optimisations and fixed issues found by code analysers
  30. Stephan Bergmann (Red Hat) started making heavy use of C++20 features in the area of text strings and made several fixes to automated tests
  31. Noel Grandin (Collabora) improved the performance of Calc UI and documents with lots of images and made automated UI tests more robust. He also did many code cleanups and optimisations, for example simplifying error reporting while making it easier for developers to debug problems
  32. Justin Luth (Collabora) made many improvements to Notebookbar UIs
  33. Heiko Tietze (TDF) improved the notification feedback for not found search keys and made the Security tab of the PDF export dialog behave more intuitively
  34. Michael Weghorn (TDF) fixed accessibility issues in areas such as status bar, spelling errors and text attributes. He also bumped Java build baseline from JDK 9 to 17 and did some cleanups and improvements related to Qt/Kf5 UI
  35. Balázs Varga (allotropia) added a UI to control personal information to be removed upon saving documents and a config option for building with or without unnecessary template files and started working on proper indications for locked down items in Options
  36. Patrick Luby (NeoOffice) fixed crashes and many issues related to UI and graphics rendering on macOS
  37. Jim Raykowski improved the accessibility checker, added UNO commands for style spotlight and made many improvements to Navigator
  38. Taichi Haradaguchi made it so bz2 module is included in the Python shipped with LibreOffice, updated several dependencies and did cleanups in makefiles
  39. Sarper Akdemir (allotropia) started working on a password strength meter
  40. Kohei Yoshida upgraded liborcus and added support for conditional loading of Apache Parquet files into Calc
  41. Christian Lohmaier (TDF) did build-related improvements and fixes
  42. Chris Sherlock refactored text and graphics rendering code
  43. Regina Henschel improved Microsoft Office compatibility regarding shape objects and made it so Connector dialog allows negative values for Line Skew
  44. Sahil Gautam added an automated test and did code cleanups
  45. Li Yang added an automated test
  46. Mihai Vasiliu fixed an issue causing Master Slides sidebar to open with zero width
  47. Omkar Acharekar added several automated tests
  48. Martin Gube made it so comments in Writer are kept when spell correction replaces a word
  49. Matthew Kogan made comparison of changed paragraph numbering optional
  50. Irgaliev Amin made it so the option to show slide pane in Impress is retained across sessions
  51. Mert Tumer (Collabora) made an optimisation to LanguageTool locale loading
  52. Paris Oplopoios (Collabora) added an easy to use conditional formatting menu to Calc

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

456 bugs, 66 of which are enhancements, have been reported by 279 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 37 )
  2. Eyal Rozenberg ( 20 )
  3. Xisco Faulí ( 20 )
  4. Regina Henschel ( 10 )
  5. Mike Kaganski ( 10 )
  6. Gerald Pfeifer ( 8 )
  7. Stéphane Guillou (stragu) ( 7 )
  8. Tracey ( 7 )
  9. Robert Großkopf ( 6 )
  10. peter josvai ( 5 )

Triaged Bugs

639 bugs have been triaged by 71 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 184 )
  2. Buovjaga ( 90 )
  3. m.a.riosv ( 54 )
  4. Heiko Tietze ( 43 )
  5. Xisco Faulí ( 34 )
  6. Dieter ( 29 )
  7. raal ( 20 )
  8. Mike Kaganski ( 19 )
  9. Kira Tubo ( 14 )
  10. Julien Nabet ( 12 )

Resolution of resolved bugs

604 bugs have been set to RESOLVED.

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

Fixed Bugs

166 bugs have been fixed by 30 people.

Top 10 Fixers

  1. Balazs Varga ( 18 )
  2. Patrick Luby ( 10 )
  3. Justin Luth ( 10 )
  4. Mike Kaganski ( 9 )
  5. Miklos Vajna ( 9 )
  6. Noel Grandin ( 9 )
  7. Michael Weghorn ( 8 )
  8. Caolán McNamara ( 8 )
  9. Jim Raykowski ( 7 )
  10. Michael Stahl ( 6 )

List of high severity bugs fixed

  1. tdf#152571 Very slow save (macOS, ARM) ( Thanks to Noel Grandin )
  2. tdf#156685 Default font color in tables is white over white background (font color should be black) ( Thanks to Heiko Tietze )
  3. tdf#157132 LibreOffice 7.6.0 copying of formulas in writer table – relative distance of cells in formula not preserved after copying to other lines ( Thanks to Xisco Fauli )
  4. tdf#157515 Crash on clicking Reset when modifying Background presentation style (gtk3) ( Thanks to Caolán McNamara )
  5. tdf#157613 Crash – Database Form – editing size of grid control causes hang requiring forced kill – SKIA raster rendering on (by default) ( Thanks to Patrick Luby )
  6. tdf#157680 Impress export corrupted pdf on MacOS ( Thanks to Patrick Luby )

List of crashes fixed

  1. tdf#101376 Wordcount Beanshell macro execution causes crash ( Thanks to Patrick Luby )
  2. tdf#154142 Crash in: SfxUndoManager::SetMaxUndoActionCount(unsigned __int64) ( Thanks to Caolán McNamara )
  3. tdf#157182 Crashes when exporting a certain presentation as PDF in Archival format PDF/A-1b ( Thanks to Michael Stahl )
  4. tdf#157515 Crash on clicking Reset when modifying Background presentation style (gtk3) ( Thanks to Caolán McNamara )
  5. tdf#157613 Crash – Database Form – editing size of grid control causes hang requiring forced kill – SKIA raster rendering on (by default) ( Thanks to Patrick Luby )
  6. tdf#157849 EDITING: crash on “Set Character Spacing” with custom value when hitting Enter (GTK3) ( Thanks to Caolán McNamara )

List of performance issues fixed

  1. tdf#157590 HANG: opening file with floating table ( Thanks to Miklos Vajna )

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

  1. tdf#100584 With an RTL sheet, make added sheets RTL as well ( Thanks to Andreas Heinisch )
  2. tdf#101376 Wordcount Beanshell macro execution causes crash ( Thanks to Patrick Luby )
  3. tdf#101970 [PACKAGING] Make default templates installation optional ( Thanks to Balazs Varga )
  4. tdf#106057 General input/output error loading pdf file (because of multiple trailers which is valid per PDF specification) ( Thanks to Mike Kaganski )
  5. tdf#111737 Not possible to create / add a new Master Slide with pressing Enter in slides/pages pane ( Thanks to Andreas Heinisch )
  6. tdf#116412 Bundled python fails to import bz2 on Windows ( Thanks to Taichi Haradaguchi )
  7. tdf#126449 Tables in DOC document are overlapping (one floating multipage table-in-table-in-table) ( Thanks to Miklos Vajna )
  8. tdf#127038 Tabbed toolbar: Unnecessary uno::InsertField redundancy in the “References” option group ( Thanks to Justin Luth )
  9. tdf#42787 Functionality request for Writer: Add deleting of Sections using the Delete function inside of the Navigator ( Thanks to Jim Raykowski )
  10. tdf#87638 Slide Pane should be titled ‘Master Slides’ when in master view ( Thanks to Andreas Heinisch )
  11. tdf#99822 FILEOPEN: Floating table objects in tables horizontal position relative to margin is wrong in Writer ( Thanks to Miklos Vajna )

WORKSFORME bugs

81 bugs have been retested by 34 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 15 )
  2. Buovjaga ( 13 )
  3. Timur ( 6 )
  4. Kira Tubo ( 6 )
  5. Dieter ( 5 )
  6. Alex Thurgood ( 4 )
  7. Heiko Tietze ( 4 )
  8. BogdanB ( 3 )
  9. Xisco Faulí ( 2 )
  10. libreofficebugs ( 2 )

DUPLICATED bugs

172 bugs have been duplicated by 27 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 83 )
  2. Buovjaga ( 24 )
  3. Heiko Tietze ( 11 )
  4. Mike Kaganski ( 9 )
  5. m.a.riosv ( 8 )
  6. V Stuart Foote ( 5 )
  7. Dieter ( 3 )
  8. raal ( 3 )
  9. Kira Tubo ( 3 )
  10. Justin L ( 2 )

Verified bug fixes

41 bugs have been verified by 13 people.

Top 10 Verifiers

  1. BogdanB ( 9 )
  2. Stéphane Guillou (stragu) ( 6 )
  3. Gerald Pfeifer ( 6 )
  4. Alex Thurgood ( 5 )
  5. Buovjaga ( 5 )
  6. Xisco Faulí ( 3 )
  7. Julien Nabet ( 1 )
  8. Roman Kuznetsov ( 1 )
  9. steve ( 1 )
  10. sdc.blanco ( 1 )

Categorized Bugs

558 bugs have been categorized with a metabug by 29 people.

Top 10 Categorizers

  1. BogdanB ( 241 )
  2. Stéphane Guillou (stragu) ( 180 )
  3. Eyal Rozenberg ( 27 )
  4. Dieter ( 14 )
  5. Heiko Tietze ( 13 )
  6. Buovjaga ( 12 )
  7. Roman Kuznetsov ( 11 )
  8. Gabor Kelemen (allotropia) ( 8 )
  9. Aron Budea ( 8 )
  10. Michael Weghorn ( 8 )

Regression Bugs

95 bugs have been set as regressions by 16 people.

Top 10

  1. Stéphane Guillou (stragu) ( 23 )
  2. Xisco Faulí ( 23 )
  3. Kira Tubo ( 11 )
  4. BogdanB ( 8 )
  5. raal ( 7 )
  6. Buovjaga ( 6 )
  7. Mike Kaganski ( 3 )
  8. Alex Thurgood ( 3 )
  9. m.a.riosv ( 2 )
  10. Gabor Kelemen (allotropia) ( 2 )

Bisected Bugs

85 bugs have been bisected by 11 people.

Top 10 Bisecters

  1. Xisco
30 Oct 2023

QA weekly focus: SVG

This week, we are kicking off a continuing “QA Weekly Focus” to attract attention to certain topics and areas.

For this first week, let’s look into issues related to our SVG support.

SVG stands for “Scalable Vector Graphics“, a widespread, open vector format and standard. It has become the most used vector format on the web, and it is for example used as the default format in Inkscape, the open source vector graphics editor.

LibreOffice supports importing and exporting SVGs in various places, and these issues are tracked in 3 meta bugs:

  • 88278: SVG import image filter (all modules)
  • 111450: SVG fileSave filter (Draw/Impress)
  • 156066: SVG filters

In recent months, the SVG topic got a fair amount of attention, in particular thanks to Xisco Fauli’s work on the import filter (see illustration).

Our friends at Inkscape have also recently voiced their interest in improving interoperability with LibreOffice (see Inkscape’s post on Mastodon).

So let’s keep the momentum going, test how well SVG files are handled by LibreOffice, and review existing reports! They might need to be clarified, consolidated, or even closed because of all the recent improvements.

The list of bugs to review is in this collaborative pad. You can join IRC to chat with the QA team, and ask questions.

Thanks everyone for your contributions!…

6 Oct 2023

QA/Dev Report: September 2023

General Activities

  1. LibreOffice 7.5.6 and LibreOffice 7.5.7 were announced on September 14 and September 26 respectively
  2. LibreOffice 7.6.1 and LibreOffice 7.6.2 were announced on September 7 and September 26 respectively
  3. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, added a help page for editing styles, improved the help page for accessibility checker, added or updated help for commands found in Writer’s Table, Styles and Form menu as well as Tools menu for all applications
  4. Stéphane Guillou (TDF) added help for Impress’s Use Background fill and made some help cleanups
  5. Rafael Lima added search functionality to the Calc Functions sidebar
  6. Bogdan Buzea improved help for vertical positioning
  7. Seth Chaiklin changed some UI strings to be more clear and updated help pages accordingly
  8. Bartosz Kosiorek added Poisson distribution to help on Calc’s Random Number Generator
  9. Gábor Kelemen (allotropia) dropped HTML Export wizard help pages, improved the layout of Area dialog and did code cleanups in the area of includes
  10. Laurent Balland improved the Impress template Growing Liberty
  11. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Szymon Kłos (Collabora) worked on LOKit and jsdialog used by Collabora Online. He also optimised the performance of data filtering in combination with conditional formats in Calc and fixed an issue with text-decoration property in exported SVGs
  14. Henry Castro and Skyler Grey (Collabora) worked on LOKit used by Collabora Online. Henry also improved Calc’s RTF filter and did fixes and improvements to database connectivity
  15. Áron Budea (Collabora) did some code cleanups
  16. Eike Rathke (Red Hat) improved the accuracy of Calc’s SUM() with mixed formula and value cells
  17. Tomaž Vajngerl (Collabora) continued polishing support for document themes. He also fixed an issue with importing row styles in XLSX spreadsheets and did some optimisations and code cleanups
  18. Julien Nabet fixed an off-by-one error in saving colour themes, made it possible to replace events set for objects, fixed an issue with changing database links while keeping original registered names and fixed a couple of database regressions. He also fixed many crashes
  19. Andreas Heinisch polished the pinned items feature and fixed an off-by-one error in navigating fields with GoToNextPlacemarker command
  20. László Németh improved Writer change tracking related to tables
  21. Xisco Faulí (TDF) dropped the HTML export wizard, improved and added automated test, did some SVG handling improvements and fixed an accessibility crash
  22. Michael Stahl (allotropia) fixed a hang with exporting accessible/tagged PDFs and optimised the size of exported tagged PDFs
  23. Mike Kaganski (Collabora) fixed issues with incorrectly imported DOCX plain text content control properties and LibreOffice Portable not starting from long paths. He also made it so the read-only attributes of directories on Windows are ignored as is the normal behaviour on the platform
  24. Caolán McNamara (Collabora) made it so SVG export of slides shows a progress indicator, improved the security of untrusted documents in relation to OLE objects and improved the speed of importing PDFs. He also did code cleanups and fixed issues found by code analysers
  25. Stephan Bergmann (Red Hat) raised the build baseline to C++20 alongside many tweaks and fixes that it required
  26. Noel Grandin (Collabora) improved the performance of selecting and dragging complex group objects and improved the stability of LibreOffice’s test suites by disabling unreliable tests. He also did many code cleanups and optimisations
  27. Justin Luth (Collabora) fixed an issue with unreliable display of shape properties and made it so unchangeable options are disabled in PDF export dialog
  28. Heiko Tietze (TDF) improved the Writer Compatibility options dialog and made activating overwrite mode for the first time display a notification
  29. Michael Weghorn (TDF) fixed accessibility issues in areas such as dialogs using multi-line edit controls, font colour toolbar item, search in options, print dialog, selection handling in macros and Calc’s SUMIF function. He also made the kf5 and qt6 UIs automatically use dark icon themes and dark document background colours when the system is in dark mode and made preparations for switching from JDK 9 to 17
  30. Balázs Varga (allotropia) improved the accessibility checker
  31. Samuel Mehrbrodt (allotropia) implemented importing slide background fill from PPT files and improved the accessibility checker
  32. Khaled Hosny (TDF) implemented support for right-to-left layout in Formula Editor while also polishing the Math visual editing feature and enabling it by default, made it possible to change Math font, added support for Arabic math expressions, made Tools -> Special Character work in Math and made it so symbols in Math Symbols Catalogue are rendered using document settings. He also updated Noto font versions and fixed saving of localized Italic Greek symbols and missing background colour in style preview
  33. Patrick Luby (NeoOffice) fixed some transparency to alpha rework fallout, fixed issues related to Skia graphics engine and PDF export of documents with embedded PDFs on macOS
  34. Jim Raykowski polished the Style Spotlight feature, improved the master document navigator context menu and expanded Navigator’s feature for bringing items to attention in the document when hovering over them
  35. Bayram Çiçek polished the search feature in Options dialog
  36. Hossein Nourikhah (TDF) made Calc’s Ctrl+End view jump behave better and ported some Developer’s Guide examples to Python and BASIC
  37. Arnaud Versini did some code cleanups
  38. Taichi Haradaguchi updated several dependencies
  39. Björn Michaelsen did some code cleanups
  40. Sarper Akdemir (allotropia) worked on adding XMP, Adobe PDF Schema and Dublin Core metadata support to PDF export, fixed PPTX issues with table shadows and image transparency and added JavaScript UNO bindings for WASM with Embind
  41. Kohei Yoshida upgraded liborcus to 0.19.0
  42. Armin Le Grand (allotropia) continued with the rework of handling attributes and properties
  43. Dan Horák (Fedora) fixed build and test issues related to powerpc64 and s390x architectures
  44. Gökay Şatır (Collabora) made it so authors can reply to their own comments in Writer
  45. Dennis Francis (Collabora) implemented sort by selection in Pivot Tables in non-manual mode
  46. Dung Saga made Search Commands also look for submenu names
  47. Darshan Upadhyay (Collabora) added an option to autoformat bulleted lists after space
  48. Christian Lohmaier (TDF) raised the Linux runtime baseline to RHEL 8 or CentOS 8 and comparable and build baseline to GCC 12 or Clang 12 with libstdc++ 8.5

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

483 bugs, 67 of which are enhancements, have been reported by 319 people.

Top 10 Reporters

  1. Eyal Rozenberg ( 22 )
  2. Stéphane Guillou (stragu) ( 12 )
  3. Regina Henschel ( 10 )
  4. Xisco Faulí ( 9 )
  5. Jim Avera ( 8 )
  6. Gabor Kelemen (allotropia) ( 8 )
  7. Mike Kaganski ( 8 )
  8. Samuel Mehrbrodt (allotropia) ( 8 )
  9. Jeff Fortin Tam ( 8 )
  10. peter josvai ( 5 )

Triaged Bugs

590 bugs have been triaged by 74 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 142 )
  2. Buovjaga ( 96 )
  3. m.a.riosv ( 66 )
  4. Heiko Tietze ( 41 )
  5. Xisco Faulí ( 34 )
  6. Julien Nabet ( 24 )
  7. Dieter ( 16 )
  8. Mike Kaganski ( 14 )
  9. Michael Weghorn ( 13 )
  10. Kira Tubo ( 11 )

Resolution of resolved bugs

507 bugs have been set to RESOLVED.

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

Fixed Bugs

161 bugs have been fixed by 35 people.

Top 10 Fixers

  1. Julien Nabet ( 13 )
  2. Khaled Hosny ( 10 )
  3. Michael Weghorn ( 9 )
  4. Miklos Vajna ( 7 )
  5. Caolán McNamara ( 7 )
  6. Xisco Fauli ( 6 )
  7. László Németh ( 6 )
  8. Samuel Mehrbrodt ( 5 )
  9. Patrick Luby ( 5 )
  10. Heiko Tietze ( 4 )

List of high severity bugs fixed

  1. tdf#156894 kf5/qt6: Dark system themes don’t automatically enable corresponding dark icon themes ( Thanks to Michael Weghorn )
  2. tdf#157115 crash on inserting chart (gtk3): Assertion `m_pBody != NULL’ failed ( Thanks to Noel Grandin )
  3. tdf#157174 LibreOffice crashes when clicking “Print Preview” ( Thanks to Julien Nabet )
  4. tdf#157231 webp 0-day CVE-2023-4863 affects LO ( Thanks to Caolán McNamara )
  5. tdf#157260 Test connection is not using the port specified in connection string for PostgreSQL using 5432 instead ( Thanks to Julien Nabet )
  6. tdf#157288 During Table editing, right click on a field doesn’t show “Primary Key” for other fields than those already primary key ( Thanks to Julien Nabet )
  7. tdf#157312 Current cell highlight doesn’t update with skia hardware rendering on macOS ( Thanks to Patrick Luby )

List of crashes fixed

  1. tdf#156126 Crash when using gpl color palette in debug build ( Thanks to Julien Nabet )
  2. tdf#156683 Crash in: comphelper::AccessibleEventNotifier::revokeClientNotifyDisposing(unsigned int, com::sun::star::uno::Reference const&) ( Thanks to Michael Weghorn )
  3. tdf#156958 Crash in: (anonymous namespace)::TabBarEdit::LinkStubImplEndEditHdl(void*, void*) when renaming layer ( Thanks to Julien Nabet )
  4. tdf#157085 CRASH: fixing accessibility check of deleted image ( Thanks to Samuel Mehrbrodt )
  5. tdf#157088 qt6: Crash on exit after using font color toolbox item with Orca running ( Thanks to Michael Weghorn )
  6. tdf#157092 Using search feature in options dialog causes crash when NVDA is running ( Thanks to Michael Weghorn )
  7. tdf#157096 CRASH: removing everything in document ( Thanks to Michael Stahl )
  8. tdf#157115 crash on inserting chart (gtk3): Assertion `m_pBody != NULL’ failed ( Thanks to Noel Grandin )
  9. tdf#157131 CRASH: after pasting all and undoing ( Thanks to Michael Stahl )
  10. tdf#157160 [CRASH] New “Search” field in Options dialog crashes all the time ( Thanks to Michael Weghorn )
  11. tdf#157174 LibreOffice crashes when clicking “Print Preview” ( Thanks to Julien Nabet )
  12. tdf#157266 Crash when trying to use new Filter feature on Tools → Options ( Thanks to Bayram Çiçek )
  13. tdf#157277 CRASH Writer crashing when hiding Sidebar and using Navigator to go to bookmark ( Thanks to Julien Nabet )
  14. tdf#157299 Calc crashes when accessing cells containing a sumif formula with NVDA ( Thanks to Michael Weghorn )
  15. tdf#157304 Macro: Retrieving selected text in FocusIn event for column crashes LO ( Thanks to Michael Weghorn )

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

  1. tdf#105303 Drop html export wizard ( Thanks to Xisco Fauli )
  2. tdf#106663 GoToNextPlacemarker skips placeholder after header ( Thanks to Andreas Heinisch )
  3. tdf#111705 Allowing Arabic mathematical expressions ( Thanks to Khaled Hosny )
  4. tdf#122718 Sidebar Functions panel misses search like Function Wizard ( Thanks to Rafael Lima )
  5. tdf#124591 Update Noto Fonts to latest releases ( Thanks to Khaled Hosny )
  6. tdf#32418 Add an “insert symbol” to Math ( Thanks to Khaled Hosny )
  7. tdf#48083 FILEOPEN PPT: Slide Background Fill is none instead of slide color (PPTX fixed in 5.2) ( Thanks to Samuel Mehrbrodt )
  8. tdf#49895 Add a “search” field in (non-advanced) Options dialog ( Thanks to Bayram Çiçek )
  9. tdf#55160 Fileopen: docx layout not imported correctly – support for nested floating tables ( Thanks to Miklos Vajna )
  10. tdf#62174 Italic Greek symbols (iGreek set) fails if UI Language is changed ( Thanks to Khaled Hosny )
  11. tdf#85263 same shortcuts for Company and Cancel in “Tools/Options/User Data” ( Thanks to Gabor Kelemen )
  12. tdf#88744 Visual formula editor does not use system clipboard ( Thanks to Khaled Hosny )
  13. tdf#97710 SVG import cant fill overlapped polyline ( Thanks to Xisco Fauli )

WORKSFORME bugs

80 bugs have been retested by 25 people.

Top 10 testers

  1. Buovjaga ( 17 )
  2. Stéphane Guillou (stragu) ( 13 )
  3. Kira Tubo ( 13 )
  4. Faisal ( 4 )
  5. m.a.riosv ( 4 )
  6. Julien Nabet ( 4 )
  7. Xisco Faulí ( 3 )
  8. Mihai Vasiliu ( 3 )
  9. Dieter ( 2 )
  10. Telesto ( 2 )

DUPLICATED bugs

132 bugs have been duplicated by 31 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 42 )
  2. Buovjaga ( 16 )
  3. Heiko Tietze ( 9 )
  4. Mike Kaganski ( 9 )
  5. m.a.riosv ( 8 )
  6. Gabor Kelemen (allotropia) ( 4 )
  7. Justin L ( 4 )
  8. Dieter ( 4 )
  9. Xisco Faulí ( 4 )
  10. Kira Tubo ( 3 )

Verified bug fixes

48 bugs have been verified by 12 people.

Top 10 Verifiers

  1. Stéphane Guillou (stragu) ( 22 )
  2. BogdanB ( 11 )
  3. Xisco Faulí ( 4 )
  4. Michael Weghorn ( 2 )
  5. Gerald Pfeifer ( 2 )
  6. Rizal Muttaqin ( 1 )
28 Sep 2023

A community resolving issues collaboratively

Resolving issues and bringing improvements to LibreOffice is usually the result of team work – a team often made up of people who have never met each other!

As a Free / Open Source project, LibreOffice has contributors in the space of translation, documentation, development, design… and Quality Assurance (QA) from around the globe. Some might have contributed for decades, others just reported a bug for the first time yesterday.

Let’s have a look at three stories in which issues were identified, triaged and resolved in different ways, but always through a combined effort.

Many hands make light work

Take for example bug 153790 on Bugzilla. At least six contributors were involved in its resolution:

  • Ruud reported an issue in sheet referencing in Calc formulas;
  • Stéphane confirmed the issue, provided more precise steps and let others know that the issue is a regression;
  • ady pinpointed more precisely in which version the issue started;
  • raal bibisected the issue to a precise commit by Eike – the issue started in version 7.4;
  • Eike provided a fix for version 7.5;
  • Finally, Xisco created a unit test so the issue does not reappear in the future.

Looking into an issue reveals another

Here’s another story split between three reports.

It all starts with an enhancement in how Tables of Figures can be populated, which was originally an issue in OOXML compatibility. Since LibreOffice 7.6, it is possible to make a Table of Figures track an extra paragraph style for a more customised result (and for improved DOCX support).

Susanne tested it, noticed duplicated entries in the Table of Figures, and reported a separate issue in bug 157200.

At the time of writing, the issue Susanne reported is still being discussed. However, while testing (and learning about the feature), Stéphane noticed a problem in how the dialog resets the Table of Figures to using the “Figures” category instead of “Illustrations”. Turns out this GTK-specific issue was a regression from when the dialog was heavily refactored back in LibreOffice 6.3, and lived on unreported for more than four years. Once it was described in bug 157223, Caolán fixed the regression… less than two hours after opening the report!

Enhancements… and their consequences

One final example in bug 156282.

Bathsheba reported an Outline Folding issue that makes its use more cumbersome in Writer: not being able to fold/unfold all headings at once in the Navigator. She also pointed out an associated frustration in not seeing the hidden headings in the Navigator. Jim, who designed the feature, offered a solution for both issues, including greying out the hidden headings in the Navigator instead of hiding them. Two birds with one stone!

Unfortunately, the patch introduced a nasty regression: a crash when using the Navigator, only happening with the GTK interface. Thankfully, Timur caught the issue only two days after it appeared, and it was therefore quickly fixed by Jim two more days after – before it could affect general users of LibreOffice releases.

Thank you all!

These are three examples among thousands of others that illustrate how improving LibreOffice is a combined effort.

All these success stories wouldn’t have unfolded, and resulted in fixes and new features, if it wasn’t for the users initiating them with a report. So thank you all for reporting issues, but also for triaging the reports, re-testing older ones, and contributing fixes! By combining our various skills and diverse perspectives, we can continue making LibreOffice better for everyone, building on its 38 years of history.

Join us to learn new skills and meet other QA contributors!…

7 Sep 2023

QA/Dev Report: August 2023

General Activities

  1. LibreOffice 7.6.0 was released on August 21
  2. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, updated help for command line PDF export and anchoring of images in Writer, improved help for Title Page and added extended tips to its dialog and added help pages for tooltips when dragging scrollbars and document themes
  3. Juan C. Sanz added Firebird’s DATEADD and DATEDIFF functions to the SQL parser
  4. Stéphane Guillou (TDF) updated help for PDF export regarding comments in margin
  5. Rafael Lima fixed issues with F1 help shortcut not working in some contexts, made the table toolbar hidden when Notebookbar is active and updated help for ScriptForge
  6. Seth Chaiklin updated help for AutoRecovery
  7. Laurent Balland extended ODF support to include reserved blank spaces in Calc custom number formats
  8. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer. He also made improvements to automated tests
  9. Jean-Pierre Ledure worked on the ScriptForge library
  10. Szymon Kłos (Collabora) worked on jsdialog used by Collabora Online
  11. Marco Cecchetti and Attila Szűcs (Collabora) worked on LOKit used by Collabora Online. Attila also added an Excel compatibility option to limit the creation of hyperlinks to only one per cell
  12. Áron Budea (Collabora) fixed a crash when parsing an XML with undeclared namespace
  13. Eike Rathke (Red Hat) made date/time arithmetic in Calc use rounding in order to work more intuitively with date and time functions
  14. Tomaž Vajngerl (Collabora) continued polishing support for document themes
  15. Julien Nabet fixed GTK3 Disabled menu items not being hidden in DontHideDisabledEntry = false mode and did some cleanups in code and in Help
  16. Andreas Heinisch made it so slides in Impress copied by Ctrl + drag and drop get unique names
  17. László Németh improved Writer change tracking related to tables
  18. Xisco Faulí (TDF) did many SVG handling and rendering improvements, fixed many crashes and made some changes and additions to automated tests
  19. Michael Stahl (allotropia) made floating tables in Writer more robust
  20. Mike Kaganski (Collabora) made it so truncated bookmark names are created to be unique thus preventing any problems with hyperlinking, fixed HTML export of nested tables at the beginning of a document, fixed an issue with missing cell padding in imported ReqIF tables, fixed PPTX import issues related to images and charts and fixed unwanted JRE errors popping up in macro contexts
  21. Caolán McNamara (Collabora) improved the performance of spreadsheets with lots of comments, implemented Small Caps in Impress and Draw and made the CJK typography-related “Enable char unit” option take effect only when the locale is a CJK one. He also fixed crashes and issues found by code analysers
  22. Stephan Bergmann (Red Hat) did many code, test and build-related cleanups
  23. Noel Grandin (Collabora) added a new Clang plugin to look for methods in the code where there is no need to guard access to the field, because the field is never modified and another plugin to warn against using the ‘operator bool’ conversion of std::optional, fixed a tricky Report Builder crash and started making it clearer in the code what kind of coordinate system is being handled and therefore to help the compilers find inconsistencies. He also did many code cleanups and optimisations
  24. Justin Luth (Collabora) fixed an issue causing line numbering to be lost in DOCX export and made many improvements and bug fixes related to AutoRecovery
  25. Heiko Tietze (TDF) made it possible to copy formulas by copying cells even when Show Formula is active
  26. Tibor Nagy (NISZ) fixed an issue with repainting sparklines in Calc after updating data
  27. Paris Oplopoios finished the GSoC project for implementing APNG (Animated PNG) support. He also fixed a text wrapping issue affecting XLSX export
  28. Baole Fang finished the GSoC project for selecting tests to run on Gerrit patches based on machine learning
  29. Dipam Turkar finished the GSoC project for converting Writer’s Java UNO API tests to C++
  30. Ahmed Gamal Eltokhy finished the GSoC project for improving PGP/GPG encryption support
  31. Bayram Çiçek finished the GSoC project for adding a search field into Options
  32. Michael Weghorn (TDF) fixed accessibility issues in areas such as popups and grid controls
  33. Balázs Varga (allotropia) worked on the accessibility Sidebar panel and added support for XLSX files encrypted with SHA-384
  34. Samuel Mehrbrodt (allotropia) disabled automatic slide advancement in Impress when moving backwards and fixed textbox indentation issues affecting PPTX export
  35. Czeber László Ádám (NISZ) fixed an issue causing lost hyperlinks when merging its cell with an empty cell and made mouse focusing into centered or right-aligned Calc cells more robust
  36. Khaled Hosny (TDF) improved the speed of populating the font list on systems that use FontConfig, fixed math rendering in elements dock with RTL UI, made it so English symbol names are always accepted in math, worked around an Adobe Acrobat bug with Type 3 fonts and unusual UPEM, added the ability to change math font in Math and fixed reading math font settings from file
  37. Patrick Luby (NeoOffice) fixed PDF export of bitmap color fonts, fixed a gradient drawing issue in slideshows and fixed many issues resulting from last month’s graphics code overhaul changing transparency to alpha
  38. Jim Raykowski made Shift+Tab behave as expected in Sidebar, made keyboard navigation skip over disabled Sidebar tabs and improved the Insert Special Character toolbar button so it displays character info in tooltips and a label
  39. Hossein Nourikhah (TDF) fixed a problem with using ccache when building on Windows and fixed RTL numbers changing to LTR upon DOCX export
  40. Arnaud Versini did some code cleanups
  41. Taichi Haradaguchi updated some dependencies
  42. Colomban Wendling (Hypra) polished the gtk3 accessibility test implementation
  43. Regina Henschel improved the “mouse as pen” feature in Impress, so the result is easier to manipulate later, made it possible to save and load themes in Draw and not only Impress
  44. Matt K made it so the –cat and –script-cat command line options inform the user they should close other running LibreOffice processes, if they are present
  45. Björn Michaelsen refactored Writer code a bit
  46. Sarper Akdemir (allotropia) improved the Clone Formatting feature, for example making it context aware (paragraph properties are applied when the selection contains a whole paragraph or there’s no selection at all)
  47. Kohei Yoshida added support for rich-text string import via orcus interface
  48. Armin Le Grand (allotropia) made performance improvements in fundamental code features related to handling attributes and properties
  49. Thorsten Behrens (allotropia) fixed an issue resulting from last month’s graphics code overhaul changing transparency to alpha
  50. Jun Nogata fixed CJK and CTL font style in Impress templates and added Japanese template to the Localization category
  51. Andrea Rosetti added a reset function to Crop dialog
  52. Denis Sorotnik made it so navigating through Calc sheet tabs using the keyboard now cycles from the last sheet to the first
  53. Henry Castro (Collabora) fixed a formula selection issue affecting merged Calc cells

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

478 bugs, 59 of which are enhancements, have been reported by 274 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 26 )
  2. Gerald Pfeifer ( 20 )
  3. Rafael Lima ( 18 )
  4. Eyal Rozenberg ( 15 )
  5. Hossein ( 13 )
  6. Telesto ( 11 )
  7. Regina Henschel ( 10 )
  8. Stéphane Guillou (stragu) ( 8 )
  9. Xisco Faulí ( 7 )
  10. Mike Kaganski ( 6 )

Triaged Bugs

471 bugs have been triaged by 78 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 82 )
  2. m.a.riosv ( 56 )
  3. Buovjaga ( 44 )
  4. Julien Nabet ( 31 )
  5. Heiko Tietze ( 28 )
  6. Gabor Kelemen (allotropia) ( 21 )
  7. Mike Kaganski ( 15 )
  8. Dieter ( 14 )
  9. Regina Henschel ( 13 )
  10. Xisco Faulí ( 11 )

Resolution of resolved bugs

603 bugs have been set to RESOLVED.

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

Fixed Bugs

215 bugs have been fixed by 35 people.

Top 10 Fixers

  1. Michael Stahl ( 20 )
  2. Balazs Varga ( 18 )
  3. Xisco Fauli ( 14 )
  4. Noel Grandin ( 13 )
  5. Khaled Hosny ( 10 )
  6. Patrick Luby ( 10 )
  7. Miklos Vajna ( 9 )
  8. Mike Kaganski ( 7 )
  9. László Németh ( 7 )
  10. Michael Weghorn ( 6 )

List of high severity bugs fixed

  1. tdf#100894 FILEOPEN FILESAVE IMPORT Conditional formatting: xls file with a lot of Conditional formatting freeze Calc when opening Styles sidebar ( Thanks to Noel Grandin )
  2. tdf#101174 Allow changing Formula Editor math font ( Thanks to Khaled Hosny )
  3. tdf#128437 FILEOPEN: Cell in table is displayed on next page ( Thanks to Michael Stahl )
  4. tdf#139164 Always default to ‘whole document’ in Print and PDF export dialogs ( Thanks to Khaled Hosny )
  5. tdf#142694 Writer stops responding with busy CPU after opening this document ( Thanks to Michael Stahl )
  6. tdf#144072 LibreofficeBase crashed when 2 fields selected in report builder from different sections and width is adjusted 2nd time ( Thanks to Noel Grandin )
  7. tdf#156209 Font size increases when copying from cell in edit mode and pasting into another in non-edit mode ( Thanks to Noel Grandin )
  8. tdf#156306 tagged PDF export of odt document runs in a loop (hangs) ( Thanks to Michael Stahl )
  9. tdf#156508 Blur shadow is solid in edit and presentation mode ( Thanks to Patrick Luby )
  10. tdf#156514 Check spelling red underlines are gone (but spell checking still works) ( Thanks to Noel Grandin )
  11. tdf#156525 Save as > HTML loses drawing object as invalid gif ( Thanks to Noel Grandin )
  12. tdf#156546 Writer freezes/hangs at redo inserting a table ( Thanks to Michael Stahl )
  13. tdf#156551 Texttables – Writer not responding anymore ( Thanks to Michael Stahl )
  14. tdf#156721 Crash if cursor in Basic IDE is in a macro from a document and that document is closed ( Thanks to Noel Grandin )
  15. tdf#156978 Crash on load of ODT with headings/ToC if Navigator open ( Thanks to Jim Raykowski )

List of crashes fixed

  1. tdf#144072 LibreofficeBase crashed when 2 fields selected in report builder from different sections and width is adjusted 2nd time ( Thanks to Noel Grandin )
  2. tdf#145743 Embedded file crash master document ( Thanks to Michael Stahl )
  3. tdf#147938 Crash in: msvcp140.dll ( Thanks to Michael Stahl )
  4. tdf#150137 Crash when parsing an XML with undeclared namespace ( Thanks to Aron Budea )
  5. tdf#151866 Crash swlo!SwFrame::GetPrevSctLeaf+0x52d: on CTRL+X ( Thanks to Michael Stahl )
  6. tdf#156589 CRASH: inserting page break ( Thanks to Miklos Vajna )
  7. tdf#156595 LO crash when deleting a table row in a row with a hidden deleted table column at the beginning. ( Thanks to László Németh )
  8. tdf#156721 Crash if cursor in Basic IDE is in a macro from a document and that document is closed ( Thanks to Noel Grandin )
  9. tdf#156783 LO crash selecting table with the whole document and changing table border ( Thanks to László Németh )
  10. tdf#156967 CALC: Basic: CSV import macro crashes Calc 7.6.0.3 (worked fine in 7.5) ( Thanks to Noel Grandin )
  11. tdf#156978 Crash on load of ODT with headings/ToC if Navigator open ( Thanks to Jim Raykowski )

List of performance issues fixed

  1. tdf#114192 Call psp::PrintFontManager::analyzeFontFile font scan only when needed ( Thanks to Khaled Hosny )
  2. tdf#142694 Writer stops responding with busy CPU after opening this document ( Thanks to Michael Stahl )
  3. tdf#156551 Texttables – Writer not responding anymore ( Thanks to Michael Stahl )

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

  1. tdf#100894 FILEOPEN FILESAVE IMPORT Conditional formatting: xls file with a lot of Conditional formatting freeze Calc when opening Styles sidebar ( Thanks to Noel Grandin )
  2. tdf#101174 Allow changing Formula Editor math font ( Thanks to Khaled Hosny )
  3. tdf#101886 Border line style control not a11y accessible ( Thanks to Michael Weghorn )
  4. tdf#101895 Paragraph dialog units shown as “ch” and “lines” when “Enable char unit” is enabled by default ( Thanks to Caolán McNamara )
  5. tdf#103480 EDITING: Hyperlink deleted when merging cells (if not in the first cell) ( Thanks to Czeber László Ádám )
  6. tdf#103706 Alternate Clone Formatting scope ( Thanks to Sarper Akdemir )
  7. tdf#104918 LibreOffice
10 Aug 2023

QA/Dev Report: July 2023

General Activities

  1. LibreOffice 7.5.5 was released on July 20
  2. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, added an example on how to get user data from registry with BASIC, added help pages for document themes and Calc drawing styles and fixed a JavaScript issue related to displaying different embedded help content depending on the operating system
  3. Stanislav Horáček improved the help for Sort command in Writer
  4. Juan C. Sanz added a new help section for direct connections to PostgreSQL databases
  5. Nay Catina Dia-Schneebeli added a help page for the new Style Spotlight feature
  6. Stéphane Guillou (TDF) improved help pages for hyphenation, Outline Folding and labels
  7. Rafael Lima fixed issues with F1 help shortcut not working in some contexts and fixed incorrect menu positions with KDE Frameworks 5 UI. He also updated help for ScriptForge, improved help on setting PYTHONPATH and did a lot of fixes in help bookmarks that connect something in the UI to a relevant help target
  8. Seth Chaiklin added help for the new “Place backup in same folder as document” option and added a tip of the day entry about Search Commands
  9. Laurent Balland added optional detection of numbers in scientific notation to HTML paste
  10. Alain Romedenne updated help for ScriptForge
  11. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer and added initial help for it
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Szymon Kłos, Áron Budea, Marco Cecchetti and Pranam Lashkari (Collabora) worked on LOKit and/or jsdialog used by Collabora Online. Szymon also made it so when inserting internal links in Impress the dialog will not mix master slides with regular ones and Áron fixed a Skia gradient transparency regression
  14. Eike Rathke (Red Hat) made it so ROW() and COLUMN() in array mode return a scalar value instead of a single element matrix and added code to deal with bad XLSX files generated by QuickBooks
  15. Tomaž Vajngerl (Collabora) continued polishing support for document themes
  16. Julien Nabet made many code cleanups and simplifications
  17. Andreas Heinisch made it so hiding a slide in Impress can be undone, made indexes of tables support Ctrl-clicking items for navigation and made it so inserting a hyperlink pre-fills the URL field, if the clipboard contains a URL. He also improved the help for CDbl and Csng BASIC functions
  18. László Németh improved Writer change tracking related to tables
  19. Xisco Faulí (TDF) did many SVG handling and rendering improvements, fixed many crashes and made some changes and additions to automated tests
  20. Michael Stahl (allotropia) made lots of improvements to the Universal Accessibility PDF export support, added support for decorative flags for objects, fixed an issue with frame styles not exporting properly in some cases and made it so setting comments to be in margin doesn’t cause link annotations to be lost in PDF export
  21. Mike Kaganski (Collabora) made it so paragraph autostyle is used to mimic Word’s table style in DOCX files, fixed the Writer scrollbar tooltip feature which had broken in multiple ways, prevented unwanted tabs from appearing sometimes in table of contents upon DOCX export, implemented “Legal” numbering style that forces all levels to use Arabic numerals to improve interoperability with Word, untangled configuration nodes related to AutoRecovery, made it so AutoRecovery interval is applied separately per document, fixed handling of WM_UNICHAR message on Windows and fixed handling of PDF page scaling factor after large pages. He also fixed many regressions and did many code cleanups and optimisations
  22. Caolán McNamara (Collabora) fixed an issue that caused Ctrl+Left to not always jump to the correct cell. He also fixed crashes and issues found by code analysers
  23. Stephan Bergmann (Red Hat) did many code, test and build-related cleanups, one focus area being preparation for more efficient handling of strings allowed by a newer build baseline
  24. Noel Grandin (Collabora) changed LibreOffice’s internal formats and data structures to work directly with alpha instead of transparency in images and graphics, so the code is in line with the representation found in image formats and APIs everywhere. He also did many code cleanups and optimisations
  25. Justin Luth (Collabora) brought back and fixed functionality to automatically save documents, which was disabled years ago due to an improper implementation. Alongside this rework, he made quality of life improvements to saving of AutoRecovery information as well. He also improved the NotebookBar UIs
  26. Heiko Tietze (TDF) made it so automatic text colour in Calc uses a better threshold for what is considered a dark background colour, made use of ScrollLock key for navigation configurable in Calc, made Writer’s Word Count dialog display the number of comments and made corrections to what is included in the display of Formatting Aids
  27. Tibor Nagy (NISZ) fixed several issues involving conditional formatting and merged cells
  28. Paris Oplopoios worked on the GSoC project for implementing APNG (Animated PNG) support. He also fixed an issue that caused inline page breaks to not be imported correctly from DOC files
  29. Baole Fang worked on the GSoC project for selecting tests to run on Gerrit patches based on machine learning. He also raised the limit of collected entries for Word Completion in Writer
  30. Dipam Turkar worked on the GSoC project for converting Writer’s Java UNO API tests to C++
  31. Ahmed Gamal Eltokhy worked on the GSoC project for improving PGP/GPG encryption support
  32. Bayram Çiçek worked on the GSoC project for adding a search field into Options
  33. Michael Weghorn (TDF) got a flying start as TDF’s new accessibility-focused developer, among other things fixing accessibility of Expert Configuration dialog and making it so the operating system setting to reduce or disable animations is obeyed with Windows, gtk3 and KDE Frameworks following Patrick Luby’s initial implementation on macOS
  34. Balázs Varga (allotropia) worked on the accessibility Sidebar panel, made it so disabled when they have no enabled submenus and fixed an issue causing Basic dialog contents to be invisible in preview mode with scrollbars enabled
  35. Samuel Mehrbrodt (allotropia) fixed an issue causing Writer comments in margin to not be exported to PDF when there was no comment on the first page
  36. Czeber László Ádám (NISZ) fixed Calc comments getting duplicated after row deletion and undo, removed a Print Preview limitation with bordered rows in Calc and made handling of whitespace in XLSX-imported formulas more robust
  37. Khaled Hosny (TDF) dropped PostScript printing support on Linux, fixed handling of automatic colour in case of overlines in PDF export, made DPI handling more robust in PDF export, fixed issues with thin spaces in Mongolian text, fixed rendering of RTL text in Impress letter-by-letter animations, made handling of superscript/subscript more robust in the context of mixed Western and CTL scripts, fixed a HarfBuzz issue involving graphite tables and glyph advances in fonts, improved the subpixel positioning of font glyphs, made it possible to insert the cursor in the middle of ligatures when editing text, made casemapping (UPPERCASE/lowercase etc.) more robust by using ICU more often, aligned special character names with Unicode names and fixed setting watermark font for CJK/CTL text. He also did many code cleanups
  38. Patrick Luby (NeoOffice) made LibreOffice respect macOS’s “Reduce animation” system setting to help users with visual hypersensitivity, added “Encrypt with GPG key” checkbox into macOS native save dialog, fixed rendering of semi-transparent SVG images in ODP files when using Skia for graphics rendering and fixed installation of language packs failing on macOS with Spotlight off
  39. Jaume Pujantell (Collabora) made selecting merged cells with keyboard shortcuts in Calc more robust
  40. Maxim Monastirsky fixed an issue causing incorrect rendering of transparent background colours in Impress/Draw in some cases and fixed setting font color from the toolbar dropdown in Report Builder
  41. Jim Raykowski improved Navigator’s drag and drop hyperlink creation functionality
  42. Christian Lohmaier (TDF) worked on raising the Linux build baseline to AlmaLinux 8
  43. Hossein Nourikhah (TDF) added a UI test for Calc truncated formula display
  44. Ashod Nakashian (Collabora) made it so the option for setting a password is disabled when saving plain text documents
  45. Arnaud Versini did many code cleanups
  46. Vladislav Tarakanov improved the rounding behaviour of scientific numbers in Calc
  47. Satya Kompella (OpenText) fixed an issue causing wanted paragraph spacing in the headers in DOC files
  48. Luigi Iucci (Collabora) made it so applying a style also applies its list level
  49. Taichi Haradaguchi updated many dependencies
  50. Colomban Wendling (Hypra) introduced AT-SPI2 tests for the GTK3 accessibility layer
  51. Regina Henschel fixed an issue with setting theme colours to text in shapes
  52. David Gilbert did many code cleanups
  53. Pierre Vacher added generic support for embedded databases of unknown type into the database wizard
  54. Sakura286 improved the riscv64 UNO bridge, fixing a test failure
  55. Wu Jiahuan improved the loongarch64 UNO bridge, fixing a test failure
  56. René Engelhard (Debian) made it so SSE is not used in Skia on 32-bit Linux distributions to allow building for them
  57. Matt K made it so pasting a table in Writer no longer inherits list formatting, disallowed non-numberic values in Navigator’s Go To control, made Calc’s Autosum a split button and made Fontwork dialog’s SameLetterHeights button more robust
  58. Svante Schubert fixed an issue with incorrect background colours in XHTML export
  59. Rico Tzschichholz (Ubuntu) made some code and build related cleanups
  60. Björn Michaelsen refactored Writer code a bit
  61. Gülşah Köse (Collabora) made it impossible to accidentally open multiple Theme Color Edit dialogs
  62. Sarper Akdemir (allotropia) fixed tooltip displaying over two monitors on Windows, tweaked the hit area for selecting textboxes in Impress and added a new expert configuration option DragThresholdPixels for Impress and Draw to define the number of pixels the cursor can move before dragging (with a higher default value than before), which will help avoid accidental dragging of text boxes
  63. Vasily Melenchuk (CIB) improved the importing of IF field from RTF and DOCX files
  64. Kohei Yoshida made the reference resolver available for orcus
  65. Rizal Muttaqin added icons for Page Number Wizard and synchronised the icons used for Insert Shape menu and Sidebar Shape deck

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

439 bugs, 65 of which are enhancements, have been reported by 254 people.

Top 10 Reporters

  1. Regina Henschel ( 16 )
  2. Eyal Rozenberg ( 13 )
  3. Stéphane Guillou (stragu) ( 12 )
  4. Mike Kaganski ( 12 )
  5. Rafael Lima ( 12 )
  6. Gabor Kelemen (allotropia) ( 12 )
  7. Telesto ( 10 )
  8. ksso ( 10 )
  9. Xisco Faulí ( 9 )
  10. Samuel Mehrbrodt (allotropia) ( 7 )

Triaged Bugs

461 bugs have been triaged by 73 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 126 )
  2. m.a.riosv ( 37 )
  3. Heiko Tietze ( 28 )
  4. Buovjaga ( 25 )
  5. Dieter ( 20 )
  6. Michael Weghorn ( 13 )
  7. ⁨خالد حسني⁩ ( 13 )
  8. Gabor Kelemen (allotropia) ( 12 )
  9. raal ( 11 )
  10. Roman Kuznetsov ( 10 )

Resolution of resolved bugs

551 bugs have been set to RESOLVED.

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

Fixed Bugs

208 bugs have been fixed by 43 people.

Top 10 Fixers

  1. Khaled Hosny ( 19 )
  2. Michael Stahl ( 18 )
  3. Balazs Varga ( 14 )
  4. Mike Kaganski ( 12 )
  5. Rafael Lima ( 10 )
  6. Justin Luth ( 10 )
  7. Xisco Fauli ( 10 )
  8. László Németh ( 6 )
  9. Heiko Tietze ( 5 )
  10. Andreas Heinisch ( 5 )

List of critical bugs fixed

  1. tdf#156286 Crash on right-click delete of selected cells in Calc ( Thanks to László Németh )

List of high severity bugs fixed

  1. tdf#125504 Notebookbar Tabbed / Compact Tabbed UI ParaStyle-controls/FontName-controls stop applying after a print preview ( Thanks to Justin Luth )
  2. tdf#144053 Installation of Language Pack fails on macOS with Spotlight off ( Thanks to Patrick Luby )
  3. tdf#154035 It is not possible to set tabs in Writer by clicking on the top ruler ( Thanks to Mike Kaganski )
  4. tdf#155125 “Encrypt with GPG key” option missing when using System File Dialog on macOS ( Thanks to Patrick Luby )
  5. tdf#156165 Writer resets previous paragraph’s style to body text if AutoCorrect is on ( Thanks to Baole Fang )
  6. tdf#52577 Right-hand part of vowel signs disappear when reordering
3 Aug 2023

LibreOffice 7.6 RC2 is available for testing

LibreOffice 7.6 will be released as final in mid-August 2023 (check the Release Plan), with LibreOffice 7.6 Release Candidate 2 (RC2) the forth pre-release since the development of version 7.6 started in mid December, 2022. Since the previous release, LibreOffice 7.6 RC 1, 100 commits have been submitted to the code repository and 62 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.6 RC2 can be downloaded for Linux, macOS and Windows, and it will replace the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla (you just need a legit email account in order to create a new account).

For help, you can contact the QA Team directly in the QA IRC channel or via Matrix.

LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!

Click the banner below to download and test – and thanks for testing!

Download it now!

12 Jul 2023

LibreOffice 7.6 RC1 is available for testing

LibreOffice 7.6 will be released as final in mid-August 2023 (check the Release Plan), with LibreOffice 7.6 Release Candidate 1 (RC1) the third pre-release since the development of version 7.6 started in mid December, 2022. Since the previous release, LibreOffice 7.6 Beta 1, 354 commits have been submitted to the code repository and 151 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.6 RC1 can be downloaded for Linux, macOS and Windows, and it will replace the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla (you just need a legit email account in order to create a new account).

For help, you can contact the QA Team directly in the QA IRC channel or via Matrix.

LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!

Click the banner below to download and test – and thanks for testing!

Download it now!

7 Jul 2023

QA/Dev Report: June 2023

General Activities

  1. LibreOffice 7.5.4 was released on June 8
  2. Olivier Hallot (TDF) continued adding Tabbed UI examples into help instructions, corrected help pages to match UI changes and refactored PostgreSQL connection setup dialog
  3. Seth Chaiklin made some UI label improvements and updated help after UI changes for Body Text style, AutoCorrect and Navigator heading manipulation
  4. Laurent Balland fixed issues with rendering of moving average trend lines in charts, added support for embedded text in scientific number format and fixed an erroneous warning in CSV import dialog
  5. Alain Romedenne updated help for ScriptForge
  6. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer, improved the handling of vertically raised or lowered text in DOCX files and expanded the developer functionality for dumping Writer document layout data
  7. Szymon Kłos (Collabora) optimised Style Preview performance and did some code cleanups
  8. Eike Rathke (Red Hat) improved date & time (duration) handling in Calc
  9. Tomaž Vajngerl (Collabora) continued polishing support for document themes
  10. Julien Nabet improved native number format handling, fixed issues found by code analysers and did many code cleanups
  11. Andreas Heinisch made the Format Cell dialog in Calc remember its window state and implemented functionality for pinning favourite documents in Start Center
  12. László Németh made many improvements to the change tracking of Writer tables
  13. Xisco Faulí (TDF) added support for many SVG filters and fixed many SVG CSS issues. He also made many additions and changes in automated tests
  14. Michael Stahl (allotropia) fixed many regressions and crashes
  15. Mike Kaganski (Collabora) made service names displayed in Language Settings match the UI language instead of the locale and implemented sorting for the language list in the Edit Modules dialog reached from Writing Aids options. He also fixed issues in XML Requirements Interchange Format export, made handling of Writer lists more robust, fixed issues causing unwanted paragraph margins in DOCX import, right-aligned numbers not being exported to PDF from DOCX files and direct formatting not read for empty last paragraphs in DOCX import
  16. Caolán McNamara (Collabora) made several performance optimisations in UI code, fixed exporting the default Impress master slide to SVG and fixed deleting recent items in Special Character dialog. He also fixed crashes and issues found by code analysers
  17. Stephan Bergmann (Red Hat) made WebDAV URL handling more robust and did many code and build-related cleanups
  18. Noel Grandin (Collabora) improved performance in Calc when loading various types of spreadsheets, when calculating cell borders and on macOS when using Keyboard Viewer, scrolling through large DOCX documents with lots of comments and Calc spreadsheets with lots of patterns and improved the startup time of LibreOffice in general. He also did many code cleanups
  19. Justin Luth (Collabora) made subscript/superscript handling in text objects more intuitive, made it so saving a password protected read-only document under a new name offers the same password protection option by default, improved exporting content controls to PDF, fixed DOCX import issues related to strikethrough handling, numbering styles and overlap setting of images, fixed DOC import issues related to wrapping and anchoring, fixed many Notebookbar paper cuts, fixed Calc cell selection when using a split window and fixed an issue with paragraph spacing involving sections
  20. Heiko Tietze (TDF) fixed an issue with unwanted scaling of overlay icons in Start Center, added some example multi-colour gradients and made it so the input field for number of copies is no longer hidden by default in the print dialog
  21. Armin Le Grand (allotropia) worked on multi-color gradient support
  22. Tibor Nagy (NISZ) fixed resizing of cropped images to original size and fixed an issue with colour scale conditional formats in XLSX files
  23. Paris Oplopoios worked on the GSoC project for implementing APNG (Animated PNG) support – now even blending modes work. He also did code cleanups
  24. Baole Fang worked on the GSoC project for selecting tests to run on Gerrit patches based on machine learning. He also made it so Calc cells formatted as text don’t check for formula correctness, fixed an issue with unwanted style change caused by AutoCorrect, implemented alphabetical sorting of categories in Customize Keyboard dialog and made word boundary detection in AutoCorrect more robust
  25. Dipam Turkar worked on the GSoC project for converting Writer’s Java UNO API tests to C++
  26. Ahmed Gamal Eltokhy worked on the GSoC project for improving PGP/GPG encryption support
  27. Bayram Çiçek worked on the GSoC project for adding a search field into Options
  28. Michael Weghorn worked on the KDE Frameworks UI, adding a new kf6 UI plugin
  29. Balázs Varga (allotropia) worked on the accessibility Sidebar panel, improved the XLSX compatibility of the CELL() function and implemented showing author and date in Calc comments
  30. Samuel Mehrbrodt (allotropia) worked on the accessibility Sidebar panel, made Calc’s colour filtering work with cells with no content and made it so bootstrap variables in Java user classpath settings are allowed
  31. Czeber László Ádám (NISZ) fixed an issue with Calc input line not updating after applying Repeat for text editing and fixed a Calc number formatting issue related to no-break spaces and filling available space
  32. Khaled Hosny (TDF) fixed ccache cache size detection (for building LibreOffice from source), fixed issues with font fallback for surrogate pairs in RTL text, losing paragraph line spacing in DOCX files with certain fonts, CJK Emphasis marks not showing in slideshow, rendering of old Hangul in vertical layout, positioning of emphasis marks in PDF export of vertical text and alignment of Tangut and Khitan script in vertical layout. He also made it so there is no need to duplicate hunspell dictionaries for every Arabic locale and made fullwidth CJK punctuation respect the option for compression
  33. Gábor Kelemen (allotropia) dropped some unused items from officecfg registry
  34. Patrick Luby (NeoOffice) improved the performance of Calc UI when using Keyboard Viewer on macOS and fixed a macOS crash related to multiple monitors and changing formatting for a large number of cells. He also fixed hanging when selecting a column or row in Calc on macOS
  35. Jaume Pujantell (Collabora) improved the support for annotations, when importing PDFs as images
  36. Maxim Monastirsky implemented styles for Writer comments
  37. Tünde Tóth (NISZ) fixed a Chart Sidebar issue, which could cause an OOXML write error
  38. Jim Raykowski made the detecting of unique names when renaming objects in Impress & Draw more robust
  39. Christian Lohmaier (TDF) made some build fixes
  40. Hossein Nourikhah (TDF) fixed an issue causing Writer’s direct cursor to leave a trail to the screen
  41. Dennis Francis (Collabora) improved the performance of Calc sheets with lots of repetitive row styles
  42. Bartosz Kosiorek implemented EmfPlusDrawCurve with cardinal spline for EMF+ graphics
  43. Ashod Nakashian, Henry Castro, Marco Cecchetti and Pranam Lashkari (Collabora) worked on LOKit used by Collabora Online. Henry Castro also fixed many issues in Calc conditional formatting and made handling of multiline text in XLSX files more robust
  44. Arnaud Versini did some code cleanups
  45. Vladislav Tarakanov fixed an issue causing small Calc window size after deleting the registrymodifications.xcu configuration file
  46. Satya Kompella (OpenText) fixed missing page numbers in the footer of a certain DOCX file
  47. Luigi Iucci (Collabora) fixed issues with some fonts not getting embedded in ODT files, pasting images from Firefox to Calc and header columns disappearing when filtering pivot tables
  48. Taichi Haradaguchi updated many dependencies
  49. Rashesh Padia (Collabora) added support for multi image TIFF files
  50. Michael Meeks (Collabora) fixed a crash in graphics handling code
  51. Bogdan Buzea fixed line count in file properties resetting to zero after going past 65535 lines
  52. Colomban Wendling (Hypra) improved gtk3 accessibility and fixed a crash related to accessibility handling
  53. Franklin Weng fixed XHTML export applying unwanted zero margins and minimum widths
  54. Regina Henschel continued the work on supporting multi-color gradients in ODF files and fixed issues related to gradients
  55. David Gilbert did code cleanups

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

458 bugs, 56 of which are enhancements, have been reported by 285 people.

Top 10 Reporters

  1. Hossein ( 19 )
  2. Eyal Rozenberg ( 19 )
  3. jindam, vani ( 13 )
  4. Mike Kaganski ( 12 )
  5. Xisco Faulí ( 12 )
  6. Regina Henschel ( 10 )
  7. Gabor Kelemen (allotropia) ( 8 )
  8. William Friedman ( 8 )
  9. Robert Großkopf ( 7 )
  10. AvidSeeker ( 7 )

Triaged Bugs

387 bugs have been triaged by 61 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 75 )
  2. Julien Nabet ( 46 )
  3. m.a.riosv ( 32 )
  4. Mike Kaganski ( 26 )
  5. Heiko Tietze ( 24 )
  6. Dieter ( 19 )
  7. ⁨خالد حسني⁩ ( 16 )
  8. ady ( 13 )
  9. Xisco Faulí ( 13 )
  10. Gabor Kelemen (allotropia) ( 9 )

Resolution of resolved bugs

517 bugs have been set to RESOLVED.

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

Fixed Bugs

193 bugs have been fixed by 40 people.

Top 10 Fixers

  1. Xisco Fauli ( 16 )
  2. Justin Luth ( 15 )
  3. Khaled Hosny ( 13 )
  4. Balazs Varga ( 13 )
  5. Mike Kaganski ( 10 )
  6. Michael Stahl ( 9 )
  7. László Németh ( 7 )
  8. Regina Henschel ( 6 )
  9. Caolán McNamara ( 5 )
  10. Baole Fang ( 5 )

List of high severity bugs fixed

  1. tdf#151946 Opening spreadsheet very slow ( Thanks to Noel Grandin )
  2. tdf#153517 CALC – wrong time value when using the autofill function and minutes are entered (not for 00 min) ( Thanks to Eike Rathke )
  3. tdf#155939 LibreOffice-7.5.4.2 Writer hangs when changing language of text ( Thanks to Michael Stahl )

List of crashes fixed

  1. tdf#122081 Crash in SwFrame::FindFootnoteBossFrame(bool) ( Thanks to Caolán McNamara )
  2. tdf#146626 Crash in macOS Calc on font size operation on multi-monitor setup ( Thanks to Patrick Luby )
  3. tdf#152983 crash in layout with chained text frames anchored in footer ( Thanks to Michael Stahl )
  4. tdf#155685 CRASH: after undoing deletion with extended select all and table at end ( Thanks to Michael Stahl )
  5. tdf#155747 Writer crash when you delete/insert a new column and then select to accept the change ( Thanks to László Németh )
  6. tdf#155825 Crash MCGR export special file odp -> pptx ( Thanks to Regina Henschel )
  7. tdf#155951 crash with XTextRange::getString() ( Thanks to László Németh )
  8. tdf#156091 BASIC IDE or Development Tools crash when expanding the + of ‘Background’ of master page ( Thanks to Mike Kaganski )

List of performance issues fixed

  1. tdf#150534 Hiding Recently Expanded Columns Results in Significant Performance Loss ( Thanks to Noel Grandin )
  2. tdf#151946 Opening spreadsheet very slow ( Thanks to Noel Grandin )

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

  1. tdf#103869 FILEOPEN LibO doesn’t open .docx file with two table separated by a page break correctly ( Thanks to Miklos Vajna )
  2. tdf#107718 Some of old Hangul not rendering faithfully in vertical layout ( Thanks to Khaled Hosny )
  3. tdf#114432 Tangut character aligned incorrectly in vertical layout ( Thanks to Khaled Hosny )
  4. tdf#115321 Vertical Japanese text lines with emphasis mark above in odt exported to PDF is shown a quarter font height lower than the normal lines, and no emphasis mark is shown ( Thanks to Khaled Hosny )
  5. tdf#118087 FILEOPEN SVG with greyscale filter opens with colors ( Thanks to Xisco Fauli )
  6. tdf#122081 Crash in SwFrame::FindFootnoteBossFrame(bool) ( Thanks to Caolán McNamara )
  7. tdf#122270 Tabbed Notebook Bar (Impress) View (tab) Normal and Master buttons do not properly update UI when user switches view ( Thanks to Justin Luth )
  8. tdf#122676 FORMATTING Currency Negative Values does not Correctly Apply (*) with a Space ( Thanks to Czeber László Ádám )
  9. tdf#122970 Direct cursor leaves screen trail with mouse pointer movement and no text ( Thanks to Hossein )
  10. tdf#125154 writer calculation using variable within table does not work with formated numbers ( Thanks to Michael Stahl )
  11. tdf#38742 Pushpins/Favourites in recent menu and start center ( Thanks to Andreas Heinisch )
  12. tdf#43671 VIEWING: CJK Emphasis marks not showing in slideshow ( Thanks to Khaled Hosny )
  13. tdf#54768 Asking to restore image to original size gets wrong size when the image is clipped ( Thanks to Tibor Nagy )
  14. tdf#64830 RTL: LibreOffice requires duplicated hunspell dictionaries for
14 Jun 2023

LibreOffice 7.6 Beta1 is available for testing

LibreOffice 7.6 will be released as final in mid August, 2023 ( Check the Release Plan ) being LibreOffice 7.6 Beta1 the second pre-release since the development of version 7.6 started in mid December, 2022. Since the previous release, LibreOffice 7.6 Alpha1, 641 commits have been submitted to the code repository and 189 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 7.6 Beta1 can be downloaded for Linux, macOS and Windows, and it can be installed alongside the standard version.

In case you find any problem in this pre-release, please report it in Bugzilla ( You just need a legit email account in order to create a new account ).

For help, you can contact the QA Team directly in the QA IRC channel or via Matrix.

LibreOffice is a volunteer-driven community project, so please help us to test – we appreciate it!

Happy testing!!

Download it now!