Log message:
libreoffice: Update to 24.2.2.2

Changelog:
24.2.2.2:
Bugs fixed compared to 24.2.2 RC1:

 1. tdf#152524 macOS: LibreOffice crashes (gpgme / gpgmeio) on macOS 13 Ventura
    [Patrick Luby]
 2. tdf#157241 Freeze when removing table [Michael Stahl]
 3. tdf#158783 editing alphabetical index crashes Writer [Armin Le Grand
    (allotropia)]
 4. tdf#159373 Crash in: ScTable::HasAttrib(short,long,short,long,HasAttrFlags)
    [Julien Nabet]
 5. tdf#159730 RTF table split document layout [Oliver Specht]
 6. tdf#159915 LibreOffice scaled incorrectly when running with KF6 or Qt6 VCL
    on Wayland [Michael Weghorn]
 7. tdf#159931 Exported pptx cannot be opened in PowerPoint because a
    referenced part does not exist [Sarper Akdemir]
 8. tdf#159996 Dialogs editor don't show controls correctly [Patrick Luby]
 9. tdf#160036 Selection invisible in a11y High Contrast modes with SKIA/
    Raster, Skia/Vulkan unaffected [Patrick Luby]
10. tdf#160095 CRASH: using ALT+RETURN twice [Julien Nabet]
11. tdf#160117 Conditional formatting handling bug in Calc 24.2 with different
    but overlapping ranges [Mike Kaganski]
12. tdf#160149 CRASH: undoing conditional format [Mike Kaganski]
13. tdf#160180 About box for 24.2 has out of date copyright year [Julien Nabet]

24.2.2.1:
Bugs fixed compared to 24.2.1 RC2:

 1. cid#1592908 dereference null return value [Caol??n McNamara]
 2. tdf#55004 backup copy fails when using share / samba (if nobrl cifs mount
    option not used) [Kevin Ottens]
 3. tdf#63259 It should be possible to use shift + F3 case change (cycle case),
    when cursor is at the beginning or end of a word and not only in the middle
    [Oliver Specht]
 4. tdf#83720 PIVOTTABLE: Wrong date format in column field [Toma? Vajngerl]
 5. tdf#92389 Writer: Comment text not accessible with screen reader [Michael
    Weghorn]
 6. tdf#99969 COPYING cells containing a chart and pasting as embedded
    spreadsheet doesn't copy the data chart (comment 14) [Mike Kaganski]
 7. tdf#124591 Update Noto Fonts to latest releases [Khaled Hosny]
 8. tdf#125934 No application icon on Wayland with the qt5 / kf5 backend
    [Michael Weghorn]
 9. tdf#126638 macOS: Can't paste, copy, cut or ?A (select all) using keyboard
    shortcuts in Save-As field (workaround: comment 38) [Patrick Luby]
10. tdf#129701 Skip empty cells option does not work for the last column in
    Calc Text Import dialog [Laurent Balland]
11. tdf#131550 Notifications bloating the UI [Heiko Tietze]
12. tdf#136905 NB Layout tab 'Page Size' drop list UX is poor [Justin Luth]
13. tdf#146356 ODT: No easy way to create an empty paragraph before Table of
    Content if document starts with table of content [Oliver Specht]
14. tdf#147731 Crash in SwFrameFormat::~SwFrameFormat() [Michael Stahl]
15. tdf#150408 "Legal numbering style" is not applied to list levels with
    <w:isLgl/> tag [Miklos Vajna]
16. tdf#150443 Track changes: Crash rejecting a grouped change [Xisco Fauli]
17. tdf#153196 FILEOPEN RTF/DOCX Extra footer appears when section break is in
    the middle of page [Michael Stahl]
18. tdf#153706 Pasting Selected Range to Sheet as GDI Image, Chart image is
    incorrect. [Mike Kaganski]
19. tdf#153761 FILESAVE ODT->DOCX hatch fill in shape is lost [Justin Luth]
20. tdf#155663 FILEOPEN RTF Image crop not imported [Michael Stahl]
21. tdf#155710 Calc crashes every time when saving linked files on macOS
    [Patrick Luby]
22. tdf#155961 cannot access the controls close to vertical scrollbar [Caol??n
    McNamara]
23. tdf#157135 LibreOffice 7.6 stalls/crashes under Windows 11 with Norwegian
    (Bokm?l) locale when opening file dialog [Mike Kaganski]
24. tdf#157158 [UI] Comment arrow drop down is white/light grey when in dark
    mode [Xisco Fauli]
25. tdf#158597 FILEOPEN DOCX Numbering in specific file is unexpectedly bold
    [Michael Stahl]
26. tdf#158735 Solver options are no longer saved during a spreadsheet load.
    [Rafael Lima]
27. tdf#158947 Pasting clipboard contents is not possible under certain
    circumstances with Wayland [Michael Weghorn]
28. tdf#158983 FILEOPEN: RTF: 2 page table is displayed in one page [Michael
    Stahl]
29. tdf#158986 FILEOPEN: RTF: Extra page break [Miklos Vajna]
30. tdf#159251 After using the navigator w/rtl user interface, text is garbled
    during selection / after hovering [Khaled Hosny]
31. tdf#159285 LAYOUT floating table: 2007 DOCX hangs trying to open [Miklos
    Vajna]
32. tdf#159420 EDITING Autofilter for empty cells disabled when by Autofilter
    in other column empty cells filtered out [Xisco Fauli]
33. tdf#159438 ODF export: bookmarks' starts and ends interleave [Mike
    Kaganski]
34. tdf#159453 Importing DOCX: Position of frame has gone [Miklos Vajna]
35. tdf#159483 Calc HTML import: support data-sheets attributes [Miklos Vajna]
36. tdf#159502 missing XML2 version [Michael Stahl]
37. tdf#159515 Custom shape with bitmap fill with image with transparent parts
    is wrongly rendered in extrusion mode [Patrick Luby]
38. tdf#159565 Ctrl+A and Select All don't work when section at the start of
    document body is hidden [Mike Kaganski]
39. tdf#159666 Crash when table and line object are selected at the same time
    [Xisco Fauli]
40. tdf#159689 Exporting glyphs to PDF produces validation warnings in VeraPDF
    [Mike Kaganski]
41. tdf#159696 Small capitals with 'Underlining' does not react to the flag for
    'Single words' [Caol??n McNamara]
42. tdf#159704 FILESAVE exporting to SVG loses the text in some shapes [Jaume
    Pujantell]
43. tdf#159730 RTF table split document layout [Oliver Specht]
44. tdf#159735 Crash when using APSO extension and closing LibreOffice [Michael
    Weghorn]
45. tdf#159752 17 Noto Fonts dropped from 24.2 bundle without notice (and 1
    added) [Xisco Fauli]
46. tdf#159769 Can't open ODF files when LibreOffice's lu* subdirectory in
    system TEMP directory is deleted [Mike Kaganski]
47. tdf#159793 Paper tray settings not saved in RTF and DOCX [Oliver Specht]
48. tdf#159797 Autocorrection: Replace dashes should also work between
    sentences. [Oliver Specht]
49. tdf#159802 Writer Document does not print with Form detail in 24.2 release
    [Noel Grandin]
50. tdf#159813 Assertion failed when dragging-and-dropping text [Mike Kaganski]
51. tdf#159815 Unexpected content inside content control with track changes and
    anchored images from DOCX [Miklos Vajna]
52. tdf#159816 Crash in drag-n-drop of multiple paragraphs with a bookmark
    [Mike Kaganski]
53. tdf#159817 Form controls coordinates scrambled when exporting to pdf with
    uncheked form creation in Writer [Noel Grandin]
54. tdf#159824 FILESAVE ODF->RTF: axial gradients become 2-color linear [Justin
    Luth]
55. tdf#159854 Trigger text is black on dark grey in Animation sidebar deck
    (dark mode) [Caol??n McNamara]
56. tdf#159862 Calc Macro set SearchWildcard to False changes
    SearchRegularExpression value. [Julien Nabet]
57. tdf#159865 Font of the drop down menu in Page Size is very low (in NB bar
    Tabbed UI) [Justin Luth]
58. tdf#159879 Crash when closing "3D View" dialog [Caol??n McNamara]
59. tdf#159908 LibreOffice crashes when using a constant as a loop variable in
    BASIC code, leading to data loss. [Mike Kaganski]
60. tdf#159910 Buttons in navigator not properly announced by Orca screen
    reader (gtk3 VCL plugin) [Michael Weghorn]
61. tdf#159938 Moving through cells with overflowing content changes the cells'
    height and wrapping [Mike Kaganski]
62. tdf#159955 When using a custom page number in Writer, the custom page
    number and the actual sum of pages are switched in the sidebar [Julien
    Nabet]
63. tdf#159968 LibreOffice can't render markers (eg. arrows) embeded to end of
    line [Xisco Fauli]
64. tdf#160003 Copying a sheet with chart and pasting to other document's sheet
    with a different name looses chart [Regina Henschel]

Log message:
libreoffice: remove empty line from PLIST

Log message:
libreoffice: probably fix debug build.

Log message:
libreoffice: add build fix for NetBSD/aarch64

For aarch64 on NetBSD we apply -mno-outline-atomics as one way of
getting around linking issues that otherwise occur with GCC from
pkgsrc. XXX when -current moves to GCC 12, this should be revisited.
Issue reported and fix supplied and tested by Paul Ripke on
pkgsrc-users. (Same approach already used elsewhere in pkgsrc, e.g.,
graphics/exiv2.)

Log message:
*: bump for cairo buildlink3.mk change

lzo was made an option

Log message:
* recursive bump for libxkbcommon 1.7.0

Marc Baudoin reported problems with using old binary packages
with the new libkxbcommon, so force everything to 1.7.0

Log message:
libreoffice: Update to 24.2.1.2

Changelog:
14.2.1.2:
List of fixed bugs

Bugs fixed compared to 24.2.1 RC1:

 1. tdf#101313 Copy-paste a Table With Merged Cells from Writer to Calc: Cells
    Placed in Wrong Position (Wrong cell offsets) [Noel Grandin]
 2. tdf#156993 Snap guides are not visible anymore [Regina Henschel]
 3. tdf#158360 [CRASH] LibreOffice crashes after editing, closing and trying to
    reopen DOCX file [Balazs Varga]
 4. 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 [Mike Kaganski]
 5. tdf#159519 LibreOffice 24.2.0.3 (Windows 7) ODF files saved with passwords
    can be opened without any password [Michael Stahl]
 6. tdf#159529 Excessive memory consumption in v24.2 [Patrick Luby]
 7. tdf#159666 Crash when table and line object are selected at the same time
    [Noel Grandin]
 8. tdf#159678 heading fields in headers and footers do not track heading
    content through the document [Baole Fang]
 9. tdf#159707 CRASH: Changing to edit mode [Julien Nabet]
10. tdf#159743 German UI: Many not plausible Keyboard Shortcut Changes [Xisco
    Fauli]

24.2.1.1:
List of fixed bugs

Bugs fixed compared to 24.2.0 RC3:

 1. cool#7769 reduce unnecessary invalidations on calc save [Caol??n McNamara]
 2. cool#8023 editeng: support HTML paste [Miklos Vajna]
 3. tdf#43848 selecting whole table with merged cells at certain position not
    possible with draging the mouse [Oliver Specht]
 4. tdf#105844 FILESAVE: Very slow saving with password compared to 5.2.5
    [Michael Stahl]
 5. tdf#106733 Implement ODF attribute fo:hyphenate to exclude a portion of
    text from hyphenation [L??szl?? N??meth]
 6. tdf#123968 Input Field (Functions): direct editing is still used, not
    pop-up dialog [Michael Stahl]
 7. tdf#132810 Gallery: Crash swlo!SwFEShell::SelectObj+0x46a when inserting a
    new shape with cursor still in textbox SwFrame::AppendDrawObj
    (SwAnchoredObject &) [Matt K]
 8. tdf#134401 FILESAVE PPTX: vertical alignment inverted (bottom<->top) when
    saving textbox with link [Attila Sz?cs]
 9. tdf#135083 Bullet goes missing on special paste RTF [Mike Kaganski]
10. tdf#139631 Inconsistent removal of preceding space when cutting word with
    track changes on (comment 7) [Michael Stahl]
11. tdf#139915 FILEOPEN DOCX Two text boxes on two pages open on a single page
    [Justin Luth]
12. tdf#140330 Conditional formatting breaks after redoing cell deletion [Mike
    Kaganski]
13. tdf#140912 FILEOPEN PPTX: extra image and text label "insert \ 
image" appears
    (even in presentation mode) [Mike Kaganski]
14. tdf#142806 Freeze/hang/crash when exporting to PDF with style inspector
    panel active [Michael Stahl]
15. tdf#146487 FILEOPEN PPTX: empty chart title shows as text "chart \ 
title" in
    Impress (while not in 365) [Samuel Mehrbrodt]
16. tdf#147291 macOS: Digital Signatures > Start Certificate Manager (OpenPGP)
    results in error instead of opening GPG Keychain [Patrick Luby]
17. tdf#151352 CRASH: closing form while the tip of the day dialog is displayed
    [Caol??n McNamara]
18. tdf#153909 2007 DOCX: Rectangle in header has unwanted offset (same MSO-LO
    if resaved in MSO) [Justin Luth]
19. tdf#154587 FILEOPEN Calc doesn't open XLSX archive [Mike Kaganski]
20. tdf#154703 [META] Export DOCX flies with framePr instead of DrawingDML
    [Justin Luth]
21. tdf#156156 Add Help button to sidebar [Christian Lohmaier, St??phane
    Guillou]
22. tdf#156352 macOS: Save as > Encrypt with GPG key results in hang / crash
    [Caol??n McNamara]
23. tdf#156443 Windows: alt+numpad doesn't work for Unicode decimal codes, like
    in WordPad/Word [Mike Kaganski]
24. tdf#156718 FILEOPEN PPTX: alternating colored lines in table / style don't
    render properly [Tibor Nagy]
25. tdf#156830 FILEOPEN PPTX: background image shifts down in presentation mode
    [Sarper Akdemir]
26. tdf#157042 [Linux only] Calc crashes when closed in rtl::str::release
    <_rtl_uString>(_rtl_uString*) (steps in comment 27) [Xisco Fauli]
27. tdf#158101 Disabled popup menu items are visible with non-gtk backend [Jim
    Raykowski]
28. tdf#158112 Sidebar pane shortcuts conflict with Alt+NumPad input (comment
    5, comment 9) [Mike Kaganski]
29. tdf#158139 Writer, Word Completion does not function [Mike Kaganski]
30. tdf#158277 Opening the Quick Find bar after selecting a word when track
    changes is active includes deleted text [Michael Stahl]
31. tdf#158279 TOC links lost when converting .doc to HTML (steps in comment 5)
    [Noel Grandin]
32. tdf#158314 Autofilter dropdown list always shows "Empty" and \ 
"Error" enties
    as active [Kevin Suo]
33. tdf#158326 FILTER autofilter seems to convert ?? in ss and ignores value
    [Andreas Heinisch]
34. tdf#158409 FILEOPEN: RTF field results do not respect current character
    properties [Vasily Melenchuk]
35. tdf#158440 Filter for background should take colors in empty cells [Henry
    Castro]
36. tdf#158445 SVG file not imported correctly [Xisco Fauli]
37. tdf#158586 FILEOPEN RTF: missing page break [Michael Stahl]
38. tdf#158652 List of comments in Navigator does not update automatically
    [Oliver Specht]
39. tdf#158695 --convert-to bogusly needs libcui (--disable-gui build) [Noel
    Grandin]
40. tdf#158740 Crash at undo after pasting table in footnote [Patrick Luby]
41. tdf#158783 editing alphabetical index crashes Writer [Michael Stahl]
42. tdf#158814 FILEOPEN DOCX RTF Empty header with formatted paragraph and
    shape appears [Miklos Vajna]
43. tdf#158924 Switching three slides when double clicking on the navigation
    button [Vladislav Tarakanov]
44. tdf#158950 Paste as Rich Text Format loses character color and paragraph
    alignment from styles [Noel Grandin]
45. tdf#158976 The "SF_Array.Shuffle" function does not place the end \ 
of the
    array at the end of the array [Jean-Pierre Ledure]
46. tdf#159015 HANG: scrolling after opening file [Michael Stahl]
47. tdf#159017 FILEOPEN: Tables displayed on the wrong place [Miklos Vajna]
48. tdf#159049 Line break is missing in RTF in clipboard when copying text from
    shape [Regina Henschel]
49. tdf#159079 With NumLock off in Numpad, then with Alt pressed the Num Pad
    arrow keys should not operate [Mike Kaganski]
50. tdf#159101 Cross-reference to referenced text causing a space at the
    beginning of a line [Matthew Kogan]
51. tdf#159102 automatic hyphenation results bad smart justify [L??szl?? N??
    meth]
52. tdf#159107 Removing row in footnote's floating table removes whole table
    (track changes on but not visible) [Miklos Vajna]
53. tdf#159128 UI Open Security options and warning dialog from infobar [Balazs
    Varga]
54. tdf#159131 Calc v7.5 is laggy when moving a line (row) [Noel Grandin]
55. tdf#159147 CRASH: Editing hyperlink while navigator is open [Jim Raykowski]
56. tdf#159157 FILEOPEN DOCX: image offset in opposite direction of TEXT_LINE
    what vertical offset specifies [Justin Luth]
57. tdf#159164 Spellchecking - South African English [Marco A.G.Pinto]
58. tdf#159171 Calc: crash after Edit->Select->Select Unprotected Cells upon a
    second time [Matt K]
59. tdf#159219 PPT: image placeholder with custom prompt imports as text box
    with a background icon [Mike Kaganski]
60. tdf#159247 [CRASH] Dialog editor crashes when inserting control with
    default options [Rafael Lima]
61. tdf#159254 Paper tray settings ignored in rtf and docx import [Oliver
    Specht]
62. tdf#159259 DOCX: a floating content control imports as a separate paragraph
    [Mike Kaganski]
63. tdf#159288 Assertion on insert trend line [Julien Nabet]
64. tdf#159307 "Cannot find a Certificate Manager" shows up even though a
    certificate manager IS installed. [Stephan Bergmann, Patrick Luby]
65. tdf#159328 Page number field shows up like plain text (no grayish
    background) [Heiko Tietze]
66. tdf#159329 Arrows in AutoFilter are black over dark background [Rafael
    Lima]
67. tdf#159333 kf5: Commands triggered via keyboard shortcut are executed twice
    when accessibility is active [Michael Weghorn]
68. tdf#159336 PDF export: multiline text is exported as one line [Xisco Fauli]
69. tdf#159350 Hiding Options dialog tabpages stopped working [Noel Grandin]
70. tdf#159368 Can't open BASIC editor from Start Center; next action crashes
    LO (gtk3) [Caol??n McNamara]
71. tdf#159381 TimeStamp(RFC3161) create problem by asn1 format error. [Noel
    Grandin]
72. tdf#159382 DOCX import: Large space between footnote number and following
    text, when paragraph has hanging indent [Mike Kaganski]
73. tdf#159384 A11y sidebar: simulated numbering warning in TOC if header
    numbering has dot [Balazs Varga]
74. tdf#159412 Passing Integer-sized Long argument via script.invoke as 0 [Mike
    Kaganski]
75. tdf#159452 Ticked checkbox in document not shown in exported PDF [Miklos
    Vajna]
76. tdf#159458 When library is renamed using Basic Macro Organizer, path to
    library is not updated in dialog.xlc and script.xlc [Mike Kaganski]
77. tdf#159461 Dialog "XML Filter Settings" is broken [Noel Grandin]
78. tdf#159474 A specific broken document can't be opened in RepairPackage mode
    [Mike Kaganski]
79. tdf#159478 FILEOPEN: RTF Checkbox Field in symbol encoding not imported
    [Oliver Specht]
80. tdf#159483 Calc HTML import: support data-sheets attributes [Miklos Vajna]
81. tdf#159496 An invalid ODF with an OLE fails to open, when asked to repair
    package interactively [Mike Kaganski]
82. tdf#159507 Calc editeng HTML paste: fragments are not supported [Miklos
    Vajna]
83. tdf#159560 Paragraph break should not change to random symbol [Oliver
    Specht]
84. tdf#159566 SVG import: mis-positioned text for specific file [Xisco Fauli]
85. tdf#159568 URL in help not found [Gabor Kelemen]
86. tdf#159572 Insert special character dialog should regard font of recent
    characters on single click [Oliver Specht]
87. tdf#159581 FILEOPEN XLSX 24.2: optimal row height from previous sheet may
    be applied to all future sheets [Justin Luth]
88. tdf#159594 SVG: some elements are not visible [Xisco Fauli]
89. tdf#159595 Data validation without error check allows to enter data other
    than defined [Julien Nabet]
90. tdf#159601 SVG: Nothing is displayed on the document [Xisco Fauli]
91. tdf#159637 Crash in PlaceEditDialog::SelectType(bool) [Xisco Fauli]
92. tdf#159641 TreeView does not repaint correctly while scrolling with PgUp in
    kf5/gen [Noel Grandin]

Log message:
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)