• Format paintbrush can now differentiate character automatic formating applied to paragraphs from those applied to text portion inside the paragraph.
  (Thanks to Maxime De Roucy)
  
  
  

• Support for contextual spacing.
  (Thanks to Miklos Vajna)
  
  

• VML import now handles lines, rotations and flips.
  (Thanks to Miklos Vajna)
  
  

• DOCX import now handles GetExpression and SetExpression fields.
  (Thanks to Miklos Vajna)

• RTF/DOCX import/export handles document zoom settings.
  (Thanks to Miklos Vajna)
  
  
  
  
  
  

• Pressing "Ctrl+[" will decrease or "Ctrl+]" will increase the font size of the selected text, respectively. (Note that this function is not available for all localizations but will soon be updated to offer full support to all.)
  (Thanks to Paul Cameron)
  
  • More info at bug Report: fdo#36187
    

• Updates to Word Count.
  (Thanks to Muhammad Haggag)
  • Added Word Count to status bar. Bug report: fdo#34772
  • Fixed two miscounting bugs. Bug reports: fdo#46757 and fdo#50141

  
  
  
  
  
  
  
  

• Table AutoFormats now record the following table-level properties.
  (Thanks to Muhammad Hammag, bug report: fdo#31005)
  • 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 to display unprintable characters.
  (Thanks to Cédric Bosdonnat)
  • More info on bug report: fdo#46073
    
    
    
    

• Support for importing Office SmartArt.
  (Thanks to Miklos Vajna)
  
  
  

• Extension of label definitions with form (paper, page) size. Labels which are not centred on the form are created correctly.
  (Thanks to Winfried Donkers)
  

• All 1700+ predefined label definitions have been modified to include the form size and obsolete definitions have been removed.
  (Thanks to Winfried Donkers)
  

• Recalculation of label positions on the form. Label definitions with gaps between labels that are wider than the right margin now produce correct documents.
  (Thanks to Winfried Donkers)
  • Existing user defined labels are automatically extended with form size.
    
    

• The form size can be entered/modified in the wizard dialog.
  (Thanks to Winfried Donkers)
  
  
  
  
  
  

• "Ctrl+D" fills down in more familiar ways, filling with contents of the cell above if no cell is selected, and, filling down multiple cells with larger selections.
  (Thanks to Kohei Yoshida)
  
  
  
  
  

• New option to specify a custom sheet name prefix in new documents.
  (Thanks to Albert Thuswaldner)
  
  
  
  
  
  

• Merge cells option added to right-click menu.
  (Thanks to Greggory Hernandez)
  
  • More info at bug report: fdo#37210 
    
    
    

• Sheets can now be hidden and/or shown by using the sheets tab context menu.
  (Thanks to Noel Power)
  
  
  
  

• Improved error message for invalid sheet name.
  (Thanks to Albert Thuswaldner)
  • More info at bug report: fdo#45285

• Export conditional formatting to .xlsx
  (Thanks to Markus Mohrhard)
  
  
  

• Improved CSV file import.
  (Thanks to Eike Rathke)
  • Handle lines with more than 64k characters (bug report: fdo#48501)
  • Differentiated different error messages (bug report: fdo#48516)
  • Better handling of broken CSV files where generator didn't follow RFC 4180 quote rules (bug report: fdo#48621)
  • Import numbers in scientific notation without having to check "import special numbers" (bug report: fdo#39716)
  • Better initial default separators, comma, semicolon and tab (bug report: fdo#38088)
    

• Added a "Save cell formulas instead of calculated values" option to CSV export.
  (Thanks to Florent Gallaire)
  • More info at bug report: fdo#45664

  
  
  
  
  
  
  
  
  
  
  

• New spreadsheet functions as defined in ODF OpenFormula:
  (Thanks to Winfried Donkers, Eike Rathke and Regina Henschel)
  
  • DATEDIF (bug report: fdo#44456)
  • IMTAN, IMSEC, IMCSC, IMCOT, IMSINH, IMCOSH, IMSECH and IMCSCH (bug report: fdo#51017)
    
    

• Added support for field items in cells.
  (Thanks to Kohei Yoshida)
  
  
  
  
  
  
  
  

• Calc now allows sorting of data from the autofilter menu.
  (Thanks to Kohei Yoshida)
  
  
  
  
  
  
  

• Calc now supports allowing pasting only text, value, or formula from the context menu.
  (Thanks to Noel Power)
  
  
  
  
  
  
  

• Detailed configuration options for formula calculation. You can now configure the reference syntax for built-in function: INDIRECT.
  (Thanks to Kohei Yoshida)
  
  
  
  
  
  
  
  
  
  
  
  
  

• The limitation of 3 sort entries has been removed.
  (Thanks to Albert Thuswaldner)
  • More info at bug report: fdo#45747

  
  
  
  
  
  
  
  
  
  
  
  

• Default number of sheets for new spreadsheets has been changed to 1.
  (Thanks to Stefan Knorr)
  • More info at bug report: fdo#50183 
    
    

• Support for X errorbars  in scatter and bar charts, importing and exporting to .xls and .ods when using ODF 1.2 (extended).
  (Thanks to Rafael Dominguez)
  
  • More info at bug report: fdo#33773    
    

• Support for color scales and data bars. Import from .xlsx and import/export from/to .ods in ODF 1.2 (extended). Warning: Some limitations still apply which will be fixed in 4.0.0
  (Thanks to Markus Mohrhard)
  

• New dialogs for conditional formats to support color scales and data bars.
  (Thanks to Stefan Knorr and Markus Mohrhard)
  
  
  
  
  
  

• Added widescreen format for Impress slideshows.
  (Thanks to Rob Snelders)
  
  • More info on bug report: fdo#42986
    
    

• Impress now correctly detects the external display and puts the presenter console on the local display.
  (Thanks to Michael Meeks)
  
  
  

• 10 new Impress master pages.
  (Thanks to Alexander Wilms, Mateus Machado Luna, Björn Michaelsen)
  
  
  
  
  
  

• Format dialogues (Font, Font Size and Spacing) and the Symbols dialogue (Tools -> Catalog) now have a button linking to Help.
  (Thanks to Karan Desai)
  • More info on bug reports: fdo#47860, fdo#47862, fdo#47863, fdo#47864.

  
  
  
  

• Docked Object Catalog pane.
  (Thanks to Bence Tomcsik)
  

•  ODF Export now comes with a "ODF 1.2 Extended (compact mode)" that gives better interoperability with older consumers of the Open Document Format.
  (Thanks to Thorsten Behrens)
  
  
  

• PDF Export with Watermark option.
  (Thanks to Andreas Mantke)
  
  

•  Implementation of import filter for Corel Draw documents. More info here and here.
  (Thanks to Fridrich Strba)
  

  Corel Draw Import

  Corel Draw Import

  LibreOffice Draw

• 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 (Win Vista/7).
  (Thanks to Mirek Mazel, Stefan Knorr, Jan Holesovsky and Michael Meeks)
  

  LibreOffice 3.5	LibreOffice 3.6

•  Rulers are now much cleaner and more light-weight.
  (Thanks to Mirek Mazel and Jan Holesovsky)
  
  
  
  
  
  
  
  
  
  

• New Splash Screen.
  (Thanks to Andrea Soragna and Stefan Knorr)
  
  

• A redesigned "About" dialog for a cleaner look.
  (Thanks to Andrew Higginson, and Stefan Knorr)
  
  
  

• New artwork for the Start Office.
  (Thanks to Stefan Knorr)
  
  
  
  

• Clicking the ">>" overflow button will not show toolbar options anymore. The full options can be shown by right-clicking the toolbar. Bug report: fdo#38276.
  (Thanks to Iain Billett)
  

• GTK themes are now able to render background gradient.
  (Thanks to Ruslan Kabatsayev)
  
  
  
  

• GTK themes now have a way for tab prelight rendering.
  (Thanks to Ruslan Kabatsayev)
  
  
  

• Writer and Calc now use split colour buttons making it possible to apply the last used colour with one mouse click for font, background, border and highlight colours.
  (Thanks to Winfried Donkers)
  
  

• GTK theming is implemented for fixed lines and frames.
  (Thanks to Ruslan Kabatsayev)
  
  
  
  

•   Default to Tango icon set in Mac OSX.
  (Thanks to Michael Meeks and the UI team)
  
  

• Support for Trinity Desktop Environment integration.
  (Thanks to Timothy Pearson and original KDE3 authors)

•   Dictionary choice removed in spellchecker when there is only one dictionary active. Bug report: fdo#40778.
  (Thanks to Caolán McNamara & Rob Snelders)

• Zooming now is based on a geometric progression. Bug report: fdo#44173.
  (Thanks to Tim Hardeck)

• Added Lanczos algorithm for resizing of images. Bug report: fdo#46378.
  (Thanks to Tomaž Vajngerl)
  
  
  
  
  
  
  

• Macro recording can be activated with a seperate option: Tools -> Options -> General -> Enable macro recording. Bug report: fdo#41865.
  (Thanks to Cor Nouws)
  
  
  
  
  
  

• Support for Japanese postcard paper size in all applications.
  (Thanks to Takeshi Abe)

• Recent Documents list is updated on Save, Save As and Close. Bug report: fdo#37775.
  (Thanks to Muhammad Haggag)

• Allow for editing of read-only documents.
  (Thanks to Stephan Bergmann)

• Added "Support for assistive technology tools" to installation process. Bug report: fdo#39833.
  (Thanks to Andras Timar)

• Implemented locale dependent date acceptance patterns for input of incomplete dates. This prevents erroneous detection of dates in Calc and Writer cell inputand CSV file import.
  (Thanks to Eike Rathke)
  • Read the blog post here. 
    

• Added en-MW locale data.
  (Thanks to Eike Rathke)
  
  
  
  
  
  

• Added myv-RU locale data.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

• Improved language tools (spellchecker, thesaurus and hyphenation patterns).
  • Updated pt-BR spellchecker.
    (Thanks to Raimundo Moura)
  • Updated Swedish spell-check dictionary. 
  • Updated French spell-check dictionary and thesaurus.
  • Updated Czech thesaurus.
  • Greatly improved German language tools with over 30,000 new words added to the German spell-check dictionary and over 7000 new symbols added to the German thesaurus. Hyphenation patterns are also improved.
    
  • Substantial improvements to the Danish spellchecker and thesaurus.
    

• The default locale is now the default locale of the operating system. Bug report: fdo#45830.
  (Thanks to Rob Snelders)

• Substantially improved OLE2 document import: .doc, .xls and .ppt.
  (Thanks to Caolan McNamara and Michael Meeks)

• Substantially improved simple .doc/.docx import.
  (Thanks to Michael Meeks and Caolan McNamara)
  
  

• Large document scrolling/re-layout/interactive editing improvements.
  (Thanks to Caolan McNamara)
  

• Large autocorrect lists handled around twice as fast.
  (Thanks to Michael Meeks)
  
  

• Improved performance for pivot tables in Calc. Refreshing of pivot table should be 35-50% faster than 3.5. In addition, the memory footprint of the pivot table is greatly reduced.
  (Thanks to Kohei Yoshida)
  

• Improved performance of raw cell value import from .xlsx spreadsheets.
  (Thanks to Daniel Bankston)
  
  
  

• Improved performance of merged cell and matrix range import from .ods files.
  (Thanks to Daniel Bankston)
  
  
  

• Embedded HSQLDB databases are now size-minimized before being saved because Base uses "CHECKPOINT DEFRAG" instead of "CHECKPOINT". This means that the space occupied by deleted rows is reall freed up.
  (Thanks to Lionel Mamane)

• (Windows version only) Java Accessibility Bridge based Accessibility does not work on Windows for ALL LibreOffice 3.6.x releases thusfar.  Bug 53474 This bug has been resolved in the upcoming release of LibreOffice 3.6.4.
  

See the complete list of open most annoying bugs here.