The NetBSD Project

CVS log for pkgsrc/misc/libreoffice/PLIST.java

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / misc / libreoffice

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.25: download - view: text, markup, annotated - select for diffs
Tue Sep 22 08:33:59 2026 UTC (7 weeks, 6 days ago) by ryoon
Branches: MAIN
CVS tags: HEAD
Diff to: previous 1.24: preferred, colored
Changes since revision 1.24: +0 -0 lines
misc/libreoffice: Update to 26.8.0.3

* G/C distfiles.

Changelog:
26.8.0.3:
Writer

  * Paragraph directions for RTL text are now automatically detected when
    opening or pasting plain text (Jonathan Clark, TDF) tdf#157037
  * Read and re-export “hidden” and “show in gallery” properties of styles
    in the DOCX files. Allowing to filter list of styles to only meaningful
    ones. (Szymon Kłos, Collabora) 5bee91d5
  * Start is now the default paragraph alignment setting in new documents.
    (Jonathan Clark, TDF) tdf#169035
  * Changing paragraph directions no longer mirrors alignment of left- or
    right-aligned paragraphs. For paragraphs that are automatically aligned
    based on writing direction, please use start or end alignment. (Jonathan
    Clark, TDF) tdf#165206
  * Improved deleted commented text ranges in Writer’s DOCX filter. blog post
    (Miklos Vajna, Collabora)
  * New option added for displaying the baseline grid for page line-spacing:
    View ▸ Grids and Helplines ▸ Display Baseline Grid. (blog post) (Tamás
    Zolnai) tdf#169806
      + The color of the grid can be changed: Tools ▸ Options ▸ LibreOffice ▸
        Appearance ▸ Customizations ▸ Baseline grid

  * Page line-spacing now works properly inside Writer frames. The text within
    the frame is correctly aligned with the baseline grid. (blog post) (Tamás
    Zolnai) tdf#93785

  * Displaying field names in Writer now shows a description of the field type
    in the case of document statistics. (Andreas Heinisch) tdf#45048

  * Plumbing to compare documents side-by-side. blog post (Miklos Vajna,
    Collabora)
  * Paragraph Composer: The new Paragraph Composer balances word spacing in the
    consecu­tive lines, fixing fundamental incompleteness of the “greedy”
    single line composer of the word proces­sors. (blog post). (László Né
    meth) tdf#38159

  * Draft View for distraction-free editing View ▸ Draft (László Németh) tdf
    #168705

  * When printing a form letter, Mail Merge dialog now preserves its Output
    options: single document/individual documents, file format (Laurent
    Balland) tdf#144771
  * Quick Find Sidebar deck allows to search through comments. (Vojtěch
    Doležal) tdf#170192
  * Improved line wrapping for bidirectional text. Spaces at the end of a line
    are now placed in paragraph writing direction, rather than reading
    direction. (Jonathan Clark, TDF) tdf#146572

  * Added an option to prevent typed text from replacing the current selection
    Tools ▸ Options ▸ LibreOffice Writer ▸ Formatting Aids: Typing: ☑ Typing
    replaces selection (Andreas Heinisch) tdf#169913
  * Fixed dragging handles to resize objects in RTL and vertical CJK documents.
    Resizing objects should now behave in a more intuitive way. (Jonathan
    Clark, TDF) tdf#56412

  * Show Formatting Marks now also makes format characters for bidirectional
    text visible. (Jonathan Clark, TDF) tdf#63929

  * It is now possible to sort sections alphabetically by their headings in
    Writer. (Jim Raykowski) tdf#167491
  * Changing of Quick Find Sidebar options now happen within the Sidebar deck
    instead of in a modal dialog. (Vojtěch Doležal) tdf#170980
  * Page navigation done with Alt + PgDn and Alt + PgUp now position the view,
    so the top of the page is at the top of the viewport. The Go to Page dialog
    was also modified to behave in the same way. (Jim Raykowski) tdf#171259
  * A minimum character limit paragraph property was added for limiting
    hyphenation left to the compound constituent boundaries. (László Németh)
    tdf#170177
  * The Word Count dialog now includes word count data for “before/after
    cursor". (Tien Nguyen Minh) tdf#123083
  * The Link End Index/Table Entry component character style now matches Link
    Start by default. (Manish Bera) tdf#50050
  * Page style names are shown within page break decorations. (Heiko Tietze,
    TDF) tdf#128616
  * The list of styles in the Styles dropdown can be configured by expert
    configuration options ShowDefaultStyles, ShowUsedStyles,
    ShowFavouriteStyles, and ShowUserDefinedStyles under
    org.openoffice.Office.Common. (Jim Raykowski) tdf#171727
  * An infobar is shown if the automatic formatting removed trailing/leading
    spaces or tabs. (Heiko Tietze, TDF) tdf#171343

Navigator

  * Writer Navigator now displays index entries. (Jim Raykowski) tdf#164864
  * Headings can be sorted alongside their contents via the Navigator (requires
    experimental features to be active). (Jim Raykowski) tdf#169674


Performance

  * The opening time of very large Writer documents with images was improved.
    (Noel Grandin, Collabora) tdf#170595


Calc

  * Data Validity allows now to silently reject invalid values (also pre 24.2
    behavior restored) (Heiko Tietze, TDF) tdf#160096
  * A Shuffle command was added for randomizing the order of cells in a range.
    (Tomaž Vajngerl, Collabora) tdf#158196
  * Calc now behaves better when typing and editing RTL text. Typing RTL text
    into an empty cell will also now automatically set the cell direction to
    RTL. (Jonathan Clark, TDF) tdf#65563 tdf#144296

  * Pivot Table Calculated Field (Balazs Varga, Collabora) tdf#78486 (Olivier
    Hallot, TDF) tdf#172107

  * XLSX compatibility with line breaks in referenced cells was improved.
    (Bayram Çiçek, Collabora) tdf#169326
  * The UI for changing text formatting in Calc’s Header/Footer dialog was
    improved. (Viraj Parmar) tdf#103035
  * Relative font sizes are now supported in Calc cell styles. (Paolo
    Benvenuto) tdf#92144
  * Ctrl + Home moves the cursor to the first non-frozen cell in the sheet.
    (Andreas Heinisch) tdf#107994
  * XLSX Form control elements now show up in the Navigator. (Jim Raykowski)
    tdf#167766
  * Converted the border toolbar button to a split button that remembers and
    reapplies the most recently used border style. (Andreas Heinisch) tdf#58349

  * Links to hidden sheets now show a notification (Heiko Tietze, TDF) tdf#
    118866

Impress

  * Transitioning from a numbered list to a bulleted list is now possible blog
    post (Miklos Vajna, Collabora)
  * Impress & Draw now support multiple page sizes in a document blog post
    (Mohit Marathe, Collabora) tdf#49787

  * Embedded templates: both 16:9 and 4:3 ratio are now proposed for some
    templates: Blueprint Plans, Beehive, DNA, Lights, Nature Illustration (16:9
    ratio is now the default). It avoids stretching of background decor when
    changing page size ratio. (Laurent Balland) tdf#170789
  * Added Presentation Sections (Pranam Lashkari, Collabora)

  * Slide Panel and Page Panel now display custom slide names next to the slide
    number above each thumbnail. (Andreas Heinisch) tdf#37654

  * The icons in the optional navigation bar in slideshows now scale
    automatically with window size changes. (Vladislav Tarakanov) tdf#158394
  * The slide selection in Outline view now tracks the cursor location.
    (Andreas Heinisch) tdf#99079


Draw

  * Swap mouse wheel zoom and scroll: When enabled in Draw, the mouse wheel
    zooms instead of scrolling, and Ctrl plus the mouse wheel scrolls instead
    of zooming. (Lucas Negrea) tdf#171291

Base

  * Preserved SQL comments in Design View: Fixed an issue where comments within
    an SQL query were automatically deleted when switching the query to Design
    View.
    ⚠️ Warning: Comments will still be lost if the query is actively edited
    while in Design View, as the visual editor regenerates the underlying SQL
    code. (Vissarion Fysikopoulos, TDF) tdf#42713
  * Date, time, and timestamp column filtering is now supported for Base when
    using the Firebird embedded database. (Vissarion Fysikopoulos, TDF) tdf#
    153057

Chart

  * LibreOffice now provides rudimentary support for import and re-export of
    new ("chartex") chart types that can be created in Microsoft Office and
    saved in OOXML formats. Chart types with this basic round-trip support
    include box-whisker, funnel, Pareto, sunburst, treemap, and waterfall
    charts. Region map charts contain extensive geographic information that is
    not supported, so while the chart type is preserved through round-trip,
    little substantial content is. No support exists yet for displaying or
    editing these chart types. Instead, a message is displayed to indicate that
    the chart type is not yet supported in LibreOffice. (Kurt Nordback,
    Collabora) tdf#165742

Math

  * Named functions and operators were added for the N’Ko and Adlam scripts.
    (Neil S. Patel) tdf#170259
  * Left-pointing vector arrows and harpoons were added for RTL formulas. (Neil
    S. Patel) tdf#158727
  * There is now a matrix creator dialog for Math. (Jan Rheinländer) tdf#170787

Core / General

  * The Organizer tab of the style dialog now shows interactive "chips" for
    each property that differs from the parent style. Each chip displays the
    property name and value, and includes an X button to reset that property
    back to parent inheritance. All properties are shown full text, no
    ellipsis. (Paolo Benvenuto) tdf#89826

  * LibreOffice now accepts font names in other languages, in addition to the
    current UI language. Documents created with other UI languages will now
    display with the author-intended fonts, as long as those fonts are
    installed on the system. (Jonathan Clark, TDF) tdf#63011
  * Keyboard shortcuts can be configured for an individual document using the
    keyboard customization dialog. (Neil Roberts, TDF) tdf#94522

  * When the generic VCL UI widgets are used (for example, when a
    desktop-integration package like libreoffice-kf6 has not been installed),
    an infobar is shown warning about the situation and how to fix it. (Heiko
    Tietze, TDF) tdf#172256
  * OpenType font variations are now natively supported. (Khaled Hosny, Alif
    Type) tdf#171624 tdf#153368 tdf#118792 tdf#152206
  * Unicode escapes now work in Find and Replace with regular expressions.
    (Anamay Narkar) tdf#106137

User Interface

  * Add more paper sizes (A0, A1, A2, B0, B1, B2, B3) to the Page style dialog,
    and also to the page sidebar panel. (Samuel Mehrbrodt, Collabora) tdf#
    106889
  * Use deterministic list of styles which is unified across Notebookbar, the
    Formatting toolbar and the Style dropdown of the Properties deck of the
    Sidebar. It doesn’t hide one standard style when you use new custom one -
    avoiding impression of random collection. (Szymon Kłos, Collabora) tdf#
    108239

  * Changes to application theme colors no longer require a restart. (Heiko
    Tietze, TDF) tdf#170678
  * Theme colors can be accessed via the Notebookbar UI in Impress. (Samuel
    Mehrbrodt, Collabora, Heiko Tietze, TDF) tdf#170485

  * A “Remove query string” option was added to the Hyperlink dialog. (Siddhi
    Salunkhe) tdf#170592
  * A maximize button is now shown for resizable dialogs on Windows. (Thomas
    Rogenmoser) tdf#141381
  * It is now possible to scroll between Notebookbar tabs using the mousewheel
    or touchpad. (Jonas Greifenhain) tdf#103033
  * Existing table styles in Writer and Calc can now be edited. The internal
    format was changed from a binary one to XML. (Karthik Godha) tdf#105933 tdf
    #49437
  * The macOS-specific menu items Emoji & Symbols, Dictation support, and
    AutoFill are now available. (Dan Williams, TDF) tdf#94251
  * Custom dictionaries now have a search filter. (Shlok Kanani) tdf#170978

  * The Calc ▸ Calculate option page was reorganized. (Sahil Gautam, Collabora)
    tdf#151144
  * The Notebookbars' background is colored individually per module. These
    colors are hard-coded for now and merged with the background to work on
    both dark and light themes, controlled via expert configuration
    NotebookbarColorTransparency with 0 for the exact defined color and 255 for
    the background color. The default is 150. (Heiko Tietze, TDF) tdf#121174

  * The Tabbed Notebookbar UI now has category labels. (Heiko Tietze, TDF) tdf#
    166641
  * The paragraph styles picker in the Notebookbar UI shows only one (styled)
    label and the style grid expands to fill the available space of the
    application (Heiko Tietze, TDF) tdf#169763 tdf#168657

  * Style filters in the Styles Sidebar deck can be applied independently. (Jim
    Raykowski) tdf#167949

Accessibility

  * The special character split-button widget is now navigable with the
    keyboard. (Michael Weghorn, TDF) tdf#168594
  * Writer tables now report row and column index text as specified in ARIA.
    (Michael Weghorn, TDF) tdf#171086

Changes in UI strings

  * The “Company” field has been relabeled to a more generic “Organization”
    in User Data options. (Aleksi Kallio) tdf#169121
  * The “Ignore system input language” check box is now more clearly labeled
    as “Apply system input language to new text”. (Prajwal Shelar; Isha
    Desai) tdf#134628
  * “Safe Mode” is now known as “Troubleshoot Mode” to reflect its intended
    use and minimize misunderstandings about what it does. (Adolfo
    Jayme-Barrientos) tdf#171916
  * “Use square [sic] page mode for text grid” is now called “Use CJK
    manuscript grid”, and its extended tooltip and help text have been updated
    accordingly. This option enables the genkō yōshi⁠# grid. (Olivier Hallot,
    TDF) tdf#171455
  * Labels of two “New” commands were clarified as “New Document” and “New
    Style from Selection”. (Heiko Tietze, TDF) tdf#169766
  * Options for “Do show again” were changed to “Do not show again”. (Heiko
    Tietze, TDF) tdf#169313


Scripting

Python

Users can create and edit Python scripts directly from Macro manager dialog
without APSO installing, the buttons are active for actions now. The Python
scripts will be opened in standard text editor on all OS. (Neil Roberts, TDF)
tdf#56289

Scripts can create instances of UNO services using a constructor instead of
having to use a string. (Neil Roberts, TDF) tdf#171122

For example:

from com.sun.star.awt import Toolkit
toolkit = Toolkit.create(self.xContext)

Similarly for singletons:

from com.sun.star.frame import theDesktop
desktop = theDesktop.get(ctx)

Users debugged remote processes to LibreOffice - started with officehelper.py -
can be released from memory. Information is available from [Developer's Guide -
Getting started] chapter. (Alain Romedenne) tdf#163465

from officehelper import SessionManager
def my_script():
  # user code goes here

g_exportedScripts = (my_script,)  # LibreOffice entry points

if __name__ == "__main__":  # entry point for IDEs
  with SessionManager() as ctx:  # remote Python context
    my_script()

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

New in LibreOffice 26.8:

  * The new ui.EnterValue(...) method displays a typed input box (cfr. the
    InputBox() Basic function) to the user and returns the entered value as a
    scalar of the requested type, or Empty/None when the user cancels the box.
    The supported types are: STRING, PASSWORD, BOOL, INTEGER, FLOAT, DATE,
    TIME, DATETIME, COMBO, LIST and RADIO.
  * (Basic only) The new array.Map(), array.Filter() and array.Reduce() methods
    introduce functional programming techniques on Basic arrays. They mimic
    their Python equivalents. Those methods allow the programmer to write
    simpler, shorter code, without necessarily needing to bother about
    intricacies like loops, branching and error handling.
  * The new session.GetUnoProperty() and session.GetPropertyByName() methods
    return the property value of resp. a UNO object or a ScriptForge service
    instance when the property name is given as a string.
  * (Python only) Python scripts may run either (1) inside the LibreOffice
    process, the usual mode, or (2) as a client of a LibreOffice server using a
    pipe or a socket. The benefit of (2) is the freedom to choose his/her
    preferred IDE to edit and debug the script. The drawback is the reference
    to the pipe/socket in the script source code. Avoid this by using a default
    pipe, named PIPE2LIBREOFFICE. The same code will run without change in both
    (1) and (2) modes.

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.

ScriptForge in the wiki: read Macros/ScriptForge (Lobaluna).

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

Android Viewer

Localization

  * AutoCorrect will now automatically replace x’s with circumflexes in
    Esperanto text. For example “sxangxigxi” becomes “ŝanĝiĝi”. (Neil
    Roberts, TDF) tdf#172042

LibreOffice Help

Help accepts MathML contents, prefixed by namespace “m” (O. Hallot, TDF)

<m:math xmlns:m="http://www.w3.org/1998/Math/MathML" display="block">
<m:semantics>
  <m:mrow>
   <m:mi>cot</m:mi>
   <m:mrow>
    ...
</m:math>

Help contents upgrades and fixes:

  * O. Hallot, TDF
  * Adolfo Jaime Barrientos
  * Stanislav Horacek
  * Jean Pierre Ledure
  * Ilmari Lauhakangas, TDF

Feature Removal / Deprecation

  * Removed obsolete Java Applet configuration settings from NetAccess and
    Security registry schemas. (Shlok Kanani) (Gabor Kelemen, Collabora) tdf#
    162563
  * Removed the obsolete OfficeBean example (which was based on Java applet
    functionality) from the SDK. (Stephan Bergmann, Collabora) 05ba63c6
  * Obsolete Gentium Basic and Gentium Book Basic fonts (v.1.102, SIL) are no
    longer bundled. Note: In case you still need these fonts, they can be
    downloaded from our site. Alternatively, you can try to migrate to new
    Gentium and Gentium Book fonts, they can be downloaded from SIL site.
    (Xisco Faulí, TDF) tdf#167563
  * AppletShape API is deprecated and will be removed in a future version.


API Changes

  * Removed the legacy Profile API and replaced it with a manual .ini file
    parser. (Shlok Kanani) tdf#49602
  * FunctionAccess::callFunction now accepts missing arguments. (Neil Roberts,
    TDF) tdf#168267


Code quality

  * VeraPDF was added as a PDF validator for automated tests. (Xisco Faulí,
    TDF) tdf#136822

Revision 1.24: download - view: text, markup, annotated - select for diffs
Mon Feb 9 16:59:59 2026 UTC (9 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2026Q3-base, pkgsrc-2026Q3, pkgsrc-2026Q2-base, pkgsrc-2026Q2, pkgsrc-2026Q1-base, pkgsrc-2026Q1
Diff to: previous 1.23: preferred, colored
Changes since revision 1.23: +0 -1 lines
misc/libreofficeL Update to 26.2.0.3

Changelg:
New features of 26.2.0:
Writer

  * Anchored objects are no longer selected after pasting. The old behaviour
    can be restored by setting the expert option
    Office::Writer::Cursor::Option::SelectPastedAnchoredObject to true.
    (Michael Stahl, Collabora) tdf#167833
  * Floating tables and the keep-with-next/don't split paragraph attributes now
    work better together in Writer (blog post). (Miklos Vajna, Collabora)
  * Change tracking: old direct format of format redlines are now preserved for
    ODT and are improved for DOCX (blog post). (Miklos Vajna, Collabora)
  * Change tracking: it is now possible to decide which change to accept for
    interdependent changes (blog post). (Miklos Vajna, Collabora)
  * Floating tables can now be split into floating tables, which improves DOCX
    export. (Michael Stahl, Collabora) fc53ab8e
  * When changing one numbered list by joining it to a previous one (Add to
    list), this now helpfully also removes any "Restart numbering" properties.
    (Justin Luth) tdf#113213
  * Spell checking dialog: various papercut fixes. Correct-All list no longer
    cleared unnecessarily (and more reliably cleared when switching to another
    application). (Justin Luth) tdf#191558 tdf#126826
  * Record Track Changes: Partly-deleted paragraphs added to the hidden list.
    In this way, track changes for partly-deleted paragraphs will not be
    displayed in the numbering list. (Bayram ?i?ek, Collabora) tdf#157596
  * Writer now takes line spacing into account for field shadings. In this way,
    bottom of some letters (e.g. "?", "?", "g", "p") will not be cut off
    because of the "field shadings" background layer. (Bayram ?i?ek, Collabora)
    tdf#167527
  * Do not show line numbering in footnote during DOCX import. (Bayram ?i?ek,
    Collabora) tdf#167202
  * Pasting a single image from the clipboard now automatically inserts a
    caption, following the Writer AutoCaption Images configuration setting.
    (Michael Stahl, Collabora) d072b5e0
  * Writer now supports Start and End paragraph alignment. These options align
    paragraphs relative to the paragraph text direction, and can simplify
    reusing styles across languages and writing systems. (Jonathan Clark, TDF)
    tdf#118350
  * Writer can now automatically set the direction of RTL text while typing.
    This behavior can be added to a paragraph style by checking the
    "Automatically set direction" option in the alignment tab of the paragraph
    dialog. (Jonathan Clark, TDF) tdf#162120
  * Writer now displays a more visible grid, and the Snap to Grid functionality
    now accurately aligns objects with the grid. (Tam??s Zolnai) tdf#89544 tdf#
    126493
  * Option to prevent dragging of selected text per Tools ? Options ?
    LibreOffice ? Writer ? Formatting Aids: Drag 'n Drop: [x] Allow text to be
    dragged and dropped (Heiko Tietze, tdf) tdf#100998

Calc

  * Added connector support for Calc. The object path in the standard toolbar:
    Insert ? Shape ? Connectors. The object path in the tabbed user interface:
    Insert ? Connectors (double click for multi-selection). (Amin Irgaliev,
    Vladislav Tarakanov) tdf#79356
  * Calc now supports xmlMaps.xml. (Bayram ?i?ek, Collabora) tdf#167689
  * Improvements to the Sort dialog options. (Regina Henschel)
      + When natural sort is enabled in the Sort dialog options, you have an
        additional choice to treat decimal separators as regular characters.
        That allows to sort IP addresses, for example, even if your locale has
        a dot as decimal separator. The fact that natural sort is enabled is
        now written to the file and thus retained when reopening the file. tdf#
        161949
      + The locale setting in the options of the Sort dialog is now written to
        the file and thus retained. Setting the locale effects not only the
        choice of a special sort algorithm but now it effects other locale
        dependent sorting properties too, e.g. which character is used as
        decimal separator for natural sort. tdf#168175.
  * Support for Biff12 (Excel 2007+) clipboard format was added, removing
    limitations of the amount of data pasted into Calc from Excel. (Laurent
    Balland) (Mike Kaganski, Collabora) tdf#127675
  * Excel 2010+ was made the default format when saving as XLSX. It was renamed
    from 'Office Open XML Spreadsheet' to 'Excel 2010??365 Spreadsheet'.
    (Justin Luth, Collabora) tdf#165180
  * Modifying a formula to Matrix mode can now simply be done by F2, ??
    Shift+Ctrl+? Enter. No need to change formula itself. (Laurent Balland) tdf
    #104888
  * The commands to set the font and the background color (.uno:Color/
    uno:BackgroundColor) apply the actual setting from the color picker, when
    assigned to a shortcut. (Heiko Tietze, TDF) tdf#138722, tdf#169812
  * Expert option Office::Calc::Content::Display::NoteTransparency allows users
    to switch off transparency for comments. (Heiko Tietze, TDF) tdf#169504
  * Column titles don't overlap anymore when column widths are small. (Heiko
    Tietze, TDF) tdf#168092}

Performance

  * Scrolling speed was improved when a spreadsheet has many hiding columns
    (Caol??n McNamara, Collabora) tdf#156297
  * Spreadsheets with lots of shapes are now faster to work with. (Noel
    Grandin, Collabora) tdf#154913
  * Removal of duplicate entries is now faster. (Noel Grandin, Collabora) tdf#
    166121
  * Reject tracked changes is faster. (Noel Grandin, Collabora) tdf#133557
  * Exporting SVGs with lots of bitmaps was optimized. (Noel Grandin,
    Collabora) tdf#169532

Impress

  * Introduced Microsoft Media Foundation APIs on Windows to support video and
    audio playback of common codecs. Managing video playback with MFPlay. About
    the supported video and audio file formats (without any additional
    installed codec), more information can be found on this link. (Balazs
    Varga, Collabora) tdf#62408 tdf#105168 tdf#159292

Base

  * Base is now truly multi-user. (Pierre Vacher) tdf#167960

Chart

  * Hovering with the mouse over Chart data range colour palette entries in the
    Sidebar now shows a live preview in the active chart. (Marco Cecchetti,
    Collabora) 25fa7051

  * Some OOXML chart style content now round-trips through LibreOffice (OOXML
    -> LO -> OOXML) successfully. For now this is incomplete, and the style
    data is neither available nor modifiable in the user interface. (Kurt
    Nordback, Collabora) tdf#168472

Performance

  * Performance issues with 3D charts were fixed. (Noel Grandin, Collabora) tdf
    #148988


Core / General

  * Fonts for which the license disallows editing, which are embedded in
    documents, are now supported. Previously, they were silently ignored, and
    the documents were displayed using substitute fonts. Now the user is asked
    if they want to open the document in edit mode (without the said fonts), or
    in read-only mode (with the fonts used for display). ODF and OOXML file
    formats are supported. (Mike Kaganski, Collabora) tdf#145967
  * A part of the infrastructure that affects connectors has been moved from sd
    to svx. This change allows implementing connectors functionality in other
    modules (Calc, Writer). (Amin Irgaliev, Vladislav Tarakanov) tdf#79356
  * Google Drive authentication was improved to use normal browser method
    (Windows only for now). (Mike Kaganski, Collabora) tdf#101630

  * PDF export: handle document external links. (Floris Bos; Olivier Hallot,
    TDF) tdf#167490 tdf#170309

Filters

Generic XML and JSON mapping to Calc

Generic XML and JSON documents with linkable ranges are now automatically
mapped to sheets in Calc. A linkable range is a section of a document
containing tabular records. When a document contains multiple linkable ranges,
each range gets mapped to a single sheet.

For example, the following JSON document

[
  {
    "id": 5001,
    "name": "Wireless Mouse",
    "description": "Ergonomic wireless mouse with adjustable DPI settings.",
    "sku": "WM-ERGO-BLK-01",
    "price": 25.50,
    "stock_quantity": 150,
    "category": "Electronics"
  },
  {
    "id": 5002,
    "name": "Mechanical Keyboard",
    "description": "RGB mechanical keyboard with brown switches for tactile feedback.",
    "sku": "MK-RGB-BROWN-02",
    "price": 89.99,
    "stock_quantity": 75,
    "category": "Electronics"
  },
  {
    "id": 5003,
    "name": "Laptop Stand",
    "description": "Adjustable aluminum laptop stand for improved ergonomics.",
    "sku": "LS-ALUM-ADJ-03",
    "price": 35.00,
    "stock_quantity": 200,
    "category": "Accessories"
  }
]

gets mapped to the following range of values when opened.

There is no constraints on the structure of the original data in the source
document as the structure of the original data is analyzed and is automatically
mapped to sheet. However, this automatic mapping is done on a best-effort
basis, and it may not work in all cases.

XML documents with linkable ranges are handled in a similar fashion. (Kohei
Yoshida, Collabora)

DOCX

  * Improved line height handling of Chinese, Japanese, and Korean DOC/DOCX
    documents. (Jonathan Clark) tdf#129808

Markdown

  * Added support for exporting to Markdown format (blog post). (Mike Kaganski,
    Miklos Vajna; Collabora) tdf#160734 tdf#168152 tdf#168172 tdf#168317 tdf#
    168341 tdf#168662
  * Added support for importing from Markdown format, either via files or via
    the clipboard. (Ujjawal Kumar) tdf#162153
  * Added support for using ODT/DOCX templates while importing a Markdown
    document (blog post). (Miklos Vajna; Collabora)

EPUB

  * EPUB export was made much faster, and a progress bar is shown during
    export. (Noel Grandin, Collabora) tdf#133976

Graphics

The Skia graphics engine is now mandatory on both Windows and macOS. (Noel
Grandin, Collabora) 07f480b7 9f9550a6

Performance

  * Rendering of shape fills was made more performant. (Noel Grandin,
    Collabora) tdf#160345 tdf#149592
  * Rendering of SVGs with pattern fills is now faster on Linux. (Noel Grandin,
    Collabora) tdf#101083

User Interface

  * All dialogs use vertical tabs with icons now. (Heiko Tietze) tdf#161497

  * Option to use horizontal tabs instead vertical. (Heiko Tietze) tdf#167108

  * The Layouts panel in the Impress Sidebar now uses a native IconView widget
    instead of the ValueSet widget. (Parth Raiyani, Collabora) tdf#166964
  * The Theme dialog now uses a native IconView widget instead of the ValueSet
    widget. (Parth Raiyani, Collabora) tdf#167074
  * The Presets and Shadow Style Positions from the border page dialog now use
    a native IconView widget instead of the ValueSet widget. (Parth Raiyani,
    Collabora) tdf#167536
  * The Go to Page/Slide/Sheet dialogs are now async. (Hubert Figui??re,
    Collabora) 8b609509 1beb3252 46c25815
  * Allow inserting hyperlink via context menu (when text is selected). (Samuel
    Mehrbrodt, Collabora) tdf#167544
  * Dialog screenshots can now be copied to the clipboard for immediate pasting
    in documents (Olivier Hallot, TDF) tdf#166391
  * On Linux, the native GTK and Qt color picker dialogs are now used by
    default instead of the custom LibreOffice one. This can be configured in
    Tools ? Options ? LibreOffice ? General (Michael Weghorn, TDF) tdf#167669
    tdf#169505
  * The page size dropdown in the NotebookBar is now visually more consistent
    with the rest of the User Interface and it displays the full names of the
    available page sizes. (Michael Weghorn, TDF) tdf#136905 tdf#169710
  * New symbols for unordered lists (Heiko Tietze, TDF) tdf#168292
  * Image library for unordered lists (bullets) updated. (Andreas Kainz; Heiko
    Tietze, TDF) tdf#139076

Accessibility

  * Accessibility of the border previews in the Border tab of various dialogs
    (like Writer's Format ? Paragraph dialog) has been improved to avoid
    confusing screen reader announcement. (Michael Weghorn, TDF) tdf#167279
  * When the Tools ? Spelling dialog shows up, it is now properly announced by
    the Orca screen reader on Linux. (Michael Weghorn, TDF) tdf#163802
  * Removing the accessible selection no longer unexpectedly sets the caret to
    the beginning of the text. (Michael Weghorn, TDF) tdf#167930
  * The Help ? Check for Updates... dialog is now screen reader accessible.
    (Michael Weghorn, TDF) tdf#104833
  * Spelling errors in Writer are now only reported to assistive technology
    when automatic spell checking is actually enabled. (Michael Weghorn, TDF)
    NVDA #19170
  * Keyboard accessibility for the Tools ? Extensions... dialog has been
    improved. (Michael Weghorn, TDF) tdf#127201
  * It is now possible to switch between vertical tabs using keyboard
    shortcuts. (Heiko Tietze, TDF; Michael Weghorn, TDF) tdf#167125 tdf#169383


Scripting

  * The version of the internal Python is 3.12.
  * Ship sqlite3 with internal python. (Xisco Fauli, TDF) tdf#168512
  * Ship dbm with internal python. (Xisco Fauli, TDF) tdf#132074
  * Ship venv with internal python. (Xisco Fauli, TDF) tdf#168511
  * Ship lzma with internal python. (Xisco Fauli, TDF) tdf#168513

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

New in LibreOffice 26.2:

  * The session.GetRangeFromCalc() method reads the values contained in a given
    range located in a given Calc file. The file does not need to be open.
  * The new ScriptForge.Sharedmemory service implements the mechanisms to
    manage persistent memory storage across Basic and/or Python scripts. In
    event-driven scripting one can often benefit from having variables still
    being available when the next script is triggered, probably due to a user
    action. And this, especially, in Basic + Python mixed environments.
  * The scriptforge.pyi stub file, which is a great support when editing python
    scripts with PyCharm or VSCode, has its syntax upgraded to Python ?? 3.10.
    Older typing features are now superseded by more modern alternatives.
  * The AccessibleContext UNO API is gradually being deprecated. A serious code
    revisit was needed. More details in tdf#168409.
  * The calc.ColorizeRange() method accepts now negative values in the
    background and foreground arguments to reset them to their default value.
  * The new SFDocuments.Shape service is focused on the description of shapes/
    images/drawing objects stored in (in the current release only) Calc
    documents. Next methods are implemented : shape.Anchor(),
    shape.ExportToFile(), shape.Pick(), shape.Resize() and shape.Rotate() about
    any pivot point.

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.

ScriptForge in the wiki: read Macros/ScriptForge (Lobaluna).

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


Localization

Improvements to proofing tools and language support

  * Spell check dictionaries were updated for the languages: Hungarian,
    Mongolian, Portuguese (pt_PT)
  * Hyphenation rules were updated for the languages: Hungarian


26.2.0.3:
List of fixed bugs

Bugs fixed compared to 26.2.0 RC2:

 1. tdf#41777 Window size reopening a document not like size when saved
    [Michael Weghorn]
 2. tdf#130857 qt5/qt6: implement theming using native Qt widgets (weld)
    [Michael Weghorn]
 3. tdf#137833 Image appears rotated when loaded in latest LO [Xisco Fauli]
 4. tdf#162527 w:drawing is displayed even though set to hidden [Aron Budea]
 5. tdf#168281 Issues with slide layout sidebar pane (Windows, qt, gen)
    [Michael Weghorn]
 6. tdf#168438 [26.2] Border Style icon in the toolbar does not work [Xisco
    Fauli]
 7. tdf#168640 Invisible characters in Customize - Keyboard UI (kf6-only)
    [Michael Weghorn]
 8. tdf#169371 LibreOffice don't start at all. A message appears on my screen
    telling: soffice.exe - program error [Christian Lohmaier]
 9. tdf#169441 Decouple bullet library items from default levels [Aron Budea]
10. tdf#169485 Cannot insert the image by drag and drop (Windows-only) [Mike
    Kaganski]
11. tdf#169802 Text still flows around hidden shape in DOCX [Aron Budea]
12. tdf#169933 Dashed and dotted lines are converted to solid lines in PDF
    output [Masayuki Iizuka]
13. tdf#169934 Transparency is lost when applying a duotone filter to images in
    Excel files [Noel Grandin]
14. tdf#170399 Crash when trying to edit template [Michael Weghorn]


26.2.0.2:
List of fixed bugs

Bugs fixed compared to 26.2.0 RC1:

 1. cid#1676290 argument cannot be negative [Caol??n McNamara]
 2. ofz#470644944 null-dereference READ [Caol??n McNamara]
 3. ofz#471087908 null-dereference READ [Caol??n McNamara]
 4. ofz#471764989 integer-overflow [Caol??n McNamara]
 5. ofz#471785270 integer-overflow [Caol??n McNamara]
 6. ofz#472735025 integer-overflow [Caol??n McNamara]
 7. ofz#473050752 integer-overflow [Caol??n McNamara]
 8. tdf#40277 Compound words & personal dictionary [L??szl?? N??meth]
 9. tdf#89365 Impress: Change from Bullets to Numbering to Bullets does not set
    bullet, needs another click [Miklos Vajna]
10. tdf#90993 EDITING: Objects anchored to frame disappear when frame anchor is
    changed. [Jim Raykowski]
11. tdf#111969 right-click on right half of last character in selection loses
    the selection (Writer) [Justin Luth]
12. tdf#127675 Pasting only 65536 rows / 256 columns / 255 characters per cell
    to Calc from Excel (missing support for BIFF12 clipboard format) [Mike
    Kaganski]
13. tdf#130695 EDITING: in custom dictionary, let abbreviations have trailing
    periods, and recognize the bad abbreviations without the dot [L??szl?? N??
    meth]
14. tdf#131124 Export of drawing to jpg or png has initial zero width/height if
    it is 3D [Regina Henschel]
15. tdf#138722 Custom shortcut for uno:BackgroundColor should set last color
    not NoFill [Heiko Tietze]
16. tdf#142693 Libreoffice Writer is not reading user page sizes from docx file
    [Aron Budea]
17. tdf#148041 Clicking text will make line spacing change for no reason in
    Impress [Balazs Varga]
18. tdf#151849 Find-and-replace shortcut becomes keyboard-layout-sensitive in
    find bar [Caol??n McNamara]
19. tdf#152706 TRANSLATION: "Requested clipboard format is not available" error
    message when using DeepL translation feature [Mike Kaganski]
20. tdf#154285 IsNumeric(1,2) returns True, must produce an error [Vaibhav
    Singh]
21. tdf#155306 Footnotes numbering start per Page in a section with more than 1
    column always shows 0 [Mike Kaganski]
22. tdf#162514 Spellchecker fails to recognize words ending in period
    (typically abbreviation) [L??szl?? N??meth]
23. tdf#165180 PPTX: Default to using Impress 'Office Open XML Presentation'
    filter (PowerPoint 2010+) (comment 48) [Justin Luth]
24. tdf#165742 Chartex charts are lost on input from OOXML and re-export [Kurt
    Nordback]
25. tdf#166945 Mouse cursor insertion is offset to left of cursor when
    right-clicking [Justin Luth]
26. tdf#167737 In Dark Mode, when leaving chart back to Calc, label font
    becomes black [Caol??n McNamara]
27. tdf#168076 [26.2 CJK vertical Skia] In the vertical writing mode, the
    3-point reader turns sideways and moves to the top to overwrite (or be
    Bold) [Xisco Fauli]
28. tdf#168110 Placeholder text is visible in presentation mode [Balazs Varga]
29. tdf#168737 FILEOPEN DOCX Overlapping redlines: multiple Accept All / Reject
    All needed [Miklos Vajna]
30. tdf#168751 FILEOPEN DOCX Overlapping redlines: character formatting on
    deleted text can not be rejected [Miklos Vajna]
31. tdf#168977 FILESAVE DOCX Document with chart in footer can't be opened in
    Word after roundtrip [Justin Luth]
32. tdf#169049 Problems with Data provider SORT_TRANSFORMATION [Regina
    Henschel]
33. tdf#169154 FILTER DOC: Files are reported as "corrupted" but can be opened
    nevertheless [Kohei Yoshida]
34. tdf#169419 Page size is written to DOCX outside of range allowed by Word /
    [MS-OI29500] [Aron Budea]
35. tdf#169456 FILEOPEN PPTX Text placeholder objects background becomes None
    instead of solid white [G??l?ah K?se]
36. tdf#169504 Comments transparency can't be disabled, which can make comments
    difficult to read. [Heiko Tietze]
37. tdf#169812 Custom shortcut for .uno:Color should set last color not open
    dialog [Heiko Tietze]
38. tdf#169813 Imported SVG changes appearance after breaking [Andreas
    Heinisch]
39. tdf#169843 Fileopen DOCX: Set of real numbers R not read properly as symbol
    [Pranam Lashkari]
40. tdf#169911 FILESAVE: ODP -> PPTX exporting animations without a target
    [Karthik Godha]
41. tdf#169914 Black background of the report builder : charts are not visible
    (Windows) [Noel Grandin]
42. tdf#169920 Glyph positions are incorrect with DFKai-SB in vertical writing
    [Jeff Huang]
43. tdf#169924 FILESAVE: ODP -> PPTX exporting animations of shapes which are
    not in the current slide [Karthik Godha]
44. tdf#169941 FILESAVE: ODP -> PPTX internal links to shapes [Karthik Godha]
45. tdf#169949 Unexpected tab portion for headings from simple DOCX file
    [Miklos Vajna]
46. tdf#169971 Background color of Start Center is white in light theme [Dan
    Williams]
47. tdf#169979 FILESAVE: ODP -> PPTX missing p:pic element [Karthik Godha]
48. tdf#169980 FILESAVE: ODP -> PPTX Improper Export of StockChart [Karthik
    Godha]
49. tdf#170003 paragraph before table is getting below spacing from the
    continuous section break [Justin Luth]
50. tdf#170012 infinite loop/crash when saving ODS with a SCA_CELL_RESIZE form
    control that moved [Justin Luth]
51. tdf#170019 daily build has wrong path to gallery in chart data point
    properties type Icon [Xisco Fauli, Heiko Tietze]
52. tdf#170027 Crash when undoing shape drag with Alt pressed [Balazs Varga]
53. tdf#170035 FILESAVE: PPTX -> PPTX internal names are exported in custom
    shape geometry [Karthik Godha]
54. tdf#170041 Writer Navigator: split frames holding floating tables aren't
    highlighted fully [Jim Raykowski]
55. tdf#170067 Writer: Unprotect section needs to ask for set password [Jim
    Raykowski]
56. tdf#170102 FILESAVE PowerPoint's Title and Content layout doesn't survive
    PPTX->ODP->PPTX conversion correctly [Aron Budea]
57. tdf#170119 DOCX LAYOUT: top margin after continuous-section break should be
    "reduced" by the sectPr's bottom margin [Justin Luth]
58. tdf#170140 spell checking: missing support of words with non-ASCII
    apostrophe [L??szl?? N??meth]
59. tdf#170166 Bullets appeared after PPTX export [Balazs Varga]
60. tdf#170171 Fileopen DOCX: Formula with brackets shows inverted question
    marks [Pranam Lashkari]
61. tdf#170202 FILESAVE PPTX Presentations with physics animations become
    invalid when saved to PPTX [Aron Budea]
62. tdf#170208 table/content without cell margin shifted left of the page
    margin [Justin Luth]
63. tdf#170257 Dragging a shape over another shape changes positions [Noel
    Grandin]
64. tdf#170261 Provide 2010 VBA export filters for docm, xlsm, pptm [Justin
    Luth]
65. tdf#170283 LibreOffice crashed when opening a .ppt file [Noel Grandin]
66. tdf#170325 Update default two digit year range start from 1930 to a more
    current one [Aron Budea]


26.2.0.1:
List of fixed bugs

Bugs fixed compared to 26.2.0 Beta1:

 1. cid#1557959 variable copied when it could be moved [Caol??n McNamara]
 2. cid#1659736 division or modulo by float zero [Caol??n McNamara]
 3. cid#1660011 variable copied when it could be moved [Caol??n McNamara]
 4. ofz#466583689 cairo doesn't really handle outside +- 1 << 23 [Caol??n
    McNamara]
 5. tdf#96389 Default tab size wrong on pptx import [Justin Luth]
 6. tdf#149756 FILEOPEN PPTX Some connectors are broken [Justin Luth]
 7. tdf#152545 Connectors line spacing problem [Justin Luth]
 8. tdf#154285 IsNumeric(1,2) returns True, must produce an error [Simon
    Chenery]
 9. tdf#155780 FileName Field displays wrong content if IsFixed is True when
    inserted by Macro. [Andreas Heinisch]
10. tdf#156611 Calc: able to insert multiple hyperlinks into cell, but they
    wont be saved [Justin Luth]
11. tdf#158289 The term "Track changes" is being used ungrammatically [Ilmari
    Lauhakangas]
12. tdf#159169 Wrong translation for German (because "Orphans" and "Widows"
    terms are still in Find and Replace > Attributes) [Samuel Mehrbrodt]
13. tdf#160096 Validity list set to not show error message does not allow
    unlisted values to be entered [Heiko Tietze]
14. tdf#163347 UI: Options - Charts - Default Colors: Chart Colors and Color
    Table do not represent actual value [Jim Raykowski]
15. tdf#164141 XLS with command button roundtripped as XLSX not opening in
    Excel [Aron Budea]
16. tdf#165180 PPTX: Default to using Impress 'Office Open XML Presentation'
    filter (PowerPoint 2010+) (comment 35) [Justin Luth]
17. tdf#165207 FILESAVE DOCX: save date field zero'd out (in MS Word) after
    round-trip [Justin Luth]
18. tdf#165225 Text is not visible on selected inactive menu bars on
    LibreOffice v.25.2.0.3 [Heiko Tietze]
19. tdf#166325 FILESAVE DOCX Word fails to open roundtripped document (bg2
    theme color turns into light2) [Aron Budea]
20. tdf#167385 Comment resolution menu does not refresh after state change
    [Michael Weghorn]
21. tdf#168452 SVG: support unicode-bidi [Xisco Fauli]
22. tdf#168737 FILEOPEN DOCX Overlapping redlines: multiple Accept All / Reject
    All needed [Miklos Vajna]
23. tdf#168818 F4 key does not cycle through individual references, when they
    have line breaks [Mike Kaganski]
24. tdf#169072 FILESAVE PPTX File fails to open in PP again, difference between
    UI and convert-to (forum-mso-de-38427.ppt) [Justin Luth]
25. tdf#169105 Writer: Font name is auto-completed but auto-completed text is
    not updated when the following chars do not match the auto-completed name
    (gtk3) [Caol??n McNamara]
26. tdf#169414 Ghost object remains in original position after object is moved
    [Noel Grandin]
27. tdf#169505 RGB, HSB, CMYK textboxes gone from color picker dialog [Michael
    Weghorn]
28. tdf#169524 FILESAVE PPTX Paragraphs in shapes get 0.6 cm before indent
    [Karthik Godha]
29. tdf#169680 FILEOPEN DOCX: images stretched or squeezed [Miklos Vajna]
30. tdf#169727 Left hand pane of main base window does not update system theme
    dynamically in macOS [Dan Williams]
31. tdf#169730 Persian (Farsi) filenames are displayed reversed in LibreOffice
    Start Center [Xisco Fauli]
32. tdf#169791 When selecting multiple text runs and adding ruby, extra
    characters are added [Jonathan Clark]
33. tdf#169825 FILESAVE PPTX Certain layouts are exported invalid [Aron Budea]
34. tdf#169841 Update logo in Start center for 26.2 [Heiko Tietze, Xisco Fauli]
35. tdf#169851 [26.2] In the cell formatting dialog, you might forget the name
    of the last used palette for background color [Jim Raykowski]
36. tdf#169871 LibreOffice Writer displays incorrect colors in BMP images when
    an odt file was created with OpenOffice Writer. [Andras Timar]
37. tdf#169882 Writer freezes when opening a file [Mike Kaganski]
38. tdf#169884 Links containing "~" in Markdown files may cause them to fail to
    open [Ujjawal Kumar]
39. tdf#169909 Provide ability to copy to clipboard the URL path from the File
    -> Properties... dialog "Location:" field [Heiko Tietze]
40. tdf#169986 footnotes are getting below spacing from the continuous section
    break [Justin Luth]


26.2.0 Beta1:
List of fixed bugs

Bugs fixed compared to 26.2.0 Alpha1:

 1. cid#1399153 uncaught exception [Caol??n McNamara]
 2. cid#1399234 uncaught exception [Caol??n McNamara]
 3. cid#1399299 uncaught exception [Caol??n McNamara]
 4. cid#1399305 uncaught exception [Caol??n McNamara]
 5. cid#1399336 uncaught exception [Caol??n McNamara]
 6. cid#1494598 uninitialized scalar field [Caol??n McNamara]
 7. cid#1659626 uncaught exception [Caol??n McNamara]
 8. cid#1659836 uncaught exception [Caol??n McNamara]
 9. cid#1659880 division or modulo by float zero [Caol??n McNamara]
10. cid#1660226 silence Uncaught exception [Caol??n McNamara]
11. cid#1660275 uncaught exception [Caol??n McNamara]
12. cid#1662039 silence Data race condition [Caol??n McNamara]
13. cid#1664877 division or modulo by float zero [Caol??n McNamara]
14. cid#1666317 logically dead code [Caol??n McNamara]
15. cid#1667045 silence Division or modulo by float zero [Caol??n McNamara]
16. cid#1667056 silence Data race condition [Caol??n McNamara]
17. cid#1667063 silence Overflowed constant [Caol??n McNamara]
18. cid#1667078 silence Overflowed constant [Caol??n McNamara]
19. cid#1667085 silence Overflowed constant [Caol??n McNamara]
20. cid#1667094 silence Overflowed constant [Caol??n McNamara]
21. cid#1675018 big parameter passed by value [Caol??n McNamara]
22. cid#1675019 variable copied when it could be moved [Caol??n McNamara]
23. cid#1675088 use of auto that causes a copy [Caol??n McNamara]
24. cid#1675089 uninitialized scalar field [Caol??n McNamara]
25. cid#1675090 unchecked dynamic_cast [Caol??n McNamara]
26. cid#1675328 variable copied when it could be moved [Caol??n McNamara]
27. cid#1675329 silence Overflowed constant [Caol??n McNamara]
28. cid#1675332 silence Dereference null return value [Caol??n McNamara]
29. cid#1675333 silence Arguments in wrong order [Caol??n McNamara]
30. cool#7880 langaugetool: fix crash on opening spelling dialog [Rashesh
    Padia]
31. cool#13193 fix Ctrl Shift V issue on impress [G??l?ah K?se]
32. cool#13574 sw redline render mode: send LOK status [Miklos Vajna]
33. ofz#465488771 integer-overflow [Caol??n McNamara]
34. tdf#62248 REPORTBUILDER: multiple groupings on same field broken [Vissarion
    Fisikopoulos]
35. tdf#75280 Convert inappropriate use of sal_uIntPtr to better integer types
    [Daniel Lee]
36. tdf#82580 get rid of prewin.h / postwin.h wrapper headers [Daniel Lee]
37. tdf#114441 Convert use of sal_uLong to better integer types [Daniel,
    codemaestro, Daniel Lee]
38. tdf#130857 qt5/qt6: implement theming using native Qt widgets (weld)
    [Michael Weghorn]
39. tdf#136419 EDITING: Select All in Frame does not select all contents [Jim
    Raykowski]
40. tdf#136905 NB Layout tab 'Page Size' drop list UX is poor [Michael Weghorn]
41. tdf#143148 Use pragma once instead of include guards (Episode 2: Endgame)
    [seyoufi22, Daniel]
42. tdf#145614 Convert #define to enum or constexpr [Simon Chenery, seyoufi22]
43. tdf#145759 Use symbolic constants instead of magic numerical constants
    [Daniel]
44. tdf#146619 Remove unused #includes from C/C++ files [Gabor Kelemen]
45. tdf#146734 F1 (Help) for "Manage" button in Template Manager has no help
    [Olivier Hallot]
46. tdf#147021 Use std::size() or std::ssize() instead of SAL_N_ELEMENTS()
    macro [Nguyen, Simon Chenery]
47. tdf#148703 Writer crash on undo after paste [David Hashe]
48. tdf#150150 [Calc][UI] Comment indicator is hidden behind the AutoFilter
    dropdown [Justin Luth]
49. tdf#152030 Allow regular deletion of selection containing an entire
    generated index/table [Jim Raykowski]
50. tdf#153183 FILESAVE DOCX writing attribute "ID" in v:shape produces invalid
    document [Xisco Fauli, Noel Grandin]
51. tdf#154443 UI: Page corners rendered incorrectly (grey squares) [Heiko
    Tietze]
52. tdf#157664 Drop operator !=, where respective operator == is defined
    [sebastiangm15]
53. tdf#158237 Use C++20 contains() instead of find() and end() [Simon Chenery]
54. tdf#158921 Exported pivot table with custom name field yields corrupt XLSX
    when opened in MSO [Xisco Fauli]
55. tdf#162504 No Help page for multiple Sidebar Decks [Olivier Hallot]
56. tdf#162562 Tabbed UI has ugly outline around tab section (gtk3) [Caol??n
    McNamara]
57. tdf#162711 In VBASupport mode, conversion to Integral type must use
    banker's rounding [Andreas Heinisch]
58. tdf#163738 Use insert() to add multiple values in containers instead of a
    loop [Nicu]
59. tdf#164685 Cleanup class SfxItemSetFixed [shlok3640]
60. tdf#165233 Use lambdas instead of std::bind [Simon Chenery]
61. tdf#166386 Provide confirmation warning dialog for MRUs "Clear Recent
    Documents" and "Clear Unavailable Files" [Sampath-1984]
62. tdf#166724 Checkbox anchor wrongly imported from xlsx [Johann LORBER,
    Justin Luth]
63. tdf#167075 Pasting a selection onto a sheet in PNG or BMP results in a
    blank image [Xisco Fauli]
64. tdf#167125 Provide keyboard shortcut to switch between vertical tabs
    [Michael Weghorn]
65. tdf#167362 LibreOffice crashes for zoomtext and jaws users when the cursor
    is on the same line as a footnote. [Michael Stahl]
66. tdf#167386 copy & pasting text boxes fail [Xisco Fauli]
67. tdf#167941 Chart style file is not supported on import from/export to OOXML
    [Kurt Nordback]
68. tdf#168054 When extracting .svg files from .odg files, only the first page
    is extracted. [Mike Kaganski]
69. tdf#168120 line thickness menu is transparent and uses different font than
    other menus [Michael Weghorn]
70. tdf#168520 Give automated tests human-readable names [Ilmari Lauhakangas,
    Roman, Jussi Suominen, Daniel]
71. tdf#168736 FILESAVE PPTX - PPT presentation with link to next slide can't
    be opened in PowerPoint after saving [Karthik]
72. tdf#168843 FILESAVE PPTX - PPT exports invalid font size when saved as PPTX
    [Karthik Godha]
73. tdf#168850 In the second sheet, pasting range in PNG or BMP, image without
    sparklines will be pasted [Xisco Fauli]
74. tdf#168897 Crash when JAWS is running and template starting with table is
    opened [Michael Stahl]
75. tdf#168943 FORMATTING - Conditional formatting range incorrectly applied
    before restart [Mike Kaganski]
76. tdf#169019 Data provider SPLIT_TRANSFORMATION wrongly written to file and
    wrongly read on loading the file [Xisco Fauli]
77. tdf#169077 Data Provider dialog does not work with format HTML [Neil
    Roberts, Regina Henschel]
78. tdf#169088 FILESAVE PPTX: PPT/PPTX files with OLE object animations can't
    be opened in PowerPoint after saving as PPTX [Karthik Godha]
79. tdf#169122 Writer: Consistent Write Error When Overwriting XML (parser
    error : Attribute style:writing-mode redefined) [Regina Henschel]
80. tdf#169148 Date picker in DOCX file has black background [Noel Grandin]
81. tdf#169225 [26.2] Color emoji background appears black with certain fonts
    [Noel Grandin]
82. tdf#169251 Crash on copy, new, paste Markdown [Miklos Vajna]
83. tdf#169347 Item width is too wide on General tab of Print Dialog (Win
    Japanese-UI) [Heiko Tietze]
84. tdf#169351 Selecting part of an array formula and clicking in Input bar,
    cannot close the information dialog by clicking OK. Only ESC works. (Linux
    X11 session, Qt-based UIs) [Caol??n McNamara]
85. tdf#169383 Vertical tabs don't go forward/backwards on Ctrl+Tab /
    Shift+Ctrl+Tab [Michael Weghorn]
86. tdf#169399 A text in a nested section jumps to next page [Mike Kaganski]
87. tdf#169414 Ghost object remains in original position after object is moved
    [Noel Grandin]
88. tdf#169438 FILESAVE: PPT -> PPTX improper export of audio in animations.
    [Aron Budea]
89. tdf#169480 Change navigation back function to first make sure the cursor is
    visible [Jim Raykowski]
90. tdf#169508 Accessibility options behave in reverse for footnotes and
    endnotes [Saburo Yoshida]
91. tdf#169521 Linkification in Input Line does not work (gtk3-only) [Caol??n
    McNamara]
92. tdf#169523 Weird links in the Help topic "VBA supported Data Model" [Ilmari
    Lauhakangas]
93. tdf#169531 Quickfind sidebar: improve strings for results summary [Pedro
    Pinto Silva, Szymon K??os]
94. tdf#169532 Draw crashes when trying to export a page into svg or wmf/emf
    format. [Noel Grandin]
95. tdf#169533 Some slide background images not shown in Presenter console
    (Linux) [Noel Grandin]
96. tdf#169539 FILESAVE: PPT->PPTX Draw OLE object Data loss [Karthik Godha]
97. tdf#169541 Crash in: Data Provider: import 2x + save = crash on open file
    [Regina Henschel]
98. tdf#169553 FILESAVE PPTX Paragraphs aligned to "Start" become centered in
    PP [karthik]
99. tdf#169554 Paste with transpose does not work when pasting to a sheet that
    has been inserted before the source sheet [Xisco Fauli]
100. tdf#169637 The background of Page Size dropdown in Tabbed UI's Layout
    became transparent (kf6, gen) [Noel Grandin]
101. tdf#169656 Crash upon starting animated GIF [Noel Grandin]
102. tdf#169657 The background color of the Hide/Show button is too dark [Heiko
    Tietze]
103. tdf#169675 PPTX FILESAVE Animations on 3D objects result in invalid PPTX
    [Aron Budea]
104. tdf#169694 FILEOPEN PPTX: OLE animations are not imported [Karthik Godha]
105. tdf#169695 Table cells background color changed unexpectedly [Jim
    Raykowski]
106. tdf#169705 FILESAVE: PPT -> PPTX invalid values in a:off element [Karthik
    Godha]
107. tdf#169706 FILESAVE PPTX Empty reference to missing audio saved during
    conversion [Aron Budea]
108. tdf#169710 Notebookbar "Page Size" dropdown doesn't shown full name of
    page sizes [Michael Weghorn]
109. tdf#169716 [LOCALHELP] Update text alignment page with START/END +
    extended tips [Olivier Hallot]
110. tdf#169729 sm Formula editor guide and localhelp coverage of the Arabic
    mathematical expressions and RTL-LTR bidi support added at 24.2 [Olivier
    Hallot]
111. tdf#169781 FILEOPEN: PPTX legacy VML files are not imported [Karthik
    Godha]
112. tdf#169785 [LOCALHELP] Update Options - View page , ref: Appearance
    [Olivier Hallot]
113. tdf#169807 Applying the original page line-spacing option does not work
    [Tam??s Zolnai]
114. tdf#169817 Data provider inserts into wrong sheet [Xisco Fauli, Regina
    Henschel]

Revision 1.23: download - view: text, markup, annotated - select for diffs
Sat Aug 30 06:44:05 2025 UTC (14 months, 2 weeks ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2025Q4-base, pkgsrc-2025Q4, pkgsrc-2025Q3-base, pkgsrc-2025Q3
Diff to: previous 1.22: preferred, colored
Changes since revision 1.22: +0 -7 lines
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.

Revision 1.22: download - view: text, markup, annotated - select for diffs
Wed Feb 5 03:50:01 2025 UTC (21 months, 1 week ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2025Q2-base, pkgsrc-2025Q2, pkgsrc-2025Q1-base, pkgsrc-2025Q1
Diff to: previous 1.21: preferred, colored
Changes since revision 1.21: +54 -2 lines
misc/libreoffice: Update to 25.2.0.3

Changelog:
25.2.0.3:
Writer

  * Track Changes in Writer: Enhancement to identify a click on a tracked
    change in the document by highlighting the corresponding entry in the
    "Manage Changes" window and sidebar panel. This enhancement greatly
    improves the ability to manage a large number of changes in long documents.
    (Jim Raykowski) tdf#161717 tdf#162018
  * Fixed handling of line object transformations in the DOCX import of Writer.
    (blog post). (Miklos Vajna, Collabora)
  * Improved font fallback in the DOCX import of Writer (blog post). (Miklos
    Vajna, Collabora)
  * Added Group and Mono controls to the Asian Phonetic Guide dialog. By
    default, the Asian Phonetic Guide dialog decomposes a selection into words
    for annotation. The Group button allows annotating the entire selection.
    The Mono button allows annotating each character individually. (Jonathan
    Clark, TDF) tdf#107184 tdf#156543
  * Improved interactivity for LOK clients in Writer's layout (blog post).
    (Miklos Vajna, Collabora)
  * Added options to set a default zoom level for opening documents, overriding
    zoom level stored in documents (Oliver Specht, Allotropia) tdf#132274
  * Added option to promote a reply comment into a root comment (Jaume
    Pujantell, Collabora) 98cd8bac
  * Writer TextBoxes now handle page captures (blog post). (Miklos Vajna,
    Collabora)
  * Boundaries are now toggled independently of Formatting Marks, are
    controlled per Tools ? Options ? Writer ? Formatting Aids, and switched on/
    off with View ? Boundaries. (Heiko Tietze, TDF) tdf#74386, tdf#163856

  * Default items for unordered lists aka bullets was updated (Heiko Tietze,
    TDF) tdf#108697

  * The Page Number Wizard now offers an option to fit the numbers into
    existing margins in order to avoid repagination. (Justin Luth, Collabora)
    tdf#161646
  * The dialog and Sidebar deck for managing tracked changes now have sorting
    options. (Jim Raykowski) tdf#161811
  * It is now possible to delete all content of a content type (excluding
    headings) via the Navigator. (Jim Raykowski) tdf#156926
  * The colour of non-printing characters can be customised. (Heiko Tietze,
    TDF) tdf#80054
  * The background colour of comments can be customised. (Heiko Tietze, TDF)
    tdf#61242
  * Comments are now tracked in the Navigator when you move the focus into
    comment boxes. (Jim Raykowski) tdf#152297
  * Selecting a match in the Find Sidebar deck will show its index number. (Jim
    Raykowski) tdf#163100
  * Resizing the area containing comments shows a visual guide. (Rafael Lima)
    tdf#162855
  * The Hanging Indent command now also works, if the targeted paragraph has no
    existing indent. (Kira Tubo) tdf#156374
  * Hovering the mouse over a heading in the Navigator displays a tooltip
    showing the word and character count of the content associated with it.
    (Jim Raykowski) tdf#63967

  * All footnotes in a document can be changed to endnotes and vice versa. (Jim
    Raykowski) tdf#89352
  * Warning and error levels in the Accessibility Sidebar deck were improved,
    and an option was added to ignore warnings. (Bal??zs Varga, allotropia) tdf
    #157233 tdf#164048
  * Support was added for inline headings, which are commonly used in legal
    documents. (L??szl?? N??meth) tdf#131728
  * Improved ignoring of the paragraph margin at the top of pages (blog post).
    (Miklos Vajna, Collabora)

Calc

  * Support import and export of connections.xml in OOXML. (Bayram ?i?ek,
    Collabora) tdf#158857
  * A statusbar icon will indicate when Data ? Calculate ? AutoCalculate is
    switched off. (Heiko Tietze, TDF) tdf#127937

  * A 'Handle Duplicate Records' dialog to select/remove duplicate records in
    Calc. Place the active cell on some data or select some range, then Data ?
    Duplicates... (Sahil Gautam) tdf#85976

  * Both the Function Wizard dialog and Functions Sidebar deck received
    improvements to searching and user experience. (Ahmed Hamed) tdf#161534 tdf
    #161296 tdf#161543
  * When selecting all while in a cell with neighbouring data, the selection
    will cover the neighbouring cells. The next call of Select All will select
    the full sheet. This behaviour can be disabled by setting the expert option
    SelectRangeBeforeAll to false. (Heiko Tietze, TDF) tdf#161641
  * Solver models can now be saved into spreadsheets and Solver is able to
    provide a sensitivity analysis report. (Rafael Lima) tdf#160062 tdf#157519
  * An expert option WrapNextPrevSheetTab was added to control the behaviour of
    navigating Calc sheets using the Ctrl?+?PgDn and Ctrl?+?PgUp keyboard
    shortcuts. (Mike Kaganski, Collabora) tdf#160580
  * An expert option WarnActiveSheet was added to control the warning about the
    active sheet being the only sheet saved or exported to some formats (like
    CSV). Suppress the message by setting it to false. (Heiko Tietze, TDF) tdf#
    33714
  * A "Summary below data" option was added to the Subtotals dialog. (Bal??zs
    Varga, allotropia) tdf#162262
  * New sheet protection options related to Pivot Tables, Pivot Charts and
    AutoFilters were added. tdf#160404 tdf#160535 tdf#160536

Impress

  * The Interaction dialog (click actions) is now async (Hubert Figui??re,
    Collabora) 25b61215
      + enable the ".uno:AnimationEffects" command in LOKit 729e333c
      + enable the ".uno:ExecuteAnimationEffect" command in LOKit ff3a316f
  * Per-paragraph semi-transparent shape text in Impress' SVG export (blog
    post). (Miklos Vajna, Collabora)
  * Automatic repeating of slides can now be activated in windowed mode. (Ariel
    Darshan) tdf#163858
  * Soft edge and glow effects are now allowed in text frame objects (Bal??zs
    Varga, allotropia) tdf#135320

Templates

  * many slight improvements to all Impress templates (Laurent Balland) tdf#
    162490
      + replace pictures with shapes for Nature_Illustration, Pencil, Piano
        templates: it enables modifications of adornments by user
      + background pictures of Blueprint Plans and Metropolis have been
        replaced with SVG pictures: they are now modifiable in Master view
        after a right click  ? Break
      + improve rendering of DNA double helix for DNA template tdf#162229
      + add authors' credit in File ? Properties
      + remove the last slide of Blueprint Plans and Vintage templates
      + all templates have now visible (font color set to black) elements in
        Master Notes and Handout
  * Objects can be centered on the slide (or page in Draw) in one step (Heiko
    Tietze, TDF) tdf#126857
  * Overflowing text in presenter notes is no longer cut off when printing
    (Tibor Nagy, allotropia) tdf#88226

Draw

  * Support for clipping stroke paths in imported PDFs was added (David
    Gilbert) tdf#85428

Base

  * The user experience of the SQL dialog was improved by making user input be
    retained during a session and showing the number of results. (Heiko Tietze,
    TDF) tdf#140298
  * Unicode ODBC calls are now supported. (Mike Kaganski, Collabora) tdf#68676
    tdf#131238


Chart

Math

  * Formulas can be stored in a user-defined category (Heiko Tietze, TDF) tdf#
    163685

Core / General

  * macOS Quick Look is now supported. See the Quick Look wiki page for more
    details. (Patrick Luby) tdf#35361

  * It is now possible to automatically sign documents after defining a default
    certificate. (Sarper Akdemir, allotropia) tdf#159040
  * The commands for setting the colour and background colour of text can be
    assigned to keyboard shortcuts. The applied colour is the active one shown
    in the toolbar and Sidebar buttons. (Justin Luth, Collabora) tdf#34804
  * Support was added for pasting HTML strikethrough formatting. (Andreas
    Heinisch) tdf#79298
  * Improved the mechanism for font rendering for quotation marks when CJK and
    Western texts are intermixed. (Jonathan Clark, TDF) tdf#66791


Filters

Visio

libvisio was updated to 0.1.8:

  * Visio5 support: provide cellType to collector in readTextField (Bartosz
    Kosiorek)
  * tests: Fix build with libxml 2.12 (Jan Tojnar)
  * Add support for simple solid fill styles (Jaume Pujantell, Andras Timar)
    tdf#77915
  * Add support for TextBackground from SheetStyle (Bartosz Kosiorek) tdf#
    136564
  * Improve Arrowheads appearance (Bartosz Kosiorek) tdf#126402
  * Fix reading FillStyleLst and TextBkgnd from shape (Bartosz Kosiorek) tdf#
    154379
  * Add support to DrawingUnits types (Bartosz Kosiorek) tdf#148175
  * On LibreOffice's side, support for opening .vstx files. (Bartosz Kosiorek)
    tdf#163170

ODF

LibreOffice 25.2 can read and write ODF version 1.4. For related fixes see tdf#
162118.

User Interface

  * Under Windows, panning and zooming on a touch screen now works properly.
    (Tibor Nagy, allotropia) tdf#85677
  * The list of most recently used files accessed via File ? Recent Documents
    was amended with a checkbox "[x] Current Module Only" that allows to filter
    the list. (Heiko Tietze, TDF) tdf#161725
  * You can now control hyphenation from the Properties deck of the Sidebar. (L
    ??szl?? N??meth) tdf#162491
  * The choice of "Link" when inserting an image is now remembered during a
    session (Andreas Heinisch) tdf#61358

Application Theming

  * The application theme can be customized independent of the system/
    desktop-environment theme. Customization options are available in Tools ?
    Options ? LibreOffice ? Appearance tab, (blog post) (Sahil Gautam,
    allotropia) tdf#163620
  * Appearance options specify whether to use light or dark theme colors. If
    Light/Dark is selected, then the application uses light/dark theme colors
    respectively. If System is selected, then the application follows the DE
    (desktop environment), meaning if the DE is in dark mode, then the
    application uses dark theme colors, and vice versa.

  * Automatic color scheme is now readonly. To customize appearance, create a
    new scheme by clicking on the New button.


  * The preferred way of customizing appearance is via theme extension. To
    install a theme extension, click on the more themes button next to the
    theme drop-down in LibreOffice Themes section. Once installed, the theme
    should appear in the schemes list.

  * Customizations section allows customization of individual theme colors. We
    can also use image background instead of color, although it's only
    available for Application Background at the moment.


Accessibility

  * System settings to disable animations are more consistently honored and
    more fine-granular control in the LibreOffice settings has been introduced
    (Per99; Michael Weghorn, TDF) tdf#161765, tdf#115688 tdf#94147
  * User interface elements now report an accessible identifier that assistive
    technology can use to reliably identify a particular element, which is
    already used e.g. by the Orca screen reader on Linux and the NVDA screen
    reader on Windows. (Michael Weghorn, TDF) tdf#155447
  * Accessible relations are correctly reported on Windows, allowing the NVDA
    screen reader to read Writer documents from top to bottom. (Michael
    Weghorn, TDF) tdf#91739
  * Positions of UI elements on Linux (including Wayland) are correctly
    reported on the accessibility level, allowing e.g. screen magnifiers to
    track the mouse or cursor position. (Michael Weghorn, TDF) tdf#160837
  * On Windows, accessibility now gets enabled whenever a tool queries
    information from LibreOffice on the accessibility level, which implies
    basic support for Microsoft Narrator and Microsoft Accessibility Insights.
    (Michael Weghorn, TDF) tdf#160982
  * A crash when opening the sidebar menu with assistive technology active on
    Windows has been fixed. (Michael Weghorn, TDF) tdf#164093

Changes in UI strings

Scripting

  * Enhance the NOW() function to support sub-seconds precision. (Andreas
    Heinisch) tdf#161469

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.2:

  * A context menu is usually predefined at LibreOffice installation.
    Customization is done statically with the Tools + Customize dialog. The
    (new) ContextMenu service provides a mean to make temporary additions at
    the bottom of a context menu.
  * When a document is closed inadvertently by the user during a macro run, or
    between two macros triggered by events, the actual behaviour is a fatal
    error message. Now the user script may test at any moment if everything is
    still ok with the IsAlive property applied to next services: Document, Base
    , Calc, FormDocument, Writer, Datasheet, Dialog.
  * To enhance the compatibility between scriptforge dictionaries, python dicts
    and arrays of PropertyValues, the Dictionary service supports now
    optionally case-sensitive keys, i.e. keys are different if a case-sensitive
    comparison finds them different.
  * A Python script intended to connect as an outside process to LibreOffice
    must use either a socket or a pipe connection. So far, only sockets were
    supported, now both are admitted.
  * One can specify the fore- and background colors of the APSO console opened
    from a user script with PythonShell().
  * A data array is a 1D array of 1D subarrays. Three methods,
    ConvertFromDataArray(), ConvertToDataArray() and ConvertToRange() are added
    to the Array service to manage them, especially in the context of complex
    Calc array functions like XLOOKUP.
  * The close button (top-right cross) of a non-modal dialog now closes the
    dialog as expected.

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.

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

Android Viewer

Localization

New languages/locales with locale data

Available as default document language and for locale-specific formatting.

  * French (Republic of Guinea) {fr-GN} [0x940C]. (Eike Rathke, Red Hat) tdf#
    163903

Improvements to proofing tools and language support

  * Updated spell check dictionaries for the languages: English (GB, ZA),
    Danish, Mongolian, Thai, Korean, Ukrainian, and Slovak.
  * Thai thesaurus and AutoCorrect support was added. (Theppitak
    Karoonboonyanan) tdf#150433 tdf#158454
  * Slovenian thesaurus was updated. (Martin Srebotnjak, OdprtiTezaver)

Revision 1.21: download - view: text, markup, annotated - select for diffs
Thu Nov 28 20:42:37 2024 UTC (23 months, 2 weeks ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2024Q4-base, pkgsrc-2024Q4
Diff to: previous 1.20: preferred, colored
Changes since revision 1.20: +24 -0 lines

misc/libreoffice: Update to 24.8.3.2

Changelog:
24.8.3.2:
List of fixed bugs

Bugs fixed compared to 24.8.3 RC1:

    tdf#119745 Scrolling with a laptop touchpad in Libreoffice way too fast [Marc Mondesir]
    tdf#131253 Frames are displayed around images even though Object boundaries is unchecked, as Text boundaries control it [Justin Luth]
    tdf#162666 UI: Styles panel - Scrolling to bottom and/or top of style list is hard with multiple table cells selected: list always jumps back to active style [Armin Le Grand (allotropia)]
    tdf#163486 Bugs found by PVS-Studio static analyzer (report in comment 35) [Xisco Fauli]
    tdf#163537 Frame boundary visibility is now controlled by View > Formatting Marks [Justin Luth]
    tdf#163582 Scrolling after middle mouse click while editing in Writer accelerates out of control [Marc Mondesir]
    tdf#163699 LO crashes when double-clicking an image in the navigator. [László Németh]
    tdf#163720 Smart justify: wrong justification of hyphen, which doesn't appear in exported PDF [László Németh]
    tdf#163730 Hang after copy text [Mike Kaganski]
    tdf#163736 XMATCH produce wrong results [Balazs Varga]


24.8.3.1:
List of fixed bugs

Bugs fixed compared to 24.8.2 RC1:

    cid#1557088 data race condition [Caolán McNamara]
    cid#1606611 data race condition [Noel Grandin]
    cid#1606825 data race condition [Caolán McNamara]
    cid#1606875 data race condition [Caolán McNamara]
    cid#1606887 data race condition [Caolán McNamara]
    cid#1606918 data race condition [Caolán McNamara]
    i#94666 After pressing [Backspace] or [Delete], the document formatting gets incorrect [Michael Stahl]
    tdf#87605 update technical dictionary [Aditya Sahu]
    tdf#95680 Convert - Metafile - Save Image... No function. Must use Alt+R [Noel Grandin]
    tdf#132253 CHARACTER DIALOG: Drop hyperlink from character attributes [Ilmari Lauhakangas]
    tdf#134198 Copy/paste of a doc results in deviating number of pages of the original (in single page view) [Miklos Vajna]
    tdf#137922 Enable extensions at Manage Templates and Options > Icon Theme/Dictionaries running from start center [Xisco Fauli]
    tdf#138711 Frame disconnect after dragging down (comment 4) [Miklos Vajna]
    tdf#139152 Exporting Image or Drawing to PNG is missing metadata, doesn't match target resolution [Noel Grandin]
    tdf#152534 Win11 dark theme support--Active selections have light blue background which makes white icons and text almost invisible [Michael Weghorn]
    tdf#157019 FILEOPEN PPTX: Round corners of rectangle shape render as square corners [Tibor Nagy]
    tdf#158252 FILESAVE XLSX Line breaks in cells disappear [Justin Luth]
    tdf#158323 CRASH when switch back from HTML View to Normal View after edit in HTML source code [Julien Nabet]
    tdf#159007 Moving a grouped object to a different layer makes it disappear [Caolán McNamara]
    tdf#159690 Manual line break forces automatic Wrap Text - comment 17 [Justin Luth]
    tdf#159938 Moving through cells with overflowing content changes the cells' height and wrapping [Justin Luth]
    tdf#160127 Grammar context menu is not displayed if no suggestions exist [Mike Kaganski]
    tdf#160202 EDITING keyboard selection in Basic editor: selection extended one position too far (e.g. Ctrl+Right selects _two_ strings in stead of one) [Andreas Heinisch]
    tdf#161359 rtf no'open [Noel Grandin]
    tdf#161453 Wrap text not exported to XLS/XLSX [Justin Luth]
    tdf#161479 Presentation is not displayed in fullscreen mode when using GTK3 as VCLPLUGIN and the screen is fractional scaled [Caolán McNamara]
    tdf#161625 Installing the same extension twice makes LibreOffice freeze (kf5/kf6) [Michael Weghorn]
    tdf#161968 UI Assign macro to shape crashes CALC [Noel Grandin]
    tdf#162259 SVG Text in Logo has some letters out of proportion [Mike Kaganski]
    tdf#162268 RTF: combination of hidden text and character attributes fails [Michael Stahl]
    tdf#162283 FILESAVE: PPT: placeholders not displayed after roundtrip [Tibor Nagy]
    tdf#162713 Changed format for date-field and time-field in tablecontrol of a form won't be saved [Noel Grandin]
    tdf#162843 Allow paste into Find/Replace box with Dvorak/QWERTY keyboard? [Patrick Luby]
    tdf#162878 Reworked localized Impress templates look ugly in RU [Laurent Balland]
    tdf#162884 German UI and styles: footnote number position should be superscript [Justin Luth]
    tdf#162979 Automatic Update stanza of the Tools -> Options -> Online Update panel does not fully show in UI [Heiko Tietze]
    tdf#163000 Wrong UTF-8 encoded Chinese characters (Skia) [Patrick Luby]
    tdf#163003 RTF import: Frame y position wrong [Oliver Specht]
    tdf#163019 Calc 24.8.1 crashes if Copy Paste Paste special are executed (steps in comment 6) [Andreas Heinisch]
    tdf#163032 Some split cells may not paint their content on following pages [Michael Stahl]
    tdf#163047 Regression: LibreOffice Calc 24.8 broke Page settings [Tibor Nagy]
    tdf#163060 Unexpected word breaks at the ends of lines [László Németh]
    tdf#163091 crash the file with macro [Mike Kaganski]
    tdf#163135 Soffice executable raises "Secure coding is automatically enabled for restorable state" warning when running in headless mode on MacOS Sonoma [Patrick Luby]
    tdf#163145 With Skia, lines of transparent-area shapes disappear during animation [Mike Kaganski]
    tdf#163149 smart justified text does not wrap correctly around frame - extends into the picture area [László Németh]
    tdf#163152 Oversaturated colors on wide-gamut iMac P1 display due to lack of color management [Patrick Luby]
    tdf#163154 FILEOPEN DOCX Writer eats bookmark of the first legacy field [Justin Luth]
    tdf#163170 Add support for MS Visio template format vstx [Bartosz Kosiorek]
    tdf#163190 [pyuno] SyntaxWarning: invalid escape sequence '\P' [Julien Nabet]
    tdf#163191 Dragging headings in Writer navigator crashes LO Writer [Jim Raykowski]
    tdf#163212 LO Writer not showing svg properly [Xisco Fauli]
    tdf#163219 ScriptForge library crash [Jean-Pierre Ledure, Mike Kaganski]
    tdf#163230 A non-breaking table cell taller than page does not break across pages [Mike Kaganski]
    tdf#163231 Correttore ortografico italiano non funziona [Julien Nabet]
    tdf#163275 Typing "-(!1)" into a spreadsheet cell and then clicking no in the dialog about formula error crashes libreoffice [Caolán McNamara]
    tdf#163284 FORMATTING: Diagonal/criss-cross borders for tables do not work in Draw/Impress [Julien Nabet]
    tdf#163285 A non-breaking table cell taller than two pages does not break at the end of the second page [Mike Kaganski]
    tdf#163291 AdditionsDialog does not work while in start center [Hossein, Xisco Fauli]
    tdf#163295 LibreOffice crashes when processing XML files containing the string "pwi". [Mike Kaganski]
    tdf#163341 Zip64 ODS sheet not opening [Michael Stahl]
    tdf#163344 Loading "14:30" time value from ODS produces a different result compared to DATE, DATEVALUE, or direct input [Mike Kaganski]
    tdf#163346 AutoCorrect Options; when the word "บรเพ็ชร" is entered, it becomes "บรเพชร" [Theppitak Karoonboonyanan]
    tdf#163359 TSA URLs are duplicated if a certificate is chosen twice in the Export as PDF dialog. [Eloi Montañés]
    tdf#163362 Icons in in-document custom toolbars created since 6.4 aren't shown in previous versions [Mike Kaganski]
    tdf#163364 Problem with opening ODS file generated by third party software. [Michael Stahl]
    tdf#163375 Calc crash when type-in a range in Formula Wizard [Balazs Varga]
    tdf#163381 XBitmap.getMaskDIB() is inverted [Noel Grandin]
    tdf#163410 slideshow: outline text effect never renders highlight color [Thorsten Behrens]
    tdf#163413 Display Snap Guides not working [Ilmari Lauhakangas]
    tdf#163482 Insert Hyperlink when added to context menu displays Character dialog not Hyperlink dialog [Ilmari Lauhakangas]
    tdf#163486 Bugs found by PVS-Studio static analyzer (report in comment 35) [Xisco Fauli, Michael Stahl]
    tdf#163516 LibreOffice Draw fails to store or restore Layer data Title and Description [Noel Grandin]
    tdf#163543 File crash in LibreOffice Writer when selecting and copying content [Xisco Fauli]
    tdf#163554 Error when reading an OOXML / Excel A1 notation 3D sheet range starting with a single-quoted sheet name, or badly writing a 3D sheet range containing a single-quoted sheet name. [Eike Rathke]
    tdf#163575 sw smart justify: crash/assert during odt conversion of an Arabic DOCX document [László Németh]
    tdf#163580 Help in LibreOffice [Ilmari Lauhakangas]
    tdf#163597 Jumping text in Impress outline edit [Armin Le Grand (allotropia)]

Revision 1.20: download - view: text, markup, annotated - select for diffs
Sat Aug 24 02:57:35 2024 UTC (2 years, 2 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2024Q3-base, pkgsrc-2024Q3
Diff to: previous 1.19: preferred, colored
Changes since revision 1.19: +2 -0 lines
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

Revision 1.19: download - view: text, markup, annotated - select for diffs
Sun Feb 11 15:31:58 2024 UTC (2 years, 9 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2024Q2-base, pkgsrc-2024Q2, pkgsrc-2024Q1-base, pkgsrc-2024Q1
Diff to: previous 1.18: preferred, colored
Changes since revision 1.18: +25 -0 lines
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)

Revision 1.18: download - view: text, markup, annotated - select for diffs
Thu Oct 19 15:51:20 2023 UTC (3 years ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2023Q4-base, pkgsrc-2023Q4
Diff to: previous 1.17: preferred, colored
Changes since revision 1.17: +1 -1 lines
libreoffice: Restore java option

As of 7.6.2.1, java option works.

Revision 1.17
Sun Oct 15 07:26:24 2023 UTC (3 years, 1 month ago) by ryoon
Branches: MAIN
FILE REMOVED
Changes since revision 1.16: +1 -1 lines
libreoffice: Update to 7.6.2.1

* Make Java as mandatory. A build without Java is broken now.

Changelog:
Writer

  * Added page number wizard in Insert menu for easy one-step insertion of the
    page number in the header/footer tdf#86630 (Paris Oplopoios / Justin Luth,
    Collabora)
    Page Number Wizard dialog
  * The Paragraph Style dropdown (in the Formatting toolbar) now gradually
    replaces the default list with styles used in the document rather than
    always showing the full list at the top. tdf#152666 (Heiko Tietze, TDF)
  * Character properties of the paragraph marker from DOCX are now also
    remembered in ODT. blog post (Miklos Vajna, Collabora)
  * Citation handling: added plumbing in Writer to build Zotero-like
    functionality blog post (Miklos Vajna, Collabora)
  * Citation handling: Reference Marks no longer expand unexpectedly when
    typing with the cursor placed after them. tdf#81720 (Matti Tyrv?inen)
  * Table of Figures can be generated more flexibly based on a paragraph style,
    not only by categories or object names. tdf#153090 (Michael Stahl,
    allotropia)
    Table of Figures based on paragraph style
  * Bibliography entries can now be edited directly from a bibliography table.
    tdf#72955 (Vojt??ch Dole?al)
  * Bibliography marks now (by default) hyperlink to matching row in a
    bibliography table. The click behaviour can be changed to open the "Display
    URL", open the newly introduced "Target URL", or "None". tdf#153396 (Vojt??
    ch Dole?al)
  * Start of multi-page floating tables in Writer commits, blog post 1, blog
    post 2, blog post 3 blog post 4 blog post 5 blog post 6 (Miklos Vajna,
    Collabora)
    Start of multi-page floating tables in Writer
  * The Accessibility Check has been moved to the sidebar to allow easier usage
    while editing the document. tdf#142978 (Samuel Mehrbrodt, allotropia)
    The new Accessibility sidebar
  * Now if you have a hidden section in your document and try (possibly
    accidentally) to delete it, then Writer will show a warning message tdf#
    130199 (Balazs Varga, allotropia)
  * DOI citation recognition in Tools/AutoCorrect: Create a hyperlink pointing
    to doi.org for DOI citation tdf#145925 (Baole Fang)
    DOI citation recognition
  * Added highlighting for used Paragraph and Character styles and highlighting
    for used Direct Formatting in text. tdf#38194, tdf#106556 (Jim Raykowski)
    Spotlight
  * keyboard navigation through forms: tab key now circularly navigates through
    content controls/fieldmarks. The modern content controls have a tabIndex
    field, which allows for precise ordering of keyboard navigation. The
    tabIndex also allows a control to be skipped - which is useful to avoid
    getting stuck in rich text controls (since the tab key needs to insert a
    tab character in that case). Form developers can specify the tabIndex via
    the content control properties UI. tdf#151548 (Justin Luth, Collabora)
    LibreOffice content control properties dialog
  * Tracked tables (L??szl?? N??meth, NISZ)
      + Track table columns (follow-up to tracked table rows) commits
        Tracked table column deletion and insertion
        Tracked table columns in Manage Changes
      + Show tables with change tracking colors within a single text change tdf
        #155187
        Moved tables (also tables deleted/inserted as part of a bigger text)
        are highlighted now.
      + Fix lost change tracking of tables within a single text change at table
        editing tdf#147180 and DOCX export tdf#150824 tdf#155187
  * The position of the cursor within the page is now exposed via accessibility
    APIs, so screen readers like NVDA can announce it. tdf#136760 Related NVDA
    change (Michael Weghorn)

Spell checking

  * Phrase checking: multi-word dictionary items of Hunspell and custom
    dictionaries are accepted tdf#154499 (L??szl?? N??meth, FSF.hu)
  * New options for proofreading: optional disabling of recognition of possible
    hyphenated and closed compound words, i.e. rule-based compounding, which
    allowed to accept also typos in Danish, Dutch, German, Hungarian,
    Norwegian, Swedish etc., and in the case of hyphenated compound words,
    English and all the other languages tdf#136306 (L??szl?? N??meth, FSF.hu)
    Accept possible closed/hyphenated compound words


Calc

  * Fixed conditional border color export to xlsx tdf#152581 (Attila Sz?cs,
    Collabora)
  * Evaluate formula inputs in Validity?? tdf#150098 (Bal??zs Varga,
    allotropia)
    Formula input in cells are now evaluated before cell value??s validity is
    checked
  * Number format:
      + ? are now supported on export to ODF to represent an integer digit,
        replaced by blank if it is a non significant zero tdf#118324 (Laurent
        Balland)
      + decimals for format in seconds without truncate like [SS].00 are now
        accepted tdf#150028 (Laurent Balland)
  * Delete Sheet tdf#153709 (Laurent Balland):
      + if Sheet is empty, no confirmation message is displayed
      + confirmation message is adapted to the number of selected sheets
  * Sheet copied to another document now retains a user-defined print range tdf
    #66613 (Andreas Heinisch)
  * Save solver settings to file tdf#38948 (Rafael Lima)
  * Added support for drawing styles for shapes and comments. This includes a
    dedicated style for comments that makes it possible to customize the
    default look and text formatting of new comments. The old workaround
    involving editing the default cell style was removed. commits (Maxim
    Monastirsky)
  * Pop-up comments now show authorship metadata. (Not visible when all
    comments are shown, to preserve layout.) tdf#156885 (Bal??zs Varga,
    allotropia)

Screenshot of pop-up comments showing authorship metadata: author name and
creation time and date.

  * Export all page styles in Calc even if they are not in use tdf#154445
    (Andreas Heinisch)
  * Automatic hyperlinks now stand out more in Calc tdf#153880 (Bal??zs Varga,
    allotropia)
    Above: Hyperlink in C2 is now more visible
  * Added pivot table compact layout. core commit 2f8d1 (Dennis Francis,
    Collabora)
  * Add Poisson distribution to Random Number Generators (Sheet ? Fill Cells ?
    Fill Random Number...) tdf#154872 (Bartosz Kosiorek)
  * Sorting by color is now possible in AutoFilter tdf#95520 (Samuel Mehrbrodt,
    allotropia)

Sort by color in AutoFilter: original unordered data on the left, ordered by
color on the right.

  * Filter/sort by color considers colors set by number format tdf#144549
    (Samuel Mehrbrodt, allotropia)
  * Import Text dialog (as CSV file or as Unformatted Text) have a new option
    to not detect number in scientific notation. This option is only available
    if "Detect special numbers" is off tdf#154131 (Laurent Balland)
    New option to detect numbers in scientific notation
  * add ??formula marker?? feature like in Quattro Pro tdf#97551 (feature
    requested by Brolin Empey in 2016, feature added by Grigory A. Mozhaev in
    2023)
  * If you have enabled the 'Protect Size' option for a shape or form control
    and you see a different size after reopening the document, please do the
    following:
    If it is a form control, put the form in 'Design Mode'. This is an icon on
    the 'Form Controls' toolbar. Then right-click on the shape or form control
    and open the 'Anchor' item in the context menu. If the anchor is set to 'To
    cell (resize with cell)', you are affected by the following problem.
    The settings 'Protect size' and anchor 'To cell (resize with cell)'
    contradict each other. Unfortunately, versions prior to 7.6 had this
    contradiction written to the file in different ways, so an automatic repair
    is not possible. Version 7.6 automatically writes the 'To Cell' anchor to
    the file if the shape or form control is size protected.
    To repair your file, set the anchor type to 'To cell'. Then uncheck the
    'Protect Size' option and set the shape to the desired size and position.
    Now you can re-enable the 'Protect size' option. Then save the file. The
    shape or form control now has an unchanged size on reopening, not only in
    version 7.6, but also in older versions.
    Possibly the problem was created because the 'Control Properties' dialog
    contains an 'Anchor' dropdown field with the entry 'To cell', but this is
    actually the anchor type 'To cell (resize with cell)'.
    Please excuse that we did not detect the problem earlier.
  * Fix theme background color lost during XLSX export tdf#91332 (T??nde T??th,
    NISZ)
  * The color for comments respectively "Notes background" and the "Text
    overflow" indicator can now be changed via Tools ? Options ? LibreOffice ?
    Application Colors tdf#154080 (Heiko Tietze, TDF)

Impress & Draw

  * Display soft breaks as line breaks at fontwork. tdf#148000 (Attila Sz?cs,
    Collabora)
  * "Show Layer" is now directly available from the right-click menu instead of
    having to set as "Visible" in Modify Layer... ? Properties. tdf#113439
    (Heiko Tietze, TDF)
  * Navigation panel for switching slides while viewing a presentation. This
    option is enabled via checkbox: Slide Show ? Slide Show Settings ? Show
    navigation panel. tdf#154839 (Amin Irgaliev, Vladislav Tarakanov)
  * Objects can now be listed in "front to back" order in the Navigator,
    showing the top-most object at the top of the list: View ? Navigator ? Show
    Shapes ? Front to back. tdf#154604 (Jim Raykowski)
  * PDFium import now supports free text annotations, and export now supports
    ink, free text and polygon/polyline annotations (Jaume Pujantell,
    Collabora)
  * Added support to open multi image tiff files tdf#155444 (Rashesh Padia,
    Collabora)
  * Auto fitting text scaling algorithm has been changed so it works similar to
    MS Office. Text scaling now separates scaling for the spacing scale
    (paragraph and line spacings) and font scale, where spacing scale can only
    be 100%, 90% and 80% and font scaling is rounded to the nearest point size.
    Spacing in the horizontal direction (for example bullet size, various
    indents) is not scaled anymore. (Toma? Vajngerl, Collabora)
  * Fix missing diacritics in slideshow animations that work letter-by-letter.
    tdf#113290 (Khaled Hosny, TDF)
  * Fix squashed display of emojis and glyphs taken from fallback fonts in
    slideshow on Windows. tdf#147999 (Khaled Hosny, TDF)
  * Fix missing CJK emphasis marks in slideshow on Linux. tdf#43671 (Khaled
    Hosny, TDF)
  * Fix gaps between justified Arabic letters in slideshow. tdf#155810 (Khaled
    Hosny, TDF)
  * Fix connectors when importing them as connectors instead of shapes. tdf#
    149756 tdf#154363 (Tibor Nagy, NISZ)

Base

  * Bug fixed tdf#43369 PostgreSQL: Specific UI for collecting PostgreSQL
    connection settings (Nirnay Korde)
  * Added Firebird's DATEDIFF function to the set of functions that can be used
    in the query designer (without the need to run SQL directly). tdf#104918
    (Juan C. Sanz)
  * Added Firebird's DATEADD function to the set of functions that can be used
    in the query designer (without the need to run SQL directly). tdf#156534
    (Juan C. Sanz)
  * Added MariaDB/MySQL functions TIMESTAMPDIFF and TIMESTAMPADD to the set of
    functions that can be used in the query designer (without the need to run
    SQL directly) (Juan C. Sanz)


LibreOffice Help

LibreOffice Help now describe access to commands from several interfaces:
Menus, tabbed interface, keyboard, toolbars, status bar and more.

Help pages describe several ways to access commands

Help contents updates and fixes:

  * E. Rathke
  * L. Balland
  * O. Hallot
  * S. Chaiklin
  * S. Horacek
  * S. Schroeder
  * M. Kaganski
  * R. Lima
  * A. Romedenne
  * Bogdan Buzea
  * Adolfo Jayme Barrientos
  * Juan C. Sanz


Core / General

  * Added support for zoom gestures when using touchpads in the main view.
    (Povilas Kanapickas)
  * Exporting to PDF updates the last printed time in document properties. tdf#
    134901 (Justin Luth)
  * Added support for document themes (Toma? Vajngerl, Collabora)
    Document Themes
      + Import and export of theme definition for OOXML format
      + Import and export of theme definition for ODF
      + Changing of the theme in Writer and extended various colors to support
        theme color definition
      + Added theme colors in the color picker in Writer and Calc
      + Added new Theme dialog to change the currently used theme
        Document Themes Dialog and Sidebar
          o Also added the possibility to define new theme colors for a theme
          o Sidebar theme deck has been adapted to also work
  * Added support for multicolor gradients (Armin Le Grand, allotropia)

    LibreOffice 7.6 has a new feature called "multicolor gradients" (MCGR)
    implemented by Armin Le Grand. A multicolor gradient still goes from a
    starting color to final color, but now additional colors are possible in
    between.
    Although the 'Gradient' tab in the 'Area' dialog has not yet been adapted
    to the new feature, you can use such gradients. The document
    File:InfoPresentation MultiColor Gradients LO76.odp lists hints on what you
    can already do, and the 'Gradient' list in the dialog contains three
    multicolor gradient examples.

Presets of Multi-Color Gradients

    You can create and modify multicolor gradients using macros, see the
    'Gradient2' struct and the associated 'ColorStop' struct in the SDK API
    reference https://api.libreoffice.org/docs/idl/ref/index.html. Find more
    details and some primitive example macros in the file
    File:MacrosForMCGR.odp.
    Since this is a new feature, you might find errors. In this case, please
    help improve the feature by reporting the issue in our bug tracking system
    "Bugzilla" https://wiki.documentfoundation.org/Bugzilla. When doing so,
    mention 'MCGR' in the subject line.
    Some notes:
        LibreOffice versions prior to 7.6 cannot interpret multicolor
        gradients. They will display a gradient made from the first and last
        color.
        You need to use "1.3 Extended (recommended)" file format. This is the
        default setting, so don't worry.
        Some gradient properties in ODF (LibreOffice) and OOXML (Microsoft
        Office) are basically incompatible. This problem is not solved by
        multicolor gradients.

  * Each view of a document now can have its language specific accelerator
    manager (G?kay ?at??r, Collabora).
  * Entering a group once again dims the objects that are not included in it.
    tdf#122735 (Armin Le Grand, allotropia).

Variety of objects in a Draw document. One group of two shapes is entered, the
surrounding objects are dimmed.

  * Fix text layout issues when using qt5/qt6 VCL plugins (as opposed to kf5/
    kf6 plugins). tdf#151925 tdf#151273 (Khaled Hosny, TDF)
  * Fix overlapping text issue with some Graphite fonts. tdf#137553 (Khaled
    Hosny, TDF)
  * Fix interaction between complex text fonts and Unicode superscript numbers.
    tdf#52577 (Khaled Hosny, TDF)
  * Fix font fallback of Unicode character from higher planes inside
    right-to-left text . tdf#153440 (Khaled Hosny, TDF)
  * Fix issue with misspelling red line covering parts of right-to-left text.
    tdf#151968 (Khaled Hosny, TDF)
  * Compress full width CJK punctuation when punctuation compression is
    enabled. tdf#129810 (Khaled Hosny, TDF)
  * Fix rendering of Tangut and Khitan Small Script in vertical text. tdf#
    114432 (Khaled Hosny, TDF)
  * Available since 7.6.1
    Fix broken contextual text rendering between Narrow No-Break Space and
    Mongolian letter. tdf#107612, tdf#112594 (Khaled Hosny, TDF)
  * Fix broken text rendering when mixing higher Unicode planes with other
    complex text. tdf#139863 (Khaled Hosny, TDF)
  * Don??t insert extra space between Indic and non-Indic text. tdf#89288
    (Khaled Hosny, TDF)
  * Don??t require installing Hunspell spelling dictionary for every Arabic
    locale, installing only ??ar?? dictionary will work for all Arabic locales.
    tdf#64830 (Khaled Hosny, TDF)
  * Fix vertical displacement of vertical text on macOS. tdf#149297 (Khaled
    Hosny, TDF)
  * Don??t use Private Use Area characters for bulleted lists, use the proper
    Unicode code points. tdf#133089 (Khaled Hosny, TDF)
  * Categorized link targets when linking to a presentation. (Szymon K??os,
    Collabora)
    Link targets dialog with categories.


Filters

General OOXML filters

  * Added support for OOXML files created in zip64 format tdf#82984, tdf#94915
    (Attila Sz?cs, Collabora)
  * Lots of fixes for frames defined by DOC/X's framePr. Issues fixed include
    lost frames, combined frames that should be separate, split frames that
    should be combined, overlapping frames, ignored parent styles, lost
    relative positioning, wrong absolute positioning, and lost rotation. tdf#
    154129, tdf#154703 (Justin Luth, Collabora)

PDF

  * Export to PDF v.1.7 by default. core commit e624e (Michael Stahl,
    allotropia)
  * Tagged PDF is now produced by default, for improved accessibility. (To
    further improve your PDF's accessibility, the PDF/UA option is available in
    the export dialog and will trigger the Accessibility Check tool). tdf#39667
    (Samuel Mehrbrodt, allotropia)
  * Exporting as a hybrid PDF now stores the original ODF document as a PDF
    compatible file attachment. core commit e052f (Toma? Vajngerl, Collabora)
  * Fix glyph size mismatch and overlap when printing of variable fonts. tdf#
    156151 (Khaled Hosny, TDF)
  * Fix missing or incorrect overline color when exporting to PDF. tdf#48707
    (Khaled Hosny, TDF)
  * Fix position of CJK emphasis marks when exporting to PDF. tdf#115321
    (Khaled Hosny, TDF)
  * Fix blank text for the default instance of CFF2 variable fonts when
    exporting to PDF. tdf#155161 (Khaled Hosny, TDF)
  * Fix underline position of Liberation fonts when exporting to PDF. tdf#
    154235 (Khaled Hosny, TDF)


EMF/EMF+

  * Implement EMR_POLYDRAW record. tdf#142249 (Bartosz Kosiorek)
  * Add missing EmfPlusDrawCurve implementation. tdf#143877 (Bartosz Kosiorek)
  * Performance boost for EMF+ images containing EmfPlusRecordTypeDrawBeziers
    records. tdf#154789 (Bartosz Kosiorek)

SVG

  * Support feColorMatrix, feGaussianBlur, feDropShadow, feFlood, feOffset. tdf
    #156066 (Xisco Fauli, TDF)
    Comparison of import of an SVG sample using feColorMatrix (7.5 on left, 7.6
    on right)


GUI

  * The recent documents picklist under File ? Recent Documents now shows the 5
    most recent module-specific items first. The list can be configured using
    the ShowCurrentModuleOnly expert option to show only files that can be
    handled by the current module. tdf#56696 (Andreas Heinisch)

Default Recent documents list
Recent documents list with ShowCurrentModuleOnly

  * Documents in the Start Center can now be pinned to show them at the
    beginning of the recently opened document list. To pin a document, hover
    the corresponding document and click on the pin icon in the top left
    corner. The selected document will then be shown in a separate line at the
    beginning of the list, along with already pinned documents. tdf#38742
    (Andreas Heinisch)

Pinned documents in the Start Center

  * Keyboard navigation for the Special Characters dialog (Insert ? Special
    Character...) has been improved and the currently selected character is now
    correctly announced by screen readers. tdf#153806 tdf#153918 (Michael
    Weghorn)
  * The title of styles in the Fontwork dialog (Insert ? Fontwork...) is now
    announced by screen readers. tdf#153657 (Michael Weghorn)


Localization

  * Improved predefined outline styles for en_US (and most locales reference
    this, so will automatically benefit). MLA/Chicago-compliant choice now
    available, and Roman numeral levels are now right-aligned. Also fixed
    indents in the "Numbering IVX" style, and made the "Numbering ivx" style
    usable. The outline numbering button was also added to the toolbar. tdf#
    56258 (Justin Luth, Collabora)
    Outline Numbering pop-up from toolbar

New languages/locales with locale data

Available as default document language and for locale specific formatting.

  * Morisyen {mfe-MU} [0x06B2]. tdf#154832 (Jean-Yves; Eike Rathke, Red Hat)
  * Santali {sat-IN} [0x0646]. tdf#154987 (Prasanta Hembram; Eike Rathke, Red
    Hat)

Additional languages in the language list

Available for text attribution.

  * Saraiki {skr-PK} [0x06B0], CTL, RTL. (Eike Rathke, Red Hat)
  * Rohingya Hanifi {rhg-Rohg-MM} [0x06B1] CTL, RTL. tdf#154031 (Eike Rathke,
    Red Hat)

Scripting

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

New in LibreOffice 7.6:

  * The (new) FormDocument service (a form document is also known as a "Base
    form", but this is confusing): open (even without first opening the Base
    document container), close, print, export to PDF, menubar management,
    access to individual controls.
  * The (new) Toolbar and ToolbarButton services: hide/show built-in or custom
    toolbars, hide/show individual toolbar buttons, get or set the script or
    command to execute when clicked.
  * In the Calc service: ranges may be sorted on any number of keys. Also a new
    RemoveDuplicates method, to clear or to compact ranges, keeping only one
    copy of identical records.
  * A new Echo method in the Document service to freeze screen updates during
    scripts or to change the actual mouse pointer.
  * Many improvements on the Dialog and DialogControl services:
      + Support of the Hyperlink control type
      + Dialog controls may be resized. The height and width are expressed in
        Map AppFont units, like in the Basic IDE.
      + All the On properties (to specify the script to be executed when an
        event occurs) are now editable.
      + Dialog controls may be created dynamically.
      + Dialog controls may be cloned with the new CloneControl method.
      + A dialog can be created from scratch.
      + Tabulations between controls are defined at once by the new OrderTabs
        method.

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 (7.6) is
fully integrated in the LibreOffice help pages (https://help.libreoffice.org/
7.6/en-US/text/sbasic/shared/03/lib_ScriptForge.html?DbPAR=BASIC). Their
translation into other languages is underway. (Alain Romedenne, Rafael Lima)

Java

  * The property userClassPath in the javasettings_$OS_$ARCH.xml file now
    supports (non nested) bootstrap variables (allowing to enter relative
    paths). core commit 7795a (Samuel Mehrbrodt, allotropia)

VBA Support

  * Added support for ExportAsFixedFormat VBA function to Export As PDF. tdf#
    149786 (Bal??zs Varga, allotropia)

Feature Removal / Deprecation

  * Option for making PDF the default print job format have been removed and
    PDF is always used. Support for PostScript as a print job format is
    deprecated and will be removed in a later release. core commit 2a405 and
    core commit c3a4f

  * Shortcut visibility setting (for context menus) has been removed from Tools
     ? Options ? LibreOffice ? View and defaults to the desktop environment's.
    The expert configuration setting ShortcutsInContextMenus is still available
    if needed (0 to hide, 1 to show, 2 for default). tdf#152898 (Caol??n
    McNamara, Collabora)

LOK API

  * Add memory trimming functionality for idle documents (Michael Meeks,
    Collabora)
  * Avoiding running graphics tests on startup in LOK mode (Michael Meeks,
    Collabora)
  * Avoid un-necessary slow whole-writer-document off-screen render in some
    cases (Michael Meeks, Collabora)
  * Swap out compressed graphics in LOK mode as well as de-compressed versions
    (Michael Meeks, Collabora)
  * Performance improvements for headless cairo rendering, avoiding PDF
    code-paths (Michael Meeks, Collabora)

Platform Compatibility

Mac

  * LibreOffice 7.6 requires macOS 10.15 or newer to run.

API Changes

  * css.qa.XDumper::dump got a kind parameter. core commit 56e17
  * remove .uno:CharBackgroundExt's secondary use to set background color.
    Instead use .uno:CharBackColor for 7.6+. tdf#85592
  * deprecate .uno::BackColor to set background color in Writer. Instead use
    the universal .uno:CharBackColor for 7.6+. tdf#85592
  * The C functions rtl_string_newFromStr and rtl_uString_newFromStr, and the
    C++ constructors for rtl::OString(char const *) and rtl::OUString
    (sal_Unicode const *) wrapping those functions, no longer support the
    undocumented behavior of accepting a null pointer string argument and
    treating it as an empty string. (Such calls had already been diagnosed with
    std::abort in debug builds since LibreOffice 7.2.) core commit 6028e
  * The Gradient2 struct and the ColorStop struct were added to support
    multicolor gradients. Search for MCGR to get the related commits. For more
    about multicolor gradients look at section Core/General.

Revision 1.16: download - view: text, markup, annotated - select for diffs
Mon Feb 13 14:59:36 2023 UTC (3 years, 9 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1
Diff to: previous 1.15: preferred, colored
Changes since revision 1.15: +0 -0 lines
libreoffice: Update to 7.5.0.3

Changelog:
LibreOffice 7.5 Community: Release Notes
Writer

  * Content controls: added a new plain text type. blog post (Miklos Vajna,
    Collabora)
  * Content controls: added a new combo box type and PDF export. blog post
    (Miklos Vajna, Collabora)
  * Content controls: added titles and tags. blog post (Miklos Vajna,
    Collabora)
  * Now tabs can be edited for multiple paragraphs with different settings at a
    time. Tabs dialogue (Format ▸ Paragraph... ▸ Tabs) is available even when
    multiple paragraphs are selected which has different settings. core commit
    9f7b3 (Pranam Lashkari)
  * Improved kashida insertion position validation, to prevent inserting
    kashida between contextually substituted glyphs breaking word shape. core
    commit 9a6b6 (Khaled Hosny)

  * Correctly calculate text caret position inside ligatures, and use caret
    positions from the font when available. tdf#30731 (Khaled Hosny)
  * Fix broken colored Arabic text when enabling Show Formatting Marks. tdf#
    150726 (Khaled Hosny)
  * It is now possible to define a custom color for Grammar mistakes in the
    Application Colors dialog (Tools ▸ Options... ▸ LibreOffice ▸ Application
    Colors). core commit 0aa61 (Rafael Lima)
  * AutoTexts created using "New (text only)" no longer insert a new line at
    the end of the AutoText. The currently embedded AutoTexts have been
    adjusted accordingly by explicitly adding a new line at the end of the
    text. User-created AutoTexts, relying on the trailing new line, should be
    re-created including the trailing empty paragraph. tdf#53023 (Andreas
    Heinisch)

  * Page number in status bar now uses a range when the view spans several
    pages. tdf#90150 (Jim Raykowski)

Spell checking

  * Better recognition of typos, and better suggestions in Danish, Dutch,
    Estonian, German, Hungarian, Norwegian and Swedish with the improved
    compound word recognition algorithm of Hunspell spell checker. Hunspell
    1.7.2 commit (László Németh, FSF.hu)
  * Moving text cursor Up/Down triggers pending spell checking of the last
    modified word. tdf#124603 (László Németh, NISZ)
  * Spell checking of plain words of hyperlinks tdf#45949 (László Németh,
    based on tdf#126657 (Khaled Hosny) and tdf#152492)
  * Keep comment of the corrected words, instead of removing it without being
    noticed tdf#65535 (László Németh) Note: continuation of the following
    improvements, which were left out of the previous release notes: core
    commit d08e4137 tdf#66043 sw: fix spell checking of word with deletion (Lá
    szló Németh, introduced in version 7.2) and core commit a6555eb8 tdf#
    65535 sw spell: ignore comment marker when checking spelling (Justin Luth,
    introduced in version 7.3).

Tables

  * Better column deletion when it intersects with merged cells. tdf#46733
    (Justin Luth)
  * Allow table row/column selection, if last cell starts with a nested table.
    tdf#47979, tdf#151478 (László Németh, NISZ)
  * Allow tracked table row/column deletion, if last cell starts with a nested
    table. tdf#150976, tdf#151657 (László Németh, NISZ)

Bookmarks

Bookmark editing in Insert Bookmark dialog window

  * Bookmark text content can be edited in the dialog. core commit aa6ec
    (Michael Stahl, allotropia)
  * The Bookmark dialog accessed from Navigator ▸ Bookmarks ▸ Right click ▸
    Edit... now opens with the clicked bookmark already selected. core commit
    9cc6a (Michael Stahl, allotropia)
  * Hidden _Toc and _Ref bookmarks imported from OOXML are shown as Hidden in
    the dialog, allowing sorting the not hidden (user-defined) bookmarks before
    them by a single click on header Hidden. tdf#150955 (László Németh,
    NISZ)

Colored bookmarks for metadata visualization

Show visible marks in custom color defined in bookmark metadata. tdf#150717 (L
ászló Németh)

See also Custom color metadata field shading, introduced in LibreOffice 7.2.

Bookmark accessibility

Screen readers get text equivalent of visible bookmarks. tdf#150947 (László N
émeth)

In the form of

#BookmarkName1 Bookmark
#BookmarkName2 Bookmark Start
#BookmarkName2 Bookmark End

Where Bookmark, Start and End are localized words.

Bookmark visualization

Various improvements of bookmark visibility (see Tools ▸ Options ▸ LibreOffice
Writer ▸ Formatting Aids ▸ Bookmarks. (László Németh, NISZ)

Note: this is a continuation to Michael Stahl’s fix for tdf#45589 ("create and
paint text portions for bookmarks"), introduced in LibreOffice 7.0.

  * ⌶-shape point bookmark (The previous shape, a single vertical line was
    overlapped with visible page margin at beginning of the paragraphs, also it
    was very similar to the NBSP and narrow NBSP shading.) tdf#150791

  * ][-shape (i.e. double) marks for neighboring bookmark ranges (instead of a
    single vertical line, which could not be distinguished from point bookmark
    symbol previously). tdf#150790

  * All bookmarks at the same character position are visible now, e.g. instead
    of a single |, neighboring bookmarks with point bookmarks are shown e.g. as
    ] ⌶ [ or ] ] ⌶ ⌶ [ [

  * Do not show visible marks for hidden _Toc and _Ref bookmarks imported from
    OOXML, like Microsoft Office does. tdf#150956

  * Multiple start marks of range bookmarks positioned before the character
    position, multiple end marks of range bookmarks positioned after the
    character position, i.e. single type boundary marks are there outside of
    the bookmark text:

some |text| here
    [[    ]]

  * Neighboring end and start marks are centered around the character position:

 |text1|text2|
[    ]] [[    ]

  * Marks of the same character position are sorted based on their type: ], ⌶,
    [, e.g.

] ] ⌶ ⌶ [ [ [


  * Same type marks of the same character position are sorted based on their
    color:

[c1 [c2 [c3 ... c3] c2] c1]

Accessibility

  * Images, embedded objects and text frames can now be marked as decorative,
    which allows assistive technology to ignore them in exported PDFs. (Michael
    Stahl, allotropia) tdf#143311 core commit 31084
  * Hyperlinks, table of content and other indices keep their language, and
    with this, their accessibility. tdf#39794 tdf#145104 (fixed in tdf#126657
    by Khaled Hosny, follow-up fixes: tdf#152492 and tdf#45949 by László Né
    meth)


Accessibility checker

  * Add several accessibility checker rules. (Paris Oplopoios, Collabora) core
    commit b4586 core commit f9eb5 core commit f03d2 core commit 2c44f core
    commit de02e core commit 043f0 core commit a1ae3 core commit 76615 core
    commit 5c893 core commit 3c0be
  * Add Rescan button to Accessibility Check dialog. (Samuel Mehrbrodt,
    allotropia) tdf#148999
  * Make Accessibility Check dialog non-modal. (Samuel Mehrbrodt, allotropia)
    tdf#148971

  * Automatic (Online) Accessibility Check has been added, which scans for
    accessibility issues while the user is editing the document. The
    accessibility status is shown in the status bar. You can enable it in the
    main menu (Tools ▸ Automatic Accessibility Checking). Currently it is only
    available when experimental mode is enabled, as it doesn't take all
    document objects into account. (Tomaž Vajngerl, Collabora)

Machine translation

  * Initial machine translation is available, backend by DeepL translate (Mert
    Tumer, Collabora) core commit e20d2

Performance

  * Cutting hundreds of pages with numbered lists in Writer tdf#129101 (Noel
    Grandin, Collabora)
  * Export to EPUB in Windows tdf#133768 (Noel Grandin, Collabora)
  * Opening Writer documents with large tables tdf#126788 (Noel Grandin,
    Collabora)

Calc

  * Cell input with leading ' apostrophe in cells that are not formatted as
    Text was changed to always strip the first apostrophe and force the
    remainder as text content. Previously, the user had to know (or guess)
    whether an input could be converted to a numeric type (number, date, ...)
    and prefix only that to force text, but not prefix a textual type that
    could not be converted, which was confusing and bad UX. The handling is not
    changed for cells already formatted as Text, where every input is continued
    to be accepted literally as content and a leading apostrophe is not
    removed. tdf#149665 (Eike Rathke, Red Hat)

  * Add support for Kamenický and Mazovia encodings. tdf#150877 (Stephan
    Bergmann, Red Hat)

  * Conditional formatting's begins-with/ends-with/contains are now
    case-insensitive like the rest of the conditions were. tdf#123990 (Justin
    Luth, Collabora)
  * Preserve tab characters and line-breaks in cell contents. tdf#75702 (Justin
    Luth, Collabora)
  * View ▸ Freeze Cells ▸ Freeze First Column/Row now always works even when
    first row or column are not visible. tdf#112641 (Justin Luth, Collabora)

  * Paste Special of cells now remembers last used settings between sessions.
    tdf#69750 (Siddhant Chaudhary)

  * Searching for a term in the Function Wizard now matches the function
    descriptions as well as their names. tdf#146781 (Andreas Heinisch)

Default “spell out” number and currency formats

Number format dialog windows of Calc and Writer got default NatNum12 ("spell
out") format codes. tdf#115007 (László Németh, FSF.hu)

  * Spell out numbers and currencies;

  * in 71 locales of 38 languages;

  * based on libnumbertext 1.0.11;

  * NatNum12 title case is fixed for English language: lowercase “and” and
    title case “-Five” e.g. in “One U.S. Dollar and Twenty-Five Cents”.

Performance

  * Replacing strings with numbers in Calc tdf#126109 (Noel Grandin, Collabora)
  * Find and replace in very large Calc sheets tdf#150749 (Noel Grandin,
    Collabora)
  * Opening large Calc spreadsheets with row height differences tdf#124098 (Bal
    ázs Varga, allotropia)

Impress & Draw

  * Impress now supports cropped video for media shapes. blog post (Miklos
    Vajna, Collabora)

  * Fix bug causing EMF graphics to appear blurry. tdf#150888 (Paris Oplopoios,
    Collabora)

  * The presenter console supports running as a normal window instead of
    fullscreen, with a setting in Tools ▸ Options ▸ Impress ▸ General ▸
    Presentation (tdf#33495). This means it can be used in a single monitor
    too, sharing the presentation in a video-conferencing tool. (tdf#92717)
    (Daniel Lohmann)

  * The in-presentation pen function can be turned off with Ctrl + A (on top of
    the existing toggle Ctrl + P), which should make more presenter devices
    compatible. tdf#149351 (Gabor Kelemen, allotropia)

  * Objects can be drag-and-dropped in the navigator, allowing reordering and
    moving them in and out of groups. tdf#145359 (Jim Raykowski)

Table Design

  * Added basic support for modifying table styles, and creating new ones.
    Modified styles are saved into documents, and can be shared via templates.
    This function can be accessed by right-clicking on a design in the Table
    Design Sidebar panel. core commit f23d3, core commit 553cf, core commit
    5d683 (Maxim Monastirsky)

  * Added a new set of default table styles. core commit daab6 (Rafael Lima)

Chart

  * Data tables are now supported in Charts. See blog post for furter details
    (Tomaž Vajngerl, Collabora)

Math

  * Elements pane from left side of Math's window was moved to Sidebar. tdf#
    150489 (Mike Kaganski, Collabora)

Core / General

  * Added support for rotate and zoom gestures when using touchpads. (Povilas
    Kanapickas)
  * Allow searching for combining marks from so-called complex scripts. tdf#
    91764 (Khaled Hosny)
  * Support font embedding on macOS. tdf#72456 (Khaled Hosny)
  * Fix disabled spellchecking and language-sensitive text layout (e.g. digit
    replacement) in table of contents and hyper link text. tdf#126657, tdf#
    145104 (Khaled Hosny)

Design

  * New application and MIME type icons tdf#132398 (Galdam Jitsu)

Accessibility

  * Restored automatic detection of HighContrast (HC) mode while providing user
    ability to disable in Tools ▸ Options... ▸ LibreOffice ▸ Accessibility. tdf
    #151522 (Caolán McNamara, Red Hat)

Text Layout

  * Improve kashida insertion by making the insertion positions explicit to
    avoid unwanted and spurious kashida insertion. tdf#104921, tdf#87731, tdf#
    106309, tdf#108604, tdf#112849, tdf#114257, tdf#127176, tdf#145647, tdf#
    146199 (Khaled Hosny)
  * Fix kashida position when inserted after a letter with a combining mark.
    tdf#139627 (Khaled Hosny)
  * Fix gaps inserted instead of kashida with some fonts. tdf#106653 (Khaled
    Hosny)
  * Fix justification of text containing spacing combining marks (e.g. in
    Malayalam). tdf#150665 (Khaled Hosny)
  * Disable ligatures when character spacing is set. tdf#66819 (Khaled Hosny)
  * Correctly enable variable fonts variation setting during text layout, as
    well as font metrics. tdf#103596 (Khaled Hosny, Caolán McNamara / Red Hat)
  * Use underline size and position as well as strike-through size and position
    values from the font when available core commit ba03e, and make overline
    size the same as underline size core commit 8da25. (Khaled Hosny)
  * Use the same skew angle for artificial (synthetic) italic text across
    graphics backends and PDF export. core commit f88e7 (Khaled Hosny)
  * Improve glyph positioning of artificial italic text, especially combining
    marks. core commit 1f9b2 (Khaled Hosny)

Edit Engine

  * Sync kashida insertion algorithm with Writer one to include fixes and
    enhancements from Writer that other LibreOffice components were missing.
    tdf#137528 (Khaled Hosny)
  * Fix bad Arabic letter spacing when text starts with left-to-right
    characters. tdf#103492 (Khaled Hosny)
  * Fix gaps in justified Arabic text when the font does not have usable
    kashida glyph. tdf#137528 (Khaled Hosny)
  * Correctly calculate text caret position inside ligatures, and use caret
    positions from the font when available. tdf#83581 (Khaled Hosny)

Performance

  * Opening Options ▸ LibreOffice ▸ Application Colors tdf#152301 (Caolán
    McNamara, Red Hat)

LibreOffice Help

  * Help contents updates and fixes

  *
      + E. Rathke
      + O. Hallot
      + M. Kaganski
      + R. Lima
      + A. Romedenne
      + Bogdan Buzea
      + Adolfo Jayme Barrientos

  * Help build optimization
      + Christian Lohmaier

Filters

doc

  * Re-allow .doc files to be renamed as .dot. tdf#125216 (Justin Luth,
    Collabora)

VBA Support

  * Added support for WordBasic.ScreenUpdating. core commit a8209 (Justin Luth,
    Collabora)
  * Added support for WordBasic.MsgBox. core commit 55628 (Justin Luth,
    Collabora)
  * Run AutoNew, AutoOpen, AutoClose events properly in Writer and Calc. tdf#
    148806 (Justin Luth, Collabora)
  * Added FormFields and ContentControls support for managing form objects. tdf
    #151548 (Justin Luth, Collabora)

PDF

  * Support embedding color (e.g. Emoji) fonts using color layers (using COLR/
    CPAL OpenType tables). tdf#104403 (Khaled Hosny)
  * Support embedding color (e.g. Emoji) fonts using color bitmaps (using CBLC/
    CBDT or sbix OpenType tables). tdf#121327 (Khaled Hosny)
  * Support embedding variable fonts and apply font variations to glyph shapes.
    tdf#108497 (Khaled Hosny)
  * Correct set Postscript name when embedding for some broken fonts. tdf#
    138325 (Khaled Hosny)
  * Fix invalid PDF font subsets when subsetting blank glyphs. tdf#112152
    (Khaled Hosny)
  * Fix visual artifacts in glyphs that use fractional point coordinates. tdf#
    126242 (Khaled Hosny)
  * Fix missing accent chars in glyphs that use deprecated arguments to CFF
    endchar operator. tdf#123234 (Khaled Hosny)
  * Apply artificial italic to fallback fonts. tdf#102914 (Khaled Hosny)
  * When exporting to PDF, you can now choose to export comments in the page
    margin. tdf#77650 (Samuel Mehrbrodt, allotropia)
  * When inserting a picture and using PDF as a source file, now it is possible
    to use larger files. core commit a5c1c (Szymon Kłos, Collabora)

SVG

  * Remove "ghost" lines (extra semi-transparent white outline) of
    semi-transparent shapes tdf#149800 (László Németh)

GUI

General changes

  * Support for dark and high contrast operating system themes on Windows,
    macOS and Linux was greatly improved. More than 40 bugs were fixed by
    contributors including Caolán McNamara (Red Hat), Rafael Lima, Michael
    Weghorn and Rizal Muttaqin.

  * When previewing styles in the side bar and the styles menu, use the CTL and
    Asian fonts set on the style for respective text instead of always using
    Western fonts. tdf#87535 (Khaled Hosny)

  * Remove redundant File ▸ Recent Documents menu from macOS dock icon. tdf#
    55922 (Khaled Hosny)
  * An improved version of a single toolbar user interface was implemented,
    supporting context-aware controls and their customization. It can be
    activated via View ▸ User Interface... ▸ Single Toolbar. Customization can
    be done either with a right click context menu actions, or via Tools ▸
    Customize... ▸ Toolbars, for various "Standard (Single Mode) - <context
    name>" targets. For now, context aware controls were added to Writer only.
    This largely makes the Contextual Single user interface obsolete, and it
    might be removed in future versions. tdf#125040 (Maxim Monastirsky)

  * GTK3 scrollbars now benefit from the "smooth scrolling" feature. Long-press
    on a scrollbar or use ⇧ Shift + Click for more precise scrolling. tdf#
    117388 (Caolán McNamara, Red Hat)

  * The Start Center can now filter recent documents by type. tdf#80934 (Heiko
    Tietze, TDF)

Icon theme

  * The Sifr icon set was refreshed to follow GNOME Adwaita’s new rounded
    style. tdf#151071 (Rizal Muttaqin)


Labelling

  * In Calc, the "language" label was changed to the more accurate "locale"
    label in the (HTML) Import Options and Text Import dialogs. tdf#138748
    (Pedro Silva, Collabora)

Font Features Dialog

The Font Features dialog (Format ▸ Character ▸ Font ▸ Features...) received
some improvements:

  * Font features that are enabled by default (e.g. Standard Ligatures) can now
    be disabled. tdf#127423 (Khaled Hosny)
  * Stylistic Sets and Character Variants features each is now grouped together
    in a separate section, so they stand out from other common font features.
    core commit 3f9a8 (Khaled Hosny)
  * Stylistic Sets and Character Variants features can have user-friendly
    labels defined in the font, these are now shown in the dialog instead of
    the generic feature names. Additionally, localized versions of these labels
    that are provided by the font are also shown when LibreOffice user
    interface is in the respective languages. core commit 19787 (Khaled Hosny)

  * Some font features can have multiple alternates, these are now supported
    for OpenType fonts as well (previously it was supported for Graphite fonts
    only). core commit 9ca3c (Khaled Hosny)

Localization

Improvements to proofing tools and language support

Dictionaries

  * Ukrainian dictionary was updated. tdf#149980 (Aron Budea, Collabora)
  * Added Persian (fa-IR) dictionary commit (Aron Budea, Collabora)
  * Slovenian thesaurus was updated (Martin Srebotnjak, OdprtiTezaver).

Language tags

  * The language list combo-box now accepts input of art-... BCP 47 private-use
    language tags like art-x-mylang or art-Latn-x-mylang (with every valid
    script subtag for Latn of course). This is an exception to the otherwise
    not accepted input of private-use subtags preventing mis-spreading
    arbitrary private-use tags, to support language attribution of artificial
    constructed languages. tdf#150370 (Eike Rathke, Red Hat)
  * Language list entries can be permanently added by dropping an
    auto-correction file acor_*.dat into the shared or user profile's autocorr/
    directory with the corresponding well-formed and valid BCP 47 language tag
    in its name. The file can be empty (0 bytes length) with no auto-correction
    data being present, data can be added and edited as usual in AutoCorrect
    Options. For example, autocorr/acor_de-DE-1901.dat will add the de-DE-1901
    tag's language entry that will be displayed as
    German (Germany, Traditional German orthography) {de-DE-1901}
    If the tag in the file name is not a well-formed BCP 47 language tag or not
    valid, it is silently ignored and no language list entry will be added. tdf
    #150371 (Eike Rathke, Red Hat)
  * For information about IETF BCP 47 language tags, see Wikipedia and W3.org

New languages/locales with locale data

Available as default document language and for locale specific formatting.

  * Portuguese (Mozambique) {pt-MZ}. tdf#148792 (Eike Rathke, Red Hat)

Currencies

  * As Croatia joins the Eurozone on the 1^st of January 2023, Croatian kuna
    (HRK) conversion to and from euro (EUR) is now supported in the EUROCONVERT
    () function, and the new default currency for Croatia is the euro. tdf#
    150011 (Eike Rathke, Red Hat)

Scripting

  * The Macro Selector dialog (Tools ▸ Macros ▸ Run Macro...) now remembers the
    last run macro (core commit 792e4 - Rafael Lima).
  * The Basic IDE now has a Zoom Slider that allow users to more easily
    increase/decrease the zoom factor applied to the code editing window. It
    can also be controlled with Ctrl + Scroll. The font size defined in the
    Options dialog (Tools ▸ Options... ▸ LibreOffice ▸ Fonts) is used as the
    100% zoom factor (core commit 0d923 - Rafael Lima).

LibreLogo

LibreLogo programming language is more usable for graphics design with the
following improvements (László Németh):

  * Up to 6 times speed increase of LABEL command by temporary layout locking
    of font settings. (Note: locking was suggested by Noel Grandin in tdf#
    105575, also he made several other performance improvements previously.)
  * Up to 32 times speed increase of drawing by custom layout locking using
    SLEEP -1 & SLEEP 0 command pairs. For example, 800 vector shapes drawn by 4
    seconds instead of more than 2 minutes (core commit e50f0)
  * LABEL command supports more HTML-like tags for formatting: localized color
    names, hundreds of OpenType and Graphite font features, font family, font
    size, strikethrough and highlighting. (core commit 43570) Note: bold,
    italic and underline formatting have been introduced by LO 7.4 in core
    commit 89c34.
  * Portable SVG export for OpenType/Graphite font features, also for rotated
    text with text portions: font features (glyphs and other settings) and
    positions of text portions are exported correctly by converting text to
    curve, as a workaround for the bugs and incompleteness of the SVG export. (
    core commit fe5cc) Test code with a rotated text containing OpenType/
    Graphite scientific inferior and red text portion:

 PICTURE “test.svg” [
   LEFT 45°
   LABEL “CO<sinf>2</sinf> <red>level</red>”
 ]

Note: see also #SVG for SVG export which was improved during these LibreLogo
developments.

  * Fix regression of parsing of default commands in core commit 37d86.

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

New in LibreOffice 7.5:

  * The (new) Datasheet service, to manage tabular views of database data. A
    datasheet may be opened from a Base window or at any moment (without the
    Base component being open). Cursor movement and current selection content
    may be processed by a user script.

  * The RunCommand() method may receive arguments (see .UNO:Commands wiki page
    ).

  * Error messages provide direct access to the help page of the failing
    method.

  * A new Normalize() method in the FileSystem service.

  * In the Calc service, new uses of the FilterFormula concept to selectively
    clear or format cells, rows or columns.

  * Support of 16,384 columns in the Calc service.

  * In the Dialog service, a new SetPageManager() method synchronizes
    automatically dropdown lists, next/previous buttons and tab headers while
    the user browses through the dialog pages.

  * A new basic.CreateUnoStruct() method for Python scripts.

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.5) is
fully integrated in the LibreOffice help pages (https://help.libreoffice.org/
7.5/en-US/text/sbasic/shared/03/lib_ScriptForge.html?DbPAR=BASIC). Their
translation into other languages is underway. (Alain Romedenne, Rafael Lima)

LOK API

Added sending unique window id along with other data to LOK API. core commit
05a77 (Gökay Şatır, Collabora)

Feature Removal / Deprecation

  * In the SDK, the deprecated tools idlc and regmerge (using the legacy type
    registry format) have been removed in favor of unoidl-write (using the
    incompatible new type registry format internally introduced in
    LibreOffice 4.1). core commit a8485d55
  * Experimental Emoji toolbar button has been removed. Using system Emoji
    insertion tools is preferred. tdf#151197 (Khaled Hosny)
  * The following font families are no longer bundled with LibreOffice, Users
    using these fonts are advised to install them on their system:
      + EmojiOne Color tdf#144348 (Khaled Hosny)
      + Source Code Pro and Source Serif Pro. tdf#136604 (Khaled Hosny)
      + KasctBook and KacstOffice. tdf#152376 (Khaled Hosny)

Platform Compatibility

Mac

  * LibreOffice 7.5 requires macOS 10.14 or newer to run.

    Due to Apple's policy regarding C++ standard library features, the minimum
    macOS version requirement will be raised in the future like so:

      o release in Aug 2023 → 10.15 Catalina

API Changes

  * The obsolete UNOIDL method com.sun.star.registry.XSimpleRegistry::mergeKey
    has been deprecated (without a replacement), and its implementation now
    unconditionally throws a RuntimeException. core commit 25fc5 (Stephan
    Bergmann, Red Hat)
  * Added a new property JobName to the com::sun::star::view::PrintOptions
    service to allow specifying a job name which is sent to the printer.
    (Samuel Mehrbrodt, allotropia)

Revision 1.15: download - view: text, markup, annotated - select for diffs
Mon Aug 22 13:58:32 2022 UTC (4 years, 2 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3
Diff to: previous 1.14: preferred, colored
Changes since revision 1.14: +0 -0 lines
libreoffice: Update to 7.4.0.3

Changelog:
Most Significant New Features

GENERAL
    * Support for WebP images and EMZ/WMZ files
    * Help pages for the ScriptForge scripting library
    * Search field for the Extension Manager
    * Performance and compatibility improvements

WRITER
    * Better change tracking in the footnote area
    * Edited lists show original numbers in change tracking
    * New typographic settings for hyphenation

CALC
    * Support for 16,384 columns in spreadsheets
    * Extra functions in drop-down AutoSum widget
    * New menu item to search for sheet names

IMPRESS
    * New support for document themes

Revision 1.14: download - view: text, markup, annotated - select for diffs
Sat Feb 5 04:53:43 2022 UTC (4 years, 9 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1
Diff to: previous 1.13: preferred, colored
Changes since revision 1.13: +12 -0 lines
libreoffice: Update to 7.3.0.3

* Fix comments.

Changelog:
7.3.0.3
Writer

General improvements

  * Hyperlinks can now be attached to shapes tdf#123626 (Samuel Mehrbrodt,
    allotropia)

  * Footnote and endnote anchors in the end of a paragraph are now treated
    exactly as they already were treated in the middle for the purposes of
    search/replace with regular expressions, i.e. they match [\p{Control}] or
    [:control:] regular expression. That means that they need to be taken into
    account when matching text against end-of-paragraph tdf#137737 (Mike
    Kaganski, Collabora)

  * Start of list level support in Writer paragraph styles blog post (Miklos
    Vajna, Collabora)

  * Start of linked character and paragraph styles blog post (Miklos Vajna,
    Collabora)

Tracked table row deletion/insertion

Add visualization and Manage Changes support for tracked deletion and insertion
of tables and table rows. (L??szl?? N??meth, NISZ)

Basic support of table change tracking (introduced by LibreOffice 7.2, see tdf#
60382, tdf#79069) was extended by the following improvements:

  * Hide deleted table rows and tables in Hide Changes mode instead of showing
    empty cells tdf#144057

  * Show table and table row insertions in cyan and deletions in pink in Show
    Changes mode tdf#146120

  * In Manage Changes, accept or reject deletion/insertion of tables or
    consecutive table rows with a single click tdf#144270

  * Clicking on a table row, accept or reject its deletion/insertion tdf#146145

  * Add tooltip to table rows with change tracking tdf#146144

  * Track insertion of empty table rows tdf#143358

  * Track deletion of empty table rows tdf#143359


Highlighted tracked row changes, and improved Manage Changes dialog window with
the new table (row) changes

Tracked text moving

During track changes, show moved text in green color and with double
strikethrough or underlines to speed up reviewing. Add new tooltip captions and
Manage Changes Action icons for tracked text moving. Re-ordered list elements
or changed paragraph or sentence order is more visible this way. Tracked moving
is detected at Move Up/Down, drag & drop, cut & paste and deletion + re-typing,
also during ODT and DOCX import (including documents created with editors which
lack of tracked text moving support, like Google Docs or web version of
Microsoft Office). tdf#145233 tdf#145718 tdf#145719 tdf#145721 (L??szl?? N??
meth, NISZ)

Tracked list item moved by Move Down, with new tooltip caption and Manage
Changes Action icons

Other improvements in track changes

Related to changes of paragraph formatting etc. (L??szl?? N??meth, NISZ).

  * Track change of paragraph style tdf#144272

  * Fixed table formula calculation at track changes tdf#39828

  * Track changes: fix table deletion at paragraph join tdf#144058

  * Track changes: keep format of hints. When a text has multiple character
    formatting settings enabled and a new one is applied with tracked changes,
    only one of the former settings is restored upon rejecting the changes. tdf
    #144173

  * Track format changes of the actual word. If there is no text selection,
    character formattings are applied on the word under the text cursor, now
    with storing the original direct character formatting in a redline "extra
    data" for rejection of the tracked formatting change. tdf#143939

  * Show bullet and numbering changes at the moved list item, not at the next
    one. tdf#145068

A list item moved by Move Down: show changes only in two items, not in four
items.

Performance

  * Increased a PDF export speed of some complex documents tdf#125892 (Noel
    Grandin, Collabora)

  * Speed up loading large RTL documents tdf#64991 (Noel Grandin, Collabora)

  * Improved rendering speed with some complex documents core commit 71429b93,
    core commit d13b63a9 (Lubo? Lu????k, Collabora)

Calc

General improvements

  * The "Link to External Data" dialogue (Sheet ? Link to External Data...) now
    lists HTML tables in the order they appear in the source. tdf#142600
    (Andreas Heinisch)

HTML table list in the "Link to External Data" dialogue. LibreOffice 7.3 (on
the right) now lists the tables in the order they appear in the source.
(LibreOffice 7.2 on the left.)

  * Neumaier summation algorithm?Wikipedia logo v3.svg was implemented for
    using modern SIMD CPU instructions like AVX2 tdf#142307 (Dante Dom??nech)

  * Whitespace line feed and character tabulation in cell formula expressions
    are now preserved and survive round-tripping between OOXML and ODF file
    formats. Tabs however can not be entered in the cell input UI and are
    converted to one space character. tdf#76310 (Eike Rathke, Red Hat)

  * CSV import/export support a sep=; and "sep=;" field separator setting. When
    reading CSV the separator is taken from an initial sep=; or "sep=;" single
    field if that is the only row content. The quoted form is preserved as
    (unquoted) cell content, of the unquoted form the separator is discarded as
    contextually it is a real field separator. When writing CSV an existing
    single top left cell's content sep=; if that is the only cell in the row is
    adapted to the current separator in the quoted form "sep=;" (if quotes /
    text delimiters aren't set empty ...) and always uses the ASCII " double
    quote character. If the line containing the sep=; is not to be imported as
    data (and thus also is not preserved when re-saving) then the From row
    number in the dialog must be set to 2. tdf#117868 (Eike Rathke, Red Hat)

  * A new Evaluate formulas option in the CSV Import and Paste Special and Text
    to Column dialog determines whether formula expressions starting with a =
    equal sign character are to be evaluated as formulas or imported as textual
    data. In the programmatic FilterOptions string this is the 13th parameter
    (token 12) with arguments either false or true. tdf#114878 (Eike Rathke,
    Red Hat)

  * Bash like autocompletion for Calc autoinput was implemented. tdf#145198
    (Dennis Francis, Collabora)

    Consider an example of the following data in a column:

ABCD123xyz
ABCD345qwel
ABCD123pqr
ABCD123xyz
PQR

    When user types A, it will show the partial suggestion BCD.

    User can accept the suggestion with the right arrow key and then the cursor
    will be placed after the letter D, waiting for more input. User can choose
    to not accept the suggestion either by typing more or by ending the edit
    mode by pressing Esc key.

    If the user accepts the suggestion BCD by right arrow key, and types 1, it
    will show a partial suggestion of 23. User can accept this by pressing the
    right arrow key.

    If the user accepts the suggestion in the 3rd step and types x it will show
    the final suggestion yz. Again user can choose to accept or decline the
    suggestion as mentioned in the 1st step.

  * Cell cursor now uses the system's highlight color instead of the default
    font color to improve visibility tdf#142121 (Natalia Gavrilova)

Note that the cursor in cell C4 now using the highlight color instead of the
default font color

  * Support Color Filter in "Standard Filter" dialog tdf#143103 (Samuel
    Mehrbrodt, allotropia)

Standard filter supports filtering by colors

  * Queries and filters using some text-based operations such as 'contains' now
    properly work even with numeric data core commit 0d1971a8 (Lubo? Lu????k,
    Collabora)

  * Quick find will now search for values instead of formulas (the search
    dialog offers both options). tdf#102506 (Julien Nabet)

New spreadsheet functions

  * None

Changed spreadsheet functions

  * Option "Search criteria = and <> must apply to whole cells" has been fixed
    to apply properly in lookup functions when turned off (tdf#139612). For
    better performance it is recommended to leave the option on unless partial
    cell matching is required. (Lubo? Lu????k, Collabora)

  * The IF() function now unconditionally propagates the condition's error
    value, if any. Previously a given ELSE-path was executed as the condition
    is never TRUE on error, which wasn't significant unless the ELSE was an
    error evaluating function like IFERROR() or ISERROR() or other IS...()
    functions.
    This changes behaviour of an undocumented side effect, so might break
    existing expressions that (unwillingly?) relied on it. tdf#146377 (Eike
    Rathke, Red Hat)

Performance

  * Improved speed of some XLSM files opening tdf#95549 (Noel Grandin,
    Collabora)

  * Speedup inserting large charts (for over 800000 cells) tdf#144052 (Noel
    Grandin, Collabora)

  * Improved speed of some XLSX files opening tdf#130795 (Noel Grandin,
    Collabora)

  * Improved speed of lookup functions in some cases tdf#139444,tdf#144249
    (Lubo? Lu????k, Collabora)

  * Improved speed for filtering by Autofilter tdf#133835, tdf#133867, tdf#
    133996 (Noel Grandin, Lubo? Lu????k, Collabora)

  * Improved use of threads for Calc calculations core commit a0e27322, core
    commit 871d5fe3 (Lubo? Lu????k, Collabora)

Impress & Draw

General improvements

  * Added PowerPoint-compatible screen sizes in Slide ? Slide Properties... ?
    Slide ? Paper Format. "Widescreen" is used in current PowerPoint,
    "On-screen show" is used in previous PowerPoint versions and Google Slides.
    (see here) If you create a file with these sizes, the exported file will be
    treated as a preset size instead of a user size. It will also be treated as
    a preset size when you import it. tdf#142286, tdf#142288 (Jun Nogata)

  * Unshare shape properties for the same type before insertion blog post
    (Miklos Vajna, Collabora)

  * tdf#140321 (Regina Henschel)

    Wire Frame - Matt - Plastic - Metal
    The dialog "3D-Settings" opens if you toggle a shape to "Extrusion on". The
    dialog has a drop-down list "Surface" with items "Wire Frame", "Matt",
    "Plastic" and "Metal". In the old version the items "Matt", "Plastic" and
    "Metal" did nothing, but the solid was always rendered as "Plastic". Now
    you get different surfaces. "Matt" is really matte. "Metal" is similar to
    "Plastic" but has more contrast.

    Unfortunately the old versions have written wrong and invalid values into
    the file. Such values might result in unwanted rendering now. To repair
    such shapes, mark the shape, then first switch to item "Matt" and then to
    "Plastic" or "Metal" respectively.

Performance

Base

  * FireBird data base engine bugfixes tdf#115547, tdf#117842, tdf#120129, tdf#
    125286, tdf#144172, tdf#144230, tdf#144340 and many concomitant commits
    (Mike Kaganski, Collabora)

Chart

Math

Core / General

  * LibreOffice can now generate one-dimensional barcodes in addition to QR
    codes. tdf#141193 (Akshit Kushwaha)

QR and Barcode dialog next to inserted barcode on page.

  * new WebDAV/HTTP UCP based on libcurl. tdf#101094, tdf#102499 (Michael
    Stahl, allotropia; Giuseppe Castagno)
      + using the OS native TLS stack on Windows and macOS, so users can now
        manage trust of CAs with OS UI on these platforms

  * Border line widths have been unified throughout LibreOffice. tdf#48622
    (Samuel Mehrbrodt, allotropia)
      + New defaults are:
          o Hairline (0.05pt)
          o Very thin (0.5pt)
          o Thin (0.75pt)
          o Medium (1.5pt)
          o Thick (2.25pt)
          o Extra thick (4.5pt)
          o Custom values are still possible

New line width defaults

Performance

  * Optimizing LibreOffice for a larger number of users. Read more in a blog
    post (Lubo? Lu????k, Collabora)

  * Fixed a mistake that was making CJK text rendering slower over time core
    commit 5b38b574 (Lubo? Lu????k, Collabora)

  * Various rendering improvements in the Skia-based rendering backend (Lubo?
    Lu????k, Collabora)

  * Official binary packages are now built using Link-Time Optimization, which
    should improve overall performance (Lubo? Lu????k, Collabora)

LibreOffice Help

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

  * Focus search results to user's current module tdf#123506 (Ross Johnson)

  * Switch from Fuzzysort to FlexSearch for index search [commit] (I.
    Lauhakangas)

  * Close navigation menus when clicking outside them [commit] (I. Lauhakangas)

  * Several improvements in Calc functions Help pages for accuracy and
    completeness and links to Calc Function wiki pages. List of patches (S.
    Fanning)

  * Help updates and fixes
      + E. Rathke
      + O. Hallot
      + M. Kaganski
      + R. Lima
      + Ming Hua
      + A. Romedenne
      + R. Johnson
  * Internal Help refactoring tdf#132643 (Johnny_M)

Filters

Improvements of DOC import/export filter

  * DOC import: greatly improved list/numbering import tdf#106541 tdf#104239
    tdf#123405 tdf#120629 (Justin Luth, SIL)

Improvements of DOCX import/export filter

  * DOCX import: greatly improved list/numbering import tdf#141964 tdf#141966
    (Justin Luth, SIL)

  * Hyperlinks attached to shapes are now imported/exported tdf#123626 (Samuel
    Mehrbrodt, allotropia)

  * DOCX import: fix permission for editing tdf#89383 (T??nde T??th, NISZ)

  * DOCX export/import: track change of paragraph style tdf#144272 (L??szl?? N
    ??meth, NISZ)

  * DOCX import: fix user index and index entry support defined by field code \
    f. This is a reworking of a previously patch. Now the import uses
    com.sun.star.text.UserIndex and com.sun.star.text.UserIndexMark index and
    index entry fields, which support the requested user index not only during
    the DOCX and OpenDocument round-trip, but its run-time functionality, the
    multiple user-defined indices tdf#77051 (L??szl?? N??meth, NISZ)

  * DOCX import: handle ZOrder of chart objects tdf#144798 (Miklos Vajna,
    Collabora)

  * DOCX import/export: improved support for sdt fields tdf#81507, tdf#130565,
    tdf#137466, tdf#100493 (Vasily Melenchuk, CIB/allotropia)

Improvements of XLSX import/export filter

  * XLSX import: decreased a row height for XLSX files created by MS Office tdf
    #144642 (Attila Sz?cs, NISZ)

  * XLSX export: cell indent doesn't increase on each save now tdf#130104
    (Kevin Suo)

  * XLSX import: fix permission for editing tdf#115933 (T??nde T??th, NISZ)

  * XLSX import/export: fix permission for editing. The password for editing
    wasn't asked, also wasn't exported in XLSX documents. tdf#118938 (T??nde T
    ??th, NISZ). Now it's exported in Calc using the following steps, also
    verified before editing:
      + In File->Save As, choose Excel 2007??365 (.xlsx) format;
      + enable checkbox "Save with password" and click Save;
      + in the dialog "Set password", click on "Options" and enable checkbox
        "Open file read-only", and enter a password for editing (i.e. skip the
        password for opening).

  * Calc buttons with macros: better XLSX support blog post (Miklos Vajna,
    Collabora)

  * OOXML chart import/export: Chart labels from cell-range tdf#143942 (Dennis
    Francis, Collabora)

  * OOXML chart import/export: Chart date categories - improved support for
    formatting, scaling, range-selection(min/max), increments core commit
    f547cf17 (Dennis Francis, Collabora)

Improvements of PPTX import/export filter

  * PPTX export: fixed interactions and hyperlinks on images tdf#124232 (Tibor
    Nagy, NISZ)

  * PPTX import: Impress doesn't drop the read-only password in PPTX file now
    tdf#144943 (T??nde T??th, NISZ)

  * PPTX import: fix hyperlinks on shapes tdf#144616 (Tibor Nagy, NISZ)

  * PPTX import: fix hyperlinks on images tdf#141704 (Tibor Nagy, NISZ)

  * Fix the incorrect import of slide footers from PPTX tdf#142221 (Sarper
    Akdemir, Collabora)

  * Make slide footers get exported to PPTX tdf#59323 (Sarper Akdemir,
    Collabora)

  * PPTX import: Transparent shadow for tables. Read more in a blog post
    (Miklos Vajna, Collabora)

Improvements of WMF/EMF filter

Improvements of SVG filter

Other

  * TXT file extension is no longer associated with T602 file format, which
    used to lead to mis-detections in some cases (Jan Hole?ovsk?, Collabora)

GUI

General

  * The wavy lines indicating spelling or grammar issues have been improved to
    be more discernible in high-resolution screens. Now, they will match the
    document??s zoom level instead of staying thin unconditionally. tdf#70519
    (Heiko Tietze, TDF)

Icon theme

  * Tweaks to Colibre icons related to graphics, saving, formatting and undo/
    redo. (Rizal Muttaqin)

Dialogs

Sidebar

Notebookbar

Localization

              If you speak an endangered language and want to help us to
Im-jabber.svg achieve our goals of providing libre tools to every person on the
              planet, please help translate our software.

New languages/locales with locale data

Available as default document language and for locale specific formatting.

  * English (Israel) {en-IL}. tdf#145173 (Eike Rathke, Red Hat)

Additional languages in the language list

Available for text attribution.

  * Klingon, tlhIngan Hol {tlh}. tdf#143946 (Eike Rathke, Red Hat)
  * Interslavic Latin {art-Latn-x-interslv} and Interslavic Cyrillic
    {art-Cyrl-x-interslv}. tdf#145853 (Eike Rathke, Red Hat)

Improvements to proofing tools and language support

  * Language entries in language listboxes created by spellchecker or
    hyphenation dictionaries or extensions that support languages without a
    predefined language listbox entry are now displayed using a possibly
    translated language/locale name obtained from the ICU (International
    Components for Unicode) library. Previously such entries were displayed as
    language tags in curly brackets, for example {en-SG}. (Eike Rathke, Red
    Hat)

  * Old Hungarian has got full-text transliteration support: Tools ?
    AutoCorrect ? Apply and Tools ? AutoCorrect ? Apply and Edit Changes
    transliterate right-to-left Hungarian text to Old Hungarian (only if the
    paragraph style of the text is Default Paragraph Style). tdf#143176 (L??szl
    ?? N??meth). More info in Release Notes 7.0

  * Added Brazilian Portuguese (pt-BR) thesaurus (Olivier Hallot)

Scripting

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

New in LibreOffice 7.3:

  * The (new) Chart service, to define chart documents stored in Calc sheets.
    Most parameters available in the user interface can be set by script.

  * The (new) PopupMenu service, to describe the menu to be displayed after a
    mouse event (typically a right-click). The menu may contain usual items,
    checkboxes or radio buttons. Each item can be decorated with icons and
    tooltips.

  * Management of printers: list of fonts and printers, printer options,
    printing documents.

  * Export of documents to PDF and management of PDF options.

  * Dialogs may host table controls. Provide tabular data, the data is
    displayed with headers and sort buttons. The selected row is returned by
    the Value property.

  * Titles, tooltips, list- or comboboxes, labels of dialogs can be translated
    on-the-fly based on tools provided in the L10N service.

  * The Calc service has been improved with facilities to identify cell ranges
    when their size is unknown, f.i. after the import of data, and to apply
    formulas with absolute and relative references on them.

  * The whole set of services 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.3)
    is fully integrated in the LibreOffice help pages (https://
    help.libreoffice.org/7.3/en-US/text/sbasic/shared/03/lib_ScriptForge.html?
    DbPAR=BASIC). Their translation into other languages is underway. (Alain
    Romedenne, Rafael Lima)

BASIC

Python

VBA changes

Feature Removal / Deprecation

Platform Compatibility

Mac

  * LibreOffice 7.3 requires macOS 10.12 or newer to run.

    Due to Apple's policy regarding C++ standard library features, the minimum
    macOS version requirement will be raised in the future like so:

      + release in Aug 2022 ?? 10.13 High Sierra
      + release in Feb 2023 ?? 10.14 Mojave
      + release in Aug 2023 ?? 10.15 Catalina

  * A rendering backend based on the Skia library is now used also on macOS [1]
    (Lubo? Lu????k, Collabora)

Windows

  * The IAccessibleTable2 and IAccessibleTableCell interfaces from the
    IAccessible2 specification have been implemented (core commit 839dbf9e,
    core commit 97a88e30) (Michael Weghorn)

Linux

API Changes

  * The C functions rtl_str_toFloat, rtl_str_toDouble, rtl_ustr_toFloat, and
    rtl_ustr_toDouble, and the C++ member functions rtl::OString::toFloat,
    rtl::OString::toDouble, rtl::OUString::toFloat, and rtl::OUString::toDouble
    no longer accept a ??+?? or ??-?? sign before ??NaN?? when parsing the XML
    Schema??style Not a Number notation. (But they still accept an optional ??+
    ?? or ??-?? sign before the legacy ??1.#NAN?? notation.) core commit
    9d27a44e

  * osl_demultiplexSocketEvents and its support functionality, all of which
    were deprecated, have been removed from the UNO C/C++ API. core commit
    db392a8a

UNO API changes

  * com.sun.star.resource.XLocale has been removed. core commit a74d15ad

  * In com.sun.star.i18n, various enum members have been renamed (to no longer
    use reserved identifiers): core commit 04af4e4f
      + in com.sun.star.i18n.TransliterationModules:
          o from ignoreTraditionalKanji_ja_JP to IgnoreTraditionalKanji_ja_JP
          o from ignoreTraditionalKana_ja_JP to IgnoreTraditionalKana_ja_JP
          o from ignoreMinusSign_ja_JP to IgnoreMinusSign_ja_JP
          o from ignoreIterationMark_ja_JP to IgnoreIterationMark_ja_JP
          o from ignoreSeparator_ja_JP to IgnoreSeparator_ja_JP
          o from ignoreZiZu_ja_JP to IgnoreZiZu_ja_JP
          o from ignoreBaFa_ja_JP to IgnoreBaFa_ja_JP
          o from ignoreTiJi_ja_JP to IgnoreTiJi_ja_JP
          o from ignoreHyuByu_ja_JP to IgnoreHyuByu_ja_JP
          o from ignoreSeZe_ja_JP to IgnoreSeZe_ja_JP
          o from ignoreIandEfollowedByYa_ja_JP to IgnoreIandEfollowedByYa_ja_JP
          o from ignoreKiKuFollowedBySa_ja_JP to IgnoreKiKuFollowedBySa_ja_JP
          o from ignoreSize_ja_JP to IgnoreSize_ja_JP
          o from ignoreProlongedSoundMark_ja_JP to
            IgnoreProlongedSoundMark_ja_JP
          o from ignoreMiddleDot_ja_JP to IgnoreMiddleDot_ja_JP
          o from ignoreSpace_ja_JP to IgnoreSpace_ja_JP
          o from smallToLarge_ja_JP to SmallToLarge_ja_JP
          o from largeToSmall_ja_JP to LargeToSmall_ja_JP
      + in com.sun.star.i18n.TransliterationModulesNew:
          o from ignoreTraditionalKanji_ja_JP to IgnoreTraditionalKanji_ja_JP
          o from ignoreTraditionalKana_ja_JP to IgnoreTraditionalKana_ja_JP
          o from ignoreMinusSign_ja_JP to IgnoreMinusSign_ja_JP
          o from ignoreIterationMark_ja_JP to IgnoreIterationMark_ja_JP
          o from ignoreSeparator_ja_JP to IgnoreSeparator_ja_JP
          o from ignoreZiZu_ja_JP to IgnoreZiZu_ja_JP
          o from ignoreBaFa_ja_JP to IgnoreBaFa_ja_JP
          o from ignoreTiJi_ja_JP to IgnoreTiJi_ja_JP
          o from ignoreHyuByu_ja_JP to IgnoreHyuByu_ja_JP
          o from ignoreSeZe_ja_JP to IgnoreSeZe_ja_JP
          o from ignoreIandEfollowedByYa_ja_JP to IgnoreIandEfollowedByYa_ja_JP
          o from ignoreKiKuFollowedBySa_ja_JP to IgnoreKiKuFollowedBySa_ja_JP
          o from ignoreSize_ja_JP to IgnoreSize_ja_JP
          o from ignoreProlongedSoundMark_ja_JP to
            IgnoreProlongedSoundMark_ja_JP
          o from ignoreMiddleDot_ja_JP to IgnoreMiddleDot_ja_JP
          o from ignoreSpace_ja_JP to IgnoreSpace_ja_JP
          o from smallToLarge_ja_JP to SmallToLarge_ja_JP
          o from largeToSmall_ja_JP to LargeToSmall_ja_JP
      + in com.sun.star.i18n.UnicodeScript:
          o from k_CJKUnifiedIdeographsExtensionA to
            kCJKUnifiedIdeographsExtensionA

Revision 1.13: download - view: text, markup, annotated - select for diffs
Sun Aug 22 02:41:50 2021 UTC (5 years, 2 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2021Q4-base, pkgsrc-2021Q4, pkgsrc-2021Q3-base, pkgsrc-2021Q3
Diff to: previous 1.12: preferred, colored
Changes since revision 1.12: +0 -1 lines
libreoffice: Update to 7.2.0.4

Changelog:
GENERAL
     Popup list to search for menu commands
     Scrollable style picker in the NotebookBar
     Fontwork panel in the Sidebar
     New list view for the templates dialog
     Built-in "Xray"-like UNO object inspector
WRITER
     Background fills can cover whole pages, beyond margins
     Page styles can now have a gutter margin
     Mail merge shows a warning about nonexistent data sources
     RDF metadata in Style Inspector
     Custom color metadata field shadings
CALC
     Calc now can filter by color in AutoFilter
     HTML tables listed in the External Data dialogue now show captions
     "Fat cross" cursor available in the options
     Type can be selected in "Moving Average" trend lines
IMPRESS & DRAW

 New templates: Candy, Freshes, Grey Elegant, Growing Liberty, Yellow Idea

     Multiple columns now available in text boxes
     Direct access to the scaling factor via the status bar

Revision 1.12: download - view: text, markup, annotated - select for diffs
Tue Aug 11 16:07:38 2020 UTC (6 years, 3 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3
Diff to: previous 1.11: preferred, colored
Changes since revision 1.11: +49 -0 lines
libreoffice: Update to 7.0.0.3

* Support Python 3.8.

Changelog:
Summary of Other New Features

GENERAL

- New icon theme, the default on macOS: Sukapura
- New shapes galleries: arrows, diagrams, icons and more...
- Glow and soft edge effects for objects

WRITER

- Navigator is easier to use, with more context menus
- Semi-transparent text is now supported
- Bookmarks can now be displayed in-line in text
- Padded numbering in lists, for consistency
- Better handling of quotation marks and apostrophes

CALC

- New functions for non-volatile random number generation
- Keyboard shortcut added for autosum

IMPRESS & DRAW

- Semi-transparent text is supported here too
- Subscripts now return to the default of 8%
- PDFs larger than 500 cm can now be generated

Revision 1.11: download - view: text, markup, annotated - select for diffs
Fri Sep 6 16:12:34 2019 UTC (7 years, 2 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3
Diff to: previous 1.10: preferred, colored
Changes since revision 1.10: +24 -0 lines
Update to 6.3.1.2

Changelog:
6.3.1.2
Bugs fixed compared to 6.3.1 rc1:
    tdf#118856 Text flickering when highlighting text in about us windows [Miklos Vajna]
    tdf#125869 LibreOffice UI freezes (shows not responding) while exporting a pdf [Noel Grandin]
    tdf#126254 Help - About is black with Linux gen and gtk2 backend [Caolán McNamara]
    tdf#126271 Selecting of control points of curves not working correctly for combined polygons [Regina Henschel]
    tdf#126418 Crash in: ScColumn::MergeBlockFrame(SvxBoxItem *,SvxBoxInfoItem *,ScLineFlags &,long,long,bool,short) [Mike Kaganski]
    tdf#126693 I cannot create custom categories for captions [Caolán McNamara]
    tdf#126781 size of conditional formatting window prevents text to be changed (right end unreachable) [Caolán McNamara]
    tdf#126805 Config Tip-Of-The-Day option is shown displaced [Heiko Tietze]
    tdf#126819 Can't retrieve the mouse position written in the statusbar [Noel Grandin]
    tdf#126830 Icons not showing in menus [Noel Grandin]
    tdf#126908 no keyID for some tooltips in table toolbar [Laurent BP]
    tdf#126928 FILEOPEN: Multiple external link chain with several calc documents doesn't work properly any more [Eike Rathke]
    tdf#126989 Libreoffice v6.3.0.4 hangs - Scan in Writer/ Impress/ Draw/(Calc?) [Mike Kaganski]
    tdf#127002 Calc: Page Formatting: Header & Footer: can't move text cursor to proper position. [Caolán McNamara]
    tdf#127021 When attempting to insert a 'set variable' field into a document, not all formatting options are available [Caolán McNamara]


6.3.1.1
Bugs fixed compared to 6.3.0 (rc4):
    cid#1448222 out-of-bounds read [Caolán McNamara]
    cid#1448262 dereference before null check [Caolán McNamara]
    tdf#39742 DRAW, IMPRESS: Menu 'Tools-Options-DRAW-Print' settings not respected [Gabor Kelemen]
    tdf#42316 Creating a new document from a template removes the signature from all Macros [Jan-Marek Glogowski]
    tdf#44786 PRINTING: Draw ignores global print options, forgets print dialog settings [Gabor Kelemen]
    tdf#54908 printing when a selection is active should take in account it and activate the "print selection" radio button [Daniel Silva]
    tdf#94300 Fill gradients dont work in area content panel of chart sidebar [Katarina Behrens]
    tdf#106000 delete/edit comment in context box not an option if comment is escaped without writing anything in it. [Miklos Vajna]
    tdf#107975 CRASH: Crash after undo operation (BigPtrArray::Index2Block(unsigned long) [Zdeněk Crhonek]
    tdf#110442 EDITING: The image within the selection doesn't disappear after cutting [Michael Stahl]
    tdf#112535 FILESAVE: DOC: Image got distorted after RT [Miklos Vajna]
    tdf#116085 Cannot start Certificate Manager with GPG4win v3 [Thorsten Behrens]
    tdf#117185 Crash when closing the document after a specific undo redo operation (Paste) due to inserted fly anchored at end of last paragraph in body [Michael Stahl]
    tdf#118384 Sidebar: Style is not added back to hierarchy after deleting and redoing it [Jim Raykowski]
    tdf#121599 (Supress-migration-dialog) [META] Firebird Migration: Suppress migration dialog when embedded HSQLDB not opened interactively [Xisco Fauli]
    tdf#122358 Forms: Right and bottom borders of form-controls set to 'FLAT' style not displayed (gtk3) [Caolán McNamara]
    tdf#122774 All items in AutoFilter popup menu are not keyboard accessible [Jim Raykowski]
    tdf#123099 Creating new "HSQLDB Embedded" database immediately brings up migration-to-Firebird dialog [Xisco Fauli]
    tdf#123591 Firebird - Incorrect Pasting of Numeric Data [Xisco Fauli]
    tdf#123702 FILEOPEN RTF Size of page margins is different in Word and Writer [László Németh]
    tdf#124108 auto-correction of typographic quotation marks and apostrophes broken for fr_CI [Eike Rathke]
    tdf#124700 LibO6.2 regression: bad misrendering of metafile [Caolán McNamara]
    tdf#125100 EDITING: Insert OLE Object behaves different if new document is generated from template [Ilhan Yesil]
    tdf#125483 Changing Locale does not update the label of the separator key [Caolán McNamara]
    tdf#125609 radiobutton receives item status changed event after listbox value selection [Justin Luth]
    tdf#125628 FORMATTING: Part of text loose yellow highlight reopening document [Tamás Zolnai]
    tdf#125923 Numbering and Bullets dialog Revert button closes window instead of reverting changes on Impress [Gülşah Köse]
    tdf#126070 New Bullets Dialog - Preview zone not resizable + levels above 6-7 not visible with default zone size [Gülşah Köse]
    tdf#126168 Crash in: rtl_uString_acquire: frame style undo redo [Vasily Melenchuk]
    tdf#126222 EDITING Writer: After scrolling extra header/footer are shown [Ilhan Yesil]
    tdf#126227 Top border not displayed on track changes (gtk3) [Caolán McNamara]
    tdf#126309 Opening RTF document with Hebrew RLT (right to left) text is shown with the text written from left to right [Miklos Vajna]
    tdf#126460 Wrong rendering with Greyscale TIF with no / transparent background [Caolán McNamara]
    tdf#126471 Mail merge ignores preselected printer when printing second time [Michael Weghorn]
    tdf#126485 Tabs and indents in numbering and item list were limited to less than 20 pt [Caolán McNamara]
    tdf#126511 Delete path to Gallery from graphics list in B&N dialog [Gülşah Köse]
    tdf#126544 in DOCX files, some styles's "text direction" appears Right-to-Left or Left-to-Right depending on User Interface Language [Justin Luth]
    tdf#126588 EDITING: Firebird: View could be executed, but crashes when trying to save [Noel Grandin]
    tdf#126590 FILEOPEN DOCX Absolute links broken in Writer [Tünde Tóth]
    tdf#126597 Don't crash Outlook 2016 when sending multiple attachments mail via SimpleMail [Jan-Marek Glogowski]
    tdf#126611 XML Form Document: instance Data Navigator isn't shown in toolbar [andreas kainz]
    tdf#126626 CRASH: pasting fly at-char selection [Michael Stahl]
    tdf#126627 CRASH: undoing redlinehide deletion [Michael Stahl]
    tdf#126641 Hyperlink to bookmark in doc[x] file does not work [Mike Kaganski]
    tdf#126642 Allow PDF form export with different defaults based on Archive setting [Jan-Marek Glogowski]
    tdf#126643 If I select LibreOffice Calc macros Python, an error message box mentions JRE is required. [Mike Kaganski]
    tdf#126663 XLSX: LibreOffice is freezed when I try open Style list in Sidebar [Julien Nabet, Noel Grandin]
    tdf#126680 Two Finger Horizontal Scroll is Reversed on Linux and macOS [Jan-Marek Glogowski]
    tdf#126684 Character Style border attributes UI doesn't show borders or allow change to borders [Mike Kaganski]
    tdf#126685 CRASH: selecting all in sheet [Noel Grandin]
    tdf#126691 Placement of items in Writer + Undo is 100% broken [Caolán McNamara]
    tdf#126708 EMF image lost in command-line conversion from .odt to .doc [Luke Deller]
    tdf#126723 FILEOPEN DOCX Numbered list item gets indent setting from next paragraphs footnote [Justin Luth]
    tdf#126732 FILEOPEN: Writer crashes on opening Docx file [Caolán McNamara]
    tdf#126736 In line dialog, tab "Line Styles", dash length and spacing cannot be larger than 5% [Caolán McNamara]
    tdf#126746 Closed shape cap style, losed after export to pptx [Bartosz Kosiorek]
    tdf#126748 Intermittent crash exporting a ODS to XLSX [Mike Kaganski]
    tdf#126766 FORMATTING -10000 sometimes shows up as .0000 [Eike Rathke]
    tdf#126769 Sidebar can't be collapsed clicking on the hide arrow [Samuel Mehrbrodt]
    tdf#126790 CRASH: Closing LibreOffice while 'Help is not Installed' dialog is open in extension manager (gen/gtk) [Caolán McNamara]
    tdf#126808 UI: Writer crashes opening the style edit window after doing many style edits [Miklos Vajna]
    tdf#126844 Find & Replace Dialog no longer permits me to format "Replace" text. (GTK3) [Caolán McNamara]
    tdf#126848 Drop-down filter window in Pivot table is flickering when move mouse point on it [Xisco Fauli]
    tdf#126859 Custom document properties cannot be accessed in LO 6.3 [Caolán McNamara]
    tdf#126889 HELP: Very large images in a page of online help [Olivier Hallot]
    tdf#126931 Wrong date formats for Upper Sorbian and Lower Sorbian [Eike Rathke]
    tdf#126943 CRASH: Closing LibreOffice while load Styles dialog is open ( gen ) [Caolán McNamara]

Revision 1.10: download - view: text, markup, annotated - select for diffs
Sat Aug 10 11:41:29 2019 UTC (7 years, 3 months ago) by ryoon
Branches: MAIN
Diff to: previous 1.9: preferred, colored
Changes since revision 1.9: +0 -1 lines
Update to 6.3.0.4

* qt4 option is no longer provided

Changelog:
See: https://wiki.documentfoundation.org/ReleaseNotes/6.3 in detail

* Improve performances
* Improve file load an save performances in Writer
* Improve MS Office file supoort in Calc
* Use tabcompact UI by default
* Use context single mode for Writer and Draw
* Support PDF/A-2 export
* And many improvements and bugfixes

Revision 1.9: download - view: text, markup, annotated - select for diffs
Tue Feb 19 16:28:03 2019 UTC (7 years, 8 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +25 -0 lines
Update to 6.2.0.3

Changelog:
Many bugfixes and improvements including:
* New menu GUI
* Fix copy and paste of table in Writer
* REGEX function in Calc
* Animation improvements in Impress and Draw
* Drop MySQL C++ Connector in Base
* Improve EMF+ graphics import
* Improve MS PowerPoint PPT/PPTX file import/export
* New icons and themes

Revision 1.8: download - view: text, markup, annotated - select for diffs
Sat Aug 18 00:11:32 2018 UTC (8 years, 3 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2018Q4-base, pkgsrc-2018Q4, pkgsrc-2018Q3-base, pkgsrc-2018Q3
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +24 -0 lines
Update to 6.1.0.3

Changelog:
Many new features including:
* EPUB export of Writer
* vlookup performance improvement of Calc
* New drawing style of Impress and Draw
* Embedded HSQLDB deprecation of Base

Revision 1.7: download - view: text, markup, annotated - select for diffs
Mon Jun 25 13:34:48 2018 UTC (8 years, 4 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2018Q2-base, pkgsrc-2018Q2
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +24 -0 lines
Update to 6.0.5.2

* Fix javaPathHelper startup error with patches from wiz@

Changelog:
6.0.5.2:
Bugs fixed compared to 6.0.5 rc1:

    tdf#33689 Date format problem using the Dutch (NL) localization [Eike Rathke]
    tdf#107867 Crash when working with form [Eike Rathke]
    tdf#114736 Crash with CJK characters in status bar (OpenGL) [Tamas Bunth]
    tdf#116527 Crash in: `anonymous namespace'::documentStartPageNumber [Caolán McNamara]
    tdf#116552 Pivot table shortcuts for moving the current field into the "Row" area [Caolán McNamara]
    tdf#117827 Synchronize Labels button not working [Laurent BP]
    tdf#118068 Impress crashes when the New Slide toolbar command is used [Caolán McNamara]
    tdf#118070 LibreOffice 6.0.4.2 fails to build with GLM 0.9.9.0: GLM_GTX_bit is an experimental extension [Louis Sautier]
    tdf#118073 LibreOffice Basic freezes when line ends with "0." [Eike Rathke]
    tdf#118161 COUNTA() returns inconsistent values depending on entering separate cells or a corresponding cell range [Eike Rathke]

6.0.5.2:
Bugs fixed compared to 6.0.4 (rc2):

    deb#899380 apparmor: fix gpg encryption hang trying to lock random_seed [Rene Engelhard]
    ofz#6104 guard against self recursive GetShadow [Caolán McNamara]
    ofz#6448 guard against self recursive GetShadow [Caolán McNamara]
    ofz#6602 guard against self recursive GetShadow [Caolán McNamara]
    ofz#6640 guard against self recursive GetShadow [Caolán McNamara]
    ofz#7146 guard against self recursive GetShadow [Caolán McNamara]
    ofz#7322 lcl_MarkEqualByStart sort logic differs from that of operator== [Caolán McNamara]
    ofz#8095 avoid recurse to death [Caolán McNamara]
    ofz#8161 guard against self recursive GetShadow [Caolán McNamara]
    ofz#8226 + valgrind: uninitialized value [Caolán McNamara]
    redmine#2585 update credits [Christian Lohmaier]
    rhbz#1065629 [fix available] RTF import probable regression with non-english BigMachines exports [Miklos Vajna]
    rhbz#1283420 message box fonts corrupted in libreoffice [Caolán McNamara]
    rhbz#1396729 [GTK3] LibreOffice Writer slows scrolling with embedded images [Caolán McNamara]
    rhbz#1569331 Libreoffice applications crash when tried to input through any IME [Caolán McNamara]
    tdf#13107 The RTF export is incorrect. [Miklos Vajna]
    tdf#38225 Unable to change name of a custom style [Mike Kaganski]
    tdf#53485 FILEOPEN EMF+ particular .emf: shown incomplete, without colored area [Bartosz Kosiorek]
    tdf#55058 EMF+ List of EMF import bugs with examples [Bartosz Kosiorek]
    tdf#84843 Disable all Drawing toolbar buttons in read-only mode [Caolán McNamara]
    tdf#87199 [a11y] merging cells crashes writer [Caolán McNamara]
    tdf#95843 Headless mode leaves zombie process [Stephan Bergmann]
    tdf#96739 Ctrl+left/right shift doesn't change text direction [Maxim Monastirsky]
    tdf#96918 Rounding display error for 15 digits integers [Eike Rathke]
    tdf#96947 Check marks on menus (Windows 7 Aero theme, OpenGL enabled) miss their borders [Miklos Vajna]
    tdf#99324 Accelerator underlines dont show when pressing Alt (Sidebar, Dialogs, Start Center) [Maxim Monastirsky]
    tdf#100243 System freezes when attempting to print while OpenGL is enabled [Julien Nabet]
    tdf#100761 after insert note, focus cannot return to the input bar [Caolán McNamara]
    tdf#104086 Ignore OpenGL Blacklist checked while use OpenGL for all rendering unchecked, enables OpenGL [Miklos Vajna]
    tdf#104658 Chart bars shrink and jump up on applying bitmap fill [Katarina Behrens]
    tdf#104893 Assert from OpenGL code when activating chart object [Miklos Vajna]
    tdf#105954 When exporting to pdf and choosing "JPEG compression", "reduce image resolution" isn't taken into account. [Miklos Vajna]
    tdf#106084 certain EMF+ images from OOXML document are not rendered correctly LibreOffice [Bartosz Kosiorek]
    tdf#106702 FILESAVE: PDF: Only first page's background is exported [Miklos Vajna]
    tdf#109143 image exported to pdf is not being cropped correctly [Miklos Vajna]
    tdf#111080 Edit form, use 'replace with' to change the type of control - nothing happens [Julien Nabet]
    tdf#111988 README and Download page System requirements are wrong for OSX - states 10.8 supported, but requires minimum 10.9 [Xisco Fauli]
    tdf#112211 FILEOPEN: RTF: Incorrect horizontal bullet position [Miklos Vajna]
    tdf#112501 Pivot table: popupbuttons are placed on wrong cells imported from XLS [Caolán McNamara]
    tdf#113143 FILESAVE PDF: wrong position of a JPEG image on exported notes page [Miklos Vajna]
    tdf#113197 FILEOPEN: EMF+ Incorrect lines' height [Armin Le Grand]
    tdf#113624 Wrong position and size of the characters in EMF/EMF+ dual mode [Bartosz Kosiorek]
    tdf#113894 [Regression] Pasting text from Writer in Calc formula field doesn't strip formatting [Maxim Monastirsky]
    tdf#114132 Tiling bitmaps does not work for charts (Format Wall) [Katarina Behrens]
    tdf#115582 VIEWING: Rotated Text in a Cell gets invisible (steps in comment 6 ) [Armin Le Grand]
    tdf#116365 Crash in: BitmapReadAccess::SetPixelForN24BitTcRgb(unsigned char *,long,BitmapColor const &,ColorMask const &) if OpenGL is enabled [Miklos Vajna]
    tdf#116420 Error when I try to open an Document in a Sharepoint WebDAV directory (# is not allowed in a filename) [Mike Kaganski]
    tdf#116511 Calc crashes when opening Function Wizard through Cmd-F2 shortcut [Tor Lillqvist]
    tdf#116725 !!br0ken!! mysteriously appears in Spellcheck after some steps [Mike Kaganski]
    tdf#116801 Fileopen DOCX: text in table is in the first column only [Miklos Vajna]
    tdf#116821 row and column toolbar not available when selecting non-adjacent rows/columns by pressing ctrl key [Maxim Monastirsky]
    tdf#116841 FILEOPEN: Bullet list has no identation [Miklos Vajna]
    tdf#116925 Automatic text color in textbox does not consider fill style of shape [Miklos Vajna]
    tdf#116939 Problem opening excelfile in latest release - due to overflow [Eike Rathke]
    tdf#116951 LibreOffice crashed when inserted "−" (minus, U+2212) character on Gnome on Wayland [Caolán McNamara]
    tdf#116976 DOCX import: bitmap does not consume its relative size [Miklos Vajna]
    tdf#116985 DOCX import, shape with textbox: incorrect text area size when shape size is relative [Miklos Vajna]
    tdf#116999 Libreoffice command line interface is not opening cgm files [Caolán McNamara]
    tdf#117005 Undo/redo is skipping the comment [Caolán McNamara]
    tdf#117015 "EMF+ Only" mode is not displaying object after GetDC record [Bartosz Kosiorek]
    tdf#117017 Text formatting .un:Subscript, .uno:Superscript work from menu and Sidebar deck, but not completed with assigned keyboard shortcut [Maxim Monastirsky]
    tdf#117028 DOCX import: textbox of shape lacks its transparent background [Miklos Vajna]
    tdf#117039 Print Preview cehrens]
    tdf#117093 Crash in: ScGridWindow::ClickExtern() [Eike Rathke]
    tdf#117105 Libreoffice 6.0.2 crashes when choosing "Tools" > "Options" and secring.gpg is present in Linux [Stephan Bergmann]
    tdf#117161 REPORTBUILDER - Horizontal align is]
    tdf#117246 RTF import: lost page breaks inside nested groups [Miklos Vajna]
    tdf#117268 FILEOPEN: RTF: parser dont draw tables correctly [Mike Kaganski]
    tdf#117311 The CUA bindings for clipboard (Copy-Paste) actions do not function in edit shf master slide is missing from content panel of its Sidebar deck [Xisco Fauli]
    tdf#117403 FILEOPEN: RTF: missing border on table [Miklos Vajna]
    tdf#117413 double display slightly offset when editing a cell [Caolán McNamara]
    tdf#117433 COUNTIF) doesn't properly count empty cells for empty ("" or "=") criteria [Winfried Donkers]
    tdf#117475 CRASH changing the master slide [Caolán McNamara]
    tdf#117477 Make new entry to OpenGL blacklist [Julien Nabet]
    tdf#117505 FILESAVE: RTF: header size changes after RT [Miklos Vajna]
    tdf#117596 Japanese text on the listbox is big in pivot charts [Tomaž Vajngerl]
    tdf#117601 Crash in: libstdc++.so.6.0.22 on merge cells in writer with TDF .debs on Debian 9 [Caolán McNamara]
    tdf#117612 DateAdd("m",...) does not truncate date to last valid day of month anymore [Eike Rathke]
    tdf#117628 Crash after closing Media Player after opening and applying file (kde4 and gen) [Caolán McNamara]
    tdf#117729 l10n: add Frisian [fy] UI translation to builds [Christian Lohmaier]
    tdf#117819 error displaying some integer values if number of decimals is forced to more than 15 [Eike Rathke]
    tdf#117821 Editing: Forms: Replace control menu selection image button places wrong control type on form (combo box) [Julien Nabet]
    tdf#117850 Quitting LibreOffice on macOS while About dialog is open causes process to get stuck consuming CPU [Tor Lillqvist]
    tdf#117864 Fails to cut copy or paste chart elements from the content menu [Caolán McNamara]

Revision 1.6: download - view: text, markup, annotated - select for diffs
Tue Aug 1 11:57:36 2017 UTC (9 years, 3 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1, pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +34 -0 lines
Update to 5.4.0.3

* Remove openjdk7 support
* Use internal libjpeg-turbo
* Disable pdfium. This requires a lot of work

Changelog:
LibreOffice 5.4 highlights

    A new standard colour palette has been included, based on the RYB colour model.
    File format compatibility has been improved, with better support for EMF vector images. This helps when you’re importing detailed diagrams from other office software.
    Imported PDF files are rendered with much better quality, also when inserted into a document, while exported PDF files – from Writer and Impress – support embedded videos (and linked videos if opened with Acrobat Reader).
    LibreOffice 5.4 supports OpenPGP keys for signing ODF documents on Linux. If you already use GPG/PGP for signing emails, it ensures the authenticity of your ODF documents regardless of the mode of transport or storage.

WRITER

    In Writer, you can now import AutoText from Microsoft Word DOTM templates.
    When you’re exporting or pasting numbered and bulleted lists as plain text, their full structure is preserved.
    In the Format menu, you can now create custom watermarks for your documents.
    New context menu items have been added for working with sections, footnotes, endnotes and styles.

CALC

    Calc now includes support for pivot charts, which use data from pivot tables. When the table is updated, the chart is automatically updated as well.
    Comments are now easier to manage, with menu commands to show, hide and delete all comments.
    When applying conditional formatting to cells, you can now easily change the priority of rules with up and down buttons.
    Extra sheet protection options have been added, to optionally allow insertion or deletion of rows and columns.
    Lastly, when you’re exporting in CSV format, your settings are remembered for the next export operation.

IMPRESS

    In Impress, when you’re duplicating an object, you can now specify fractional angles. In addition, your settings are saved for the next duplication operation.

Revision 1.5: download - view: text, markup, annotated - select for diffs
Sat Feb 4 01:48:00 2017 UTC (9 years, 9 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2017Q2-base, pkgsrc-2017Q2, pkgsrc-2017Q1-base, pkgsrc-2017Q1
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +1 -1 lines
Update to 5.3.0.3

* Use internal harfbuzz and graphite2
  LibreOffice 5.3.0 requires harfbuzz with graphite2 support.
  Enabling graphite2 in fonts/harfbuzz breaks graphics/librsvg, so
  I cannot enable graphite2 in fonts/harfbuzz.

* Explicitly specify static libraries of harfbuzz and graphite2
  with path to fix a linking of libvcllo.so

* Add some comments to patches

Changelog:
Highlights

LibreOffice 5.3 offers a number of interesting new features in
every area: a new cross-platform text layout engine that uses
HarfBuzz for consistent text layout on all platforms, with significant
advantages across languages and alphabets; a revised Help menu,
with new quick links to user guides and community support forums,
for an improved user experience; and better import/export filters
to new and legacy MS Office documents.

Writer now supports Table Styles, for applying formatting to a
table which is preserved when you make edits to it; a new Page Deck
in the sidebar lets the user quickly customise page settings without
having to go through a separate dialog box; and a new Go to Page
Box makes it possible to jump to another page in the document with
just a few keystrokes.

Calc provides a new set of default cell styles, with greater variety
and better names than in previous releases; in fresh installations,
"enable wildcards in formulas" is now the default option, rather
than regular expressions, to improve compatibility with other
spreadsheet software; and a new text entry box lets the user narrow
down the functions he is looking for, and simplifies the search
for the right one.

Impress now opens with a template selector, to get the user off to
a quick start; and a new Slide Properties Deck is now available in
the sidebar while in slide master mode.

Revision 1.4: download - view: text, markup, annotated - select for diffs
Sat Dec 24 21:45:03 2016 UTC (9 years, 10 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2016Q4-base, pkgsrc-2016Q4
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +25 -1 lines
Update to 5.2.4.2

* Fix NetBSD/i386 build

Changelog:
* Many bugfixes

Revision 1.3: download - view: text, markup, annotated - select for diffs
Tue Dec 6 15:21:00 2016 UTC (9 years, 11 months ago) by ryoon
Branches: MAIN
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +1 -1 lines
Update to 5.2.3.3

* Drop external PostgreSQL dependency. Use internal one to reduce conflict
* Add cups option, from mrg@. Thank you.

* Calc does not work properly in some case. I will revisit later.
* i386 build will fails. I will revisit later.

Changelog:
New features and bugfixes including:

Revision 1.2: download - view: text, markup, annotated - select for diffs
Thu Feb 11 09:45:26 2016 UTC (10 years, 9 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +2778 -2782 lines
Update to 5.1.0.3

Changelog:
New features:
Writer:
Spelling dialog no longer automatically closes once spellcheck is complete. tdf#79312 (Marek Dolezel)
Widow/Orphan paragraph text-flow enabled by default for new documents. tdf#89714 (SIL)
Hide Whitespace option added to View menu tdf#39080 (Ashod Nakashian, Collabora)
Outline split button available in formatting toolbar, but hidden by default tdf#95403 (Maxim Monastirsky)
While in print preview mode to jump a specific page, the only thing you have to do to enter the page number on the numeric field in the toolbar. tdf#80657 (Gülşah Köse)

Calc:
New commands to add rows below and columns right. (Philippe Jung)
Formula Wizard shows the values of parameters and results on the Structure page. (Benjamin Ni)
Statistics regression: linear, logarithmic, power: Add a new statistics dialog for calculating regression. tdf#74667 commit (Tomaz Vajngerl, Collabora)
Organize sheet level context menus. commit (Yousuf Philips)
PNG export in LibreOffice Calc was added, as in Writer and Impress. blog entry (Miklos Vajna, Collabora)
Option to search formatted display strings using find bar and also "Find & Replace" dialog. tdf#48456 (Dennis Francis)
INDIRECT function: better compatibility for legacy OOo documents, improved interoperability with Excel tdf#92256,tdf#93688 (Katarina Behrens, CIB)
Custom number formats with question mark in decimal part (such as 0.???), to get decimal alignment without '0', are now saved in ODF tdf#40517 (Laurent BP)

Formula engine:
Table structured references

tdf#85063 (Eike Rathke, Red Hat)

    The following restrictions of Table structured references that were present in 5.0 were addressed:
        The column names must not be present as cell content in the table's header row any more; column-header-less tables are now supported.
            For this, for new database ranges without header cells or with empty header cell content, internal names are generated, for example Column1, Column2, ...
            Internal names are imported from OOXML spreadsheet documents and continue to function in formula expressions.
        Saving to OOXML, structured references are now written (not transformed to A1 notation any more) and the table context is maintained.
        Saving to OOXML, the defined database ranges are now exported as <table> elements.
    Modifying header cell content updates the internal table column names.
        When deleting header cell content, formulas referring the column name continue to function and are still editable using the previous name.
        When duplicating header cell content, duplicated column names internally are numbered. For example, having two FooBar header cells the column names will be FooBar and FooBar2. This is automatically reflected in existing formula expressions.
        When inserting columns within a table, numbered column names are internally generated for empty header cells, starting with the column number within the table. For example, inserting two columns before the third column of a table the generated names are Column3 and Column4.
            The generated column names are updated if text is entered in such an empty cell.
        All internal column names are unique within one table, which is reflected when displaying existing formula expressions.

Sticky end column/row anchors

tdf#92779 (Eike Rathke, Red Hat)

    For range references that encompass at least two columns or rows where the end reference points to the last column or row, i.e. AMJ or 1048576, the end column or row is sticky now and not moved when inserting or deleting columns or rows.
    When inserting columns or rows and updating a reference the end reference would be shifted out of the sheet bounds, the reference is anchored at the last column or row instead of generating a #REF! error.
        For example a reference B2:B1048575 when inserting two rows will be updated to B2:B1048576.
        The column or row will become sticky then, in the example row 1048576.
    A reference like B1048576:C1048576 does not have a sticky end row anchor, because only one row is referenced.

Compatibility with ODF 1.2

Function WEEKNUM strictly complies with ODF 1.2 function definition and ISOWEEKNUM has been introduced. tdf#50950 (Winfried Donkers + Eike Rathke)

    In the UI the WEEKNUM_ADD function has been renamed to WEEKNUM_EXCEL2003 to point out it exists for interoperability of documents created with Microsoft Excel.
        Importing such documents created with older Microsoft Excel versions map the WEEKNUM function to WEEKNUM_EXCEL2003
        Saving to ODF or OOXML writes WEEKNUM, older LibreOffice and OpenOffice.org release map that to WEEKNUM_ADD.
        For new documents the WEEKNUM function should be used.
    WEEKNUM now supports all arguments of the second parameter as defined in ODF OpenFormula (ODFF), see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#WEEKNUM
    The ISOWEEKNUM function has been implemented to calculate the week number according to ISO 8601, see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ISOWEEKNUM
    WEEKNUM_OOO provides compatibility with older LibreOffice and OpenOffice.org releases for cases that can not be mapped to WEEKNUM or ISOWEEKNUM as defined in the standard, specifically if the mode argument is 1 the old WEEKNUM implementation returned a week number calculated as if it was an ISO 8601 calculation but with the week starting on Sunday instead of Monday. This is not covered by any standard.
        Not offered in the Function Wizard to prevent accidental use. Use it only if interoperability with older LibreOffice or OpenOffice.org releases is required.
        Currently still saved wrongly as ISOWEEKNUM with 2 parameters for interoperability with older LibreOffice or OpenOffice.org releases.
            This will be changed in future for release 5.3 and the function will be saved as ORG.LIBREOFFICE.WEEKNUM_OOO, the current 5.1 release is already enabled to read that.

Impress and Draw:

    Slide navigation and sorting commands were added with corresponding shortcut keys. tdf#91909 (Philippe Jung, Yousuf Philips)
    Master slide view appears in a different background color to normal view. tdf#87905 (Katarina Behrens, CIB)
    KDE, XFCE, and Mate ScreenSavers are now also inhibited when presenting (Andrzej Hunt).

Impress Mode selection

Several modes were active in Impress:

    Page to edit slides content
    Page Master to edit slides container
    Notes to add Notes
    Notes Master to edit Notes container
    Plan to sketch a presentation
    Handout to define the handout format
    Slide sorter to organise presentation

It was hard to navigate between Master / non master modes. Tabs above the working area were jumping right and left, consuming screen space.

Now, two toolbox icons have been added:

    one to toggle Tab bar visibility. It is hidden by default. Clicking the toggle disables the new Mode Selection tool and restores the previous behaviour.
    one to Select the Working mode among the 7 modes listed above. It is divided in two zones: top zone is regular mode (dealing with content of the presentation), bottom zone is the Master mode (dealing with container).

Slide Design

Slide Design dialog in Slide ▸ Slide Design now affects all selected (standard) slides. (Caolán McNamara, Red Hat)
Equalize Width/Height

When multiple objects are selected, the right click context menu Shapes submenu now supports Equalize Width and Equalize Height which adjusts the width/height of the selected objects to the width/height of the last selected object. (Caolán McNamara, Red Hat)

Save Background Image

Right clicking a slide now supports saving a background image to file, this matches the pre-existing set background image option. (Caolán McNamara, Red Hat)

View/Edit Control Points

The Shape Properties dialog for enhanced shapes now lists and enables editing the control points. This is in addition to the preexisting mechanism of selecting with the mouse the yellow control handle of the shape, but enables viewing and fine control over the control values. (Caolán McNamara, Red Hat)

Presenter Console

There is now a button on the presenter console to restart the timer of the slideshow without restarting the slideshow itself (see this blog entry) (Miklos Vajna, Collabora; Andreas Kainz)

OpenGL Transitions

All OpenGL transitions have been ported to OpenGL 2.1+, which removes support for very old GPUs but allows a better usage of modern ones. Four new transitions have been added and exploit these new available features. (Emmanuel Gil Peyrot, Collabora; Tomaž Vajngerl, Collabora)

Math:

    Autoclosing brackets is optional now tdf#43090

Import MathML from Clipboard

(Regina Henschel)

    The tool “Math Input Panel” in Windows or the context menu of a formula in a browser allow to copy the MathML source to clipboard. The Math module in LibreOffice has got a new item “Import MathML from Clipboard” in menu Tools to import such source and convert it into LibreOffice’s own formula syntax StarMath.

MathML and StarMath have some differences and therefore sometimes corrections on the imported formula are needed, but most of the formula should be correct. If a conversion is not possible, nothing happens.

The import expects, that a <math> element exists, which has an attribute xmlns="http://www.w3.org/1998/Math/MathML".

Base:
Ancient SeaMonkey based mozab driver was only used on Windows 32 bit and is removed now. This functionality is replaced with mork driver, that supports Thunderbird address book.

Given that SeaMonkey based mozab driver also provided Outlook and Outlook Express address book integration, that Windows 32 bit only feature is lost for now. Note that Windows 64 bit never supported ancient SeaMonkey based mozab driver.

Chart:
Trend Line

    Exponential and Power trend lines accept negative Y values tdf#70673 (Laurent BP)
    Improve equation rendering by removing some useless 1: (Laurent BP)
        polynomial: f(x) = 1x^2 + 1x +1 => f(x) = x^2 + x +1

Core:

Unicode character input with Alt+X

Some Windows applications, such as Microsoft Word and WordPad, permit the user to input arbitrary Unicode characters by typing an hexadecimal code point (for example, 2026 for …) and then pressing Alt+X. LibreOffice now includes this functionality as well. (Note: This feature adds to the long-existing, equivalent Linux/GTK functionality of pressing Ctrl+⇧ Shift+U+hexadecimal code point.) tdf#73691 (SIL)

Details:

    Toggles (switches back and forth) between the character before the cursor and its Unicode notation.
    Intelligently handles combining characters, expanding the entire character immediately.
    Selection is not necessary, but if used will limit the input to those characters. (Draw/Impress/Calc have the final result selected, but not Writer.)
    Handles all 16 Unicode planes
    Available in Writer, Draw, Impress, Calc and Math.
    Re-assignable keyboard shortcut: Tools ▸ Customize ▸ Keyboard ▸ Category:Options ▸ Function:Toggle Unicode Notation. Defaults to Alt+X assigned at the global level. (Alt+C used for Basque/Dutch/Galician/German/Brazilian-Portugese locales and ⌘ Command+⌥ Option+X used for MacOS).

WebDav Improvements

    Better LOCK/UNLOCK support tdf#82744 (Giuseppe Castagno)
    Support a (https-like) non-standard vnd.sun.star.webdavs URL scheme in addition to the non-standard (http-like) vnd.sun.star.webdav scheme, core commit d3de490437df4c9093f32e97fc185066d64c0f46 (Stephan Bergmann, Red Hat)

Filters:
New import filters

    Gnumeric is now an officially supported import format (does not work on Windows) (It was supported as part of the experimental features for some time) (Markus Mohrhard)
    Microsoft Write (.wri files) can now be imported, via libwps. (Sean Young)
    Apple Keynote 6 files can now be imported, via libetonyek. tdf#88682 (David Tardon, Red Hat)

Improvements in OpenXML filter

    Export of the modified VBA stream back to binary Microsoft formats and OOXML (Rosemary Sebastian, Markus Mohrhard)
        There is a new configuration value that allows to control whether to use this feature (by default yes) or switch back to the old behavior of discarding or writing back the unchanged stream
        The following features are not yet (completely) supported: Protected macros, macro sheets, active x and some of the designer features.
    Improved export of embedded objects to DOCX and PPTX, including export of Math formulas (Michael Stahl, Red Hat)
    Numerous other improvements to the Microsoft OOXML import and export filters, the Microsoft Office binary file formats and the RTF format. Details:
        OOXML Filters → OOXML, DOCX, XLSX, PPTX, VML, drawingML
        Microsoft Office binary file filters → DOC, XLS, PPT, "ww8"
        RTF Filters → RTF

Improvements in MS Visio filter

    Implement overriding of colour of lines and of text from layer properties and the visibility and/or printability of a layer. tdf#50309, tdf#68392 (Fridrich Strba)
    Fix incorrect handling of stencil text. tdf#90154 (Fridrich Strba)
    Basic initial implementation of hatch fill. tdf#44552, tdf#76835 (Fridrich Strba)
    Implement support of bullets/lists. tdf#92349 (Fridrich Strba)
    Implement support of default tab-stops and custom tab-sets in paragraph properties. (Fridrich Strba)
    Instead of line-break, spit out a new paragraph when a paragraph break is found. (Fridrich Strba)
    Initial emulation of line rounding property. (tdf#90603) (Fridrich Strba)
    VSDX theme color import fix (tdf#92270) (Andras Timar, Collabora)
    fix VSDX char background handling (tdf#92271) (Andras Timar, Collabora)

Improvements in CorelDRAW filter

    Do not drop empty text lines. tdf#67873 (David Tardon)


GUI:
    In dialog Tools ▸ Options ▸ LibreOffice ▸ View was added displays the current status OpenGL: Enabled or Disabled

Reorganization of the menus

The main menus in Writer, Calc and Impress were reorganized to improve usability, group similar functions together, add functions that were not present and sorting items based on their usage and importance. blog entry

    Reorganization of the menus in Writer, including the addition of a Styles menu tdf#91781 (Yousuf Philips)


    Reorganization of the menus in Calc, including the addition of a Sheet menu tdf#91820 (Yousuf Philips)

Remote Files Dialog

    In Start screen and menu File was added item Open remote files for opening file on remote resources such as Google Drive, OneDrive, SharePoint, etc.
    In menu File was added item Save to remote server for saving file on remote resources such as Google Drive, OneDrive, SharePoint, etc.
    Blog entry

Sidebar

    Sidebar Deck and Panel states are saved between sessions tdf#67770 (Laurent Godard)

    Reorganize the Area content panel found in the Properties deck. tdf#90078 (Rishabh Kumar, Yousuf Philips)

To left section Area in Libreoffice 5.0, to right - in LibreOffice 5.1

    Reorganize the Line content panel found in the Properties deck. tdf#89543 (Rishabh Kumar, Yousuf Philips, Katarina Behrens [CIB])

To left section Line in Libreoffice 5.0, to right - in LibreOffice 5.1

    Creation of a Shadow content panel found in the Properties deck in Calc, Impress and Draw. tdf#87702 (Rishabh Kumar, Yousuf Philips)

New section Shadow in Sidebar in LibreOffice 5.1

    Addition of new contour and spacing controls to the Wrap content panel in Writer. core commit 30c2ae28eecb3f1a4454784974c0c2bffc60334e tdf#93775 (Rishabh Kumar, Yousuf Philips)

To left section Wrap in Libreoffice 5.0, to right - in LibreOffice 5.1

    Increase and decrease font size buttons added to sidebar properties pane in Calc. tdf#86179 (Maxim Monastirsky)

On top - section Character in Calc 5.0, from below - in Calc 5.1

    Cell reference edge added to alignment section of sidebar in Calc. tdf#91802 (Rishabh Kumar)

    Cell styles added to properties pane in Calc. tdf#73071 (Rishabh Kumar, Yousuf Philips, Maxim Monastirsky)

    Grouped Slide Transitions for easy selection and added icon based selection palette to Sidebar in Impress tdf#36946 (Tor Lillqvist, Collabora; Michael Meeks, Collabora; Andreas Kainz, Yousuf Philips)

Section Slide Transition in Impress 5.1

    New Chart sidebar tdf#91063 (Markus Mohrhard, Yousuf Philips, Heiko Tietze)
        Some limitations still apply

    Image flip buttons are now available in Writer also (Samuel Mehrbrodt [CIB])


    Icons now honor RTL/Vertical Text settings and rotate/flip accordingly, as in the toolbar. tdf#85767 (Samuel Mehrbrodt [CIB])

    An "AutoCorrect Options" item has been added in the spell checking context menu. Users can now directly enter the autocorrect replacement table when there's no satisfying suggestion in the "Always correct to" submenu. tdf#92341 (Yousuf Philips, Samuel Mehrbrodt [CIB])

    The Spelling Dialog now has a toolbar for pasting and inserting special characters. tdf#95682 (Caolán McNamara, Red Hat, Inc.)

Linux/Gtk

    Enable auto-accelerator behaviour for gtk tdf#92630 (Simon Long, Raspberry Pi)


Localization:
New languages/locales with locale data

Available as default document language and for locale specific formatting.

    Added locale data for Arabic [ar-BH] [ar-IQ] [ar-JO] [ar-LY] [ar-MA] [ar-QA] [ar-SY] [ar-YE]. tdf#95485 (Ghasan Al-Sakkaf and Eike Rathke)

Improvements to proofing tools and language support

    Proofing tools for German language (de-AT, de-CH, de-DE) have been largely improved (tdf#96782):
        The spell-check dictionary now contains over 250,000 words. The new version adds over 20,000 new words.
        The thesaurus now contains over 135,000 words in over 35,000 meaning groups. The new version adds ~ 35,000 new words.
        The hyphenation patterns have been updated and contain an improved exception list.
    Updated Slovenian thesaurus (Martin Srebotnjak)
    New Guarani (gug-PY) thesaurus (Giovanni Caligaris and Olivier Hallot)
    Updated Hungarian spell-check dictionary (tdf#95024), major update, implemented the spelling reform defined by the 12th edition of Rules of Hungarian Spelling (by the Hungarian Academy of Science, 2015) (László Németh, Collabora)
    Updated Greek spell-check dictionary (tdf#94415)
    Updated Portuguese (pt-PT) spell-check dictionary
    Updated Swedish spell-check dictionary
    Updated Spanish spellcheck dictionary (Ricardo Palomares)

Revision 1.1: download - view: text, markup, annotated - select for diffs
Wed Aug 12 00:57:20 2015 UTC (11 years, 3 months ago) by ryoon
Branches: MAIN
CVS tags: pkgsrc-2015Q4-base, pkgsrc-2015Q4, pkgsrc-2015Q3-base, pkgsrc-2015Q3
Import libreoffice-5.0.0.5 as misc/libreoffice.

LibreOffice is a free, community-developed, multi-platform office
productivity suite. It includes key desktop applications:
word processor, spreadsheet, presentation manager, and drawing program,
with a user interface and feature set similar to other office suites.

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>