Created page with "{{TopMenu}} {{Menu}} {{Menu.Documentation}} {{OrigLang|LibreOffice 4.2 ReleaseNotes}} 4.2 = LibreOffice 4.2 Changes = == About this page == {{Abou..."
New page
{{TopMenu}} {{Menu}} {{Menu.Documentation}}
{{OrigLang|LibreOffice 4.2 ReleaseNotes}}
[[Category:ReleaseNotes|4.2]]
= LibreOffice 4.2 Changes =
== About this page ==
{{Aboutthispage|ReleaseNotes/4.1|4.1 release}}
== Writer ==
* Embedding images into HTML files enables sending merge mails with images in HTML format {{fdo|63211}} (Edmond Ciorba, Andras Timar)
<center>
{|
|-
| [[Image:Fdo-63211-before.png|thumb|center|444px|Before]]
| [[Image:Fdo-63211-after.png|thumb|center|444px|After]]
|}
</center>
* Character border: format one or more characters with a border. {{fdo|35155}} (Tamás Zolnai)
*:Supported file formats: ODT, HTML, DOC, DOCX, RTF
*:Setting: {{bc|Format|Character|Borders (tab)}}
<center>
{|
|-
| [[Image:Fdo-35155-borders_tab_page.png|thumb|center|340px|Borders tab page in Character dialog]]
| [[Image:Fdo-35155-examples.png|thumb|center|445px|Border around one or more characters]]
|}
</center>
* Select-All now works in the special situation when the document starts with a table {{fdo|37606}} (Miklos Vajna)
[[Image:Sw-starttable-selectall.png|thumb|center|445px|New select all when document starts with a table]]
* Spellcheck popup menu now allows change tracking operations. {{fdo|35746}} (Miklos Vajna)
[[Image:Swspellpopup-redline.png|thumb|center|445px|New Writer spellcheck popup menu with redline operations]]
* Multiple selection of styles in the Style and Formatting window allow to delete or hide them {{fdo|67461}} (Joren De Cuyper)
* RTF import: added initial support for group shapes {{fdo|66040}} (Miklos Vajna)
<center>
{|
|-
| [[Image:Sw-rtf-groupshape-before.png|thumb|center|444px|Before]]
| [[Image:Sw-rtf-groupshape-after.png|thumb|center|444px|After]]
|}
</center>
* Writer can now create DOT files. For more details, see [http://vmiklos.hu/blog/lo-dotexport.html this blog entry]. (Miklos Vajna)
[[Image:Dotexport.png|thumb|center|445px|Writer can now save as the .dot format.]]
* AutoCorrection of border enhanced: differences are more visible {{fdo|71740}}. (Laurent Balland-Poirier)
[[File:BorderThicknessComparison.png|200px|thumbnail|center|Comparison of border thickness with AutoCorrection]]
=== New Default Template ===
* A New default template designed for Writer based on feedback from discussions [http://nabble.documentfoundation.org/Default-LO-Style-td4061081.html Default LO Style] and [http://nabble.documentfoundation.org/Default-Writer-Template-td4076271.html Default Writer Template] (Ahmad Harthi)
[[Image:New_Template_Screenshot.png|thumb|center|444px|Larger title, new headings, bigger line spacing, and more]]
=== DOCX Interoperability ===
* Writer now preserves the 'Track Changes ON' when present in a DOCX (track changes data itself is partially preserved) {{fdo|64826}} (Adam Co)
* Solid page background color now roundtripped in DOCX. {{fdo|65257}} (Adam Co)
* Fix for page border margins in DOCX. {{fdo|64350}} (Adam Co)
* Fix for different Odd & Even page flag ignored. {{fdo|65655}} (Adam Co)
* Fix for hidden footer being imported to Writer as normal footer. {{fdo|64238}} (Adam Co)
* Writer now preserves underline color. {{fdo|65710}} (Adam Co)
* Writer now preserves character shading. {{fdo|65400}} (Adam Co)
* Writer now preserves page numbers that don't start at '1'. {{fdo|66543}} {{fdo|44689}} (Adam Co)
* Fix for export of text-box inset property to DOCX. {{fdo|66929}} (Adam Co)
* Fix for DOCX export of page border - (interoperability export case #2) http://wiki.openoffice.org/wiki/Writer/MSInteroperability/PageBorder
* Fix for preservation of bullets with level 0 (should not be shown) {{fdo|66781}} (Adam Co)
* Fix for page border shadows in DOCX. {{fdo|64350}} (Adam Co)
* Borders in headers\footer now not being lost. {{fdo|67013}} (Adam Co)
* Text-Box background gradient color now preserved correctly. {{fdo|65295}} (Adam Co)
== Calc ==
* Added WEBSERVICE and FILTERXML spreadsheet functions for access to web data. (Markus Mohrhard)
* Added LEFTB, LENB, MIDB and RIGHTB spreadsheet functions working on DBCS double byte character strings. (Zhang Lu)
* Added COVARIANCE.P and COVARIANCE.S spreadsheet functions for MS-Excel interoperability. {{fdo|70000}} (Winfried Donkers)
* Added STDEV.P and STDEV.S spreadsheet functions for MS-Excel interoperability. {{fdo|44134}} (Winfried Donkers)
* Added VAR.P and VAR.S spreadsheet functions for MS-Excel interoperability. {{fdo|61002}} (Winfried Donkers)
* Added BETA.DIST and BETA.INV spreadsheet functions for MS-Excel interoperability. {{fdo|71008}} (Winfried Donkers)
* Added BINOM.DIST and BINOM.INV spreadsheet functions for MS-Excel interoperability. {{fdo|71081}} (Winfried Donkers)
* Added CONFIDENCE.NORM and CONFIDENCE.T spreadsheet functions for MS-Excel interoperability. {{fdo|71350}} (Winfried Donkers)
* Added F.DIST, F.DIST.RT, F.INV, F.INV.RT and F.TEST spreadsheet functions for MS-Excel interoperability. {{fdo|71436}} (Winfried Donkers)
* Added EXPON.DIST, HYPGEOM.DIST, POISSON.DIST and WEIBULL.DIST spreadsheet functions for MS-Excel interoperability. {{fdo|71722}} (Winfried Donkers)
* Improved CRITBINOM spreadsheet function to handle large sample quantities. (Winfried Donkers)
* Right-click context menu on bottom left scrollbar arrows to switch sheets (Caolán McNamara)
<center>
{|
|-
| [[Image:Select-sheet-menu.png|center|Menu Preview]]
|}
</center>
* Extend formula range from all corners {{fdo|67592}} (Tomaž Vajngerl)
<center>
{|
|-
| [[Image:CalcExtendingRangeFromAllCorners.png|center|Menu Preview]]
|}
</center>
* Random number generation ({{bc|Menu|Edit|Fill|Random Number...}}) {{fdo|66477}} (Tomaž Vajngerl).
<center>
{|
|-
| [[Image:RandomNumberGenerato.png|center|Random Number Generator]]
|}
</center>
* Statistics functions {{bc|Menu|Data|Statistics}} (alternative to Excel's Add-in "Analysis ToolPak") {{fdo|66477}} (Tomaž Vajngerl)
** Sampling
** Descriptive Statistics
** Analysis of Variance (ANOVA)
** Correlation
** Covariance
** Exponential Smoothing
** Moving Average
* Implemented 'Find All' also in case of 'search in all sheets' option - creates a dialog describing matching cells {{fdo|39881}} (Matúš Kukan)
<center>
{|
|-
| [[Image:FindAllMatchingCells.png|center|455px|Find All : matching cells dialog]]
|}
</center>
== Impress / Draw ==
* Visual clue in Slide Sorter when a Slide has a Transition or Animation(s) {{fdo|65456}} (Edmond Ciorba, Andras Timar)
[[Image:Impress-visual-clues.png|thumbnail|center]]
* Adding icons to slides having custom animation or transition set, in presenter view, makes easier to present the whole content of the slides {{fdo|65457}} (Edmond Ciorba, Andras Timar)
<center>
{|
|-
| [[Image:Fdo-65457-Presenterpreview.png|thumb|center|310px|Presenter Preview]]
| [[Image:Fdo-65457-Notesview.png|thumb|center|310px|Notes View]]
| [[Image:Fdo-65457-Slidesorterview.png|thumb|center|310px|Slidesorter View]]
|}
</center>
* Impress remote control for iOS
* The side bar is now enabled by default (only in Impress)
* New Custom Animation toolbar {{fdo|62082}} (Samuel Mehrbrodt)
<center>
{|
|-
| [[Image:Customanim.png]]
|}
</center>
== Base ==
* INCOMPATIBLE CHANGE: a checkbox bound to a (var)char (string) field will now write 'true' or 'false', whereas up to LibreOffice 4.1 it wrote the strings '1' or '0'. The read behaviour is backwards compatible and will recognise values '1' or '0'. (Lionel Elie Mamane)
* NEW FEATURE: reference values in checkboxes are now honoured. This allows to have again the old behaviour of writing '1' or '0' if desired. It also allows e.g. to invert the behaviour of the checkbox (bound to a boolean field) by setting the checkbox properties as follows 'Reference (on): false' and 'Reference (off): true' (Lionel Elie Mamane)
* NEW TECHNOLOGY PREVIEW FEATURE: Firebird SQL connector for LibreOffice Base (Andrzej Hunt). When creating a new Database, select Firebird Embedded in the drop down menu (you have to first enable the Experimental features in {{bc|Tools|Options|LibreOffice|Advanced}}). This allows creation of databases that perform many times faster than the previous built-in HSQLDB 1.8, avoiding the C++-to-Java overhead inherent in using HSQLDB. We plan to phase HSQLDB out over the next few releases, and provide a smooth migration path to Firebird. Connecting to modern HSQLDB 2.x external databases remains available through HSQLDB's native interface, namely JDBC.
{{hilite|Start of a few words about Firebird. Please feel free to improve: "The integration of Firebird in LibreOffice Base is a big step forward. Firebird is a mature relational SQL database that is ACID-compliant and boasts cross-platform support, multi-generation architecture, referential integrity, logging and monitoring capabilities. It offers high performance, excellent concurrency and powerful language support for stored procedures and triggers, and more. It has been used in production systems, under a variety of names, since 1981."}}
<center>
{|
|-
| [[Image:FirebirdDB.png]]
|}
</center>
== Chart ==
* Import charts from xlsx which don't have proper references but have internal data (Muthu Subramanian)
* Toolbar buttons for vertical/horizontal grids change behavior to variate grid between major, major&minor and off. {{fdo|66422}} (Tomaž Vajngerl)
* Trend lines enhancements:
** Support more than one trend line per series (Tomaž Vajngerl)
** Force intercept for trend lines {{fdo|40314}} (Tomaž Vajngerl)
** Extrapolation of trend lines {{fdo|40316}} (Tomaž Vajngerl)
** Polynomial trend lines {{fdo|35712}} (Tomaž Vajngerl)
** Moving average trend lines {{fdo|40315}} (Tomaž Vajngerl)
<center>
{|
|-
| [[Image:TestCaseTrendLine.png|thumb|center|455px|Trend lines enhancements: multiple trend lines, force intercept (''top left''), extrapolate trend line (''top right''), polynomial trend lines (''bottom left''), moving average trend line (''bottom right'')]]
|}
</center>
== Core ==
* Upgrade internal XPDF to Poppler {{fdo|38878}} (Peter Foley, Tor Lillqvist, Fridrich Štrba)
* Support for undocumented <code>SOLAR_USER_RTL_TEXTENCODING</code> environment variable has been removed, {{commit|668c627eb4e66208738d5acdecbcad106efa8252}}
* Added support for BCP 47 language tags. {{fdo|37496}} (Eike Rathke)
** Including reading and writing ODF 1.2 fo:script and *:rfc-language-tag attributes.
** Including reading and writing tags from/to OOXML.
** See also http://erack.org/blog/archives/30-LibreOffice-goes-BCP-47.html
* A for-now rudimentary "stealth mode" to not automatically access a document's external references, {{rhbz|887420}} (Stephan Bergmann).
** See also [http://whatofhow.wordpress.com/2013/12/02/stealth-mode/ http://whatofhow.wordpress.com/2013/12/02/stealth-mode/].
== Options / General ==
=== Windows Registry changes ===
Windows Registry as a configuration backend. Under Windows, LibreOffice uses keys under HKLM/Policies/LibreOffice as a configuration layer on the top of program's layer and below user's layer.
The following structure is assumed:
Last element of Key becomes prop, first part is the path and optionally nodes, when the node has oor:op attribute. Values can be the following: Value (string) and Final (dword, optional)
For example the following registry setting:
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\LibreOffice\org.openoffice.UserProfile\Data\o]
"Value"="Example Corp."
"Final"=dword:00000001
becomes the following in configuration:
<!-- set the Company name -->
<item oor:path="/org.openoffice.UserProfile/Data">
<prop oor:name="o" oor:finalized="true">
<value>Example Corp.</value>
</prop>
</item>
Another example:
[HKEY_LOCAL_MACHINE\Policies\LibreOffice\org.openoffice.Office.OptionsDialog\OptionsDialogGroups\ProductName/#fuse\Pages\BasicIDEOptions/#fuse\Hide]
"Value"="true"
becomes the following in configuration:
<!-- Hide Tools - Options - LibreOffice - Basic IDE Options panel -->
<item oor:path="/org.openoffice.Office.OptionsDialog/OptionsDialogGroups">
<node oor:name="ProductName" oor:op="fuse">
<node oor:name="Pages">
<node oor:name="BasicIDEOptions" oor:op="fuse">
<prop oor:name="Hide">
<value>true</value>
</prop>
</node>
</node>
</node>
</item>
With this feature it becomes possible to centrally manage LibreOffice configuration with Group Policy Objects in a Windows domain. It is possible set and optionally lock many LibreOffice settings. The feature was developed by the order of Hungarian [http://szabadszoftver.kormany.hu/about-us/ E-Governmental Free Software Competence Centre].
=== Code quality ===
Improved code quality based on the Coverity scan analysis.
[[File:Coverity scan analysis results bar.png|thumb|center|800px|link=File:Coverity scan analysis results.ods|
Results based on the Coverity scan analysis results. ([http://www.coverity.com/company/press-releases/read/libreoffice-improves-software-quality-with-coverity-scan Data available after registration])]]
<!-- TODO:
add credits
**git log for: 'coverity'
**and 'CID#' -->
== Filters ==
* Support for the default Microsoft Office 2010 and 2013 {{fdo|35422|Agile decryption}} mechanism (Tomaž Vajngerl)
* Support for OOXML encryption {{fdo|59524}} (Tomaž Vajngerl)
* Improved MathML Export (Frédéric Wang)
* Always embed 14 standard Postscript fonts in PDF (Khaled Hosny)
* Apple Keynote import filter (David Tardon)
[[File:Apple Keynote import.png|thumb|center|444px|Apple Keynote import filter]]
* Enable libmwaw legacy filters (David Tardon + ?mwaw credit)
** Acta Mac Classic Document
** More Mac v2-3 Document
** WordPerfect Works Document
* Numerous improvements have been made to the Microsoft OOXML Import and Export filters as well as for the Microsoft Office binary file formats and the RTF format. Details:
** OOXML Filters→ [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=oox OOXML], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=docx DOCX], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=xlsx XLSX], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=pptx PPTX], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=vml VML]
** Microsoft Office binary file filters→ [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=doc+ DOC], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=xls+ XLS], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=ppt+ PPT], [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=ww8+ "ww8"]
** RTF Filters→ [http://cgit.freedesktop.org/libreoffice/core/log/?qt=grep&q=rtf RTF]
== GUI ==
* GNOME3 Application Menu integration {{fdo|48835}} (Caolán McNamara)
<center>
{|
|-
| [[Image:Libreoffice-appmenu.png]]
|}
</center>
* Multirow tab dialog tab balancing {{fdo|66435}} Now if tabs in a tab dialog need to wrap onto a second line to fit into the space available they will wrap in a more balanced fashion that avoids a single orphan tab. (Stefano Facchini and Caolán McNamara)
<center>
{|
|-
| Before: [[Image:Before-balancing.png]]
|}
</center>
<center>
{|
|-
| After: [[Image:After-balancing.png]]
|}
</center>
* Support MATE and XFCE Desktops (native Open/Save dialogs) {{fdo|46990}}(Pader Rezso)
* Add "Find All" to the Find bar {{fdo|64451}} (Andrzej J.R. Hunt)
* Windows are now grouped together by application in the taskbar on Windows 7 and higher (Jesús Corrius)
<center>
{|
|-
| [[Image:Windows-taskbar-group.png]]
|}
</center>
* Recent documents list support in the taskbar icon on Windows 7 and higher (Jesús Corrius and Fridrich Štrba)
<center>
{|
|-
| [[Image:Recent_documents_taskbar.png]]
|}
</center>
* More supported document types have been added to the "Open With" menu on Windows (Jesús Corrius)
* Ruler enhancements: snapping to ruler ticks, show ticks above numbers, tooltips (Tomaž Vajngerl)
<center>
{|
|-
| [[Image:RulerEnhancements.png]]
|}
</center>
* Implementing an about:config functionality in Options tab (Efe Gürkan YALAMAN)
<center>
{|
|-
| [[Image:Expert Config.png]]
|}
</center>
* Extend support for Document Management Systems: connection to GDrive is now possible, a CMIS Properties dialog allow to edit them (Cuong Cao Ngo)
=== Formula editor ===
* Make use of ZoomSlider in Math {{fdo|63351}} (Thomas Arnhold)
* Auto Closing of brackets {{fdo|43090}} (Marcos Paulo de Souza)
* Math: New feature to add colors directly from the Elements Dock by clicking their name (Marcos Paulo de Souza)
<center>
{|
|-
| [[Image:Mathcolor.png]]
|}
</center>
=== Flat icons (Sifr) ===
* A new set of icons have been included in LibreOffice 4.2, these icons named Sifr, where designed to reach the goal of having a beautiful non-distracting icons to help the user concentrate on the document. (Issa Alkurtas, Norah Abanumay, Mirek M., Pavel Haratický and Ahmad Harthi)
[[Image:Screenshot from 2013-11-19 15-33-23.png|thumb|1000px|center|Writer with Sifr icons]]
=== Smiley Face ===
* Smiley now smiles! (Ahmad Harthi)
[[Image:Smiling_smiley.png|thumb|600px|center|Smiley face before and after]]
== Localization ==
=== Language tag support ===
Changes as a result of supporting BCP 47 language tags (see also [[#Core]]).
* Catalan Valencian [ca-ES-valencia] is now supported as language for document content. {{fdo|68714}} (Eike Rathke)
* The legacy kludge for Catalan Valencian UI translation [ca-XV] is now the proper [ca-ES-valencia] tag. (Eike Rathke)
* All legacy kludge [sh-*] locales are now proper [sr-Latn-*] with support of [sh-*] for existing documents. (Eike Rathke)
* Added [en-GB-oed] grandfathered tag for "English, Oxford English Dictionary spelling" to language list. (Eike Rathke)
* Cleaned up the macrolanguage code kludge [ku-*] used for Kurdish written in Latin script and distinguishing scripts by differentiating by country. {{fdo|63460}} (Eike Rathke)
** ku → kmr-Latn (Northern Kurdish, Latin script)
** ku-TR → kmr-Latn-TR (Northern Kurdish in Turkey, Latin script)
** ku-SY → kmr-Latn-SY (Northern Kurdish in Syria, Latin script)
** ku-IQ → ckb-IQ (Central Kurdish in Iraq, Arabic script)
** ku-IR → ckb-IR (Central Kurdish in Iran, Arabic script)
** added sdh-IQ (Southern Kurdish in Iraq, Arabic script)
=== New languages/locales in language list ===
Available for character attribution and spell-checking.
* Added Ngäbere_Panama [gym-PA] to language list. {{fdo|66602}} (Eike Rathke)
* Added Kumyk [kum-RU] to language list. {{fdo|70089}} (Eike Rathke)
* Added Nogai [nog-RU] to language list. {{fdo|69987}} (Eike Rathke)
* Added Karakalpak Latin [kaa-Latn-UZ] to language list. {{fdo|70217}} (Eike Rathke)
* Added Ladin [lld-IT] to language list. {{fdo|70530}} (Eike Rathke)
* Added Puinave [pui-CO] to language list. {{fdo|71454}} (Eike Rathke)
=== New languages/locales with locale data ===
Available as default document language and for locale specific formatting.
* Added Ladin_Italy [lld-IT] locale data for full locale support. {{fdo|70530}} (Domingo Sacristan and Eike Rathke)
* Added French (Burkina Faso) [fr-BF] and locale data. {{fdo|71243}} (David Delma and Eike Rathke)
* Added Bamanankan/Bambara_Mali [bm-ML] locale data. {{fdo|71361}} (JJ Méric and Eike Rathke)
* Added Puinave_Colombia [pui-CO] locale data. {{fdo|71836}} (Michael Bauer and Eike Rathke)
* Added Arabic_UAE [ar-AE] and Arabic_Kuwait [ar-KW] locale data referrers for AED and KWD currencies. {{fdo|71140}} (Eike Rathke)
== Performance ==
== Infrastructure ==
== Scripting ==
* LibreOffice now bundles [http://www.access2base.com/ Access2Base], a simplified API for scripting of Base (and Writer database forms) in the Basic programming language. It is more concise and easier to learn than the cross-language standard UNO API.
== Extensions ==
== Feature removal / deprecation ==
== API Changes ==
=== UNO API changes ===
The following UNO interfaces and services were changed:
* com.sun.star.awt.XMessageBox {{commit|805c6101b3427cc98b53f1c48f22f705206c384d}}
* com.sun.star.awt.XMessageBoxFactory {{commit|805c6101b3427cc98b53f1c48f22f705206c384d}} createMessageBox no longer takes a position and type as a s string, now position is dropped and type replaced by an enum
=== UNO API removals ===
The following UNO interfaces and services were removed from the API:
* com.sun.star.awt.MessageBoxCommand {{commit|805c6101b3427cc98b53f1c48f22f705206c384d}}
* com.sun.star.awt.UnoControlSimpleAnimation {{commit|303096c50c850b05a158a1a429c9fd5d0251a892}}
* com.sun.star.awt.UnoControlSimpleAnimationModel {{commit|303096c50c850b05a158a1a429c9fd5d0251a892}}
* com.sun.star.awt.XSimpleAnimation {{commit|303096c50c850b05a158a1a429c9fd5d0251a892}}
* com.sun.star.awt.UnoControlThrobber {{commit|680608b15dd158f9ad4ceae328abb10b5185a27b}}
* com.sun.star.awt.UnoControlThrobberModel {{commit|680608b15dd158f9ad4ceae328abb10b5185a27b}}
* com.sun.star.awt.XThrobber {{commit|680608b15dd158f9ad4ceae328abb10b5185a27b}}
=== Autodoc replaced by doxygen ===
The SDK no longer contains the autodoc documentation tool {{commit|9d93ed7cd1b36830f6d7aedd4e6f15667774de1d}}.
IDL API documentation can be extracted by doxygen version 1.8.4 or later instead.
Download it from http://www.stack.nl/~dimitri/doxygen/download.html
There are some differences in the documentation markup between autodoc and doxygen; the warnings printed by doxygen are helpful in finding comments that need tweaking.
=== uno-skeletonmaker ===
The obsolete <code>--java4</code> command line parameter was removed from the <code>uno-skeletonmaker</code> tool {{commit|3cb10e9220da27ca7db2f68007be9e310bdefc4d}}
== Most Annoying Bugs ==
The following annoying bugs were not fixed [[ReleasePlan#Summary | in time]] and will be addressed in the regular [[ReleasePlan#4.2_release | bug fix releases]]:
== ODF changes ==
* This version corrects the mispelling « turquise » for Table Style in Impress. The files which use this style should be fixed by following the following howto: [[Documentation/HowTo/fix odp fdo71428]]