From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
Deutsch • ‎English • ‎español • ‎français • ‎日本語 • ‎português do Brasil • ‎slovenščina
BHS 6.3.0 Alpha1 large.png

About this page


  • The "Words With TWo INitial CApitals" AutoCorrect exception list function has been extended to also be considered when changing case in "Capitalize first letter of every sentence" and "Correct accidental use of cAPS lOCK key" functions. This allows avoid auto-capitalization in words like mRNA, iPhone, fMRI. It has been renamed to "Words With TWo INitial CApitals or sMALL iNITIAL" tdf#121779 (Mike Kaganski - Collabora).
  • Added UNO command .uno:TableCellBackgroundColor to allow setting single and multiple selected table cell(s) background color tdf#82504 (Jim Raykowski)
  • Add "Send Outline to Clipboard" button to Navigator -> Context Menu (right click on "Headings") tdf#123395 (Wenzhe Pei).
  • Variable input fields Insert ▸ Field ▸ More Fields... ▸ Variables ▸ Input field can now be edited inline, in the same way as was already possible for function input fields Insert ▸ Field ▸ More Fields... ▸ Functions ▸ Input field tdf#123968 (Michael Stahl, CIB)
  • Index/Table of Contents Update is now Undo/Redo enabled and no longer clears the Undo stack tdf#38703 (Michael Stahl, CIB)
  • Improved copy from Calc into Writer text tables: only visible cells of a filtering are being copy and paste tdf#124646 (László Németh, NISZ)

Interoperable text-based form controls

  • Optional Forms menu layout, similar to Microsoft Office (Tamás Zolnai, Collabora)
  • Implement GUI for legacy form controls (Tamás Zolnai, Collabora)

See also: Form controls in LibreOffice

Open/Save Performance

  • Improve performance of bookmarks. Export time is 1.5 times faster tdf#117066 (Noel Grandin, Collabora)
  • Improve performance of large tables. tdf#84635 (Noel Grandin, Collabora)
  • Improve performance of embedded fonts. tdf#69060 (Mike Kaganski, Collabora)
  • Improve perfomance for some ODT files tdf#63640 (Noel Grandin, Collabora)


  • Add UNO API to let cell anchored graphics resize with the cell (Samuel Mehrbrodt, CIB) tdf#124329
  • Added new drop-down widget into formula bar instead old tool Sum (Gagandeep Singh) tdf#120697
New drop-down widget in formula bar
  • User can disable the extra dialog for search results. For activate of this dialog use option Show summary of replaced cells in dialog Tools > Options > Calc > General > Input Settings tdf#87965 (Heiko Tietze)
Search results

Rework Data -> Statistics -> Sampling dialog

All work was made by Eike Rathke commit

  • Add "With replacement" checkbutton
    • checked: WR (with replacement, put back after draw), larger sample size than population size possible
      • mutually exclusive with "Keep order"
    • unchecked: WOR (without replacement, do not put back after draw), sample size limited to population size
      • automatically unchecked for "Periodic" samples
  • Add "Keep order" checkbutton
    • checked: samples are drawn in order of population data
      • WOR method mutually exclusive with "With replacement"
      • automatically checked for "Periodic" samples
    • unchecked: samples are drawn in random order
  • Limit "Sample size" and "Period" input fields to size of population for all WOR methods
    • when limiting, increment "Sample size" and "Period" up to their last known value when enlargening the population size

Previously, for "Periodic" samples the "Period" field was never limited, which for populations of smaller size makes no sense.

The new recent implementation for "Random" without "Keep order" and without "With replacement" set (WOR) strictly needs "Sample size" limited to population size.

New spreadsheet functions

FOURIER() function

FOURIER(Array, GroupedByColumns, Inverse, Polar, MinimumMagnitude) is a matrix formula that computes discrete Fourier transform [DFT] of an input array (first argument) using a couple of Fast Fourier Transform algorithms. All features of this formula will also be available graphically via the dialog Data ▸ Statistics ▸ Fourier analysis tdf#74664 blog (Dennis Francis, Collabora)

The data in input array(first argument) can be:

  • grouped by columns (needs to be indicated by flag GroupedByColumns = TRUE). In this case the array can contain 1 or 2 columns, where the first column contains the real part of input sequence and second column if present contains the imaginary part of the input sequence. If there is only 1 column, the input sequence is treated as purely real.
  • grouped by rows (needs to be indicated by flag GroupedByColumns = FALSE). In this case the array can contain 1 or 2 rows, where the first row contains the real part of input sequence and second row if present contains the imaginary part of the input sequence. If there is only 1 row, the input sequence is treated as purely real.

The third argument "Inverse" is a boolean flag to indicate whether an inverse DFT needs to be computed. This argument is optional and the default value is FALSE.

The fourth argument Polar is a boolean flag to indicate whether the final output needs to be in polar coordinates. This argument is optional and the default value is FALSE.

The result of DFT consists of two columns - first column contains the real parts (or the magnitudes if Polar=TRUE) and second column contains the imaginary parts (or the phases if Polar=TRUE).

There is a 5th optional parameter, MinimumMagnitude. This parameter is used only if Polar=TRUE. All frequency components with magnitude less than MinimumMagnitude will be suppressed with a zero magnitude-phase entry. This is very useful when looking at the magnitude-phase spectrum of a signal because there is always some very tiny amount of rounding error when doing FFT algorithms and results in incorrect non-zero phase for non-existent frequencies. By providing a suitable value to this parameter, these non-existent frequency components can be suppressed. By default the value of this 5th parameter is 0.0, so *no* suppression is done by default.

Fourier Analysis Tool in action


  • Speed-up loading of XLSX files. tdf#121052 tdf#67629 tdf#85482 (Noel Grandin, Collabora)
  • Speed-up loading of ODS files. tdf#120445 (Noel Grandin, Collabora)
  • Speed-up loading and rendering of Calc files (Serge Krot, CIB) tdf#121052
  • Speed-up saving files to XLS format. tdf#85470 (Noel Grandin, Collabora)

Changed spreadsheet functions

Impress & Draw

  • May now drag'n'drop multiple Impress animations to reorder them. (Brian Fraser) commit
  • Introduce an expert option 'WriteLayerStateAsConfigItem' with default value 'true'. If you set it to 'false', the visible/printable/locked state of layers are only written ODF conform to part styles.xml, otherwise to settings.xml in addition. You might need the option 'false' to avoid inconsistency in case you manipulate layers via macro. (Regina Henschel) commit
  • OOXML preset shapes as used by PowerPoint or SoftMaker had some glitches in handle-movement, when you tried to alter the shapes in LibreOffice. The shape outline moved in opposite direction of the handle movement, or the handle jumped to a new location, when you touched it, or the handle was not movable at all. That is fixed for most shapes now.(Regina Henschel, tdf#115813, tdf#125126, tdf#125181, tdf#125445)



  • Implement feature to disable legend entry for series (Markus Mohrhard) tdf#51671
  • Add palette selection to options charts default colors (Jim Raykowski) tdf#105225



Core / General

  • LibreOffice TWAIN module on Windows was reimplemented as a separate 32-bit shim executable (twain32shim.exe). This allows both 32-bit and 64-bit LibreOffice to use 32-bit TWAIN Windows component. Now finally LibreOffice x64 for Windows is able to use scanner (tdf#114635 - Mike Kaganski, Collabora).
  • The number of saved searches in the Find & Replace dialog can be adjusted per expert configuration Tools ▸ Options ▸ LibreOffice ▸ Advanced org::openoffice::Office::Common::Misc::FindReplaceRememberedSearches tdf#122322 (Heiko Tietze)
  • New command .uno:InsertNarrowNobreakSpace introduced bound to Shift+Alt+Space that inserts a non-breakable narrow space (U+202F) tdf#121596 (Heiko Tietze)
  • Now, like other controls for example the tree control, it is be possible to create and change properties of UNO grid control and UNO Hyperlink control within the Dialog-Editor tdf#53524,i#119731 (Shubham Goyal, Samuel Mehrbrodt).
  • Tip-Of-The-Day dialog shows useful information once per day on startup tdf#124238 (Heiko Tietze)
Tip of the Day
  • What's-New infobar pointing to the release notes when a new version is started for the first time tdf#69042 (Heiko Tietze)
What's New infobar
  • Sentence selection (triple click) is available for keyboard customization now (no default shortcut assigned) tdf#124552 (Heiko Tietze)

LibreOffice Help

  • Help pages in Python Macro programming (Alain Romedenne, Olivier Hallot)
  • More pages on undocumented BASIC objects and functions (Alain Romedenne, Olivier Hallot)
  • Python and BASIC code fragments better rendered in Help pages (Olivier Hallot)

Bascode rendering.png

  • Python and Basic code fragments can now be copied to clipboard on a mouse click for later use - tdf#122548 (Olivier Hallot)
  • Extension of the XML dictionary (DTD) to simplify markup for Help pages (Olivier Hallot)
  • The Online Help Editor (Olivier Hallot, Mike Saunders)
  • Refactoring of Math icons to SVG (Mark Robbinson)
  • Refactoring of Help file names for Draw (Ilmari Lauhakangas)
  • Code cleanups and typo fixing (Sophia Schröder, Andrea Gelmini)
  • Calc functions CONCAT, TEXTJOIN, IFS, SWITCH documented (Olivier Hallot, Wilfried Donkers)
  • Calc functions now indicates the LibreOffice release of their implementation (Olivier Hallot, Mike Kaganski)


Improvements of the PDF export filter

  • added support for PDF/A-2 export, switched UI to use that instead of PDF/A-1 tdf#62728 (Thorsten Behrens, CIB)

Improvements of OOXML filters

Improvements of Tagged PDF export

Several enhancements were made to Tagged PDF export in order to improve accessibility of produced documents and PDF standard compliance, in particular:

  • better tagging of bullets and numbered lists
  • export of image title and description (alt text)
  • images on slide/page background are now exported as artifacts, thus not announced by screenreader

This work has been sponsored by Blackboard Ally (Armin Le Grand, Katarina Behrens, CIB)


Classic Toolbars

  • Toolbar More controls was deleted and all tools from this toolbar were moved to toolbar Form Controls. It was made for all modules of LibreOffice. tdf#112411 (Roman Kuznetsov)

Icon Theme

  • Sifr icon theme got a huge update (Andreas Kainz)
  • Karasa Jaga icon theme reworked from 22px*22px size to 24px*24px one. tdf#124808 (Rizal Muttaqin)
To up Karasa Jaga large icons in version 6.2, to down - in version 6.3
  • Karasa Jaga icon theme got SVG (Scalable Vector Graphics) version. tdf#125368 (Rizal Muttaqin)



  • Sidebar width can now be configured via the Office/UI/Sidebar/General/MaximumWidth config option. tdf#124255 (Samuel Mehrbrodt, CIB)
  • Some improvements to handle different widths for sidebar decks commit 1 commit 2 (Samuel Mehrbrodt, CIB)
  • Changed Bullet style's names in Style section of Writer Sidebar tdf#124471 (Roman Kuznetsov)
Changed Bullet style's names in Style section of Sidebar. Before - to left, after - to right

Calc/Draw tabs

  • Calc and Draw tabs were changed for more visible and usability tdf#124572 (Tomaž Vajngerl, Collabora)
To left Calc tabs in version 6.2, to right - in version 6.3
To left Draw tabs in version 6.2, to right - in version 6.3

Calc Formala bar

  • Drop-down control in Calc Formula bar was reworked for solve some visual problems tdf#101443 (Thorsten Wagner)
On top - before, on bottom - after



Incorporation of other languages

Feature removal / deprecation


Support for Java 5 has been removed. Java 6 is now the oldest supported version. (Samuel Mehrbrodt, CIB)


Platform Compatibility


  • Statusbar shows Insert in normal mode on macOS (additional to Overwrite) to draw attention to the context menu tdf#107918 (Heiko Tietze)



KDE 5 + Qt5

API changes

UNO API changes

  • The range of supported values for a Writer document's property ZoomValue has been reduced from 5–1000 to 20–600. commit
  • Registering a XMouseListener/XKeyListener to a XWindow will now submit mouse/key events even if technically the events happened in a widget inside that window. (Samuel Mehrbrodt, CIB) tdf#122920

Configuration changes

SDK changes

Android Viewer

New Features