head 1.3; access; symbols pkgsrc-2025Q2:1.2.0.8 pkgsrc-2025Q2-base:1.2 pkgsrc-2025Q1:1.2.0.6 pkgsrc-2025Q1-base:1.2 pkgsrc-2024Q4:1.2.0.4 pkgsrc-2024Q4-base:1.2 pkgsrc-2024Q3:1.2.0.2 pkgsrc-2024Q3-base:1.2 pkgsrc-2024Q2:1.1.0.4 pkgsrc-2024Q2-base:1.1 pkgsrc-2024Q1:1.1.0.2 pkgsrc-2024Q1-base:1.1; locks; strict; comment @// @; 1.3 date 2025.08.30.06.44.05; author ryoon; state dead; branches; next 1.2; commitid YqLowkUvtqHXJI8G; 1.2 date 2024.08.24.02.57.35; author ryoon; state Exp; branches; next 1.1; commitid fXA5jidb9Xpyq1nF; 1.1 date 2024.02.11.15.31.58; author ryoon; state Exp; branches; next ; commitid 5LZobZ6t3IyWR1YE; desc @@ 1.3 log @misc/libreoffice: Update to 25.8.1.1 Changelog: 25.8: Writer * Move line hyphenation rule is added to choose whether or not to hyphenate the last line words of the pages and move the whole lines to the next pages instead (blog post). See also interoperability with MSO 2016 and later in Filters (this development was funded through the NGI0 Entrust Fund, a fund established by NLnet Foundation with financial support from the European Commission??s Next Generation Internet programme). (L??szl?? N??meth) tdf# 165354 * While hyphenating text, there is an option to move the whole last line to the next page in order to avoid splitting the last word in the page (another case in file details 'File history' section). While hyphenating text, there is an option to move the whole last line to the next page in order to avoid splitting the last word in the page (another case in file details 'File history' section). * Paragraph, column, page and spread end zones (blog post) (L??szl?? N??meth) * Minimum, desired and maximum word spacing feature (blog post) (L??szl?? N?? meth) * First and secondary keys are shown in the tooltips of index fields. (Andreas Heinisch) tdf#143157 * For Heading entries, Navigator now displays a tooltip with the outline word and character count that includes all sub-outline words and characters. (Jim Raykowski) tdf#163646 * Tooltip with the outline word and character count that includes all sub-outline words and characters Tooltip with the outline word and character count that includes all sub-outline words and characters * A command was added to insert a paragraph break before a table: ".uno:BreakAboveTable". (Ujjawal Kumar) tdf#149825 * It is now easier to control how text is selected while scrolling the view. (Oliver Specht, CIB) tdf#50743 * A dialog was added for copying the content of a field from a read-only document. (Oliver Specht, CIB) tdf#164318 * Dialog for copying the content of a field from a read-only document * A new field that displays the page count for a range until the next numbering reset was added. (Oliver Specht, CIB) tdf#71583 * A command (with the shortcut Ctrl?+??? Shift?+?F2) was added for converting fields into plain text. (Oliver Specht, CIB) tdf#45946 * Per-window track changes recording in Writer (blog post). (Miklos Vajna, Collabora) * It is now possible to 'reinstate' changes in Writer (reject with history, blog post). (Miklos Vajna, Collabora) * Support for interdependent tracked changes is now improved (blog post blog post 2). (Miklos Vajna, Collabora) * An option to redact images was added in the Auto-Redact dialog Tools ? Auto-Redact ? Add Target. (Karthik Godha) tdf#139331 * Select 'All Images' from the dropdown menu in the 'Add Target' dialog to redact images. Select 'All Images' from the dropdown menu in the 'Add Target' dialog to redact images. * It is now possible to set the language of certain punctuation characters in Writer. (Jonathan Clark, TDF) tdf#66791 tdf#166011 tdf#166012 * In some cases, Writer will treat punctuation as a different language than intended. This can now be controlled by selecting the text and setting the correct language. In some cases, Writer will treat punctuation as a different language than intended. This can now be controlled by selecting the text and setting the correct language. Accessibility * There is now an accessibility check for links and references in header/ footer. (Bal??zs Varga, Collabora) tdf#164797 Performance * A certain heavy DOC file inspired optimisations to the loading of language data and laying out of graphical objects. (Noel Grandin, Collabora) tdf# 141415 * Loading Writer documents with change tracked moves is now faster. (Noel Grandin, Collabora) tdf#162343 * Undo handling was optimised, making the deletion of very large Writer tables much faster. (Noel Grandin, Collabora) tdf#136238 * Loading of Writer tables containing bookmarks was made faster. (Mike Kaganski, Collabora) tdf#165918 * Large right-to-left Writer documents are faster to open. (Noel Grandin, Collabora) tdf#64991 Calc * Text Import dialog, that is used in CSV import, now has Always show on import checkbox (enabled by default). This checkbox controls, if the dialog will be shown on CSV import, or if the saved (configured on last dialog use) settings will be used automatically. When the checkbox is unchecked, and the dialog is normally not shown, it is possible to show it (once), using a new Edit filter settings checkbox in the File Open dialog, which works the same way as long-existing respective checkbox in File Save dialog: it gets enabled, when a file format, that has configurable settings, is selected in the filter frop-down list. (Shardul Vikram Singh) tdf#74580 * Text Import dialog now has checkbox to always show on CSV import. Text Import dialog now has checkbox to always show on CSV import. * Conditional formatting operators in icon sets can now be customised. (Ahmed Hamed) tdf#61313 * Conditional formatting operators in icon sets can now be customised. Conditional formatting operators in icon sets can now be customised. * A "Clear AutoFilter" option was added to the context menu of Calc cells. (Ujjawal Kumar) tdf#164322 * "Clear AutoFilter" option. "Clear AutoFilter" option. * Text Import dialog is now only shown for Paste Special actions to avoid unnecessary interruptions. (Shardul Vikram Singh) tdf#65872 New functions * CHOOSECOLS function was added. (Xisco Faul??, TDF) tdf#151000 * CHOOSEROWS function was added. (Xisco Faul??, TDF) tdf#150999 * DROP function was added. (Xisco Faul??, TDF) tdf#150998 * EXPAND function was added. (Xisco Faul??, TDF) tdf#151001 * HSTACK function was added. (Xisco Faul??, TDF) tdf#150868 * TAKE function was added. (Xisco Faul??, TDF) tdf#150997 * TEXTAFTER function was added. (Xisco Faul??, TDF) tdf#150865 * TEXTBEFORE function was added. (Xisco Faul??, TDF) tdf#150864 * TEXTSPLIT function was added. (Xisco Faul??, TDF) tdf#150866 * TOCOL function was added. (Xisco Faul??, TDF) tdf#150879 * TOROW function was added. (Xisco Faul??, TDF) tdf#150878 * VSTACK function was added. (Xisco Faul??, TDF) tdf#150867 * WRAPCOLS function was added. (Xisco Faul??, TDF) tdf#150881 * WRAPROWS function was added. (Xisco Faul??, TDF) tdf#150880 Performance * Speed of rendering XLSX files with lots of conditional formatting was improved. (Noel Grandin, Collabora) 185df5e6 * Speed of opening XLSX files with lots of conditional formatting was greatly improved. (Noel Grandin, Collabora) tdf#134864 * Speed of opening XLSX files with lots of graphical objects was significantly improved. (Noel Grandin, Collabora) tdf#130326 tdf#150623 * Row height calculation when switching Calc sheets was optimised, greatly reducing the waiting time in complex spreadsheets. (Noel Grandin, Collabora) tdf#150623 * Switching Calc sheets with lots of drawing objects is now much faster. (Noel Grandin, Collabora) tdf#131595 * Spellchecking performance in multi-language spreadsheets was improved (Caol ??n McNamara, Noel Grandin; Collabora) 9a1f131a 3c7156da * Handling large charts in Calc is now much faster when loading, toggling edit mode and switching sheets. (Noel Grandin, Collabora) tdf#147874 tdf# 151876 * The loading speed of XLSX files with lots of customFormat attributes in rows was improved. (Noel Grandin, Collabora) tdf#163015 * The loading speed of XLSX files with lots of formulas, conditional formatting and comments was greatly improved. (Noel Grandin, Collabora) tdf #166684 * The performance of working with spreadsheets with lots of comments was improved. (Noel Grandin, Collabora) tdf#161372 Impress * Ctrl?+?scrollwheel changes how many slides are displayed per row in the Slide Sorter view. (Oliver Specht, CIB) tdf#117946 * Embedded fonts in PPTX files are now supported. (Toma? Vajngerl, Collabora) faf45f80 d0ee08cf * Better algorithm to determine is a font is used and needs to be embedded when exporting to PPTX (Toma? Vajngerl, Collabora) 777ff280 * Master Slides in Impress and Master Pages in Draw can now be copied. (Mohamed Ali) tdf#45617 Draw * Boundaries are shown for page margins; disable with the expert option Draw::Misc::TextObject::ShowBoundary (Heiko Tietze, TDF) tdf#89420 * Draw page boundaries. Draw page boundaries. Core / General * A new application-wide Viewer mode is implemented. In it, all files are opened in read-only mode; all editing tools are disabled. The mode is controlled by the new "ViewerAppMode" expert configuration. (Mike Kaganski, Collabora) tdf#62845 * On Windows, the automatic (??MAR??) update mechanism now only registers its update_service.exe as a Windows ??LibreOffice Maintenance Service?? (that allows to do updates with administrator privileges) when LibreOffice is installed to C:\Program Files. (Stephan Bergmann, Collabora) tdf#164225 tdf #162780 * Background image in the document now visible as a bitmap thumbnail in Page Style ? Area ? Bitmap. (Justin Luth) tdf#125969 * Background image now visible as a bitmap thumbnail. Background image now visible as a bitmap thumbnail. * SHA384 with AES_192 is now taken into account, it allows for example to open more encrypted files. (Julien Nabet) tdf#166241 * PDF signature timestamping on document export now requires a single cryptographic signature computation instead of two. A PIN code must therefore be entered at most once in the process. (Juraj ?arinay) tdf# 147452 * The format of PDF documents signed on export is now compatible with Adobe Reader. (Juraj ?arinay) tdf#121133 * OLE objects, such as Charts in Calc, can now be resized proportionally with or without ?? Shift key in edit mode (same behavior as other shape objects). Moreover, moving OLE objects in edit mode by dragging the border is forced to 45?? direction if ?? Shift is pressed. (Laurent Balland) tdf# 163816 * Resizing a chart in edit mode preserves height/width ratio with handles in corner; ?? Shift key toggles behavior. Resizing a chart in edit mode preserves height/width ratio with handles in corner; ?? Shift key toggles behavior. Filters * Autofilters are now imported from MS Excel XML files. (Kohei Yoshida) tdf# 154311 * Encrypted hybrid PDFs can now be imported. (David Gilbert) tdf#55425 * Display of Chinese, Japanese, and Korean DOC/DOCX documents is significantly more accurate. (Jonathan Clark, TDF) tdf#88908 tdf#83844 tdf# 80596 * Add layout interoperability of hyphenated DOCX documents created in MSO 2016 and later: Move only hyphenated word across pages and columns (not full line, as in the previous MSO 2013 interoperability fix), (blog post), see also the associated ODF extension and user interface developments (this development was funded through the NGI0 Entrust Fund, a fund established by NLnet Foundation with financial support from the European Commission??s Next Generation Internet programme). (L??szl?? N??meth) tdf#165354 * DOCX multilevel numbering fixed. (Michael Stahl, Collabora) tdf#166975 * DOCX multilevel numbering compared DOCX multilevel numbering compared PDF 2.0 Support for exporting PDF 2.0 (ISO 32000-2) was added (Toma? Vajngerl, Collabora) * Implemented modern AES-256 encryption that is mandatory with PDF 2.0. * Added PDF/A-4 support, which is using PDF 2.0 as the base. * Rearranged the PDF Export UI to more logically combine the sections (Forms). * Combined the PDF and PDF/A versions into one drop-down. * Added new structure elements (/Em /Strong /Title) * Added /AFRelationship for the embedded files. * In hybrid mode the embedded ODF document is marked as source. * Rearranged PDF export dialog showing PDF 2.0 as the output version. Rearranged PDF export dialog showing PDF 2.0 as the output version. User Interface * Edit Field dialog can be opened in read-only documents. (Oliver Specht, CIB) tdf#164318 * Formatting toolbar is visible in sections that are marked as editable in read-only documents. (Tibor Nagy, Collabora) tdf#146549 * Currency dropdown no longer requires clicking an OK button. (Szymon K??os, Collabora) tdf#165589 * Quick Find bar now has an option to match diacritics. (Johann Lorber, Linagora) tdf#163616 * Match Diacritics in Quick Find bar. Matches "atencao" and "aten??o" Match Diacritics in Quick Find bar. Matches "atencao" and "aten??o" * A toggle button to show the password in password input dialogs was added. (Bal??zs Varga, Collabora; Karthik Godha) tdf#146947 * Toggling rotation mode for a selected object can now be done with a single click in Writer and Calc and not only in Impress and Draw. (Oliver Specht, CIB) tdf#90293 * LibreOffice document windows as well as the Start Center will now toggle into and out of native macOS full screen mode by pressing a window's green title button. (Patrick Luby) tdf#128186 * LibreOffice's Window menu now includes the window positioning and arrangement menu items that Apple added in macOS Sequoia. (Patrick Luby) tdf#165448 * Welcome/WhatsNew dialog offers access to the UI picker and the appearance options (Heiko Tietze, TDF) tdf#137931 * The UI picker View ? User Interface... allows to activate toolbars (Heiko Tietze, TDF) tdf#158880 * Activate toolbars in user interface picker. Activate toolbars in user interface picker. Accessibility * Menus in the File ? Templates ? Manage Templates dialog are now screen reader accessible on Windows. (Michael Weghorn, TDF) tdf#157001 * Support for the IAccessible2 "text-indent" attribute was added, which can be used by assistive technology like screen readers to report the indent of a paragraph's first line (the NVDA screen reader on Windows supports that from NVDA version 2025.1 on). (Michael Weghorn, TDF) tdf#164795 * The table design view in Base (Tables ? Create Table in Design View...) no longer becomes unresponsive when a screen reader is active on Windows. (Michael Weghorn, TDF) 8a919d02 * Comboboxes and other controls inside toolbars are now also represented in the accessibility tree of the application. (Michael Weghorn, TDF) tdf# 163989 Changes in UI strings Scripting * The version of the internal Python is 3.11.13. * Ship pip with internal python. (Xisco Fauli, TDF) tdf#162786 The ScriptForge libraries An extensible and robust collection of macro scripting resources for LibreOffice to be invoked from user Basic or Python scripts. (Jean-Pierre Ledure) The libraries expose a total of 33 services each with a bunch of methods and properties. New in LibreOffice 25.8: * The new calc.XRectangle(rangename) property returns the coordinates (in pixels) on the screen where the given range is located. This opens the door to effective use of popup menus. See Wiki: popup menu. * The translation in Spanish is now available (B. Antonio Fern??ndez). * The calc.Intersect(range1, range2) method computes the common area of 2 input ranges. * With the contextmenu.RemoveAllItems() method, you can opt for configuring a totally customized context menu. Example in Wiki: context menu. * To avoid duplicates, the document.MenuHeaders property lists the menus present in the menubar. * The Calc service now hosts new formatting methods (AlignRange, BorderRange, ColorizeRange, DecorateFont and FormatRange). See an example on Wiki: format range. * TabPageContainer controls may now be inserted in dialogs by code. Page switching in dialogs: Wiki: tabbed pages. * Still in dialogs, the dialog.ImportControl() method copies controls between dialogs: Wiki: building compound dialogs * The new platform.UntitledPrefix property provides the prefix used to name new documents. This can make macros more language agnostic. * The Exception service is revised : the ReportScriptErrors, StopWhenError, ReturnCode and ReturnCodeDescription properties let the author of scripts decide what ScriptForge should do when an error is detected by the software. * The ui.CreateBaseDocument() let you define, in addition to HSQLDB, FIREBIRD and CALC (embedded) databases, also the type FIREBIRD_EXTERNAL. * The new calc.DefinedNames property associated with the calc.DefineName() method lets you manage defined names both at sheet and global levels. The whole set of services (except when better done by native built-in functions) is made available for Python scripts with identical syntax and behavior as in Basic. @ text @$NetBSD: patch-include_comphelper_errcode.hxx,v 1.2 2024/08/24 02:57:35 ryoon Exp $ --- include/comphelper/errcode.hxx.orig 2024-08-22 12:18:16.158178965 +0000 +++ include/comphelper/errcode.hxx @@@@ -25,6 +25,7 @@@@ #include #include #include +#include #if defined(DBG_UTIL) #if __has_include() @ 1.2 log @misc/libreoffice: Update to 24.8.0.3 Changelog: 24.0.8.3: Writer * Performance of rendering text in CJK writing systems with font fallback was improved. (Jonathan Clark, TDF) tdf#81272 * The width of the Comment panel can now be adjusted. (Samuel Mehrbrodt, allotropia) tdf#73953 tdf#159145 * Bullets used in the document can now be selected in the bullets dropdown. (Samuel Mehrbrodt, allotropia) tdf#161056 * Improve support for multi-page floating tables. blog post. (Miklos Vajna, Collabora) * Legal numbering in Writer: DOC and RTF support blog post. (Miklos Vajna, Collabora) * Fixed an issue with shape positioning in DOCX import for RTL paragraphs. (Miklos Vajna, Collabora) tdf#160833 * Improved continuous endnotes to be based on sections, now enabled by default for all DOCX, DOC and RTF documents. blog post (Miklos Vajna, Collabora) tdf#160984 * Formatting characters are now treated independently from fields following toggle for non-printable characters (aka Pilcrow / Ctrl+F10), keeping and respecting the settings under Tools Options > Writer > Formatting Aids, and visualized all in blue. (Heiko Tietze, TDF) tdf#58434 tdf#161196 * Appearance of various formatting characters Appearance of various formatting characters * The hyperlink tab was removed from character properties. Please use the dedicated dialog instead. (Heiko Tietze, TDF) tdf#132253 * A formatting aid was added to enclose selected text with parentheses, square brackets, curly braces or quotation marks when pressing the respective opening character. Configured using Tools Options > Writer > Formatting Aids > Enclose with characters. (Yi?it Ak?ay) tdf#151710 * Style spotlight only applies to styles that are used in the document. (Jim Raykowski) tdf#158992 * Table Alignment and Left/Right spacing can be changed via the Sidebar. (Oliver Specht, CIB) tdf#159662 * Hyperlink names show as tooltips. (Tibor Nagy, allotropia) tdf#159899 * New "Find" deck in the Sidebar, which lists the results of a quick search along with their context. The shortcut Alt+9 is assigned to it. (Khushi Gautam) tdf#95405 * Quick Find deck in Sidebar Quick Find deck in Sidebar Navigator * Insert various types of cross-references by drag-and-dropping items from the Navigator to the document, which pops up a list of options that apply to the content type. This feature replaces the "Drag mode" button (which only offered "Insert as Hyperlink/Link/Copy"). (Note that for an unsaved document, this feature only supports Bookmarks and Sections.) (Jim Raykowski) tdf#36310 * It is now possible to delete footnotes and endnotes using the Navigator. (Jim Raykowski) tdf#160598 * Headings display flat in the Navigator when sorted alphabetically. (Jim Raykowski) tdf#160657 * Navigator now has an indicator for images with broken links. (Jim Raykowski) tdf#158114 Hyphenation Exclude words from hyphenation Format > Character... > Position > Exclude from Hyphenation is the first and ODF-compliant solution to disable the hyphenation of selected words in hyphenated paragraphs without losing spell checking and locale-dependent text layout. blog post. (L??szl?? N??meth) tdf#106733 * With the new "Exclude from hyphenation" formatting in paragraph 3, the word "?kobio" keeps spell checking and text layout: "?" (O with umlaut) gets wide dots only in German because of locale-dependent font features of Linux Libertine (Display G). Disabled hyphenation of the word "?kobio" in paragraph 2 and 3. Using the old workaround in paragraph 2 (modifying language of the word to [None]) resulted lost text layout and spell checking. With the new "Exclude from hyphenation" character formatting in paragraph 3, the word "?kobio" keeps spell checking and text layout: "?" (O with umlaut) gets wide dots only in German because of locale-dependent font features of Linux Libertine (Display G). "No Break" context menu and visualization Hyphenated words got a new context menu item "No Break" to disable their hyphenation using the new ??Exclude from hyphenation?? character formatting. (The context menu item remains available for the words with disabled hyphenation to enable their hyphenation again.) (L??szl?? N??meth) tdf#161563 Words with disabled hyphenation are visualized with light gray dotted underline in Show Formatting Marks mode. tdf#161565 * New "No Break" context menu of hyphenated words, and light gray dotted underline visualization of words with disabled hyphenation. (Note: no visualization for the previous workaround, the word with language setting "None" in the second paragraph.) New "No Break" context menu of hyphenated words, and light gray dotted underline visualization of words with disabled hyphenation. (Note: no visualization for the previous workaround, the word with language setting "None" in the second paragraph.) Hyphenation across page By disabling Format Paragraph... > Text Flow > Hyphenation across options, both parts of a hyphenated word shall lie within a single column, page or spread. blog post. (L??szl?? N??meth) tdf#132599 * By disabling Column (which disables also Page and Spread), Writer moves the last hyphenated line of the column or page to the next column or page, similar to the default behavior of MSO 2013 and newer. * By disabling only Spread, Writer moves the last hyphenated line of the right pages to the next page (a spread is a set/pair of a left and a right page, which can be seen simultaneously, for instance when opening a book), according to New Hart's Rules (Oxford University Press, 2005). * By disabling Page, last hyphenated line of every page moves to the next page. * By disabling Last full line of paragraph, the hyphenated word of the last full line of the paragraph moves to the last line (if there is enough place for it). This results in longer last lines, and removed hyphenation in the bottom right-hand corner of the paragraph. * Disabling Hyphenation across Page, last hyphenated line ("except that it has at-") was shifted to the next page. Note: clean-up ??Don??t hyphenate...?? options to ??Hyphenate??, similar to MSO and DTP. Disabling Hyphenation across > Page, the last hyphenated line of the page ("except that it has at-") was shifted to the next page. Note: also prior "Don't hyphenate..." options were moved to the end of the hyphenation settings, negating them to "Hyphenate" (similar to MSO and DTP). Compound constituent characters at line end In Format > Paragraph... > Text Flow > Compound characters at line end, set 3 (or more) characters to improve the hyphenation in Danish, Dutch, German, Hungarian, Norwegian and Swedish by preferring the hyphenation between constituents of a compound word instead of breaking the second (third, etc.) constituent right after its first 2 (or more) characters. (L??szl?? N??meth) tdf#158885 For example, German "Computerprogramm" can be hyphenated as "Computerpro -gramm", but setting 4, only "Computer-programm", according to its compound constituents "Computer|programm". This can be useful for better typography, especially in headings or left-aligned text. Calc * Define ranges when exporting sheets to PDF. (Nick Wingate, Collabora) 13bd849f * Improve localization for the status bar and the sidebar with multiple views. blog post. (Miklos Vajna, Collabora) * The sheet protection dialog is async. (Hubert Figui?re, Collabora) e86c6423 * Add FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY, UNIQUE functions. (Bal??zs Varga, allotropia) tdf#126573 OASIS OFFICE-4156 OASIS OFFICE-4157 OASIS OFFICE-4158 * Add LET function. (Bal??zs Varga, allotropia) tdf#137543 * Add XLOOKUP function. (Winfried Donkers) (Bal??zs Varga, allotropia) tdf# 127293 OASIS OFFICE-4154 * Add XMATCH function. (Bal??zs Varga, allotropia) tdf#128425 OASIS OFFICE-4155 * Improve copy and paste between Calc and Google Sheets. blog post. (Miklos Vajna, Collabora) tdf#159483 * Improve threaded calculation performance. Lockless Number Formatting and optimized reference counting. (Caol??n McNamara, Collabora) tdf#160056 * Optimize redraw after a cell change by minimizing the area that needs to be refreshed. (Caol??n McNamara, Collabora) 9bc2872d * In multi-window view of a spreadsheet, allow spell-checking enabled in one window while disabled in another. (Caol??n McNamara, Collabora) 7ecf1c5a * Comments can now be deleted from the Navigator's right-click menu. (Rafael Lima) tdf#158704 * AutoFill can now be called via UNO commands without needing to use the mouse. (Bayram ?i?ek, Collabora) 35c93c5f * Improvements to the comment indicator in Calc. Use the expert setting NoteIndicator with values above 1 to have a fix size for the indicator. (Heiko Tietze, TDF) tdf#158958 * Cell focus rectangle moved apart from cell content. (Rafael Lima) (Heiko Tietze; TDF) tdf#143733 * Cell focus rectangle outside the cell Cell focus rectangle outside the cell * Support importing and exporting OOXML pivot table (cell) format definitions, which allow direct formatting of the pivot table cells (which survive pivot table update). (Toma? Vajngerl, Collabora) * Pivot table looks different when import of pivot table cell formats is supported Pivot table looks different when import of pivot table cell formats is supported * AutoFilter now has a Lock checkbox to prevent losing an unapplied selection when searching. (Sahil Gautam) tdf#133836 * Displaying comment authorship metadata is now optional. (Heiko Tietze, TDF) tdf#156885 * Data validity can now be made case-sensitive. (Bal??zs Varga, allotropia) tdf#157657 * Comments can be edited by right-clicking them in the Navigator. (Rafael Lima) tdf#158514 * The cell cursor was made more accessible to colour blind users. (Sahil Gautam) tdf#158891 * Sheet > Insert Cells now allows adding more than one row or column at a time. (Sahil Gautam) tdf#80390 * New option to denote with background color if the active cell is in Edit Mode (Tools > Options > LibreOffice Calc > View > Edit Cell Highlighting). (Sahil Gautam) tdf#63374 * Format > Conditional > Icon Set is now more flexible, offering a number of operators from a dropdown instead of only the static ">=". (Ahmed Hamed) tdf#61313 * Comparison operators from a dropdown. Comparison operators from a dropdown. Impress * Notes are now available as a collapsible pane under the slide in Normal view. This can be turned on with View > Notes Pane. (Sarper Akdemir, allotropia) tdf#33603 * View menu expanded, with "Notes Pane" highlighted. The Notes pane is visible below the slide. Notes pane in Normal view * By default, the running Slideshow Presentation is immediately updated when applying changes in EditView or in PresenterConsole, even on different Screens. It can be switched on/off using Slide Show > Slide Show Settings... > Live-mode slideshow editing. (Armin Le Grand, allotropia) * Show text formatting toolbar when editing a text box in second toolbar row. (Samuel Mehrbrodt, allotropia) dee3e2d7 * The default number of slides per row, that is used in the Slide Sorter ( View > Slide Sorter) can now be set in Expert Configuration (Tools > Options > LibreOffice > Advanced > Open Expert Configuration) - search property SorterSlidesPerRow. Previously this number was hard coded. (Cor Nouws, Collabora) tdf#160601 * Default number of slides per row in Sorter can now be set in Expert Configuration. Default number of slides per row in Sorter can now be set. * Bundled Templates: refactoring of the templates from Indonesian community (Candy, Freshes, Grey Elegant, Growing Liberty and Yellow Idea) to replace dummy texts with localized placeholders to ease user workflow. (Laurent Balland) tdf#160712 * Fixed dummy texts (Lorem Ipsum) were replaced with placeholders. Fixed dummy texts (Lorem Ipsum) were replaced with placeholders. * A dialog was added for jumping to a specific slide or page in Impress and Draw. (Akshay Warrier) tdf#159372 * Pressing Enter in an empty list item ends the list. (G??l?ah K?se, Collabora) tdf#160213 * Scrolling between slides is now possible in Normal view. (Sarper Akdemir, allotropia) tdf#38164 * PPTX files with heavy use of custom shapes now open faster. (?ron Budea, Collabora) tdf#148616 Draw * Support was added for tiling patterns in imported PDF files. (David Gilbert) tdf#113050 * Hovering over a layer's tab highlights the objects it contains. (Jim Raykowski) tdf#157255 * Three layers highlighted by hovering over a layer's name. The object's colours are inverted when highlighted. Base * Firebird: Saving of data should be done automatically. (Juan C. Sanz) tdf# 117118 * Firebird: Solved DATALOSS Data updated (new/edit) using the data Beamer window or Dataform in odt/ods files when they are closed. (Juan C. Sanz) tdf#117513 * Connect to MS Access mdb files by means of "ACE.OLEDB.12.0" provider. (Juan C. Sanz) tdf#158056 tdf#43187 tdf#137252 tdf#157561 Chart * New chart types "Pie-of-Pie" and "Bar-of-Pie" break down a slice of a pie as a pie or bar sub-chart respectively. This also enables import of such charts from OOXML files created with Microsoft Office / 365. (Kurt Nordback) tdf#50934 * A Bar-of-Pie chart breaking down the Australian Energy mix for the year 2021-2022 A Bar-of-Pie chart breaking down the Australian Energy mix for the year 2021-2022 * Text inside chart's titles, text boxes and shapes (and parts thereof) can now be formatted with the Character dialog (available with the Character button in the Formatting toolbar, with the right-click context menu, or with the top-bar menu: Format > Character). This allows, for example, to use subscripts and superscripts in formulas annotating the chart. (Bal??zs Varga, allotropia) tdf#39052 tdf#58038 Math Core / General * Diacritics no longer being clipped on screen. (Jonathan Clark) tdf#152024 * The "Special Characters" dialog allows typing the Unicode (U+NNN) to filter the matching glyphs. (Mike Kaganski, Collabora) tdf#111816 * The recent document list will now only show documents for the current module (Writer only showing text documents, Calc only showing spreadsheets, etc). The change simply toggles the ShowCurrentModuleOnly setting from False to True, and can be changed back in Expert Configuration. (Samuel Mehrbrodt, allotropia) tdf#159120 * The user is now notified of the need to reload the document to take into account a change in Macro Security Level. (Rafael Lima) tdf#159985 * LevelBar widget is now implemented for JSDialog. (Hubert Figui??re, Collabora) 460a7103 * Although it was already possible to type their ISO 639-2 codes by hand, " [Multiple]" (mul) and "[Undetermined]" (und) are now listed at the top of language lists (along with "[None]", zxx). (Eike Rathke, Red Hat) tdf# 160256 * Chinese and Japanese word selection is now based on ICU rules. Issues can be reported on the ICU website. (Jonathan Clark, TDF) tdf#49885 * New "Sinusoid" shape added to the Basic Shapes category. (Ritobroto Mukherjee) tdf#50998 * New sinusoid shape New sinusoid shape * There is now an option to disable active content and OLE Automation in Tools > Options > LibreOffice > Security > Security Options and Warnings. (Sarper Akdemir, allotropia) tdf#158375 * Buttons that control Font, Highlight and Background colors now retain their value between sessions. (Andreas Heinisch) tdf#72991 * Improved WebDAV/HTTP UCP authentication with Microsoft SharePoint, depending on server configuration. (Michael Stahl, allotropia) d7492813 * Improved CMIS UCP authentication with Microsoft SharePoint, depending on server configuration. (Michael Stahl, allotropia) d2d97395 * The MAR-based automatic update available on TDF Windows builds is no longer experimental-mode--only. See Tools > Options > Online Update > Automatic Update. (Stephan Bergmann, allotropia) * Objects can now be searched in the Gallery sidebar deck. (Oliver Specht; CIB) tdf#81880 * Search box filtering for object names that contain the string "check". Search box filtering for object names that contain the string "check". Filters * If the option Tools > Options > LibreOffice > Security > Options > Remove personal information on saving is enabled, then personal information will not be exported. This includes author names and timestamps (created, modified, printed), editing duration, printer name and config, the template associated with a document, as well as author and date information for comments and tracked changes. (Samuel Mehrbrodt, allotropia) + ODF: c479944e ba891193 + ODS/UOS: 2d60017a + OOXML: 1e49f469 + RTF: 16c7a6f7 63b46c21 09c5cdfe + DOC: 21120ae0 b6cdd1d7 + PPT: a298ba36 + PPTX: 5fe7062f + XLS(X): 9d0d9d8a 0acac1a2 * Writer can now retain the default page style's background when saving as DOCX. (Justin Luth, Collabora) tdf#126533 SVG * Support feMerge, feComposite and feBlend. (Xisco Fauli, TDF) tdf#159660 tdf #160171 tdf#160721 tdf#160726 tdf#160782 ODF Wholesome Encryption A new mode of password-based ODF encryption has been implemented, with the following advantages: * more performant due to deriving a key only once per package * more tamper-resistant with authenticated encryption (AES-GCM) * better hiding of metadata to reduce information leaks * higher resistance to brute forcing using memory-hard Argon2id key derivation function (Michael Stahl, allotropia) tdf#105844 Warning: Warning.svg You will need LibreOffice 24.2 to open these encrypted files. To disable this feature, change Tools . Options . Load/Save . General . ODF format version to a version that is not "Extended". User Interface * The default bullet selection can now be modified. (Samuel Mehrbrodt, Tibor Nagy; allotropia) tdf#108697 tdf#69724 * The Keep Ratio setting in the Position and Size dialog was made more intuitive. (Heiko Tietze, TDF) tdf#158531 Accessibility * Buttons and combo boxes in Writer's Navigator now set the properties needed for proper announcement by screen readers. (Michael Weghorn, TDF) tdf# 159910 * Toggling formatting like bold or italic in Writer is now announced by the NVDA screen reader (version 2024.3 or newer). (Michael Weghorn, TDF) tdf# 160695 * Previously incorrect position-reporting of UI elements on the accessibility layer when using the GTK 3 UI variant on Linux was fixed, which, for example, makes GNOME Magnifier reliably show the right portion of the screen while typing when zoom is enabled on Wayland. (Michael Weghorn, TDF) tdf#159369 * For the GTK 3 UI variant on Linux, a problem resulting in an incorrect accessibility tree being reported was fixed, improving announcement by the Orca screen reader. (Michael Weghorn, TDF) tdf#160806 * Accessibility for comboboxes has been improved. (Michael Weghorn, TDF) tdf# 160971 Changes in UI strings * The legacy Fontwork command in Impress and Draw was renamed to Text along Path. (Olivier Hallot, TDF) tdf#94535 * The label "Structure:" in the Function Wizard dialog has been changed to "Content:". (Bayram ?i?ek, Collabora) tdf#161502 * Organizer was renamed to General in style dialogs. (Samuel Mehrbrodt, allotropia) tdf#161388 Scripting JavaScript * Rhino was updated to 1.7.14 version. The Rhino JavaScript Debugger window is removed with this change. (Stephan Bergmann, allotropia) 58c4457a Basic IDE * New Color Scheme dialog to pick one of six syntax highlighting color schemes independently from the current Application Colors. Find it in View . Color Scheme. (Rafael Lima) tdf#156925 * Color Scheme dialog opened, with the "Breeze Dark" scheme selected and applied to the code in the background. Color Scheme dialog in action * The current line in Basic Editor now has a highlight color for better visibility. (Rafael Lima) tdf#158750 * The visibility status of the UI elements Object Catalog, Watched Expressions and Call Stack (which can be toggled in the View menu) is now remembered after closing and reopening the Basic IDE. (Rafael Lima) tdf# 155381 * Clicking the line number in the status bar will open the Go to Line dialog. (Rafael Lima) tdf#158749 * A command was added for toggling code block commenting. (Rafael Lima) tdf# 140004 ScriptForge * Advanced Python IDE's like PyCharm or VSCode utilize type hints to offer autocomplete suggestions during code writing by analyzing type annotations and combining them with the code context. Type hints, also referred to as type annotations, are comments embedded in the code specifying the data types of variables, parameters, and return values. Python scripts may benefit from the support of type hints when using the ScriptForge API. (Jean-Pierre Ledure) c5e0c65b * Documentation popup appearing when hovering a ScriptForge method in the PyCharm Community IDE Documentation popup appearing when hovering a ScriptForge method in the PyCharm Community IDE Command Line * For Impress files, the --show parameter can now take an optional = {slide-number} to specify at which slide the slideshow should start. For example, start a slideshow directly at the fifth slide with: libreoffice --show=5 presentation.odp. (Justin Luth, Collabora) tdf#69192 Android Viewer Localization Changes to locale data * For the English (South Africa) {en-ZA} and other South African {*-ZA} locales, the decimal separator was changed to period dot (".", previously comma ",") and the group separator was changed to comma (",", previously the space character). This is done in order to align with common practices and the latest changes in the Unicode Common Locale Data Repository (CLDR). (Eike Rathke; Red Hat, Inc.) tdf#159829 @ text @d1 1 a1 1 $NetBSD: patch-include_comphelper_errcode.hxx,v 1.1 2024/02/11 15:31:58 ryoon Exp $ @ 1.1 log @misc/libreoffice: Update to 24.2.0.3 * Disable generation and installation of multi language help files to reduce package size and build time. Changelog: 24.2.0.3: Writer * "Legal" ordered list numbering: make a given list level use Arabic numbering for all its number parts. tdf#150408 (Mike Kaganski, Collabora) * Comments can now use styles, the "Comment" paragraph style being the default one. This makes it easier to modify the formatting of all comments at once, or to visually categorise different types of comments. tdf#103064 * Improve first page headers/footers OOXML import: Use first page property in the existing page style instead of creating a new page style just for the first page. tdf#136472 (Toma? Vajngerl, Collabora) Navigator * Linkable elements can now be drag-and-dropped from the Navigator onto a text selection to use the selection as the hyperlink text. tdf#156111 (Jim Raykowski) * Nested Sections can now be collapsed just like Headings (tdf#158103) and can be hidden or made visible from their context menu (tdf#157681). (Jim Raykowski) * In Outline Folding mode, the hidden headings are now greyed out in the Navigator instead of not being visible. tdf#156282 (Jim Raykowski) * Comments in a thread are now grouped in the Navigator. tdf#157729 (Jim Raykowski) Multi-page floating tables Support for multi-page floating tables was improved in various aspects: * Overlap control, border and footnotes: blog post (Miklos Vajna, Collabora) * Nesting: blog post (Miklos Vajna, Collabora) * Wrap on all pages: blog post (Miklos Vajna, Collabora) * UI improvements: blog post (Miklos Vajna, Collabora) Templates * Templates with the required settings for Japanese text added to the Localization category. This increases interoperability with Microsoft Word for Japanese users. tdf#86483, core commit feeb3a46 (Jun Nogata) New line break algorithm for interoperability Since 2013, the non-proprietary, metric-compatible alternative fonts are no longer guaranteed the same paragraph layout, because MS Word 2013 and later introduced a new default line breaking algorithm for justified text. To fix the lost interoperability, the same algorithm has been implemented in Writer to reduce spaces within justified lines by up to 20%. tdf#119908 blog post (L??szl ?? N??meth, donor: NLnet). For example, the 2-page test document in Writer has been reduced to one page, just like in MS Word, as visible on the following composite image (red text typeset by MS Word, which covered by the black text typeset by LibreOffice Writer). After the development, the red MS Word text is visible only at high magnification next to the black Writer letters, as the line breaks are already exactly the same: Note: used only for DOCX interoperability yet (including for ODT files which are converted from new DOCX files with space shrinking), but planned to be the default justification algorithm of the next major versions of LibreOffice. Calc * New search field in the Functions sidebar deck. tdf#122718 (Rafael Lima) * Number format: scientific format now supports and saves to ODF (tdf#153993 and tdf#156449 Laurent Balland) + embedded text, with number format such as ###.000 E0 + lower case for exponent, with number format such as ###.000e0 + exponent with blank '?' instead of '0', with number format such as 0.00E+?0 * Font is live-previewed again: it is temporarily applied on the selected cell(s) by hovering or navigating in the font dropdown (sidebar or toolbar). tdf#158320 (Caol??n McNamara, Collabora) * Shortcuts to switch sheets now work to cycle from last to first (Ctrl?+?Tab ?? or Ctrl?+?Page Down; ? Cmd?+?Tab ?? or ? Cmd?+?Page Down) and vice versa (Ctrl?+??? Shift?+?Tab ?? or Ctrl?+?Page Up; ? Cmd?+??? Shift?+?Tab ?? or ? Cmd?+?Page Up;). tdf#156311 (Denis Sorotnik) Column/Row Highlighting for Active Cell * Highlight the row and column for the active cell. tdf#33201 (Sahil Gautam) * Accessible through Tools ? Options ? LibreOffice Calc ? View, or through the menu entry View ? Column/Row Highlighting Impress * Implemented Small Caps for Impress: details in blog post. tdf#98367 (Caol?? n McNamara, Collabora) Slide Show Settings * The setting "Show navigation panel" in Slide Show ? Slide Show Settings... will now be saved to local configuration. tdf#157788 (Amin Irgaliev, Vladislav Tarakanov) * Moved Presenter console and Remote control settings from Tools ? Options ? LibreOffice Impress to Slide Show ? Slide Show Settings.... Additionally, the labels and dialog layout has been improved. tdf#135089 core commit 7ca9c5bd (Samuel Mehrbrodt, allotropia) * Additionally, there is a new check box so that the Bluetooth Remote control server can be enabled without also enabling the (currently insecure) WiFi server. core commit aee059ff (Michael Stahl, allotropia) Templates * Fixed Impress templates where incorrect fonts were selected for CJK and CTL. core commit 3adf0 (Jun Nogata) * Numerous improvements and fixes to templates (Laurent Balland, with contributions from J??r?me Bouat): + fixed blue elements on slide and in sidebar; + added and improved placement of various placeholders; + fixed order of slides; + made images lighter; + made fonts and formatting more consistent; + fixed styles and their hierarchy; + removed unnecessary markup; + improved ODF compliance; + fixed font declaration issues; + fixed preview size in Notes view; + made it easier to use them in a different language than English; + moved credits to appropriate location. + Relevant reports and commits: tdf#122080 tdf#158017 tdf#158022 tdf# 158202 tdf#158203 tdf#158204 tdf#158205 tdf#158206 tdf#158230 tdf# 158250 tdf#158488 core commit 619500d6 core commit d103f4af core commit f1f8fd84 core commit 23c300a0 core commit a9ad36ae Draw * Draw now imports multi-page TIFF files (i.e. a TIFF file with several subfiles) placing one image per page. tdf#155444 (Rashesh Padia, Collabora) Base Chart Math * Support setting and rendering a formula's Right-to-Left direction. tdf# 134193 (Khaled Hosny, TDF) * Support Arabic and Persian operators and symbols. tdf#111705 (Khaled Hosny, TDF) * The Math font can now be changed in Format ? Fonts... (default is OpenSymbol). tdf#101174 (Khaled Hosny, TDF) * Tools ? Special Character... is now available in the Formula editor. tdf# 32418 (Khaled Hosny, TDF) * Inline (Visual) formula editing mode is now enabled by default, graduated from experimental mode feature core commit 2d47c824 (Khaled Hosny, TDF) Core / General * A new calendar-based numbering scheme (YY.M.Patch) is introduced since this release. This will help users to more easily see how current their installed version of LibreOffice is. * Changes in automatic saving of documents: "Save AutoRecovery information" is turned on by default, as well as "Always create backup copies". Backup copies accumulate in the folder specified by Tools ? Options ? LibreOffice ? Paths. Both settings can be turned off in Tools ? Options ? Load/Save ? General ? Save. tdf#152463 (Bogdan Buzea) * Fixed many AutoRecovery limitations and re-enabled AutoSave UI. Added "Place backup in same folder as document" option. tdf#65509 tdf#68565 tdf# 57414 (Mike Kaganski / Justin Luth, Collabora) * Fixed various Notebookbar paper cuts: lots of menu improvements, better print preview support, proper reset of customized layout, better use of radio buttons, less "jumps" back to Home tab, no longer broken after file reload or print preview or master view. tdf#126006 tdf#125504 tdf#122270 tdf#141136 tdf#148121 (Justin Luth) * Added search functionality to Tools ? Options. tdf#49895 (Bayram ?i?ek) * Automatically switching to dark app colors and a dark icon theme when a dark color scheme is configured in the desktop settings now also works for the Qt-based UI variants used e.g. by default on KDE Plasma. tdf#156894 tdf #149611 (Michael Weghorn) * Expert config now shows explanatory text to the config items in a tooltip tdf#157431 (Samuel Mehrbrodt, allotropia) * Expert config can now be filtered by modified values. Modified values are displayed in **bold** text. tdf#157432 (Samuel Mehrbrodt, allotropia) * Improved editing capabilities in Expert config dialog: (Samuel Mehrbrodt, allotropia) + Proper input type validation + Editing lists in an own dialog * Sometimes spell checker algorithms send 2 lists for the same part of the sentence. One of the lists is sometimes empty. Now the non-empty list is shown on right click. (G?kay ?at??r, Collabora Productivity) * Null pointer issue in password-dialog / libreofficeKit is fixed. (G?kay ?at ??r, Collabora Productivity) * Duden corrector encoded text issue is fixed. (G?kay ?at??r, Collabora Productivity) * Updated German language shortcuts for general compatibility. (G?kay ?at??r, Collabora Productivity) * In experimental mode, made the MAR-based automatic update available on TDF Windows 64-bit builds, see Tools ? Options ? Online Update ? Automatic Update. (Stephan Bergmann, allotropia) * On Windows, Alt?+?NumPad codes support had been enhanced to allow full Unicode range. Note that this interferes with shortcut handling; Alt?+?Number shortcuts now only work with main keyboard area numbers on Windows, not with NumPad numbers. Also note, that this enhancement does not include Windows' EnableHexNumpad registry setting support. tdf#156443 (Mike Kaganski, Collabora) * Introduced additional editable metadata fields Contributor, Coverage, Identifier, Publisher, Relation, Rights, Source, Type. See File ? Properties... ? Description. tdf#138792 (Sarper Akdemir, allotropia) Filters Orcus-based filters The following improvements derive primarily from the 0.19 release of the orcus library (Kohei Yoshida, allotropia). * Overhauled the Gnumeric import filter to fix bugs and add missing features. Most notable feature additions are: + cell styles + rich-text strings + named ranges + row heights and column widths + merged cells * Added support for importing rich-text strings in the Excel 2003 XML format. Import of "Drawing Canvas" from docx-documents Word has an object called "Drawing Canvas" where you draw shapes on it. They are combined into one object, similar as grouping them. This drawing canvas has to be used in Word, if the drawing contains connector shapes. Word writes this object in two flavors to the file. One is the original drawing canvas in DrawingML markup and the other is a fallback with reduced properties in VML markup. Previous LibreOffice versions could only read the VML fallback. Now the DrawingML is read. That gives you these new import features: * The drawing canvas background is imported. * Connectors are no longer imported as simple shapes but as true connectors, attached to the start and end shape. * Primitive shapes like ellipses are imported as ooxml-shape and thus text inside the shape can wrap now. * Shapes can use multicolor gradients, theme colors and glow effects. (Regina) ODF Wholesome Encryption A new mode of password-based ODF encryption has been implemented, with the following advantages: * more performant due to deriving a key only once per package * more tamper-resistant with authenticated encryption (AES-GCM) * better hiding of metadata to reduce information leaks * higher resistance to brute forcing using memory-hard Argon2id key derivation function Warning: You will need LibreOffice 24.2 to open these encrypted files. For this reason, by default the pre-existing standard ODF encryption is used. This is available if Experimental Features are enabled in Tools ? Options ? LibreOffice ? Advanced. tdf#105844 (Michael Stahl, allotropia) OOXML SVG support * Support SVG OOXML extension (http://schemas.microsoft.com/office/drawing/ 2016/SVG/main namespace * Import the SVG image (svgBlip element) instead of the fallback PNG * Export the SVG image in addition to fallback PNG image, which is used if the svgBlip element is not supported (older MS Office versions). tdf#126084 (Toma? Vajngerl, Collabora) GUI * The Insert Special Characters dropdown now shows a character description for the selected character (and in tooltip on hovering). tdf#156538 (Jim Raykowski) * The save with password dialog now features a password strength meter that utilizes zxcvbn-c to determine the password strength. tdf#157518 (Sarper Akdemir, allotropia) * Turn Security Warnings popup windows into infobars to avoid annoying blocker warning dialogs. tdf#157482 (Bal??zs Varga, allotropia) - In the previous implementation, if the appropriate configuration options are enabled, a warning was issued and/or the personal information have been removed each time the document is saved. These Security Warnings popup windows have been turned into individual infobar warnings at the top of the page. The infobar can be displayed both for hidden and for personal information. In this way, the user receives a hint without significantly disrupting the workflow. A button on the banner could additionally open a dialog in which individual pieces of information can be removed. * Options dialog pages behaved inconsistently when options are locked down. Several of the UI elements do not reflect this by becoming disabled and displaying a lock icon on their left. By the end all the Options pages will work consistently when options are locked down. tdf#157698 (Bal??zs Varga, allotropia) * Clarify the options dialog text around macro security settings, to specify exactly what is permitted, and what is prevented. tdf#157588 (G??bor Kelemen, allotropia) * It is now possible to reset the cropping for an image. tdf#86628 (Andrea Rosetti) Accessibility * Tree views like the one in the Expert Configuration Dialog (reachable via Tools ? Options ? LibreOffice ? Advanced ? Open Expert Configuration) are now correctly exposed via accessibility APIs, so the table content is announced by screen readers. tdf#99609 (Michael Weghorn, TDF) * A system setting to reduce/disable animations is now honoured by LibreOffice to disable the "marching ants" animation when copying cells in Calc. (This is new in LibreOffice 24.2 for Windows and Linux; for macOS, this is already included in LibreOffice 7.6.) tdf#155414 (Patrick Luby; Michael Weghorn, TDF) * Issues in the handling of mouse positions in the Windows-specific accessibility implementation were fixed, so that the NVDA screen reader can announce the text of a Calc cell under the mouse pointer correctly. tdf# 156679 (Michael Weghorn, TDF) * Various popup menus like the border line style control (e.g. used in Writer: Format ? Paragraph ? Borders ? Line ? Style) or the font color chooser (e.g. used in Writer: Format ? Character ? Font Effect ? Font Color ) are now correctly announced by the NVDA screen reader on Windows. tdf# 101886 tdf#141101 tdf#156561 (Michael Weghorn, TDF) * The UNO grid control is now properly exposed to the accessibility layer and can therefore be announced by the NVDA screen reader. tdf#156473 (Michael Weghorn, TDF) * The multi line edit (e.g. used in the Help ? Check for Updates...) dialog now supports the accessible Text interface, which allows screen readers to announce its text content. tdf#104833 (Michael Weghorn, TDF) * An active-descendant-changed accessible events no longer gets incorrectly sent when a combobox value changes without the combobox being focused, which was causing confusing behavior with the NVDA screen reader in the print dialog. tdf#157137 (Michael Weghorn, TDF) * On Windows, the IAccessible2 role is now reported for frames, instead of reporting them as dialogs. Commit (Michael Weghorn, TDF) * Status bars in dialogs are now reported with the correct accessible role, so screen readers can find and report them accordingly. tdf#157639 (Michael Weghorn, TDF) * The content of the Tools ? Word Count... dialog is now announced by the NVDA screen reader on Windows when the dialog opens. tdf#157633 (Michael Weghorn, TDF) * On Windows, text attributes are now reported on the accessibility layer according to the IAccessible2 text attributes and object attributes specifications, no longer by using custom attribute names and values. Invalid spelling is now also reported via the corresponding text attribute. Together with a corresponding change in version 2024.1 of the NVDA screen reader, this makes announcement of misspelled words work when reading a line of text in Writer. tdf#157696 (Michael Weghorn, TDF) * On Windows, text alignment is now reported via the corresponding IAccessible2 object attribute, which makes it possible for assistive technology like the NVDA screen reader to announce it. tdf#135922 (Michael Weghorn, TDF) * Checkboxes in the spelling dialog can now be toggled using the space key tdf#135921 (Michael Weghorn, TDF) * Writer paragraphs using the "Block Quotation" paragraph style now also use the block quote accessibility role, which makes it possible for screen readers to announce them as block quotes. tdf#135586 (Michael Weghorn, TDF) * The VoiceOver screen reader on macOS no longer unhelpfully says "collapsed" when a Writer paragraph or toolbar button receives focus. Commit (Michael Weghorn, TDF) * Toggle buttons can now be toggled using the corresponding accessible action, which e.g. allows screen readers to do so. tdf#112661 tdf#112662 (Michael Weghorn, TDF) * The label for row and column headers in Calc is now reported via the "rowindextext" and "colindextext" object attributes as specified in the ARIA specification. The Orca screen reader makes use of these for the announcement of cells. tdf#158030 (Michael Weghorn, TDF) * The Orca screen reader on Linux now announces the current status of the underline toolbar button, i.e. it indicates whether underlining is currently active or not. tdf#123864 (Michael Weghorn, TDF) Changes in UI strings * Language settings was changed to Languages and Locales in options. tdf# 157716 (Aswath T) * Decimal separator key was changed to Decimal key on the numpad in options. tdf#113478 (Adoche Onaji) * Modify was changed to Assign in Customize dialog. tdf#155214 (Aswath T) * Scale was changed to As percentage of the parent in Area dialog tdf#154019. (Heiko Tietze, TDF) * Description was changed to Alt Text. tdf#155044 (Heiko Tietze / Ilmari Lauhakangas, TDF) * Evaluate up to level was changed to Include up to level in index dialog. tdf#157908 (Seth Chaiklin) * Add paragraph and table spacing at tops of pages was changed to Add paragraph and table spacing at top of first page and page breaks in options. tdf#141676 (Seth Chaiklin) * AutoUpdate changed to Automatic update from document in the Organize tab of Style dialog. tdf#149796 (Seth Chaiklin) * Instead of Widow and Orphan controls, the Text Flow tab of Paragraph Style dialog now talks about paragraph splitting. tdf#156795 tdf#156109 Samuel Mehrbrodt (allotropia) Localization * LibreOffice is now available in Armenian Armenian is an Indo-European language, spoken by 5??7 million people in the Republic of Armenia and elsewhere in the world. The translation of LibreOffice ??s user interface was largely done by Tigran Zargaryan. Read more about this in our blog Improvements to proofing tools and language support Dictionaries * Slovenian thesaurus was updated (Martin Srebotnjak, OdprtiTezaver). Scripting BASIC * CCur now respects system locale. tdf#128122 (Jonathan Clark) The ScriptForge libraries An extensible and robust collection of macro scripting resources for LibreOffice to be invoked from user Basic or Python scripts. (Jean-Pierre Ledure) The libraries expose a total of 32 services each with a bunch of methods and properties. New in LibreOffice 24.2: * The (new) Dataset service helps browsing through the data collected with tables, queries or SQL SELECT statements. Getting and updating records data is made easy with the use of dictionaries field name => field value. Binary fields can be extracted to files or updated with the content of files. * The Database service supports the transaction mode with in particular the Commit() and Rollback() methods. * Use the new filesystem property of the Document service to navigate through the internal file structure of documents like in usual folders and files. * The Files() and Subfolders() methods in the FileSystem service provide the list of files and folders present in a folder. They accept now an additional IncludeSubfolders boolean argument. * The UserData property of the Platform service gives access to the content of the equivalent page in the Tools/Options dialog. * The Documents service is enriched with a set of functions to manage styles. E.g. suppressing all unused styles can be done in a few lines of code. The whole set of services (except when better done by native built-in functions) is made available for Python scripts with identical syntax and behaviour as in Basic. The English version of the documentation of the ScriptForge libraries (24.2) is fully integrated in the LibreOffice help pages (https://help.libreoffice.org/ 24.2/en-US/text/sbasic/shared/03/lib_ScriptForge.html?DbPAR=BASIC). Their translation into other languages is underway. (Alain Romedenne, Rafael Lima) Feature Removal / Deprecation * Drop Impress/Draw's HTML Export wizard. Exporting to HTML from the UI behaves now the same way as using --convert-to html:"impress_html_Export" from the command line, the slides being exported as a single document. tdf# 105303 (Xisco Fauli, TDF) * Removed FTP protocol support from LibreOffice, following browser vendors and general industry trends. tdf#146386, core commit 4a26dcac (Michael Stahl, allotropia) Platform Compatibility * On Windows, text attributes are now reported on the accessibility layer according to the IAccessible2 text attributes and object attributes specifications, no longer by using custom attribute names and values. Assistive Technology that currently only supports the custom LibreOffice attributes needs to be adapted to support attributes according to the IAccessible2 specifications. For the NVDA screen reader, this has been implemented for the upcoming version 2024.1. tdf#157696 * The minimum requirements for building and running LibreOffice on Linux have been raised from Red Hat Enterprise Linux 7/CentOS 7 to Red Hat Enterprise Linux 8/CentOS 8 (or equivalent). This also means that Qt 5.15 is the minimum supported Qt version for the Qt 5 based "VCL plugins" (qt5/kf5). core commit 02f48a32 API Changes * The constant group com.sun.star.sheet.NamedRangeFlag now supports the HIDDEN flag, which allows to hide named ranges from the UI. MSO compatibility with hidden named ranges is now supported as well. tdf#154449 (Rafael Lima) * New UNO commands for Writer: + .uno:SpotlightParaStyles and .uno:SpotlightCharStyles for the Spotlight feature on Paragraph and Character styles respectively. They are now available in the menu: Format ? Spotlight tdf#156114 (Jim Raykowski) + .uno:InsertDateFieldVar and .uno:InsertTimeFieldVar for variable date and variable time fields respectively. This allows assigning shortcuts to both fixed and variable variants of the date and time fields. Both variants are now available from the menu: Insert ? Field. core commit 6c073a18 (Xisco Fauli, TDF) Configuration Changes * A new setting can be used to disable insecure network protocols (such as unencrypted HTTP, SMTP, and TLS versions older than 1.2). If disabled, the WebDAV UCP will automatically attempt to connect via HTTPS instead, while other services will refuse to connect. core commit 5365daf6 core commit 8e46dd95 core commit 8b0b453e + org.openoffice.Office.Security/Net/AllowInsecureProtocols * A new setting can be used to disable soffice --accept core commit ec3ffe62 + org.openoffice.Office.Security/Net/AllowInsecureUNORemoteProtocol * The following configuration keys have been deprecated: + org.openoffice.Office.Inet::Settings::ooInetFTPProxyName tdf#146386 + org.openoffice.Office.Inet::Settings::ooInetFTPProxyPort tdf#146386 * The following deprecated configuration keys have been removed: + org.openoffice.Office.Common/InternalMSExport/UseOldExport tdf#154077 (Gabor Kelemen, allotropia) + org.openoffice.Office.Histories/HistoryItem/Password (Samuel Mehrbrodt, allotropia) + org.openoffice.Office.Paths/Storage (Samuel Mehrbrodt, allotropia) + org.openoffice.Office.Linguistic/SpellChecking/IsSpellCapitalization (Samuel Mehrbrodt, allotropia) * Customization of start center colors StartCenterThumbnailsHighlightColor and StartCenterThumbnailsHighlightTextColor removed in favor of system defaults tdf#158084 (Heiko Tietze, TDF) @ text @d1 1 a1 1 $NetBSD$ d3 1 a3 1 --- include/comphelper/errcode.hxx.orig 2024-02-01 12:49:34.343781328 +0000 d5 1 a5 2 @@@@ -23,6 +23,7 @@@@ #include d8 1 @