LibreOffice 24.8 Alpha1 is available for testing

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

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

Read More

QA/Dev Report: April 2024

General Activities

  1. Olivier Hallot (TDF) added Help content for user interface selection dialog, Calc row recalculation at load time, automatic labeled ranges in Calc and font embedding. He also updated menu item paths in Help
  2. Rafael Lima added support for hidden named expressions in Calc, added Reload command to Notebookbar UIs and made named ranges created by the Solver in Calc hidden by default
  3. Stéphane Guillou (TDF) updated Help content for Navigator’s Navigate By
  4. Alain Romedenne continued improving the officehelper Python script for connecting to LibreOffice processes
  5. Dione Maddern improved Help content for inserting objects from the Gallery and did cleanups in Help
  6. Colton Garrett improved Help content for OpenCL and added a Help page for digital signing of paragraphs
  7. Laurent Balland did style cleanups in Impress templates
  8. Miklós Vajna (Collabora) fixed an issue with shape positioning in DOCX import and did many code cleanups
  9. Áron Budea (Collabora) fixed an issue with unwanted spacing in printed text
  10. Marco Cecchetti, Gökay Şatır, Pranam Lashkari, Szymon Kłos and Michael Meeks (Collabora) worked on LOKit used by Collabora Online
  11. Attila Szűcs (Collabora) continued improving the performance of handling transparent animated GIFs
  12. Tomaž Vajngerl (Collabora) improved the text scaling in Impress text boxes, implemented support for custom cell format of pivot table output found in OOXML and did many code cleanups and restructurings
  13. Julien Nabet added gssapi authentication support for the MariaDB/MySQL connector, fixed UI issues in Writer’s Paragraph dialog related to the “Allow to split paragraph” option, fixed crashes and did code cleanups
  14. Xisco Faulí (TDF) continued the implementation of SVG filters
  15. Michael Stahl (allotropia) changed the handling of paragraph and text attributes in empty lines at the end of paragraphs to match the behaviour seen in Microsoft Word
  16. Mike Kaganski (Collabora) fixed issues with rotated text being partially cut off, made it possible to create DDE links to files with special characters in their names on Windows, made the Basic LIKE operator more robust, fixed an issue preventing Windows users with special characters in their names from importing PDF files into Draw, made the position shifting behaviour more robust for objects anchored As Character in Writer, fixed an issue with chapter titles in headers/footers getting mixed up due to headings in endnote content, fixed handling of em and ex units in the properties of imported SVG files, improved the stability of text part positioning in SVG files, fixed handling of whitespace in SVG text, fixed a Draw issue causing font colour to not be retained in certain situations and restored HTML map export for text hyperlinks in frames. He also did many code cleanups and optimisations
  17. Caolán McNamara (Collabora) continued improving performance of threaded calculation in Calc. He also fixed crashes and many issues found by static analysers and fuzzers
  18. Stephan Bergmann (allotropia) worked on WASM build, added a new Expert Configuration setting to not offer Safe Mode in the UI, fixed the msvc_win32_arm64 UNO bridge and worked on Windows Subsystem for Linux support. He also did many code cleanups and adapted the code to compiler changes
  19. Noel Grandin (Collabora) did a big restructuring allowing optimisations to writerfilter which is responsible for RTF and OOXML file support, continued improving the speed of print preview with large merged rows in spreadsheets, improved the speed of loading conditional formatting rules in XLS files and changed to a faster algorithm for generating selection overlays. He also did many code cleanups and optimisations
  20. Justin Luth (Collabora) fixed an issue with paragraph style overrides in imported DOCX files, fixed an issue with protected cell ranges not exporting to XLSX correctly, made parsing of cell addresses in XLSX import more robust, fixed a UI glitch in Groupedbar Compact related to pivot tables and made the z-index of VML GroupShapes import correctly from DOCX files
  21. Michael Weghorn (TDF) worked on the accessibility features of Windows, GTK3 and GTK4 UIs in areas such as toolbar button toggles and Navigator, made IME cursor position reporting more reliable and fixed an issue with form control help texts showing up where they shouldn’t with kf5 UI
  22. Balázs Varga (allotropia) made it possible to do character formatting in chart text elements and included OOXML support for the formatting, continued polishing XLOOKUP and SORT function implementations and added Excel2021 array function SEQUENCE to Calc
  23. Patrick Luby fixed a macOS hang caused by JDBC driver extension, fixed PDF export of presentations containing PDF images, fixed an issue with cursor leftovers being displayed when using Skia/Metal UI rendering on macOS and made SVG icon rendering respect Retina resolution on macOS
  24. Jim Raykowski made fixes and optimisations to Navigator in Impress/Draw context, including fixing an update glitch after saving and reloading and made it possible to delete footnotes and endnotes using the Navigator in Writer
  25. Sarper Akdemir (allotropia) reworked Presenter Notes in Impress, so they are now available as a collapsible pane under the slide in Normal view and made it so mouse scrolling fully visible slides/pages in Impress/Draw switches between the previous/next one
  26. Samuel Mehrbrodt (allotropia) worked on Impress Presenter Notes pane together with Sarper, made it so text formatting toolbar gets enabled when focusing into a text box and ensured text is properly aligned when tabstop is outside of textbox
  27. Armin Le Grand (allotropia) continued polishing support for editing Impress slides during presentation and continued the rework of handling attributes and properties
  28. Oliver Specht (CIB) improved the dialog for managing user fields, made it so Cycle Case will be applied to the sentence if the cursor is at the sentence end and implemented support for DOCVARIABLE fields in imported DOC files
  29. Arnaud Versini did cleanups in locale handling code
  30. Heiko Tietze (TDF) did improvements to several dialogs and made it so the cell focus rectangle in Calc appears outside the active cell
  31. Taichi Haradaguchi updated Help content after UI changes, updated external library versions and did many UI string fixes and cleanups
  32. Vasily Melenchuk (CIB) fixed a crash in Writer Navigator
  33. Vivek Javiya (Collabora) extended the easy conditional formatting dialog in Calc
  34. László Németh added DOCX import support for hyphenate-keep, added a Hyphenation Across option into Paragraph dialog’s Text Flow tab in Writer, made it possible to resize table rows even if cursor is outside the table in Writer and made Writer table cell selection and resizing more robust when dealing with images in cells
  35. Ilmari Lauhakangas (TDF) removed obsolete reserved shortcuts and improved documentation for the related code
  36. Gábor Kelemen (allotropia) fixed some dialog settings not being remembered across sessions and did code cleanups in the area of code simplification and includes
  37. Ritobroto Mukherjee added sinusoidal and coil-like shapes and ported Java TerminationTest ODK example to C++
  38. Christian Lohmaier (TDF) worked on build support under Windows Subsystem for Linux
  39. Moritz Duge (allotropia) optimised the loading of GPG key data
  40. AntonyDas Nadar (Collabora) enabled accessibility for comboboxes in Sidebar
  41. Thorsten Behrens (allotropia) made editing Impress slides during presentation non-experimental
  42. Khushi Gautam implemented the Sidebar Quick Find deck in Writer as part of an Outreachy project
  43. Gabriel Masei (1&1) improved CSV field separator detection when several separators are selected on import
  44. Mohit Marathe added UI to set document properties TabsRelativeToIndent and TabOverMargin
  45. Sujatro Bhadra replaced AutoFormat button with table style listbox in Writer’s Convert Text to Table dialog
  46. Eike Rathke (Red Hat) added [Multiple] and [Undetermined] to language list
  47. Leonid Ryzhov made LanguageTool use correct default URL when username/API key are set
  48. Jonathan Clark (TDF) worked on making BreakIterator (for breaking words or lines) use ICU
  49. Juan C. Sanz made it possible to connect to MS Access .mdb files by using Microsoft.ACE.OLEDB.12.0 provider
  50. Kira Tubo added several automated tests for Writer
  51. Zeph Chai ported ChartInDraw and ChartInWriter ODK examples to Python
  52. Sahil Gautam extended Insert Cells Dialog to allow adding a set of rows/columns and made the cell background change when entering edit mode in Calc
  53. Ahmed Hamed improved the conditional formatting dialog by replacing the static “>=” with a dropdown of different operators
  54. Luv Sharma made the handling of “#” characters more robust in Basic
  55. Jakub Kościelak did fixes to the Windows installer and improved the presentation of the Windows version string in Help – About dialog (based on earlier work by Joel Dowdy and Achintya Sharma)
  56. Alex Henrie added missing file types to Linux desktop files
  57. Todor Balabanov improved the accuracy of the comparison code in NLP Solver

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

410 bugs, 67 of which are enhancements, have been reported by 260 people.

Top 10 Reporters

  1. Gabor Kelemen (allotropia) ( 16 )
  2. Telesto ( 14 )
  3. Mike Kaganski ( 12 )
  4. Heiko Tietze ( 10 )
  5. Stéphane Guillou (stragu) ( 10 )
  6. Eyal Rozenberg ( 9 )
  7. Xisco Faulí ( 8 )
  8. Tyler ( 7 )
  9. peter josvai ( 7 )
  10. Cor Nouws ( 5 )

Triaged Bugs

398 bugs have been triaged by 66 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 61 )
  2. m_a_riosv ( 48 )
  3. Heiko Tietze ( 47 )
  4. Buovjaga ( 27 )
  5. Dieter ( 21 )
  6. V Stuart Foote ( 21 )
  7. Mike Kaganski ( 20 )
  8. raal ( 14 )
  9. Xisco Faulí ( 14 )
  10. ady ( 12 )

Resolution of resolved bugs

430 bugs have been set to RESOLVED.

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

Fixed Bugs

149 bugs have been fixed by 37 people.

Top 10 Fixers

  1. Mike Kaganski ( 19 )
  2. Michael Stahl ( 7 )
  3. Noel Grandin ( 7 )
  4. Heiko Tietze ( 6 )
  5. Patrick Luby ( 6 )
  6. Jim Raykowski ( 5 )
  7. Xisco Fauli ( 5 )
  8. Balazs Varga ( 5 )
  9. László Németh ( 4 )
  10. Michael Weghorn ( 4 )

List of high severity bugs fixed

  1. tdf#154581 Paragraph language and character formatting (bold, italic) lost when pasting HTML ( Thanks to Michael Stahl )
  2. tdf#160016 Inserted GIF flipped vertically; previews in Gallery and Fontwork dialog flipped or mangled ( Thanks to Tomaž Vajngerl )
  3. tdf#160444 Crash on closing the 3D-Effects Window ( Thanks to Patrick Luby )
  4. tdf#160632 TABLE: Crash when using column width dialog ( Thanks to Noel Grandin )
  5. tdf#160698 Crash after opening Print dialog ( Thanks to Tibor Nagy )
  6. tdf#58434 Show formatting marks when displaying non-printing characters +F10, rather than field shading +F8 (for formatting marks as in comment 18) ( Thanks to Heiko Tietze )

List of crashes fixed

  1. tdf#159379 Writer crashes when multiple images are drag-and-dropped “As Character” (steps in comment 8) ( Thanks to Miklos Vajna )
  2. tdf#159683 Crash on closing LibreOffice with certain content on the clipboard ( Thanks to Miklos Vajna )
  3. tdf#159719 SfxItemPool::IsInRange crash: save and reload in Impress or Draw ( Thanks to Armin Le Grand (allotropia) )
  4. tdf#160444 Crash on closing the 3D-Effects Window ( Thanks to Patrick Luby )
  5. tdf#160590 Impress crashes with skia Metal enabled, skia raster software rendering works (MacOS Monterey (12.7.4) w/Intel HD Graphics 6000) ( Thanks to Patrick Luby )
  6. tdf#160632 TABLE: Crash when using column width dialog ( Thanks to Noel Grandin )
  7. tdf#160698 Crash after opening Print dialog ( Thanks to Tibor Nagy )
  8. tdf#160765 EDITING: Insert comment – Copy – Paste Comments – Undo – Show comment -> LO crash ( Thanks to Andreas Heinisch )
  9. tdf#160768 Changing value in a text box control with a link cell set up, Crash ( Thanks to Noel Grandin )
  10. tdf#160827 Crash on opening certain .docx files ( Thanks to Julien Nabet )

List of performance issues fixed

  1. tdf#160399 Print Preview freezes with whole row merged in large spreadsheet ( Thanks to Noel Grandin )
  2. tdf#160706 speed up loading conditional formatting rule in XLS ( Thanks to Noel Grandin )

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

  1. tdf#107081 LOCALHELP: Index: backgrounds;inserting form Gallery ( Thanks to Dione Maddern )
  2. tdf#108057 Primary key should default to AutoValue=Yes when type is integer ( Thanks to Mike Kaganski )
  3. tdf#132253 CHARACTER DIALOG: Drop hyperlink from character attributes ( Thanks to Olivier Hallot )
  4. tdf#132599 Option to stop words hyphenating across pages

Read More

QA/Dev Report: March 2024

General Activities

  1. LibreOffice 7.6.6 and LibreOffice 24.2.2 were released on March 28
  2. Olivier Hallot (TDF) renamed Fontwork to Text along Path in the UI while updating Help, added Help content for ExportAsFixedFormat VBA method and new Calc functions FILTER, SORT and SORTBY and did several cleanups and fixes in Help
  3. Rafael Lima made several improvements to Calc’s Solver dialog, improved the visual consistency of the Tabbed UI and added a warning about the need to reload file after changing macro security level
  4. Stéphane Guillou (TDF) updated Help content after UI changes and improved the Help page for macro security
  5. Alain Romedenne made many improvements to the officehelper Python script for connecting to LibreOffice processes
  6. Dione Maddern rewrote the Help page for Calc’s SUMIF function, updated Help for Writer’s View options and did cleanups in Help
  7. Gábor Kelemen (allotropia) did many cleanups in the area of includes while improving the script for finding unneeded includes. He also made some Help fixes
  8. Pierre F. made many improvements and fixes to Help pages, for example in the areas of regular expressions and Basic
  9. Andras Timar (Collabora) made Help build more robust on Windows and made some cleanups in Help regarding translatable strings
  10. Laurent Balland updated Grey Elegant Impress template
  11. Miklós Vajna (Collabora) improved copying and pasting between Google Sheets and Calc and did many code cleanups and improvements to automated tests
  12. Áron Budea, Marco Cecchetti, Gökay Şatır, Pranam Lashkari, Jaume Pujantell and Michael Meeks (Collabora) worked on LOKit used by Collabora Online
  13. Gülşah Köse (Collabora) made it so pressing Enter in an empty list item ends the list in Impress
  14. Attila Szűcs (Collabora) improved the performance of handling transparent animated GIFs and made it so image placeholders imported from PPTX files do not display text
  15. Tomaž Vajngerl (Collabora) did many code cleanups in graphics code
  16. Julien Nabet fixed incorrect display of custom page numbers in Sidebar, fixed an issue with duplicating a sheet in Calc causing unwanted axis label to appear in charts and fixed some crashes
  17. Andreas Heinisch fixed an issue with saving print ranges to XLS files
  18. Xisco Faulí (TDF) made a dozen additions and changes to automated tests and added a script to replace missing fonts in test documents. He also improved SVG support by implementing overflow:visible, switch element and the filters feMerge, feMergeNode, feBlend and feComposite.
  19. Michael Stahl (allotropia) made the Curl-based WebDAV content provider more robust
  20. Mike Kaganski (Collabora) fixed issues with copying and pasting charts in Calc, fixed an issue causing incorrect closing tags in Writer HTML export, fixed an issue affecting conditional formatting in overlapping cell ranges, made canceling out of Insert Chart dialog more robust in case of multiple views, fixed an issue with picking a connection type in Database Wizard, fixed an issue in the UNO API implementation for text ranges, harmonised the rounding in Calc’s number formatter and ROUND function and made it so index field names can be single characters which is good news for Japanese users
  21. Caolán McNamara (Collabora) improved the performance of threaded calculation in Calc, fixed an issue with Calc’s currency selection dropdown in GTK UIs, improved dark mode support and made “Always autocorrect to” more robust. 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) improved loading time for PPTX files with lots of unused master slides, improved loading time for DOCX files with lots of headers and footers, optimised the handling of columns in Calc, improved the speed of print preview with large merged rows in spreadsheets. He also did many code cleanups
  24. Justin Luth (Collabora) made the new global config option RecalcOptimalRowHeightMode also work for XLSX files, fixed a crash when trying to overwrite file in read-only directory when its lock file exists, fixed an issue with z-ordering of objects in DOCX files, fixed image placement issues in DOC/DOCX files, made searching backwards for end of paragraph regex work in Writer, fixed an issue causing unwanted toggling of Ordered List button and made it so frame text boundary line in Writer is only shown if display of formatting marks is active
  25. Michael Weghorn (TDF) fixed HiDPI scaling with KF6/Qt6 UIs under Wayland and worked on the accessibility features of GTK4 UI
  26. Balázs Varga (allotropia) added Excel2021 array functions FILTER, SORT and SORTBY to Calc, fixed issues with chart rendering in XLSX files, improved the performance of Calc’s SUMPRODUCT function and fixed an issue with objects not shown in slideshow in a PPTX file if they have fillstyle or linestyle
  27. Patrick Luby (NeoOffice) fixed issues related to the transparency-to-alpha rework, fixed a Skia issue related to a changed default, fixed horizontal swiping and scrolling when using an RTL UI, made it possible to encrypt files with using public GPG keys with unknown Ownertrust on macOS and fixed macOS crashes
  28. Jim Raykowski fixed an issue preventing use of keyboard shortcuts when focused into a tab bar element in the Sidebar, fixed an issue with text selection over pages for multi column tables with repeated headings, improved the name display of custom shapes in the Navigator in Impress/Draw and added a UNO API command to set layer of objects in Draw
  29. Sarper Akdemir (allotropia) made it so a reload is not required for embedded objects to be disabled
  30. Regina Henschel worked on extruded/3D shape support in PPTX files
  31. Samuel Mehrbrodt (allotropia) improved the accessibility checker
  32. Armin Le Grand (allotropia) continued polishing support for editing Impress slides during presentation and continued the rework of handling attributes and properties
  33. Oliver Specht (CIB) made it possible to insert an empty paragraph before an index that is the first element in a Writer document, made Clone Formatting more robust in Impress, added a search field to Gallery and made Cycle Case also work at the end of words
  34. Arnaud Versini did some code cleanups and optimisations
  35. Heiko Tietze (TDF) made Infobar close buttons easier to hit, made Bullets and Numbering dialog cleaner, improved dark mode support and added a “What’s new?” dialog to be shown on first run of a major version
  36. Hossein Nourikhah (TDF) worked on Developers Guide examples and fixed updating hyperlinks in Draw
  37. Tibor Nagy (allotropia) fixed an issue with disappearing text in merged Calc cells and fixed a placeholder box being too tall in PPTX files
  38. Kurt Nordback finished adding a chart type for “pie-with-remainder-as-another-pie” and fixed an issue where stacked column charts did not show connection lines
  39. Taichi Haradaguchi did some cleanups in dialog definition files
  40. Vasily Melenchuk (CIB) improved the code for WinAPI FlashWindow() function that alerts the user about an event in an application
  41. Hubert Figuière (Collabora) worked on jsdialog used by Collabora Online
  42. David Gilbert did code cleanups in PDF import code
  43. Jean-Pierre Ledure worked on the ScriptForge library
  44. Leonard Sasse did many cleanups in Python files
  45. Fridrich Štrba fixed building with Java 8 and autoconf 2.72
  46. Vivek Javiya made heading colours dynamic in Calc, allowing for automatic adjustment
  47. László Németh fixed hyphenation at stem boundary by adding a new hyphenation option “Compound characters at line end” and implemented hyphenate-keep paragraph property to keep both parts of a hyphenated word within a single page
  48. Adlair Cerecedo-Mendez added LibreOffice minor version and CPU architecture to PDF metadata
  49. Skyler Grey (Collabora) improved animating of bullets in presentations exported as SVG
  50. René Engelhard (Debian) did build fixes
  51. Sahil Gautam made hyperlinks accessible via keyboard

Kudos to Ilmari Lauhakangas for helping to elaborate this list.

Reported Bugs

468 bugs, 82 of which are enhancements, have been reported by 297 people.

Top 10 Reporters

  1. peter josvai ( 20 )
  2. Stéphane Guillou (stragu) ( 17 )
  3. Rafael Lima ( 12 )
  4. Telesto ( 11 )
  5. Jeff Fortin Tam ( 10 )
  6. Gabor Kelemen (allotropia) ( 9 )
  7. prrvchr ( 8 )
  8. Michael Otto ( 7 )
  9. Kevin Suo ( 6 )
  10. Mike Kaganski ( 6 )

Triaged Bugs

469 bugs have been triaged by 73 people.

Top 10 Triagers

  1. Stéphane Guillou (stragu) ( 149 )
  2. V Stuart Foote ( 29 )
  3. m_a_riosv ( 28 )
  4. Heiko Tietze ( 22 )
  5. Buovjaga ( 20 )
  6. Julien Nabet ( 15 )
  7. Mike Kaganski ( 15 )
  8. Rafael Lima ( 15 )
  9. dunguyen ( 14 )
  10. ady ( 14 )

Resolution of resolved bugs

429 bugs have been set to RESOLVED.

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

Fixed Bugs

143 bugs have been fixed by 35 people.

Top 10 Fixers

  1. Mike Kaganski ( 12 )
  2. Caolán McNamara ( 12 )
  3. Julien Nabet ( 8 )
  4. Justin Luth ( 7 )
  5. Pierre F ( 6 )
  6. Xisco Fauli ( 6 )
  7. Patrick Luby ( 6 )
  8. Rafael Lima ( 6 )
  9. Balazs Varga ( 5 )
  10. Noel Grandin ( 5 )

List of critical bugs fixed

  1. tdf#160036 Selection invisible in a11y High Contrast modes with SKIA/Raster, Skia/Vulkan unaffected ( Thanks to Patrick Luby )
  2. tdf#160095 CRASH: using ALT+RETURN twice ( Thanks to Julien Nabet )

List of high severity bugs fixed

  1. tdf#142133 Hyperlinks cannot be clicked / interacted with in PDF export of RTF or DOCX files (comment 9) ( Thanks to Xisco Fauli )
  2. tdf#152524 macOS: LibreOffice crashes (gpgme / gpgmeio) on macOS 13 Ventura ( Thanks to Patrick Luby )
  3. tdf#154863 Crash when moving images around in a multipage table ( Thanks to Matt K )
  4. tdf#157258 “Always autocorrect to” deletes the word instead of replacing (affects extensions like Grammalecte, LanguageTool, Antidote) ( Thanks to Caolán McNamara )
  5. tdf#159094 FILESAVE PDF Tagged PDF export of media file fails to create PDF ( Thanks to Tibor Nagy )
  6. tdf#159373 Crash in: ScTable::HasAttrib(short,long,short,long,HasAttrFlags) ( Thanks to Julien Nabet )
  7. tdf#159931 Exported pptx cannot be opened in PowerPoint because a referenced part does not exist ( Thanks to Sarper Akdemir )
  8. tdf#160149 CRASH: undoing conditional format ( Thanks to Mike Kaganski )
  9. tdf#160184 allow to “Encrypt with GPG key” on save using public keys with unknown Ownertrust ( Thanks to Patrick Luby )
  10. tdf#160365 Writer: unable to turn off “text boundaries” for frames / tables ( Thanks to Justin Luth )
  11. tdf#83720 PIVOTTABLE: Wrong date format in column field ( Thanks to Tomaž Vajngerl )
  12. tdf#93352 UI. RTL: Horizontal scrolling for right-to-left Sheet moves in opposite direction (macOS and Linux) ( Thanks to Patrick Luby )

List of crashes fixed

  1. tdf#152524 macOS: LibreOffice crashes (gpgme / gpgmeio) on macOS 13 Ventura ( Thanks to Patrick Luby )
  2. tdf#154072 crash / no effect when clicking some dropdown buttons when toolbar overflows ( Thanks to Caolán McNamara )
  3. tdf#154863 Crash when moving images around in a multipage table ( Thanks to Matt K )
  4. tdf#158344 FILEOPEN DOCX Crash on opening file ( Thanks to Miklos Vajna )
  5. tdf#158945 Calc: crash when entering text in a cell ( Thanks to Julien Nabet )
  6. tdf#159373 Crash in: ScTable::HasAttrib(short,long,short,long,HasAttrFlags) ( Thanks to Julien Nabet )
  7. tdf#159879 Crash when closing “3D View” dialog ( Thanks to Xisco Fauli )
  8. tdf#159933 crash when applying Solarize filter to raster image ( Thanks to Noel Grandin )
  9. tdf#160095 CRASH: using ALT+RETURN twice ( Thanks to Julien Nabet )
  10. tdf#160149 CRASH: undoing conditional format ( Thanks to Mike Kaganski )
  11. tdf#160192 CRASH when trying to overwrite file in read-only directory when its lock file exists ( Thanks to Justin Luth )
  12. tdf#160222 LibreOffice 7.6.5 – SF_Session RunApplication crash for unknown reason ( Thanks to Jean-Pierre Ledure )
  13. tdf#160368 Crash on save after deleting sheet ( Thanks to Caolán McNamara )

List of performance issues fixed

  1. tdf#159687 Cutting rows from specific file with whole column references in formula is slow ( Thanks to Balazs Varga )

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

  1. tdf#103068 New Database Wizard gets confused between ODBC and JDBC connection if you backup twice to step 1. ( Thanks to Mike Kaganski )
  2. tdf#116156 Python // officehelper.py misbehaves since 5.3.7 ( Thanks to Alain Romedenne )
  3. tdf#126464 Remove “Numbering on/off” UNO command

Read More

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 additions 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

Read More