11 Mar 2024

QA/Dev Report: February 2024

General Activities

  1. LibreOffice 7.6.5 was released on February 22
  2. LibreOffice 24.2.1 was released on February 29
  3. Olivier Hallot (TDF) added help content for Calc’s XLOOKUP and XMATCH functions, Navigate By in Find toolbar, Draw’s Shrink text on overflow and did many fixed and cleanups in Help
  4. Rafael Lima made it so selected text in the BASIC editor is automatically inserted into the search bar, added a command for toggling code block commenting in BASIC IDE and fixed an issue where Duplicate Sheet command might create the sheet in the wrong file, if having two open files with the same name
  5. Stanislav Horacek updated command paths in Help
  6. Stéphane Guillou (TDF) updated command paths in Help
  7. Alain Romedenne updated ScriptForge Help pages, updated Python shell script Help for macOS and improved Python example in SDK
  8. Dione Maddern did many fixes and updates to Help pages, mostly fixing links
  9. Gábor Kelemen (allotropia) made some cleanups in Help and in UI and UNO bridges code
  10. Laurent Balland fixed an issue with skip empty cells option not working for the last column in Calc Text Import dialog, made it so custom number formats using the ? character replace trailing zeroes with figure spaces which have a width approximating a digit and removed unneeded thumbnail.png images from Wizard templates
  11. Miklós Vajna (Collabora) added legal numbering support for DOC and RTF files, made Calc HTML import support data-sheets attributes, made Calc’s cell editing accept pasted HTML fragments, made DOCX content control handling more robust and continued polishing floating table support
  12. Szymon Kłos, Gülşah Köse, Marco Cecchetti, Gökay Şatır, Pranam Lashkari, Michael Meeks and Méven Car (Collabora) worked on LOKit used by Collabora Online
  13. Attila Szűcs (Collabora) fixed PPTX issues with multiline field wrapping and stacked text
  14. Henry Castro (Collabora) tweaked Calc’s background colour filter to not extend transparent colours to empty cells and fixed an issue with Sidebar not displaying the full localised currency string for cell properties
  15. Tomaž Vajngerl (Collabora) made it so the currencies used in a spreadsheet are put at the top of the currency pop-up list, made pivot table data cache handling smarter and improved the handling of XLS documents with unknown DRM encryption (mainly due to some Excel addons)
  16. Julien Nabet fixed an issue where Data validation without error check allowed entering incorrect data, fixed LOWER not being supported in Base’s Query-GUI if condition was LIKE and fixed an issue with Calc Macro setting SearchWildcard to False changing SearchRegularExpression value. He also fixed some crashes
  17. Andreas Heinisch made Calc’s Autofilter sorting and removing duplicates more robust and made it so a single click is enough to access options through Calc’s status bar
  18. Xisco Faulí (TDF) made over a dozen addition and changes to automated tests, improved dark mode support of Writer comment UI, fixed an issue with Autofilter empty option, made SVG text baseline handling more intuitive, added support for in and result SVG filter attributes and fixed a crash
  19. Michael Stahl (allotropia) added support for cropped images in RTF import, fixed an issue with unwanted formatting in DOCX numbered lists, fixed page style for even/odd section breaks in RTF/DOCX import and fixed a memory leak related to copying Writer content
  20. Mike Kaganski (Collabora) made many improvements to repairing broken documents, implemented auto-accelerator feature on Windows, fixed an issue with PDF compliance, fixed an issue with vertical alignment of math formulas, fixed an issue preventing Select All in Writer from working when section at the start of document body was hidden, made the handling of temporary directories more robust, fixed an issue with unwanted wrapping in Calc and fixed crashes. He also restored a Boost library patch related to Windows locales, which was found to work around a Windows bug causing a hang after opening file dialogs
  21. Caolán McNamara (Collabora) improved dark mode support for charts and optimised Calc’s performance. He also fixed crashes and many issues found by static analysers and fuzzers
  22. Stephan Bergmann (allotropia) worked on WASM build. He also did many code cleanups and adapted the code to compiler changes
  23. Noel Grandin (Collabora) dramatically improved the memory use when exporting a PDF with lots of small graphics and expanded mergedlibs build support. He also did many code cleanups
  24. Justin Luth (Collabora) made many improvements to VML and DML graphics support and gradient support in Microsoft document formats, fixed an issue with unwanted optimal row height in XLSX import and made it so applied date/time language is detected in Impress’s insert header/footer dialog
  25. Michael Weghorn (TDF) worked on bringing native Qt widgets to Qt/KDE UI, fixed clipboard issues affecting Qt-based UIs under Wayland on Linux, added support for module-specific window icons on Wayland and fixed accessibility issues in areas such as the Navigator and Calc’s rows and columns
  26. Balázs Varga (allotropia) made the recently-added Calc XLOOKUP function implementation more robust, added Excel2021 function XMATCH to Calc and added a global config setting RecalcOptimalRowHeightMode for optimal row height recalculation when loading spreadsheets
  27. Patrick Luby (NeoOffice) made many improvements to certificate management on macOS, worked around a nasty bug in Apple’s toolchain hampering debugging, fixed a performance issue related to font handling on macOS and fixed many macOS crashes
  28. Jim Raykowski made Draw less jumpy when deleting pages, made “New style from selection” work in Impress and Draw, revamped Writer Navigator’s go to page spin control, made keyboard shortcuts work when focus is in toolbar in all UIs and improved the layout of the top toolbox of the Navigator
  29. Sarper Akdemir (allotropia) added a panel that shows presenter notes in editing view in Impress
  30. Regina Henschel fixed an issue with snap guides disappearing in Impress and Draw and took the first step in implementing 3D element support for PPTX import
  31. Sahil Gautam added a selection locking feature to Calc’s Autofilter
  32. Samuel Mehrbrodt (allotropia) tweaked highlighting in Navigator, so headings get highlighted instead of bookmarks residing in them, added an option to not write temporary file next to local file to provide a better experience with Samba network shares and made it possible to modify default bullet selection in Writer
  33. Armin Le Grand (allotropia) implemented support for editing Impress slides during presentation and continued the rework of handling attributes and properties
  34. Oliver Specht (CIB) fixed an issue where the paragraph end Pilcrow character changed to a different one, if a symbol font was used, fixed importing checkboxes from RTF files, fixed selection in Writer tables with split/merged cells, made special character dialog respect the recently used font, added Writer table sidebar controls to change table alignment and left/right spacing, made it possible to use Cycle Case when cursor is at the beginning or end of a word and not only inside it, improved compatibility with RTF tables, added support for paper tray settings in RTF and DOCX files, made it so Clone Formatting in Impress only applies paragraph attributes from and to fully selected paragraphs and made it so dash replacement autocorrection also works between sentences
  35. Matt K fixed a couple of Writer crashes
  36. Arnaud Versini did some code cleanups
  37. Jaume Pujantell (Collabora) fixed an issue causing text in shapes to be lost when exporting Impress presentations to SVG and implemented reading simple solid fills from the fill styles list in a Visio file theme
  38. Heiko Tietze (TDF) improved the look of Writer comments, made the Keep Ratio setting more intuitive in the Position and Size dialog and made infobar appearances uncluttered
  39. Hossein Nourikhah (TDF) made the build configure error out, if a buggy Windows SDK version is found
  40. Omkar Acharekar worked on bringing native Qt widgets to Qt/KDE UI as part of an Outreachy project
  41. Tibor Nagy (allotropia) fixed an issue where the layout of content to be printed from Calc was not refreshed when changing the orientation
  42. Kurt Nordback worked on adding a chart type for “pie-with-remainder-as-another-pie”
  43. Taichi Haradaguchi updated some dependencies and fixed a link in Help
  44. Juan C. Sanz made it so Firebird embedded databases get their data saved automatically regardless of whether or not the save button is pressed
  45. Ashod Nakashian (Collabora) fixed corner-case issues with DOCX content controls and change tracking
  46. Yiğit Akçay added a feature for enclosing selected text in parentheses/brackets or quotation marks in Writer
  47. Vladislav Tarakanov fixed an issue with slideshow navigation bar, where double-clicking would advance three slides
  48. Vasily Melenchuk (CIB) fixed an issue with field styles in RTF import
  49. Áron Budea (Collabora) did some code cleanups
  50. Hubert Figuière and Vivek Javiya (Collabora) worked on jsdialog used in Collabora Online
  51. Akshay Warrier added a goto page/slide dialog for Impress and Draw
  52. Kevin Ottens fixed backup copy creation for files on mounted Samba shares
  53. David Gilbert fixed a PDF import performance issue involving tiling pattern fills
  54. Po-Yen Huang fixed an issue with Calc’s ROUND function producing inconsistent results in some cases (co-authored with Franklin Weng and Firefly
  55. Kohei Yoshida optimised Calc’s performance
  56. Zeph Chai translated an ODK example from Java to Python

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

477 bugs, 55 of which are enhancements, have been reported by 313 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 23 )
  2. Mike Kaganski ( 11 )
  3. lvm ( 11 )
  4. Telesto ( 10 )
  5. Rafael Lima ( 9 )
  6. Xisco Faulí ( 9 )
  7. Regina Henschel ( 8 )
  8. Stéphane Guillou (stragu) ( 7 )
  9. Adalbert Hanßen ( 7 )
  10. Olivier Hallot ( 7 )

Triaged Bugs

458 bugs have been triaged by 79 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 86 )
  2. Buovjaga ( 45 )
  3. Heiko Tietze ( 29 )
  4. Julien Nabet ( 29 )
  5. V Stuart Foote ( 22 )
  6. Mike Kaganski ( 21 )
  7. ady ( 21 )
  8. m_a_riosv ( 21 )
  9. Xisco Faulí ( 21 )
  10. Dieter ( 16 )

Resolution of resolved bugs

419 bugs have been set to RESOLVED.

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

Fixed Bugs

147 bugs have been fixed by 40 people.

Top 10 Fixers

  1. Mike Kaganski ( 15 )
  2. Xisco Fauli ( 9 )
  3. Michael Stahl ( 8 )
  4. Miklos Vajna ( 8 )
  5. Oliver Specht ( 7 )
  6. Noel Grandin ( 6 )
  7. Olivier Hallot ( 6 )
  8. Justin Luth ( 5 )
  9. Patrick Luby ( 5 )
  10. Heiko Tietze ( 5 )

List of critical bugs fixed

  1. tdf#157135 LibreOffice 7.6 stalls/crashes under Windows 11 with Norwegian (Bokmål) locale when opening file dialog ( Thanks to Mike Kaganski )
  2. tdf#159707 CRASH: Changing to edit mode ( Thanks to Julien Nabet )

List of high severity bugs fixed

  1. tdf#126638 macOS: Can’t paste, copy, cut or ⌘A (select all) using keyboard shortcuts in Save-As field (workaround: comment 38) ( Thanks to Patrick Luby )
  2. tdf#127293 Add XLOOKUP function in Calc ( Thanks to Balazs Varga )
  3. tdf#149499 CRASH: inserting page break and undoing ( Thanks to Matt K )
  4. tdf#156352 macOS: Save as > Encrypt with GPG key results in hang / crash ( Thanks to Caolán McNamara )
  5. tdf#159302 Formula OLE in a line of text or its full height frame is now misaligned vertically, due to change of sm map units ( Thanks to Mike Kaganski )
  6. tdf#159519 LibreOffice 24.2.0.3 (Windows 7) ODF files saved with passwords can be opened without any password ( Thanks to Michael Stahl )
  7. tdf#159529 Excessive memory consumption in v24.2 ( Thanks to Patrick Luby )
  8. tdf#159581 FILEOPEN XLSX 24.2: optimal row height from previous sheet may be applied to all future sheets ( Thanks to Justin Luth )
  9. tdf#159743 German UI: Many not plausible Keyboard Shortcut Changes ( Thanks to Xisco Fauli )
  10. tdf#54169 LibO doesn’t obey Windows OS setting “only show the accelerator underline when the Alt key is being pressed” ( Thanks to Mike Kaganski )
  11. tdf#55004 backup copy fails when using share / samba (if nobrl cifs mount option not used) ( Thanks to Kevin Ottens )

List of crashes fixed

  1. tdf#147731 Crash in SwFrameFormat::~SwFrameFormat() ( Thanks to Michael Stahl )
  2. tdf#149499 CRASH: inserting page break and undoing ( Thanks to Matt K )
  3. tdf#155710 Calc crashes
13 Feb 2024

QA/Dev Report: January 2024

General Activities

  1. LibreOffice 24.2 was released on January, 31
  2. Olivier Hallot (TDF) fixed a duplicate Covariance command in Notebookbar UIs, updated menu item paths in Help pages and updated Help pages for conversion filters and style Spotlight
  3. Rafael Lima added a Color Scheme switcher to Basic IDE, added a “Delete Comment” command to the Navigator context menu, fixed drawing comment triangles in Calc at all zoom levels, made it so the visibility of UI components in the Basic IDE is remembered, made Basic IDE highlight the line where the cursor is positioned, made it possible to open the “Go to Line” dialog from the statusbar in Basic IDE, fixed Calc AutoFilter arrow color in dark mode, made it so line numbering and breakpoint in Basic IDE are on the left even in right-to-left UI and fixed a crash in Dialog Editor. He also improved the ScriptForge Help pages
  4. Stanislav Horacek updated menu paths in Help alongside other cleanups and fixes
  5. Ilmari Lauhakangas (TDF) removed unnecessary images from SVG icon themes, saving nearly 5 MB of space. He also changed the Help CSS to account for a quirk in Safari
  6. Stéphane Guillou (TDF) continued linking Sidebar decks to Help
  7. Alain Romedenne updated ScriptForge Help pages
  8. Dione Maddern did many fixes and updates to Draw dialog Help pages
  9. Gábor Kelemen (allotropia) added accessible descriptions to new Dublin Core metadata boxes, updated Help after removal of FTP protocol support and did code cleanups in the area of code simplification and includes
  10. Laurent Balland did cleanups in the metadata of Impress templates
  11. Miklós Vajna (Collabora) fixed the layout handling of empty paragraphs formatted as superscript in Writer, added support for HTML paste to Writer shape text or Calc cell text edit and continued polishing support for multi-page floating tables in Writer
  12. Jean-Pierre Ledure worked on the ScriptForge library
  13. Gabriel Masei (1&1), Paris Oplopoios, Szymon Kłos, Méven Car, Andras Timar, Attila Szűcs and Áron Budea (Collabora) worked on LOKit used by Collabora Online. Andras also fixed some FreeBSD build issues while Attila fixed hyperlink colouring in certain PPTX files and a textbox vertical alignment inversion issue when saving PPTX files
  14. Henry Castro (Collabora) made the status bar in Calc work as expected with language selection
  15. Eike Rathke (Red Hat) made it so the maximum number of hours that can be entered into a Calc cell with time formatting is now a 32-bit integer instead of 65535
  16. Tomaž Vajngerl (Collabora) continued refactoring the EditEngine text editing code
  17. Julien Nabet fixed an issue preventing some position parameters to go beyond 17 mm in Writer, fixed an issue that made ReportBuilder wizards show two different data sources, fixed several crashes and did code cleanups
  18. Andreas Heinisch made it so font, highlight and background colour in toolbar buttons is remembered between sessions, fixed canceling Text Import in Calc locking the document and made it so question mark can be used in autotext shortcuts
  19. László Németh continued polishing support for smart justify found in DOCX files and implemented ODF attribute fo:hyphenate to exclude a portion of text from hyphenation
  20. Xisco Faulí (TDF) fixed a regression with multiline text exported to PDF as one line, added support for viewBox in symbol elements in SVG import and made nearly 20 additions and improvements to automated tests
  21. Michael Stahl (allotropia) continued polishing revamped ODF encryption, fixed a regression preventing editing of index entries in Writer, worked on WASM build, fixed a Writer issue causing objects to disappear after undo followed by Enter due to invisible anchor selection and fixed slowness if Style Inspector visible during PDF export
  22. Mike Kaganski (Collabora) made font substitution more robust, implemented support for inserting Unicode decimal codes via Alt+NumPad on Windows, fixed storing URLs in DOCX files, fixed a Writer formatting error in paragraphs with justified text, fixed PPTX import of graphic placeholder with a custom prompt, made it so Delete and Backspace move the cursor correctly in change tracking mode, fixed floating content controls importing from DOCX as separate paragraphs, improved the debugging experience in Visual Studio, fixed autotext / word completion tooltips not showing up, fixed an issue with saving word completion options, improved the IDE integration build code, got rid of unwanted space between footnote number and following text, when paragraph has hanging indent in imported DOCX files, fixed passing Integer-sized Long argument via script.invoke in BASIC, fixed unwanted interleaving of bookmark starts and ends and fixed updating path to library when it is renamed using Basic Macro Organizer. He also fixed crashes and did code cleanups
  23. Caolán McNamara (Collabora) fixed an issue causing Similarities dialog to not appear in Base, made optimal column width in Calc more robust, fixed an issue with checkboxes under GTK3 not being disabled when settings are locked down from config, fixed an issue with Hyperlink dialog width growing too large with long text in clipboard, improved Calc performance by reducing window content invalidations and enabled Small Caps toolbar button in Impress. He also fixed crashes and many issues found by static analysers and fuzzers
  24. Stephan Bergmann (allotropia) worked on the online update feature and WASM build and fixed an issue preventing certificate manager use. He also did many code cleanups and adapted the code to compiler changes
  25. Noel Grandin (Collabora) optimised opening files on Unixes, fixed an issue causing Paste as RTF to lose character color and paragraph alignment from styles, improved scrolling performance in Calc and made cryptographic signing more robust. He also did many code cleanups
  26. Justin Luth (Collabora) fixed a problem with tracked changes showing in Start Center thumbnail, fixed various cases of context menu not appearing in Writer when right-clicking the last half character, fixed an object z-order issue in DOCX files, fixed loss of number formatting in charts in DOCX import, fixed DOCX export issues causing unwanted overlapping of objects, fixed unwanted offset added to shapes in headers in DOCX import and fixed issues with pie chart import in OOXML files
  27. Michael Weghorn (TDF) worked on bringing native Qt widgets to Qt/KDE UI and fixed accessibility issues in areas such as shortcuts. He also did many updates and cleanups to the LibreOffice Android Viewer code
  28. Balázs Varga (allotropia) fixed an issue with copying master slide style in PPTX documents, made it so the user is taken straight to the Security Options and Warnings dialog after clicking the relevant button in an infobar notification and made accessibility warnings about simulated numbering smarter
  29. Patrick Luby (NeoOffice) fixed many macOS crashes and a hang on iOS during export
  30. Jim Raykowski made Spotlight more elegant by only showing it for styles that are used in the document, fixed a hyperlink editing crash while having Navigator open and made it possible to insert cross references from Navigator by dragging and dropping
  31. Sarper Akdemir (allotropia) continued working on the feature for disabling active content, fixed an issue with background image shifting down in presentation mode in PPTX files and made it so Dublin Core meta data attribute dc:date is added to exported PDF files
  32. Christian Lohmaier (TDF) fixed packaging of Noto fonts on macOS, fixed an issue with Windows build signing, added Armenian language pack and fixed Windows aarch64 cross-build
  33. Regina Henschel fixed an issue with line break missing from RTF clipboard data after copying shape text
  34. Sahil Gautam added a UI label for page preview zoom slider and made Calc cell cursor more accessible for colour blind users
  35. Samuel Mehrbrodt (allotropia) made the removal of meta data more extensive when the option to remove it when saving is active, implemented resizing of Writer comment section, made it so only documents from the current module are shown by default in Recent Documents and fixed an issue with an empty chart title getting unwanted text in imported PPTX files
  36. Thorsten Behrens (allotropia) fixed build issues related to certain libraries, fixed an xpdfimport crash with missing fonts, made MAR-based LibreOffice updater non-experimental and wholesome ODF package encryption the default
  37. Armin Le Grand (allotropia) continued the rework of handling attributes and properties
  38. Oliver Specht (CIB) made it so that upon entering a legacy text fieldmark in Writer, placeholder text gets pre-selected, made sure paper tray settings are respected when importing RTF and DOCX files and made clone formatting switch off lists
  39. Matt K fixed an issue with conditional formatting getting lost when moving Calc sheets around and fixed many crashes
  40. Adam Seskunas added an automated test for moving focus to inserted image in Writer
  41. Arnaud Versini did some code cleanups
  42. Darshan Upadhyay, Jaume Pujantell and Vivek Javiya (Collabora) worked on jsdialog used by Collabora Online. Jaume also made font embedding in DOCX files more robust
  43. Heiko Tietze (TDF) made Template Manager cleaner by hiding useless buttons, made the options in Image compression dialog behave more logically and improved the look of Calc comment indicator
  44. Hossein Nourikhah (TDF) added a minimal Python extension as an example, fixed a JUnit test not running and decreased the maximum number of columns in Calc’s data entry form to prevent performance issues
  45. Skyler Grey (Collabora) added a Calc option to keep edit mode on Enter/Tab, particularly useful for devices with an onscreen keyboard
  46. Gökay Şatır (Collabora) fixed Ignore All not working with LanguageTool spellchecking errors
  47. Omkar Acharekar worked on bringing native Qt widgets to Qt/KDE UI as part of an Outreachy project
  48. Tibor Nagy (allotropia) made Calc support creation of accessible PDFs, fixed many other accessible PDF issues and fixed an issue with table styles in PPTX import
  49. Kurt Nordback fixed an issue with combo chart render order
  50. Marco Cecchetti (Collabora) fixed Calc view invalidation issues
  51. Dennis Francis (Collabora) improved the performance of conditional formatting in Calc
  52. Matthew Kogan fixed an issue with an unwanted space appearing at start of line when field wraps
  53. Kevin Suo made it so Empty and Error entries are shown as non-selected and inactive when hidden by autofilter
  54. Eli Schwartz (Arch Linux) improved the portability of shell scripts
  55. Bayram Çiçek (Collabora) made inactive Calc sheets movable and copyable
  56. Xuan Chen fixed a Java UNO bridge test failure on riscv64 CPU architecture
  57. Winfried Donkers added Excel2021 function XLOOKUP to Calc

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

515 bugs, 76 of which are enhancements, have been reported by 297 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 40 )
  2. Xisco Faulí ( 19 )
  3. Telesto ( 16 )
  4. Mike Kaganski ( 12 )
  5. Tracey ( 10 )
  6. Rafael Lima ( 10 )
  7. Robert Großkopf ( 9 )
  8. Stéphane Guillou (stragu) ( 9 )
  9. Regina Henschel ( 8 )
  10. Justin L ( 8 )

Triaged Bugs

523 bugs have been triaged by 67 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 109 )
  2. Buovjaga ( 80 )
  3. m_a_riosv ( 56 )
  4. Heiko Tietze ( 41 )
  5. Xisco Faulí ( 29 )
  6. Mike Kaganski ( 23 )
  7. Julien Nabet ( 17 )
  8. Rafael Lima ( 14 )
  9. Telesto ( 13 )
  10. V Stuart Foote ( 12 )

Resolution of resolved bugs

456 bugs have been set to RESOLVED.

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

Fixed Bugs

181 bugs have been fixed by 39 people.

Top 10 Fixers

  1. Mike Kaganski ( 21 )
  2. Rafael Lima ( 13 )
  3. Caolán McNamara ( 9 )
  4. Justin Luth ( 8 )
  5. Michael Stahl ( 8 )
  6. László Németh ( 6 )
  7. Tibor Nagy ( 6 )
  8. Heiko Tietze ( 6 )
  9. Samuel Mehrbrodt ( 5 )
  10. Matt K ( 5 )

List of high severity bugs fixed

  1. tdf#155917 Writer crashes when inserting ODT file containing PDF into table in another ODT doc ( Thanks to Michael Stahl )
  2. tdf#158965 Find Record: Similarities dialog won’t appear ( Thanks to Caolán McNamara )
  3. tdf#159243 Armenian characters displaying incorrectly (as boxes) on macOS (fonts not packaged properly) ( Thanks to Christian Lohmaier )
  4. tdf#159386 Selecting all in a certain table causes assert in SfxPoolItem::SetWhich with a debug build ( Thanks to Caolán McNamara )
  5. tdf#73678 FORMATTING: Conditional Formatting lost when Click-drag Sheet2 tab to position 1 or adding, then
16 Jan 2024

LibreOffice 24.2 RC2 is available for testing

LibreOffice 24.2 – with a new year.month versioning scheme – will be released as final at the beginning of February, 2024 ( Check the Release Plan ) being LibreOffice 24.2 Release Candidate 2 (RC2) the forth pre-release since the development of version 24.2 started in mid June, 2023. Since the previous release, LibreOffice 24.2 RC1, 113 commits have been submitted to the code repository and 61 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

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

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!

12 Jan 2024

QA/Dev Report: December 2023

General Activities

  1. LibreOffice 7.5.9 and 7.6.4 were announced on December 7
  2. Olivier Hallot (TDF) updated menu item paths in Help pages and updated and restructured dozens of help pages
  3. Rafael Lima fixed line count width in Writer file properties dialog, added a button leading to Download page in the dialog showing up if trying to access Help without offline files available and made it possible to enter edit mode for comments in Calc via Navigator. He also updated ScriptForge help and added a Help page about installing offline Help
  4. Stanislav Horacek did many fixes and cleanups in Help pages
  5. Ilmari Lauhakangas (TDF) made it so multi-selection is no longer possible in Start Center as it is not actionable. He also streamlined the navigation layout of Help
  6. Stéphane Guillou (TDF) linked Sidebar decks to Help and did other Help updates
  7. Alain Romedenne updated ScriptForge help pages
  8. Dione Maddern updated Help for Draw’s Consolidate Text functionality
  9. Sophia Schröder did many cleanups in Help
  10. Gábor Kelemen (allotropia) added support for XF86Forward / XF86Back key events for use in Impress slideshows and did code cleanups in the area of unused config keys and includes
  11. Laurent Balland did many fixes in Impress templates, collaborating with Jérôme Bouat
  12. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer. He also updated pdfium and did fixes to automated tests
  13. Jean-Pierre Ledure worked on the ScriptForge library
  14. Michael Meeks (Collabora) fixed a deadlock
  15. Szymon Kłos, Áron Budea and Gökay Şatır (Collabora) worked on LOKit used by Collabora Online
  16. Nick Wingate (Collabora) added an option to define ranges when exporting Calc sheets to PDF
  17. Henry Castro (Collabora) made it so an error dialog pops up in Calc, if trying to insert a row after the maximum one
  18. Eike Rathke (Red Hat) fixed an issue with unwanted deletion of data ranges in Calc
  19. Tomaž Vajngerl (Collabora) streamlined the OOXML import of headers/footers in page styles, made handling of embedded SVGs in FODT files more robust and added support for writing SVG images into OOXML using the MS OOXML extension. He also did lots of refactoring in the EditEngine text editing code
  20. Julien Nabet fixed an issue with changing field options in Firebird databases, implemented more user management functionality for MySQL and MariaDB databases, made colour handling more robust in sparklines, fixed an issue with stepped line types in XY scatter charts and fixed StepTime being ignored with AnimatedImages in Basic Dialog (together with bug reporter Jurassic Pork). He also fixed crashes and many issues found by static analysers and did many code cleanups
  21. Andreas Heinisch made Mail Merge more robust with regards to database names
  22. László Németh continued polishing support for smart justify found in DOCX files and fixed an issue with soft hyphens not being displayed in text boxes and shapes
  23. Xisco Faulí (TDF) did many improvements and additions to automated tests and fixed regressions
  24. Michael Stahl (allotropia) revamped ODF encryption resulting in much faster saving and loading, better resistance to tampering, better hiding of metadata and higher resistance to brute forcing. He also fixed a Writer crash related to text formatting of group shapes anchored as character
  25. Mike Kaganski (Collabora) continued polishing the handling and detection of broken ZIP packages (document containers), improved the load time of DOCX files with hundreds of images, fixed issues with incorrect Math formula font size and Escape key not closing formula editor (not in any released version), fixed undoing the first applied cell formatting in Calc, fixed an issue with unwanted extra empty paragraphs appearing after a table before a section break in DOCX files, made line breaking in Writer behave according to Unicode Line Breaking Algorithm rules, fixed an issue with line breaks in justified right aligned text and fixed an issue with applying Calc cell styles. He also fixed many crashes and did many code cleanups and improvements to automated tests
  26. Caolán McNamara (Collabora) optimised Calc’s performance and fixed many issues found by static analysers and fuzzers
  27. Stephan Bergmann (allotropia) worked on the online update feature. He also did many code cleanups and adapted the code to compiler changes
  28. Noel Grandin (Collabora) continued polishing the renovation of bitmap alpha handling. He also did many code cleanups and optimisations
  29. Justin Luth (Collabora) made it so the Select Outline Format split button in the Properties Sidebar deck in Writer now opens Bullets and Numbering dialog and its Outline tab, if you click on the button part, fixed handling of legacy dropdown fields direct bold and char settings in DOCX and RTF files, fixed a page break issues in RTF import, made it so there is no longer a possibility to get into a restart/reinstall loop after installing an extension and fixed an issue with losing selection in Writer after right-clicking the last half character
  30. Michael Weghorn (TDF) made it so listboxes don’t take mouse wheel input, if mouse is not positioned over them and fixed accessibility issues in areas such as heading levels and checkable items. He also did many updates and cleanups to the LibreOffice Android Viewer code
  31. Balázs Varga (allotropia) fixed an issue causing a huge number of unwanted master slides appearing in PPTX import and continued working on proper indications for locked down items in Options
  32. Patrick Luby (NeoOffice) continued improving the scrolling performance on macOS, fixed an issue causing unwanted horizontal scrolling in Calc on macOS, eliminated flickering upon window resizing in macOS with Skia/Metal and fixed clipboard contents causing trouble with clipboard recorders on macOS. He also fixed some macOS crashes
  33. Jim Raykowski made comment threads appear grouped in the Navigator, made images with broken links easier to find in the Navigator and implemented a feature to identify the objects in a layer by hovering with the mouse over layer tabs
  34. Sarper Akdemir (allotropia) added an option to disable active content such as DDE commands and OLE objects
  35. Christian Lohmaier (TDF) fixed a Windows AARCH64 build issue
  36. Chris Sherlock refactored text rendering code
  37. Regina Henschel implemented curved connector routing method used in OOXML files
  38. Sahil Gautam continued polishing the feature for highlighting the current row and column in spreadsheets
  39. Irgaliev Amin improved math formula compatibility with Microsoft Office
  40. Samuel Mehrbrodt (allotropia) did many improvements to the Expert Configuration and macro signature confirmation dialogs and made it so dialog button accelerators work without Alt key on Windows
  41. Thorsten Behrens (allotropia) did code and build cleanups, for example improving build reproducibility
  42. Armin Le Grand (allotropia) continued with the rework of handling attributes and properties
  43. Oliver Specht (CIB) fixed issues with numbering losing its text colour in DOCX import, handling toggled text formatting properties in DOCX files, paragraphs imported without numbering from RTF files, list of Calc comments not updating automatically and checkbox sizes being imported wrong from RTF files
  44. Matt K fixed displaying dialogs in Calc’s full screen mode
  45. Martin Gube added an automated test
  46. Taichi Haradaguchi updated some dependencies
  47. René Engelhard did some build fixes
  48. David Gilbert did code cleanups
  49. Adam Seskunas added an automated test
  50. Andras Timar (Collabora) fixed shape colour not being imported in Visio files
  51. Ricardo Donino ported a Draw Java SDK example to Python
  52. Theppitak Karoonboonyanan added Thai AutoCorrect data
  53. Jonathan Clark made it so BASIC CCur function obeys locale setting
  54. Li Yang improved menu highlight text colour in high contrast mode on Windows
  55. Arnaud Versini did some code cleanups

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

453 bugs, 71 of which are enhancements, have been reported by 283 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 33 )
  2. Telesto ( 17 )
  3. Jérôme ( 16 )
  4. Eyal Rozenberg ( 11 )
  5. Rafael Lima ( 11 )
  6. Xisco Faulí ( 9 )
  7. Stéphane Guillou (stragu) ( 8 )
  8. Tracey ( 6 )
  9. Regina Henschel ( 6 )
  10. William Friedman ( 6 )

Triaged Bugs

412 bugs have been triaged by 64 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 79 )
  2. m.a.riosv ( 58 )
  3. Heiko Tietze ( 27 )
  4. Buovjaga ( 26 )
  5. Julien Nabet ( 23 )
  6. raal ( 21 )
  7. Xisco Faulí ( 19 )
  8. Dieter ( 18 )
  9. ady ( 18 )
  10. V Stuart Foote ( 14 )

Resolution of resolved bugs

438 bugs have been set to RESOLVED.

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

Fixed Bugs

153 bugs have been fixed by 32 people.

Top 10 Fixers

  1. Mike Kaganski ( 14 )
  2. Balazs Varga ( 11 )
  3. Patrick Luby ( 8 )
  4. Julien Nabet ( 8 )
  5. Laurent Balland ( 8 )
  6. Caolán McNamara ( 7 )
  7. Justin Luth ( 6 )
  8. Noel Grandin ( 6 )
  9. Samuel Mehrbrodt ( 6 )
  10. Rafael Lima ( 3 )

List of critical bugs fixed

  1. tdf#154339 Plain text copied to clipboard and pasted to CSV is not saved. ( Thanks to Xisco Fauli )

List of high severity bugs fixed

  1. tdf#123396 LO Writer automatically replaces SVGs embedded in FODT files with an embedded low-resolution PNGs and drops the SVGs from the documents ( Thanks to Tomaž Vajngerl )
  2. tdf#123864 No feedback for screen reader when radio button for underline attribute changes ( Thanks to Michael Weghorn )
  3. tdf#154044 Undoing the first applied cell formatting only works for column A ( Thanks to Mike Kaganski )
  4. tdf#155266 VIEWING / SCROLLING: very laggy jerky scrolling on macOS Intel Writer: scroll lag ( Thanks to Patrick Luby )
  5. tdf#157915 Error UNO type of C++ when running a Basic macro with instruction commitChanges for org.openoffice.Office.Commands/Execute/Disabled ( Thanks to Noel Grandin )
  6. tdf#158223 Charts: Data range will be deleted when deleting following sheet ( Thanks to Eike Rathke )
  7. tdf#158379 Crash when trying to print specific RTF file (macOS) ( Thanks to Patrick Luby )
  8. tdf#158551 Crash in: mdds::mtv::soa::multi_type_vector::cbegin() const on Paste Special with Operation ( Thanks to Julien Nabet )
  9. tdf#33201 UI: Highlight (not select) current row and column in spreadsheet ( Thanks to Sahil )
  10. tdf#60558 FILEOPEN DOCX: floating table w/parallel wrap followed by an inline table doesn’t wrap beside in empty space on right ( Thanks to Miklos Vajna )

List of crashes fixed

  1. tdf#140401 LibreOffice crashed due to custom installed fonts ( Thanks to Patrick Luby )
  2. tdf#156820 Crash when changing color with custom colour picker accessed from overflowing toolbar ( Thanks to Noel Grandin )
  3. tdf#158379 Crash when trying to print specific RTF file (macOS) ( Thanks to Patrick Luby )
  4. tdf#158450 Crash when picking custom colour for column separator line ( Thanks to Caolán McNamara )
  5. tdf#158505 Crash exporting Writer file with bibliography to PDF ( Thanks to Vojtěch Doležal )
  6. tdf#158551 Crash in: mdds::mtv::soa::multi_type_vector::cbegin() const on Paste Special with Operation ( Thanks to Julien Nabet )
  7. tdf#158593 Expert dialog crashes when editing locked down “set” configuration ( Thanks to Stephan Bergmann )
  8. tdf#158686 FILEOPEN RTF Crash when changing to print preview ( Thanks to Miklos Vajna )
  9. tdf#158703 Crash if I use the space bar several times and then punctuation (French Locale) ( Thanks to Mike Kaganski )
  10. tdf#158720 Crash for attribute string search (“oo”, “uno”, “ooname”) in the Expert Configuration dialog ( Thanks to Samuel Mehrbrodt )
  11. tdf#158794 Pasting a DDE link into a footnote / endnote crashes ( Thanks to Mike Kaganski )
  12. tdf#158837 Crash in: int rtl::str::indexOfStr_WithLength(char16_t const*, int, char16_t const*, int) ( Thanks to Noel Grandin )
  13. tdf#158862 LibreOffice crashes when attempting to inspect a UNO object in the Watch Window during debugging after successful initial inspection. ( Thanks to Mike Kaganski )

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

  1. tdf#111969 right-click on right half of last character in selection loses the selection (Writer) ( Thanks to Justin Luth )
  2. tdf#117651 AutoCorrect does not change preexisting text inside /slashes/ to italics, nor change -strikethrough- ( Thanks to Matt K )
  3. tdf#123396 LO Writer automatically replaces SVGs embedded in FODT files with an embedded low-resolution PNGs and drops the SVGs from the documents ( Thanks to Tomaž Vajngerl )
  4. tdf#123864 No feedback for screen reader when radio button for underline attribute changes ( Thanks to Michael Weghorn )
9 Jan 2024

LibreOffice 24.2 RC1 is available for testing

LibreOffice 24.2 – with a new year.month versioning scheme – will be released as final at the beginning of February, 2024 ( Check the Release Plan ) being LibreOffice 24.2 Release Candidate 1 (RC1) the third pre-release since the development of version 24.2 started in mid June, 2023. Since the previous release, LibreOffice 24.2 Beta1, 158 commits have been submitted to the code repository and 59 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

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

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!

13 Dec 2023

LibreOffice 24.2 Beta1 is available for testing

LibreOffice 24.2 – with a new year.month versioning scheme – will be released as final at the beginning of February, 2024 ( Check the Release Plan ) being LibreOffice 24.2 Beta1 the second pre-release since the development of version 24.2 started in mid June, 2023. Since the previous release, LibreOffice 24.2 Alpha1, 425 commits have been submitted to the code repository and 137 issues got fixed. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 24.2 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!

6 Dec 2023

QA/Dev Report: November 2023

General Activities

  1. LibreOffice 7.5.8 was released on November 2
  2. LibreOffice 7.6.3 was released on November 23
  3. Olivier Hallot (TDF) updated menu item paths in Help pages and updated and restructured dozens of help pages
  4. Rafael Lima updated ScriptForge help
  5. Stanislav Horacek updated menu item paths in Help pages alongside other corrections
  6. Ilmari Lauhakangas (TDF) updated Help pages after UI string changes
  7. Gábor Kelemen (allotropia) did code cleanups in the area of unused config keys and includes
  8. Laurent Balland extended ODF to allow lowercase for exponent characters and blank expontent digits and did many fixes in Impress templates
  9. Miklós Vajna (Collabora) worked on multi-page floating tables in Writer. He also did code cleanups and build fixes
  10. Jean-Pierre Ledure worked on the ScriptForge library
  11. Szymon Kłos, Michael Meeks and Marco Cecchetti (Collabora) worked on LOKit used by Collabora Online
  12. Henry Castro (Collabora) made Calc’s background colour autofiltering more robust and added an automated test for PPTX master slides
  13. Attila Szűcs (Collabora) improved FontWork text placement
  14. Skyler Grey (Collabora) continued polishing STYLEREF field support for DOCX compatibility
  15. Eike Rathke (Red Hat) made several improvements to date & time functions and calculations in Calc
  16. Tomaž Vajngerl (Collabora) wrote automated tests in preparation for OOXML header/footer import refactoring
  17. Julien Nabet simplified Hyperlink dialog after FTP support removal, fixed crashes and did many code cleanups
  18. Andreas Heinisch made Hyperlink and Edit Index dialogs remember their changed settings and fixed non-working Reset to Parent button in Paragraph Style dialog
  19. László Németh continued polishing change tracking of case cycling, fixed gtk popup listbox positions in Sidebar under X11, made it so lost linked graphics are shown in Accessibility Checker, fixed lost character background of non-breaking spaces and added support for smart justify found in DOCX files
  20. Xisco Faulí (TDF) did some automated test additions and cleanups
  21. Michael Stahl (allotropia) removed support for FTP, reduced the file size of exported tagged PDFs, made curl use OpenSSL on Linux after a version upgrade removed support for NSS, fixed an issue with disappearing paragraphs before tables in RTF documents, implemented support for \spltpgpar in RTF import (page breaks) and fixed Delete Undo/Redo of bookmark positions
  22. Mike Kaganski (Collabora) made command line arguments accept Windows \\?\ path prefixes, improved the Visual Studio IDE integration, improved the handling of macros in signed documents, fixed Excel’s Range.Find and Range.Replace wildcard recognition, added the ability to detect a broken ZIP package (document container), did some improvements to remote use of LanguageTool and made document repair more robust. He also made some clarifications in Help pages as well as many code cleanups and build fixes
  23. Caolán McNamara (Collabora) optimised the speed of calendar conversions in Calc and made font handling on Linux more robust. He also did code cleanups and optimisations and fixed issues found by code analysers
  24. Stephan Bergmann (allotropia) did many code cleanups, for example in the area of strings and adapted the code to compiler changes
  25. Noel Grandin (Collabora) optimised the speed of spellchecking code and made UI tests easier to debug. He also did many code cleanups and optimisations, for example simplifying the drawing of gradients and creating a Clang plugin that looks for fields on objects that can be local variables
  26. Justin Luth (Collabora) fixed modifying hyperlinks in form controls and made mouse click targeting of hyperlinks in shapes more robust
  27. Heiko Tietze (TDF) made Start Center use system colours and made Quick Find and Find and Replace dialogs use a better icon
  28. Michael Weghorn (TDF) fixed accessibility issues in areas such as button toggling, Spelling dialog and radio buttons. He also did many updates to the LibreOffice Android Viewer, for example making it support Android system theme, resulting in a re-release in Google Play Store
  29. Balázs Varga (allotropia) continued working on proper indications for locked down items in Options
  30. Patrick Luby (NeoOffice) fixed many graphics and UI rendering glitches and improved the scrolling performance on macOS
  31. Jim Raykowski improved Navigator performance, fixed an issue with unwanted direct formatting being applied from Character Properties dialog, fixed an issue with Draw layer visibility settings, made it so sections can be shown as an expandable/collapsible hierarchy in the Writer Navigator and made it possible to protect and hide sections via Navigator
  32. Sarper Akdemir (allotropia) added a password policy and strength meter to Save with Password dialog
  33. Christian Lohmaier (TDF) fixed opening PDF files in the macOS appstore version and improved the MSI packaging code
  34. Chris Sherlock refactored text rendering code
  35. Regina Henschel implemented support for importing Wordprocessing Canvas, wpc:wpc element in DOCX files
  36. Sahil Gautam implemented highlighting the current row and column in spreadsheets
  37. Irgaliev Amin made the buttons in Impress navigation bar scalable
  38. Paris Oplopoios (Collabora) made rendering of conditional formats more robust and made chart background colour match with document colour
  39. Frank Steiner enabled using medium/full font hinting even with subpixel positioning on Linux
  40. Gökay Şatır (Collabora) improved localised keyboard shortcuts
  41. Khushi Gautam modernised the “Flowchart Alternate Process” shape to use circular corner rounding in all sizes
  42. Vasily Melenchuk (CIB) made exported RTF files leaner by dropping unnecessary fallback images for shapes
  43. Samuel Mehrbrodt (allotropia) moved various Impress options to more intuitive places, made it so expert configuration items show descriptions, added proper editing support for numbers in expert config and made lists editable in expert config
  44. Venetia Furtado made it so the Extensions button in Start Center leads to a reasonable URL even from translated interfaces
  45. Thorsten Behrens (allotropia) did code and build cleanups that improve build reproducibility
  46. Armin Le Grand (allotropia) continued with the rework of handling attributes and properties
  47. Oliver Specht (CIB) fixed an issue preventing pasting hyperlinks from PowerPoint to Impress and Draw by adding a new paste option: Simple HTML, implemented handling of paragraph attributes in RTF import and fixed an issue with disappearing footnotes after applying spelling corrections
  48. Matt K fixed an issue with Find and Replace applying the font attributes of the first character in the ‘find’ match to the entire replaced string, added AutoCorrect support for italic and strikethrough, fixed an off-by-one error in AutoCorrect with Track Changes active and made it so empty UNO listeners are not allowed, making macro code stabler
  49. Hossein Nourikhah (TDF) improved and expanded SDK example code and buildability
  50. Gülşah Köse (Collabora) worked on jsdialog used by Collabora Online

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

454 bugs, 63 of which are enhancements, have been reported by 279 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 54 )
  2. Stéphane Guillou (stragu) ( 13 )
  3. Mike Kaganski ( 12 )
  4. Eyal Rozenberg ( 9 )
  5. Jérôme ( 9 )
  6. Kira Tubo ( 8 )
  7. Timur ( 6 )
  8. László Németh ( 5 )
  9. Regina Henschel ( 5 )
  10. David García ( 5 )

Triaged Bugs

482 bugs have been triaged by 71 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 131 )
  2. Buovjaga ( 60 )
  3. m.a.riosv ( 39 )
  4. Heiko Tietze ( 32 )
  5. raal ( 22 )
  6. Mike Kaganski ( 18 )
  7. Julien Nabet ( 17 )
  8. Michael Weghorn ( 16 )
  9. Xisco Faulí ( 13 )
  10. Dieter ( 10 )

Resolution of resolved bugs

479 bugs have been set to RESOLVED.

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

Fixed Bugs

168 bugs have been fixed by 32 people.

Top 10 Fixers

  1. Balazs Varga ( 34 )
  2. Noel Grandin ( 9 )
  3. Mike Kaganski ( 8 )
  4. Michael Weghorn ( 7 )
  5. László Németh ( 6 )
  6. Michael Stahl ( 6 )
  7. Laurent Balland ( 5 )
  8. Andreas Heinisch ( 4 )
  9. Patrick Luby ( 4 )
  10. Jim Raykowski ( 4 )

List of high severity bugs fixed

  1. tdf#158341 FILEOPEN DOCX Endless loop on opening file ( Thanks to Miklos Vajna )

List of crashes fixed

  1. tdf#127547 Freeze/crash in Microsoft Print to PDF dialog when trying to paste (Ctrl-V) a filename in the ‘Save Print Output As’ dialog ( Thanks to Noel Grandin )
  2. tdf#158169 Crash when using multiple Views ( Thanks to Armin Le Grand (allotropia) )
  3. tdf#158171 Crash when double-clicking DeepL translation dialog OK button ( Thanks to Julien Nabet )
  4. tdf#158224 EDITING CRASH Cannot convert bitmap to polygons ( Thanks to Noel Grandin )
  5. tdf#158345 Opening Hyperlink dialog leads to crash ( Thanks to Julien Nabet )
  6. tdf#158459 Crash copying a range with tracked changes to clipboard ( Thanks to Mike Kaganski )

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

  1. tdf#104288 FILESAVE RTF: File size increases with factor 5 after re-saving a certain RTF-document ( Thanks to Vasily Melenchuk )
  2. tdf#108318 Copying a hyperlink into a textbox messes up its frame target ( Thanks to Justin Luth )
  3. tdf#112131 Unable to modify hyperlink target in document ( Thanks to Justin Luth )
  4. tdf#112661 NSAccessibility – RecentFiles button missing accessibility action support equivalent to click/tap inputs. ( Thanks to Michael Weghorn )
  5. tdf#112662 NSAccessibility – Templates button in StartCenter missing accessibility action support equivalent to click/tap inputs. ( Thanks to Michael Weghorn )
  6. tdf#115871 “Reset to Parent” button in Paragraph Style dialog does not revert to parent values for any of the controls in the Outline & List tab ( Thanks to Andreas Heinisch )
  7. tdf#119908 FILEOPEN: DOCX: Layout differences with justified paragraph. MS 2013 introduced a new “smart justify” that can shrink as well as expand. ( Thanks to László Németh )
  8. tdf#125580 Slightly off value when adding date plus time values ( Thanks to Eike Rathke )
  9. tdf#127498 TIMEVALUE() sometimes returns a slightly less or greater than expected value ( Thanks to Eike Rathke )
  10. tdf#127547 Freeze/crash in Microsoft Print to PDF dialog when trying to paste (Ctrl-V) a filename in the ‘Save Print Output As’ dialog ( Thanks to Noel Grandin )
  11. tdf#96401 FILEOPEN: DOCX – Specific file reported as corrupted (openable in MSO but not in other programs because of unzip error, backslash “\” as filename separator) ( Thanks to Mike Kaganski )

WORKSFORME bugs

50 bugs have been retested by 28 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 11 )
  2. Buovjaga ( 6 )
  3. Dieter ( 5 )
  4. Julien Nabet ( 3 )
  5. Timur ( 2 )
  6. BogdanB ( 2 )
  7. Rainer Bielefeld Retired ( 2 )
  8. Steven Casey ( 1 )
  9. ikjt ( 1 )
  10. Heiko Tietze ( 1 )

DUPLICATED bugs

121 bugs have been duplicated by 29 people.

Top 10 testers

  1. Stéphane Guillou (stragu) ( 55 )
  2. Buovjaga ( 14 )
  3. Gabor Kelemen (allotropia) ( 9 )
  4. m.a.riosv ( 6 )
  5. Mike Kaganski ( 5 )
  6. Timur ( 4 )
  7. V Stuart Foote ( 4 )
  8. raal ( 3 )
  9. Justin L ( 2 )
  10. Xisco Faulí ( 2 )

Verified bug fixes

33 bugs have been verified by 8 people.

Top 10 Verifiers

  1. Dieter ( 11 )
  2. Stéphane Guillou (stragu) ( 11 )
  3. Gabor Kelemen (allotropia) ( 4 )
  4. BogdanB ( 2 )
  5. Gerald Pfeifer ( 2 )
  6. Buovjaga ( 1 )
  7. Timur ( 1 )
  8. Julien Nabet ( 1 )

 
 

Categorized Bugs

341 bugs have been categorized with a metabug by 26 people.

Top 10 Categorizers

  1. Stéphane Guillou (stragu) ( 137 )
  2. BogdanB ( 61 )
  3. Buovjaga ( 21 )
  4. Heiko Tietze ( 20 )
  5. Xisco Faulí ( 16 )
  6. Dieter ( 13 )
  7. Eyal Rozenberg ( 12 )
  8. Gabor Kelemen (allotropia) ( 11 )
  9. Jérôme ( 11 )
  10. László Németh ( 9 )

Regression Bugs

50 bugs have been set as regressions by 16 people.

Top 10

  1. Stéphane Guillou (stragu) ( 14 )
  2. m.a.riosv ( 7 )
  3. Xisco Faulí ( 5 )
  4. Gabor Kelemen (allotropia) ( 4 )
  5. Buovjaga ( 4 )
  6. raal ( 3 )
  7. Kira Tubo ( 2 )
  8. ady ( 2 )
  9. Sophie Sipasseuth ( 2 )
  10. W Cole ( 1 )

Bisected Bugs

39 bugs have been bisected by 10 people.

Top 10 Bisecters

  1. Stéphane Guillou (stragu) ( 13 )
  2. Buovjaga ( 6 )
  3. raal ( 6 )
  4. Xisco Faulí ( 5 )
  5. Kira Tubo ( 2 )
  6. BogdanB ( 2 )
  7. Gabor Kelemen (allotropia) ( 2 )
  8. Timur
30 Nov 2023

LibreOffice 24.2 Alpha1 is available for testing

LibreOffice 24.2 will be released as final at the beginning of February, 2024 ( Check the Release Plan ) being LibreOffice 24.2 Alpha1 the first pre-release since the development of version 24.2 started in mid June, 2023. Since then, 4271 commits have been submitted to the code repository and more than 787 bugs were set to FIXED in Bugzilla. Check the release notes to find the new features included in this version of LibreOffice.

LibreOffice 24.2 Alpha1 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!

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!…