LibreOffice 5.4：版本資訊

TDF LibreOffice首頁 Document Liberation Project 社區部落格 Weblate翻譯 Nextcloud Redmine LibreOffice問答捐助

EN
AN
AR
AST
BE
BG
BN
BRX
CA
CS
DA
DE
EL
EO
ES
FA
FI
FR
GD
GL
GUG
HE
HI
HR
HU
ID
IS
IT
JA
JV
KO
KU
LO-LA
LT
MN
MR
NE
NL
NO
OC
OM
PA
PL
PT
PT-BR
RO
RU
SAH
SK
SL
SQ
SV
TA
TE
ไทย (TH)
TR
UK
UZ
VI
正體 (ZH-TW)
简体 (ZH-CN)
Article Title: ReleaseNotes/5.4/zh-tw

關於本頁

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

After you add a release note, please also add this text into the Whiteboard field of the respective Bugzilla report, referencing the appropriate LibreOffice version: inReleaseNotes:xx.y

What does a good feature look like here:

It has a short description, and a way for a busy reviewer to find and play with the feature. Target someone who is extremely busy, and knows little-to-nothing about the product. So if a user interface element is key to the feature, be very explicit about where it is, e.g. using a menu path that leads to it: Format ▸ Character ▸ Position [tab] ▸ ‘90 degrees’.
It credits the main authors who did the work (add them in parentheses after the feature description) and references the relevant Bugzilla ticket.
If the feature can be shown off with a sample file – particularly for new import-able features, it would be wonderful to have a link to a test file that we can use to show that feature off to best effect. That really helps us to make good screenshots to show off the features, and allows reviewers to do their testing.

For more details, see the guidelines.

Thanks in advance for your help filling this out!

Writer

AutoText import from .dotx and .dotm files blog entry (Szymon Kłos - Collabora)
RTF filter now supports all types of custom document properties blog entry (Miklos Vajna - Collabora)
New "Edit Section" UNO command which works if cursor is in a section, has been created and added in context menu. tdf#102132 (Gülşah Köse).

New "Footnotes and Endnotes" UNO command which works if cursor is in a footnote or endnote, has been created and added in context menu. tdf#103258 (Gülşah Köse)

Huge improvement in the export of bullets & numbering via copy & paste 0425ccba5b2f8819d6fade05d96a72d64db1ce0c (Jan Holešovský - Collabora)

New formatting toolbar focused on the use of styles is accessible through View ▸ Toolbars ▸ Formatting (Styles). tdf#106781 (Yousuf Philips)

New toolbar formatting styles

Custom Watermark inserting in Format ▸ Watermarks. blog entry (Szymon Kłos - Collabora)

Styles submenu was added to Context Menu, which includes basic character styles. tdf#102915, tdf#85940 (Yousuf Philips)

New submenu Styles in context menu Writer

AutoCorrect options for markup strikeout and italic are added 6bfe94a631b5c5029a1f96a52b000d25e33bad4a (Tiago Santos)

New AutoCorrect markup options in Writer

Rename Moderate business letter templates to Modern business letter. tdf#111331 (Caolán McNamara, Heiko Tietze)

Calc

Calculate with Precision as shown option (Laurent Balland-Poirier) now works also with
- fraction format tdf#105657
- several subformats tdf#106052
- engineering notation tdf#106252
- thousands divisors tdf#106253

CSV export settings are now remembered. tdf#55236 (Bernhard Widl, CIB)
Priority of conditional formatting rules can be changed with new up/down buttons. tdf#74074 (Manfred Blume, CIB)

New buttons for priority of rules conditional formatting

New cell comment commands added
- Comments toggle command to show/hide all comments on currently selected sheet(s) added to View ▸ Comments. tdf#107258 (Gülşah Köse, Eike Rathke)
- Delete All Comments commands available under menu Sheet ▸ Cell Comments acting on the currently selected sheet(s) tdf#107143 (Gülşah Köse)
- Show All Comments and Hide All Comments commands acting on the currently selected sheet(s) added. tdf#84837 (Gülşah Köse)

While building formulas, when selecting a cell or range on another sheet with the pointer, absolute sheet references are now created instead of relative. tdf#90799 (Eike Rathke (Red Hat, Inc.))

Support negative year date (BCE) in cell input and date display. (Eike Rathke (Red Hat, Inc.))
- Accepted inputs include the ISO 8601 format -YYYY-MM-DD and locale dependent input like -Y/M/D or M/D/-Y or D.M.-Y
- For BCE dates years are displayed negative unless a specified date format already includes an era code, e.g. G or GG
- Last day BCE is -0001-12-31, the next day CE is 0001-01-01
- Previous versions could already calculate such dates, but did not display negative years

A new Cell Protection toggle command was added to Edit ▸ Cell Protection to change the protection status of the cell. tdf#95885 (Gülşah Köse)

Four new sheet protection options have been added to optionally allow insertions and deletions of rows and columns. The Insert rows and Insert columns options allow row and column insertions even when the sheet is protected, whereas the Delete rows and Delete columns options allow row and column deletions. Note that when row and column insertions are enabled, you can insert rows or columns even when the range to insert the new rows or columns into contains protected cells which will get shifted after the insertion. Row and column deletions, on the other hand, are only allowed on unprotected cells. tdf#43535 (Kohei Yoshida, Collabora)

New sheet protection options.

Cell styles now accessible in their own dedicated Styles menu in Format ▸ Styles. tdf#91820 (Yousuf Philips)
Standard and Percent buttons of number format became toggle. tdf#86119 (Gülşah Köse)

New spreadsheet functions

New function ROUNDSIG to round a value at a number of significant digits. tdf#105931 (Winfried Donkers)

Changed spreadsheet functions

The semantics of the COUNTIF, SUMIF and AVERAGEIF Criteria argument has been changed.
- The equals empty "=" and not-equals not-empty "<>X" criteria now also match empty cells of a given range like they are evaluated in other spreadsheet applications.

Impress & Draw

Duplicate dialog box ⇧ Shift + F3:
- Enable fractional angle tdf#77816 (Laurent Balland-Poirier)
- Save previous parameters tdf#104423 (Laurent Balland-Poirier)

Ctrl + M shortcut assigned to inserting a new slide in Impress. tdf#87674 (Yousuf Philips)

Base

…

Chart

New feature - Pivot Charts tdf#83257: blog 1, blog 2, blog 3 (Tomaž Vajngerl, Collabora)

Pivot Charts

Math

Implement context menu edit commands: cut, copy, paste for the Formula command input panel tdf#106479 (Maxim Monastirsky)

Context menu edit commands: cut, copy, paste for the Formula command input panel

BASIC

The CDateFromIso runtime function accepts also ISO 8601 date strings with separators, i.e. in the format YYYY-MM-DD (Eike Rathke (Red Hat, Inc.))
- this was also backported to release 5.3.4
The CDateFromIso and CDateToIso runtime functions handle the full date range in the proleptic Gregorian calendar, i.e. from -32768-01-01 (BCE) to 32767-12-31 (Eike Rathke (Red Hat, Inc.))
- CDateFromIso input specification:
  - The year part must consist of either two (supported only in YYMMDD format without separators for compatibility) or at least four digits. With four digits leading zeros must be given if the absolute value is less than 1000, it can be negative with a leading minus sign if the date passed denotes a year before the common era (BCE) and it can have more than four digits if the absolute value is greater than 9999. The formatted string can be in the range "-327680101" to "327671231", or "-32768-01-01" to "32767-12-31".
  - An invalid date results in an error. Year 0 is not accepted, the last day BCE is -0001-12-31 and the next day CE is 0001-01-01. Dates before 1582-10-15 are in the proleptic Gregorian calendar.
- When automatically converting a date serial number to a printable string, for example for the Print or MsgBox command, the locale's default calendar is used and at that 1582-10-15 cutover date may switch to the Julian calendar, which can result in a different date being displayed than expected. Use the CDateToIso function to convert such date number to a string representation in the proleptic Gregorian calendar.

Core / General

The standard color palette was updated. tdf#87538 blog post (Yousuf Philips, Thibaut Brandscheid, Heiko Tietze)
New 'chart palettes' color palette was created containing multiple chart palettes. tdf#106534 (Yousuf Philips)
Fix text layout issues for Tibetan, Khmer. tdf#109142 (Khaled Hosny)

Help Contents

The default size of the body help text was increased. (Adolfo Jayme Barrientos)
New help pages for undocumented BASIC constants, VBA functions and statements. (tdf#84675 - Olivier Hallot)
Update of Template manager help pages (Gabor Kelemen)

Document signing

Under Linux, you can now use OpenPGP keys to sign ODF documents. tdf#89037 (Katarína Behrens, Samuel Mehrbrodt, Thorsten Behrens - CIB)
Added support for ECDSA keys on Linux and macOS blog entry (Miklos Vajna - Collabora)
The signature status is now shown with colored infobars tdf#105566 (Katarína Behrens, Samuel Mehrbrodt - CIB):

Document with invalid signature

Filters

Improvements in EMF+ vector images import (used by .doc, docx, .xls, .xlsx, .ppt file formats)

Improve import of EMF+ images, created with ChemDraw tdf#31814 (Bartosz Kosiorek)
Add support for drawing rectangles, EmfPlusDrawRects tdf#107016 (Bartosz Kosiorek),
Add support for drawing Bézier curves, EmfPlusDrawBeziers tdf#107019 (Bartosz Kosiorek),
Add support for drawing Pie, which is used for circle charts, EmfPlusDrawPie tdf#107034 (Bartosz Kosiorek),
Add support for translating of the current world, EmfPlusTranslateWorldTransform tdf#106084 (Bartosz Kosiorek),
Draw an extra line between the last point and the first point, to close the shape, EmfPlusDrawLines tdf#39053 (Bartosz Kosiorek),
Add support for scaling world, EmfPlusScaleWorldTransform tdf#106084 (Bartosz Kosiorek),
Add support for drawing arc, EmfPlusDrawArc tdf#107034 (Bartosz Kosiorek)
Add support for bold font, EmfPlusStringFormat (f9af0abce2c266a53f536a207a62bc691213f6a0) (Bartosz Kosiorek)
Add support for converting page space coordinates to device space coordinates, SetPageTransform tdf#39327, tdf#47243, tdf#103639 (Bartosz Kosiorek)

Test image in LO 5.3, labels and circuit elements are not correctly placed,
Test image in LO 5.4, labels and circuit elements are correctly placed. Still rotating support needs to be implemented
Reference test image from XnView (Wine 1.8.5)

Test image created by ChemDraw in LO 5.3, image is not visible at all
Test image created by ChemDraw in LO 5.4, image is displayed. Still some lines are shifted.
Reference test image created by ChemDraw in Office 365 (Ubuntu 16.10)

Improvements in the PDF filter

LibreOffice now uses pdfium to render inserted PDF images. blog report 1, blog report 2 (Miklos Vajna - Collabora)
Support for linked and embedded videos in the PDF export of Writer and Impress. blog entry (Miklos Vajna - Collabora)

Other filters

Fix handling of BOM⁠ for plain text files tdf#63673 (Maxim Monastirsky)
Fix export to .xlsx of FLOOR/CEILING functions tdf#100011 (Eike Rathke, Bartosz Kosiorek)
Implement ADO rowset XML import filter tdf#106525 (Mike Kaganski - Collabora)
Implement support for Web Query (.iqy) files tdf#106359 (Mike Kaganski - Collabora)
Fix handling of Word 2013+ tables (table border aligns with margin and text is indented) tdf#106742 (Vitaliy)

GUI

…

Start Center

…

Window

…

Configuration

…

Basic Editor

The menu items are moved according to a general design concept. Close item was moved to up the first section of File menu. GoToLine item was moved from View menu to Edit menu under Find&Replace c7c0b8c2e818a4f59ef9003529673bdbfa8ad188 (Lera Goncharuk)
Setting of the line numbering saves after restart. The line numbering is enabled by default. tdf#91913 (Lera Goncharuk)

Notebookbar (experimental)

Toolbar with shortcuts was introduced in the tabbed Notebookbar. User can edit shortcuts using the Customization dialog: Tools ▸ Customize... ▸ Toolbars ▸ Notebookbar shortcuts (Szymon Kłos)

Tabbed Notebookbar with shortcuts

Notebookbar supports themes (Szymon Kłos)

Notebookbar with blue theme

Online

General

Responsive design of the document iframe (Pranav Kant, Collabora)
Read-only mode for the document iframe (Pranav, Kant, Collabora)

LibreOffice Online
Responsive design
Readonly mode

Render all the glyphs in the character dialog on the server (Henry Castro, Collabora)
Undo / Redo notification when there are conflicting edits (Henry Castro, Collabora)
Notify the clients about server non-availability / recycling (Ashod Nakashian, Collabora)
Initial Input Method support for complex languages (Pranav Kant, Collabora)

Performance

Improve performance by avoiding compression of PNG compression of un-changed tiles, and by avoiding sending PNG's that are already at the client side (Michael Meeks, Collabora; Tor Lillqvist, Collabora)
Substantial re-write of the WSD core to drastically simplify the code, improve threading - using mostly non-blocking I/O, improve maintainability and performance (Ashod Nakasian, Michael Meeks, Jan Holesovsky Collabora)

Writer

Native comment rendering, with animations (Henry Castro, Collabora)
Optional rendering of non-printing characters
Change-tracking / red-lining support & rendering (Pranav Kant, Henry Castro, Collabora)

Calc

Increased amount of rows available in the Online Calc to 10.000 (Marco Cecchetti, Collabora)

Impress

…

Localization

…

New languages/locales with locale data

Available as default document language and for locale specific formatting.

…

Additional languages in the language list

Available for text attribution.

Manchu [mnc-CN]. tdf#105448 (Eike Rathke (Red Hat, Inc.))
Xibe [sjo-CN]. tdf#105448 (Eike Rathke (Red Hat, Inc.))
Kituba (Democratic Republic of the Congo) [ktu-CD]. (Eike Rathke (Red Hat, Inc.))

Incorporation of other languages

Our goal is to support as many languages as possible. We would like to thank the following people for voluntary translation into LibreOffice and helps in preserving their native languages:

Michael Wolf has translated most of the user interface of LibreOffice into Upper Sorbian (hsb) and has started with the translation to Lower Sorbian (dsb). LibreOffice Online has been completely localized into Upper Sorbian and Lower Sorbian. LibreOffice is the first office suite available in the Sorbian language.

Improvements to proofing tools and language support

Updated English spell-check dictionaries
Updated Croatian spell-check dictionary
Updated Polish spell-check dictionary and thesaurus
Updated French spell-check dictionary and thesaurus
The language list for text attribution now also displays BCP47 language tags provided by dictionaries if a language is not known in the predefined set of languages. (Eike Rathke (Red Hat, Inc.))
- Such additional language tags are placed in curly brackets / braces, for example {en-DK}, and are displayed at the top of the list after the [None] entry.
The grandfathered language tag en-GB-oed (deprecated since 2015-04-17) for Oxford English Dictionary spelling is now an alias of en-GB-oxendict tdf#100462. (Eike Rathke (Red Hat, Inc.))
- en-GB-oxendict was already supported in earlier releases but not mapped to the list of predefined languages; both language tags now map to "English, OED spelling (UK)".
- Writing a document that previously contained text attributed with en-GB-oed the attribution is now written as en-GB-oxendict.

If you speak an endangered language and want to help us to achieve our goal of providing free tools for every single person on Earth, please join us.

Scripting: Python and Basic

Access2Base updated

Access2Base, the Basic library for Base users, is now available in its version 1.7.0 (Jean-Pierre Ledure).

Form, subform, dialog and control events can be dynamically got and updated with the new On (form-events), On (dialog-events) and On (control events) properties.
The new module object class together with its properties and methods makes it easy to navigate through the Basic libraries attached to the current Base file or application.

Full documentation is available on the documentation website.