Log Message:
libreoffice: Update to 7.4.4.2

Changelog:
7.4.4.2:
  * 1 About This Page
  * 2 Writer
      + 2.1 General Improvements
      + 2.2 New typographic settings
      + 2.3 New numbering in Show Changes mode
      + 2.4 New remote grammar checker: LanguageTool
  * 3 Calc
      + 3.1 General Improvements
      + 3.2 Performance
  * 4 Impress & Draw
  * 5 Base
  * 6 Chart
  * 7 Math
  * 8 Core / General
      + 8.1 General Improvements
      + 8.2 Lighting of extruded custom shapes
      + 8.3 Performance
  * 9 LibreOffice Help
  * 10 Filters
      + 10.1 DOCX import/export filters
          o 10.1.1 Unlock protected change tracking by password verification
      + 10.2 PPTX import/export filters
      + 10.3 RTF filter import/export
      + 10.4 PDF export
      + 10.5 HTML export
      + 10.6 EMF/WMF import
      + 10.7 TIFF import
  * 11 GUI
      + 11.1 Icon Theme
  * 12 Localization
      + 12.1 New languages/locales with locale data
      + 12.2 Improvements to proofing tools and language support
  * 13 Scripting
      + 13.1 DispatchHelper .UNO:command directory
      + 13.2 The ScriptForge libraries
      + 13.3 VBA Support
      + 13.4 Basic
  * 14 Feature Removal / Deprecation
  * 15 Platform Compatibility
      + 15.1 Mac
  * 16 API Changes
      + 16.1 Jump Lists
  * 17 Android Viewer

About This Page

This is an in-progress scratch-pad of notes to build release notes from as and
when we release. Please do not list features that are to be shipped already in
the 7.4 release! Please do not add wish-list features that you hope will be
implemented, but only what actually is implemented already.

What does a good feature look like here:

  * It has a description, and a way for a busy reviewer, to find and play with
    the feature. Target someone who is extremely busy, and knows
    little-to-nothing about the product. So if a user interface element is key
    to the feature, be very explicit about where it is, e. g. Menu -> Format ->
    Character -> Position [tab] -> '90 degrees' paths to the elements you
    changed. Of course, you know your feature is important, and that everyone
    should care about the Extensible AutoShapes Properties dialog -- but often
    the guys taking the screenshots and writing the notes do not.
  * It credits the main authors who did the work -- just add them in brackets
    after the feature, where possible.
  * If the feature can be shown off with a sample / test file -- particularly
    for new import-able features, it would be wonderful to have a link to/
    up-load of a test file that we can use to show that feature off to best
    effect. That really helps us to make good screenshots to show off the
    features, and allows reviewers to do their testing.

Thanks in advance for your help filling this out!

Writer

General Improvements

  * Menu item Tools -> Update -> Update all now updates the preview of OLE
    objects blog post (Miklos Vajna; Collabora)

  * Various border improvements around tables and paragraphs to make them more
    Word-compatible blog post (Miklos Vajna; Collabora)

  * Fixed Index or Table of Contents generation when Create Index or Table of
    Contents -> For: is set to Chapter in the Table of Contents, Index or
    Bibliography dialogue (Insert -> Table of Contents and Index). The generated
    entries start from the current chapter level, instead of the previously
    hardwired level 2 tdf#130318 (Andreas Heinisch; Emanuele Gissi, CNVVF)

  * Writer now supports clearing breaks from Word for improvement layout
    fidelity blog post (Miklos Vajna; Collabora)

  * Accessibility check dialog (Tools -> Accessibility Check...) is now rendered
    asynchronously core commit 61fed0c4 (Nick Wingate; Collabora)

  * For documents that are loaded read-only, Writer will now allow to view
    tracked changes, both via the dialog from Edit -> Tracked Changes ->
    Manage... and in the sidebar. core commit 82e789bf (Michael Stahl,
    allotropia)

  * Tracked footnote deletion and insertion are visible in the footnote area
    tdf#85610 (László Németh, NISZ)

[640px-Changed_footnotes]

Format footnote numbers to show tracked footnote deletion and insertion in the
footnote area

  * Handle the "hang" baseline OpenType property, allowing text of \ 
different
    sizes to align to the hanging baseline. tdf#104930 (Mark Hung)

  * Writer now supports rich text and checkbox content controls from Word
    natively blog post (Miklos Vajna; Collabora)

  * Writer now also supports dropdown, picture and date content controls from
    Word natively blog post (Miklos Vajna; Collabora)

  * Auto-correction for markup *bold*, /italic/, -strikeout- and _underline_ is
    now switched off by default. Turn it back on in Tools -> AutoCorrect ->
    AutoCorrect Options... -> Options. tdf#133023 (Heiko Tietze, TDF)

  * Improved positioning of glyphs, getting rid of certain problems with
    kerning and unwanted shifting of characters during typing tdf#144862 (Caol
    án McNamara, Red Hat)

New typographic settings

Add new optional hyphenation settings to adjust paragraph-level text flow (Lá
szló Németh)

  * Hyphenation zone (it's for limiting hyphenation, used especially with not
    justified paragraph alignment). tdf#149420

  * Minimum word length for hyphenation tdf#149324

  * Do not hyphenate the last word of the paragraph tdf#149248

Note: these features are part of CSS4 Text Module Level 4, DTP software
and in the case of hyphenation zone, OOXML/MSO.

[640px-Parahyphenation_lastword_minword]

Text Flow tab of Format -> Paragraph... has new hyphenation settings for quick
adjustment of errors of automatic hyphenation and for interoperability

New numbering in Show Changes mode

Show actual and original numbering of list items in Show Changes mode. tdf#
115523 tdf#115524 (László Németh, NISZ)

  * Don't use dummy mixed numbering, which counted the deleted list items as
    not deleted ones.
  * Show the actual number first, and after that, the original number within
    brackets, for example "1.[2.]".
  * Not only the deleted and inserted list items, but the following ones show
    the actual and original numbers e.g. to help to recognize changes of a
    legal text.
  * To improve the visibility of these list items, changed numbering and
    paragraph text are separated by a space, not a tabulator to avoid of
    incorrectly tabulated lists.

[480px-Numbering_changes]

Show Changes mode shows changes in numbering correctly: don't count deleted
list items, show also the original numbers of all list items with changed
numbering (left: before the fix, right: after the fix, List 1: tracked deletion
of a list item, List 2: tracked insertion of a list item, List 3: both tracked
deletion and insertion)

New remote grammar checker: LanguageTool

  * Writer now can take advantage of the remote LanguageTool APIs for grammar
    checking. API docs (thanks to Adfinis for sponsoring this feature) core
    commit d952df36 (Mert Tümer; Collabora)

[1280px-Ltgrammarchecker1]

Language Settings of Tools -> Options adds new settings for grammar checking
with LanguageTool APIs.
[640px-Grammarchecker]

Context menu shows the proper word after checking grammar with remote
LanguageTool APIs.

Calc

General Improvements

  * Support for sparklines was added (blog post) (Tomaž Vajngerl, Collabora)

  * [463px-Sparklines]

    Sparklines in Calc

  * [1372px-Sparklines2]

    Example with 3 types of sparklines

  * Calc now supports and uses 16384 columns (blog post) . (Luboš Luňák,
    Collabora)
  * Added COUNTA, PRODUCT, STDEV, STDEVP, VAR, VARP functions to drop-down
    autosum widget on Formula bar tdf#139602 (Dhiraj Holden)
  * Put text in selected cell into hyperlink item Text when you use the
    Hyperlink dialog (Ctrl+K). If the user selects an entire cell by a single
    click, and inserts an URL via the hyperlink dialog, the entire content of
    the corresponding cell will be replaced instead of inserting a duplicate,
    or appending the URL. If the cell contains more than one URL or an URL
    including some additional text within the cell, the hyperlink dialog will
    only preselect the text field when opening. If this is not the case, it
    fill the URL field as well. tdf#80043 (Andreas Heinisch)
  * The height of the formula bar is now stored into the document. tdf#99708
    (Samuel Mehrbrodt, allotropia)
  * Improve Move/Copy sheet dialog: OK button caption is changed according to
    the command chosen (Move or Copy). tdf#139464 (Laurent Balland)
  * A new context menu Duplicate Sheet is added, which can be accessed when you
    right-click on the sheet tabs area. This allows for quick duplicate (i.e.
    make a copy) of an existing sheet. tdf#145745 (Rafael Lima)
  * Automatic cell matrix expansion for formula expressions that return an
    array/matrix. For formula expressions entered into a cell that obviously
    return an array/matrix, the result cell range is expanded as if
    Shift+Ctrl+Enter was used to close an array formula. The previous
    behaviour of only one cell being used to display only the top left element
    can still be forced by selecting/marking a single cell prior to input. tdf#
    149378 (Eike Rathke, Red Hat)
  * Ease access to a sheet in a spreadsheet with a large number of sheets, with
    a new menu entry Sheet -> Navigate -> Go to Sheet to get a new dialog to
    search for sheets names. tdf#129674 (Laurent Balland)

  * [GoToSheetExample]

    Example of using "Go to Sheet" dialog

  * Hidden columns/rows can have an indicator per View -> Hidden Row/Column
    Indicator tdf#128258 (Heiko Tietze, TDF)

  * [Hiddenrowcol]

    Dotted line indicating hidden columns

  * Sort options and sort items are easier to access now tdf#131155 tdf#140290
    (Heiko Tietze, TDF)

  * [364px-Sortdlg]

    Most frequently used sort options placed on the first tab

  * Number format: enhance readability of long decimal number with format
    0.000"-"000"-"000. Embedded text in decimal part is now \ 
correctly saved and
    restored in ODS format tdf#96723 (Laurent Balland)

  * The formula bar auto input now also suggests non-English function names and
    Named Ranges when you are typing the formula tdf#142031 (Andreas Heinisch)

Performance

  * Improved performance when many columns contain data (blog post) . (Luboš Lu
    ňák, Collabora)
  * Improved performance of functions such as COUNTIF, SUMIFS and VLOOKUP,
    especially with unsorted data tdf#139444 tdf#144777 tdf#146546 (Luboš Luň
    ák, Collabora)
  * Faster recalculation in some documents with many formulas tdf#119083 (Luboš
    Luňák, Collabora)
  * A huge CSV file speed opening was improved tdf#94677 (Luboš Luňák,
    Collabora)
  * Improved performance of Excel export filter tdf#95346 tdf#117366 tdf#126326
    tdf#133749 tdf#140893 (Luboš Luňák, Collabora)
  * Improved performance when loading spreadsheets that require recalculation
    core commit c315a2f7 core commit 64cb1d10 (Luboš Luňák, Collabora)

Impress & Draw

  * Start of document themes in Impress: shape text blog post (Miklos Vajna,
    Collabora)
  * Also added shape fill support for document themes in Impress blog post
    (Miklos Vajna, Collabora)
  * support using slide background as shape fill for PPTX interoperability
    (Armin Le Grand, Samuel Mehrbrodt, allotropia) tdf#128150
    [Use-bg-fill]
    Shape on the master slide using the slides background as fill - 7.3 and 7.4

Base

Chart

Math

Core / General

General Improvements

  * Added support for WebP images import/export tdf#114532 (Luboš Luňák,
    Collabora)
      + Note that currently, WebP is converted to PNG internally, to ensure
        backward compatibility of the generated document files.

  * Made dialog for naming a new color asynchronous core commit 7741b21f (Nick
    Wingate, Collabora)

  * The configuration now remembers whether recent documents were opened
    read-only or editable, and opening via File -> Recent Documents or the Start
    Center will open them in the same mode as the last time. core commit
    404c51f3 (Michael Stahl, allotropia)

  * Added support for EMZ/WMZ files tdf#103954 (Paris Oplopoios)

Lighting of extruded custom shapes

Enhancements for lighting extruded custom shapes to make rendering more
compatible with MS Office binary formats and interpret more ODF attributes. tdf
#145700 (Regina Henschel)

  * Wrong interpretation of the z-direction of lights is corrected. Especially
    a center lighting from observer to object works now. The position of
    specular high lights on rounded surfaces is same as in MS Office now.
  * The item "Metal" is replaced by items "Metal ODF" and \ 
"Metal MS compatible"
    in submenu "Surface" in toolbar "3D-Settings". The \ 
latter is not usable in
    strict ODF file format "ODF 1.3". In preset "Metal ODF" \ 
the specular color
    is Gray as specified in ODF. In preset "Metal MS compatible" the \ 
specular
    color is the shape fill color or the extrusion color respectively, similar
    to rendering in MS Office.
  * The service EnhancedCustomShapeExtrusion in API is extended with a new
    attribute MetalType. It has the value MetalODF or MetalMSCompatible. This
    attribute is used in surface preset "Metal MS compatible".
  * The ODF attribute draw:extrusion-shininess is interpreted now. This
    attribute is similar to the setting "Specular Intensity" in the \ 
"Material"
    tab of the "3D Effects" dialog of 3D objects. The attribute has no \ 
direct
    UI, but is available as attribute Shininess in service
    EnhancedCustomShapeExtrusion in the API.
  * The ODF attribute draw:extrusion-diffusion is interpreted now. Only its
    default value "0%" is not interpretated, because already existing \ 
shapes
    have this attribute not set but expect a value of 100%. For existing shapes
    you can force to write the attribute to file by toggling extrusion off and
    back on. The attribute is used in preset surface "Metal MS \ 
compatible". The
    attribute has no direct UI, but is available as attribute Diffusion in
    service EnhancedCustomShapeExtrusion in the API. A value smaller than 100%
    reduces the rendered brightness of the object.
  * The ODF attributes draw:extrusion-first-light-harsh and
    draw:extrusion-second-light-harsh are interpreted now. The lights are
    rendered soft by distributing parts of the light intensity to four light
    directions around the original light directions during rendering. The
    lighting presets in submenu "Lighting" in the toolbar \ 
"3D-Settings" set the
    attribute compatible to MS Office. The attribute has no direct UI, but is
    available as attribute FirstLightHarsh and SecondLightHarsh in service
    EnhancedCustomShapeExtrusion in the API.
  * The implementation of ODF attribute draw:extrusion-specularity is adapted
    to the corresponding shape property in MS Office binary formats. This
    attribute corresponds to the setting "Specular Color" in the \ 
"Material" tab
    of the "3D Effects" dialog of 3D objects. Only that not abitrary \ 
colors but
    only variants of Gray are used. The attribute has no direct UI, but is
    available as attribute Specularity in service EnhancedCustomShapeExtrusion
    in the API. A value of "0%" forces the first light to be not specular,
    which produces a matte surface in rendering the object. That is used in
    surface preset "Matte".

Performance

  * Improved text layout performance for cases like PDF export, document
    loading and others, more info in the blog post. (Luboš Luňák, Collabora)

LibreOffice Help

  * Help pages for the ScriptForge scripting library (J.P. Ledure, A.
    Romedenne, R. Lima)

  * Help updates and fixes
      + E. Rathke
      + O. Hallot
      + M. Kaganski
      + R. Lima
      + A. Romedenne
      + S. Chaiklin
      + Adolfo Jayme Barrientos

Filters

DOCX import/export filters

  * DOCX: import textboxes (with tables, images etc.) in group shapes tdf#66039
    (Attila Bakos, NISZ)

Unlock protected change tracking by password verification

Unlock protected change tracking of DOCX documents by mandatory password
verification tdf#128744 tdf#106843 (László Németh, NISZ)

  * clicking on Record changes icon of Track Changes toolbar (or Edit -> Track
    Changes -> Record) asks for password verification instead of showing only a
    warning message before unlocking without the password;
  * On Security page of File -> Properties... dialog window, Unprotect button
    accepts the correct password with disabling record changes instead of
    rejecting the correct password.

PPTX import/export filters

  * PPTX export: fixed export of embedded video files tdf#53970 (Tünde Tóth,
    NISZ)
  * PPTX import: fixed import of linked media files. Linked media files were
    imported as images in documents created with Impress after PPTX export. tdf
    #53970 (Tünde Tóth, NISZ)
  * PPTX: add "glue points" to some basic shapes (ellipse, triangle, right
    triangle, trapezoid, parallelogram, diamond, pentagon, hexagon, heptagon,
    octagon). Note: PPTX import doesn't import connectors connected to the glue
    points -- only ODP export keeps them for the planned editing, i.e. moving
    the connected shapes without losing the connecting lines and arrows. tdf#
    147459 (Tibor Nagy, NISZ)

RTF filter import/export

  * RTF filter improvements tdf#148515 tdf#95706 tdf#139948 tdf#116358 tdf#
    111851 tdf#104390 tdf#118047 tdf#131234 (Vasily Melenchuk, CIB/allotropia)

PDF export

  * Improved PDF export options in the command-line blog post (Miklos Vajna,
    Collabora)
  * Field type of Numeric, Currency, Date and Time forms are exported to PDF
    tdf#105972 (Xisco Fauli, TDF)

HTML export

  * Export encoding (character set) configuration is dropped from Options|Load/
    Save|HTML Compatibility, HTML is now always exported using UTF-8 encoding
    tdf#148413 (Mike Kaganski, Collabora)

EMF/WMF import

  * Added support for Miter Limit for EMF+ format tdf#142261 (Bartosz Kosiorek)
  * Added support for individual line endings for EMF+ format tdf#143875, tdf#
    55058 (Bartosz Kosiorek)
  * Fixed holes in lines created with LINETO for EMF/WMF tdf#89331 (Bartosz
    Kosiorek)
  * Added Z compressed graphic formats support for EMF/WMF (.emz and .wmz file
    formats) tdf#103954 (Paris Oplopoios)
  * Use variable types according to EMF+ documentation tdf#103859 (Bartosz
    Kosiorek)
  * Fix displaying EMF+ PathGradient fill tdf#131506 tdf#143031 (Bartosz
    Kosiorek)

TIFF import

  * TIFF: import filter rewritten to import via libtiff in order to support
    many more variants (Caolán McNamara, Red Hat, Inc. and Julien Nabet)
  * Add support for OfficeArtBlip TIFF format core commit 8c9e6d3a (Bartosz
    Kosiorek)

GUI

  * The Navigator can now scroll to the item on selection by a single click,
    without leaving the navigator. Enable this with the expert option
    NavigateOnSelect at org.openoffice.Office.Writer > Navigator tdf#131063
    (Jim Raykowski)
  * Start Center thumbnail rendering improved tdf#134065, tdf#147998, core
    commit b70d17b0 (Mike Kaganski, Collabora)

  * [398px-Before]

    Before

  * [398px-After]

    After

  * Search field for the Extension Manager tdf#126672 (Samuel Mehrbrodt,
    allotropia)

  * The font dialog was reworked to remain compact when Asian and/or Complex
    languages are enabled tdf#139395 and tdf#146928 (Heiko Tietze, TDF)

  * [350px-Charnamedlg]

    Character dialog

  * Experimental dark mode support for Windows 10 and Windows 11. See this blog
    post. tdf#118320 (Caolán McNamara)

[LibreOffice_Dark_in_Windows]

Dark LibreOffice in Windows

Icon Theme

  * The Colibre icon theme which is the default theme in Windows, now has a
    dark variant while maintaining the monoline color composition from
    Microsoft. tdf#146545 (Rizal Muttaqin)

[794px-Colibre-dark]

Dark Colibre Icon Theme

Localization

New languages/locales with locale data

Available as default document language and for locale specific formatting.

  * Pennsylvania Dutch {pdc-US}. tdf#146602 (Peter K. Zacharias, Pennsylvania
    Dutch Education Corporation; Eike Rathke, Red Hat)
  * Aranese {oc-ES}. tdf#147053 (Javier Torres Fernández; Eike Rathke, Red
    Hat)
  * Dhivehi {dv-MV}. tdf#148428 (Adam, M. A.; Eike Rathke, Red Hat)
  * English (Mauritius) {en-MU}. (Eike Rathke, Red Hat)

Improvements to proofing tools and language support

  * Added Central Kurdish (ckb) Spell Checker & Dictionary. commit 1, core
    commit 5727a12a (jwtiyar nariman; Olivier Hallot, TDF)
  * Occitan since 2018 has several type variant language subtags in the IANA
    language-subtag-registry. Historically LibreOffice used oc-FR for Occitan
    Languedocien and oc-ES for Occitan Aranese as language tags. These were
    underspecified at least for oc-FR and are now augmented to be written as
    oc-FR-lengadoc and oc-ES-aranes, the previous oc-FR and oc-ES are still
    recognized and accepted as aliases. LibreOffice 7.3.5 will accept
    oc-FR-lengadoc and oc-ES-aranes as aliases for oc-FR and oc-ES for forward
    compatibility. tdf#147390 (Eike Rathke, Red Hat)
  * Danish spell checking dictionary has been updated (stavekontrolden.dk)
  * Slovenian thesaurus was updated (Martin Srebotnjak, OdprtiTezaver).

Scripting

DispatchHelper .UNO:command directory

com.sun.star.frame.DispatchHelper service .UNO:Commands wiki page has been
upgraded. It lists all usable 7.4 commands together with their arguments.

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 26 services each with a bunch of methods and
properties.

New in LibreOffice 7.4:

  * The (new) Menu service, to describe a new menu to be displayed in the
    menubar. The menu may contain usual items, checkboxes or radio buttons.
    Each item can be decorated with icons and tooltips.

  * The (new) UnitTest service, a framework to setup testcases and testsuites
    for complex Basic modules and extensions.

  * The (new) Region service , to manage locales, timezones and daylight saving
    times. What time is it in Tokyo when it is 12am in Brussels ? Also to
    convert numbers to letters in any language.

  * Get the list of the available extensions and their install directories
    (filesystem service).

  * Run menu commands with arguments (ui, document services).

  * Manage a fallback language (l10n service).

  * Export sheet ranges as images or PDF files (calc service).

  * Erase rows or columns from sheet ranges based on filters expressed as
    formulas (default = erase all empty rows or columns) (calc service).

  * Create and place a pivot table (calc service).

  * Resize and/or center dialogs on a background window or dialog (dialog
    service).

The whole set of services (except when not relevant) is made available for
Python scripts with identical syntax and behaviour as in Basic.

The English version of the documentation of the ScriptForge libraries (7.4) is
fully integrated in the LibreOffice help pages (https://help.libreoffice.org/
7.4/en-US/text/sbasic/shared/03/lib_ScriptForge.html?DbPAR=BASIC). Their
translation into other languages is underway. (Alain Romedenne, Rafael Lima)

VBA Support

  * Added support for Application.WindowState, commit (Tomaž Vajngerl,
    Collabora)

  * Added support for Application.GetOpenFilename tdf#118246 (Tomaž Vajngerl,
    Collabora)

  * Export VBA-Project using detected charset on import tdf#75263 (Andreas
    Heinisch)

  * VBA Range.Sort expands a single cell range to Range.CurrentRegion tdf#
    149579 (Eike Rathke, Red Hat)

  * Not case-sensitive support of VBA NumberFormat tdf#52602 (Eike Rathke, Red
    Hat)

  * Support for referencing a Sheet by Name tdf#149325 (Eike Rathke, Red Hat)

Basic

  * Up to and including LibreOffice 7.2, missing optional procedure arguments
    would be treated as an object of type Error, with error code '448', which
    would be coerced to e.g. numerical value '448' or boolean true in
    expressions depending on expression context. This now raises an error, as
    expected tdf#144353. In particular, expressions like "if IsMissing(FOO) or
    FOO" used to work "by accident", but now don't any more.

Feature Removal / Deprecation

  * FTP support is deprecated and will be removed in a future version.

  * In the SDK, the tools idlc and regmerge (using the legacy type registry
    format) are deprecated and will be removed in a future version, in favor of
    unoidl-write (using the incompatible new type registry format internally
    introduced in LibreOffice 4.1). core commit 40f2aee6

  * The C function typelib_setCacheSize has been deprecated without a
    replacement, and calling it no longer has any effect. core commit c3e9eb99

API Changes

  * The service EnhancedCustomShapeExtrusion in API is extended with a new
    attribute MetalType. It has the value MetalODF or MetalMSCompatible. The
    attribute is not usable in file format "ODF 1.3". For implementation
    context see Lighting of extruded custom shapes.
  * The service SpreadsheetViewSettings has a new property FormulaBarHeight
    allowing to read/set the height of the Calc formula bar. core commit
    d0cacf09 (Samuel Mehrbrodt, allotropia)