ReleaseNotes/3.6

Writer

 * Format paintbrush now differentiates automatic character formating attributes applied to a paragraph from those applied to a portion of the text inside a paragraph. These automatic character formating attributes are applied to the entire paragraph by default; if is held while the format is passed, these attributes are applied to only the selected text. (Maxime de Roucy)
 * Support for contextual spacing. (Miklos Vajna)
 * Sw-contextual-spacing.png


 * VML import (used inside older DOCX files) now handles lines, rotations and flips. (Miklos Vajna)
 * DOCX import now handles GetExpression and SetExpression fields. (Miklos Vajna)
 * RTF/DOCX import/export now handles the document zoom setting. (Miklos Vajna)
 * Pressing with  or with  will decrease or increase font size of the selected text, respectively.  (Cameron Paul)
 * Word count (whole document and selection) in status bar (Robert Roth)
 * Fixes for two miscountings:, (Muhammad Haggag)


 * Sw-word-count-highlight.png


 * Table AutoFormats now record the following table-level properties: . (Muhammad Haggag)
 * Break
 * Keep with next paragraph
 * Repeat heading
 * Allow table split across pages
 * Allow rows to break across pages
 * Merge adjacent line styles
 * Table shadow


 * Shows Text Boundaries depending on the choice of display unprintable characters (Cédric Bosdonnat).
 * Support for importing Smart Art. (Miklos Vajna)


 * Smartart-sw.png


 * Try this example DOCX document.


 * [[Media:smartart.docx]]


 * Revision identifiers (RSIDs) are generated, stored in documents and used to improve document comparison quality (Tzvetelina Tzeneva).

Label / business card wizard

 * Extension of label definitions with form (paper, page) size. Labels which are not centered on the form are created correctly now. (Winfried Donkers)
 * All 1700+ predefined label definitions have been modified to include the form size, obsolete definitions have been removed. (Winfried Donkers)
 * Recalculation of label position on the form. Label definitions with gaps between labels that are wider than the right margin now produce correct documents. Existing user defined labels are automatically extended with form size. (Winfried Donkers)
 * The form size can be entered/modified in the wizard dialog: (Winfried Donkers)
 * Label-sizing-improvements.png

Calc

 * fills-down in more familiar ways, filling with the contents of the cell above if no cell is selected, and filling down multiple cells with larger selections (Kohei Yoshida)


 * New option to specify a custom sheet name prefix in new documents. (Albert Thuswaldner)
 * Custom-sheet-prefix-screenshot.png


 * Marked cells in Calc can now be merged via the right mouse click context menu. (Greggory Hernandez)


 * Sheets can be hidden and shown by using sheets tab context menu (Noel Power)


 * Improved error message for invalid sheet name. (Albert Thuswaldner)


 * Export conditional formatting to xlsx (Markus Mohrhard)


 * Improved CSV file import.
 * Handle lines with more than 64k characters. (Eike Rathke)
 * Differentiate between "max rows exceeded" and "max columns exceeded" and "max cell size exceeded" error messages. (Eike Rathke)
 * Better handling of broken CSV files where generator didn't follow RFC 4180 quote rules. (Eike Rathke)
 * Import numbers in scientific notation without having to check "import special numbers". (Eike Rathke)
 * Better initial default separators, comma, semicolon and tab. (Eike Rathke)


 * Added a "Save cell formulas instead of calculated values" option to CSV export. (Florent Gallaire)
 * Formulas export.png


 * New spreadsheet function DATEDIF as defined in ODF OpenFormula and for MS-Excel interoperability. (Winfried Donkers, Eike Rathke)


 * New spreadsheet functions IMTAN, IMSEC, IMCSC, IMCOT, IMSINH, IMCOSH, IMSECH and IMCSCH as defined in ODF OpenFormula. (Regina Henschel)


 * Support field items in cells. You can now insert date, sheet name, and title fields into cells. To insert a field, activate the cell to be in edit mode, right-click on the cell, and select Insert Field in the context menu to insert a field. (Kohei Yoshida)
 * Insert-field-items-in-cell.png


 * Allow sorting of data from the autofilter menu. (Kohei Yoshida)
 * Sort-option-in-autofilter.png


 * Quickly allow pasting only text, value, or formula from the context menu. (Noel Power)
 * Calc-paste-only-from-menu.png


 * Detailed configuration options for formula calculation. You can now configure the reference syntax for built-in function INDIRECT.  In the future we may add more calculation options here to allow users to configure run-time formula calculations. (Kohei Yoshida)


 * Remove the limitation to 3 sort entries in calc. (Albert Thuswaldner)
 * LO-multiple-sort-keys.png


 * Default number of sheets for new document will be 1, instead of 3 –, (Stefan Knorr)- Note that since version 3.5 you can edit this setting via.


 * Support for X errorbars in scatter and bars charts, import and exporting to xls and ods when using ODS 1.2 extended. (Rafael Dominguez)


 * Support for color scales and data bars. Import from xlsx and import/export from ods in ODF1.2 Extended. Warning: Some limitation still apply and will be fixed in 4.0.0 (Markus Mohrhard)


 * New dialogs for conditional formats to support color scales and data bars (Design: Stefan Knorr, Implementation: Markus Mohrhard)

Impress

 * Added widescreen format for impress-slides. (Rob Snelders)
 * Correctly detect the external display and put the presenter console on the local display (Michael Meeks)
 * 10 new master pages (Alexander Wilms, Mateus Machado Luna, Björn Michaelsen)

Math

 * Format dialogs (Font, Font Size, Spacing) and Symbols now have help buttons., , ,  (Karan Desai)
 * Imagem20.png

Basic IDE

 * Docked Object Catalog pane (Bence Tomcsik)
 * Docked Object Catalog.png

Core

 * Support for Japanese postcard paper size in all applications. (Takeshi Abe)
 * Recent Documents list are updated on Save, Save As, Save All, and Close. (Muhammad Haggag)
 * Allow for editing of read-only documents. (Stephan Bergmann) Paraphrasing from the commit message of :
 * When e.g. viewing mail attachments (that have been stored r/o to some download directory by the mail application), it would be nice if the user could easily temporarily modify them (say, play around with a spreadsheet, changing some numbers and triggering recalculation of formulas) by clicking the "Edit File" button and not being asked to create a copy for editing. Thus:
 * The "Edit File" button now only toggles the r/o status of the view. It no longer asks to create a copy for editing if the underlying document is physically r/o.
 * When a modified document is toggled to a r/o view via "Edit File," LO still asks the user to save or discard the changes. However, if the underlying document is physically r/o, saving the document opens the "Save As" dialog, instead of just doing a "Save" operation (which would fail on the physically r/o document).
 * The title of the document window now contains "(read-only)" if and only if either the view is r/o or the document is physically r/o (or both).
 * Add Support assistive technology tools option to installation process (Andras Timar).
 * Added Lanczos algorithm for resizing of images and use it instead of interpolate algorithm. This change has increased the quality of images when reducing image resolution in PDF export. (Tomaž Vajngerl)
 * [[File:Lanczos Resampling.jpg]]


 * Macro recording can be activated with a separate option: . (Cor Nouws). This allows using that (limited) functionality without turning on the experimental features.
 * EnableMacroRecording-general option.png

Filters

 * Import filter for Corel Draw documents. More details here and here.


 * PDF Export with Watermark option. See it at . (Andreas Mantke)
 * PDF export with watermark.png


 * ODF Export now comes with a "ODF 1.2 Extended (compat mode)", that yields better interoperability with older consumers of the Open Document Format. It comes at the price of a slightly reduced standards conformance though. (Thorsten Behrens)

GUI

 * General cleanup of the UI: 3D borders in rulers and status bars were removed, toolbars are borderless and have a subtle background gradient for improved look (Windows Vista/7/later only) (Mirek Mazel, Stefan Knorr, Jan Holesovsky, Michael Meeks)
 * {| class="wikitable"

! LibreOffice 3.5 ! style="background: #92e285; " | LibreOffice 3.6
 * libreoffice-3.5.png
 * libreoffice-3.6.png
 * libreoffice-3.5-mac.png
 * libreoffice-3.6-mac.png
 * }
 * libreoffice-3.6-mac.png
 * }


 * Default to Tango icon set on macOS (Michael Meeks & UI team)


 * Rulers are now much cleaner and more light-weight (design by Mirek Mazel, implemented by Jan Holesovsky)
 * updated-rulers.png


 * New Splash screen design (Andrea Soragna, Stefan Knorr (astron)).
 * LibreOffice 3.6.0.3 Splash Screen.png


 * The About dialog (access via ) has been redesigned for a cleaner look (Andrew Higginson) and received new artwork (Stefan Knorr (astron), based on the splash screen design by Andrea Soragna).
 * LibreOffice 3.6.0.3 About Box.png


 * New artwork for the “Start Center” window (Stefan Knorr (astron), based on the splash screen design by Andrea Soragna).
 * LibreOffice 3.6.0.3 Start Center.png


 * Writer and calc use split color buttons, making it possible to apply the last used color with one mouse click for font, background, border and highlight colors (Winfried Donkers)
 * [[File:Split-Colors-writer.png]] [[File:Split-Colors-calc.png]]


 * Clicking the overflow button will not show toolbar options anymore, the options could be shown by right-clicking the toolbar.  (Iain Billett)
 * Toolbar options menu in 3.6.png


 * Support for Trinity Desktop Environment integration (widgets, open/save dialogs, and address books) (Timothy Pearson and original KDE3 integration authors)


 * Dictionary choice removed in spellchecker when there is only 1 dictionary active (Caolán McNamara & Rob Snelders)


 * Zooming does now base on a geometric progression instead of an arithmetic one (Tim Hardeck)


 * GTK themes are now able to render background gradient (the screenshots here use oxygen-gtk's "libreoffice" branch) (Ruslan Kabatsayev)
 * Toolbar-gradient-and-combo-list.png


 * GTK themes now have a way for tab prelight rendering (Ruslan Kabatsayev)
 * Tab-prelight-and-themed-frame.png


 * GTK theming is implemented for fixes lines and frames (Ruslan Kabatsayev)
 * Options-menu-with-themed-lines.png

Localization

 * Implemented locale dependent date acceptance patterns for input of incomplete dates. This prevents erroneous detection of dates in Calc and Writer cell input and CSV file import. See blog article for details. (Eike Rathke)


 * Edit date acceptance patterns under, pasted text, CSV file import, ...   (Eike Rathke) EditDateAcceptancePatterns.png


 * Added English_Malawi en_MW locale data. (Eike Rathke)


 * Added Erzya_Russia myv_RU locale data.


 * Improved language tools (spell-check dictionaries, thesaurus, hyphenation patterns). Information taken from dictionary repository:
 * Updated Brazilian Portuguese (pt-BR) spellchecker (Raimundo Moura)
 * Updated Swedish spell-check dictionary
 * Updated French spell-check dictionary and thesaurus
 * Updated Czech thesaurus
 * Greatly improved German language tools (de-DE, de-AT, de-CH) with over 30,000 new words added to the German spell-check dictionary and over 7,000 new synonyms added to the German thesaurus. Hyphenation patterns were also improved.
 * substantial improvements to the Danish spellchecker and thesaurus


 * The default locale now is the locale of the operating system. (Rob Snelders)

Performance

 * Substantially improved OLE2 document import: .doc, .xls, .ppt (Caolan McNamara, Michael Meeks)
 * Substantially improved simple .doc/.docx import (Michael Meeks, Caolan McNamara)
 * Large document scrolling / re-layout / interactive editing improvements (Caolan McNamara)
 * Large autocorrect lists handled around twice as fast (Michael Meeks)
 * Improved performance of pivot table in Calc. Refreshing of pivot table should be now 35-50% faster than 3.5.  In addition, memory footprint of pivot table is reduced significantly. (Kohei Yoshida)
 * Improved performance of raw cell value import from xlsx documents. (Daniel Bankston)
 * Improved performance of merged cell and matrix range import from ods documents. (Daniel Bankston)
 * Embedded HSQLDB databases are now size-minimized before being saved (LibreOffice uses "CHECKPOINT DEFRAG" and not only "CHECKPOINT"). The space occupied by deleted rows is thus really freed, but saving/closing the file may take a longer time. (Lionel Mamane)

Infrastructure

 * Many modules ported to faster, more reliable gnumake (David Tardon, Matus Kukan, David Ostrovsky & more)

Most Annoying Bugs
The following annoying bugs were not fixed in time and will be addressed in the regular bug fix releases:


 * (Microsoft Windows only) The ADO (ActiveX Data Objects) driver is inactive. Hence, the default way of connecting to MS Access databases (.mdb and .accdb files) does not work; confirmed corrected in 3.6.1. Workaround: connect through ODBC (or use a 3.5.x LibreOffice release). Fixed in 3.6.1
 * Report wizard "Finish" button does nothing -> cannot create report through wizard; Workaround: create report in design mode or with a previous version of LibreOffice (the report can then be used and edited in LibreOffice 3.6.0). Fixed in 3.6.1.
 * Exporting files with hyperlinks in footnotes/endnotes or even a table of content to DOCX was generating corrupted files that other office suites weren't able to open. Fixed in 3.6.1
 * (Microsoft Windows only) LibreOffice silently terminates after splash screen. This happens the first time a user starts LibreOffice after the upgrade (and generally whenever there are changes to bundled or shared extensions). Workaround: manually restart LibreOffice. Fixed in 3.6.1
 * Various problems with bundled extensions. This includes, but is not necessarily limited to the below issues. Workaround: manually remove the per-user cache for bundled extensions and restart LibreOffice. How to do this is platform-dependend. On Linux, in a terminal window enter &ldquo; &rdquo;. On macOS X, in a  window enter &ldquo; &rdquo;. On Microsoft Windows, in a   window enter &ldquo; &rdquo; (and note the requirement to restart LibreOffice twice, see above).  Fixed in 3.6.1
 * No spell-checking (the &ldquo;ABC&rdquo; check is missing in front of items in the lists at even for languages for which bundled dictionary extensions are installed under ).
 * The &ldquo;Correct TWo INitial CApitals&rdquo; AutoCorrect option does not work.
 * Missing dictionary options pages (in, selecting a bundled dictionary extension like &ldquo;English spelling dictionaries, hyphenation rules, thesaurus, and grammar checker&rdquo; does not display an &ldquo;Options...&rdquo; button).
 * In some cases, LibreOffice will refuse to start completely. On Windows, it will display an error box about an &ldquo; &rdquo;, on Linux and macOS X it will print a message about an unhandled exception to   (visible when starting LibreOffice's   from a terminal window).
 * Exporting (saving) spreadsheet file with cell comments to XLS/XLSX will lose comments. Workaround: use LibO 3.5.x release or save as ODS instead. Fixed in 3.6.1
 * The option of conditional spacing between paragraphs is not displayed when formatting style (tab Indents and Spacing). Fixed in 4.2.0
 * Workaround:
 * Creates the style, checking "Autoupdate".
 * Apply to a paragraph style created.
 * Formats the paragraph and checking "contextual spacing" (Don't add space between paragraphs of the same style).
 * If you prefer, modify the style unchecking "Autoupdate".