OpenOffice.org/LibreOffice

[Jelc]

General Improvements
Faster start up times

OpenOffice.org 3.2 Calc and Writer have both reduced 'cold start' time by 46% since version 3.0 was released just over a year ago, according to tests by our developers (results will vary on different operating systems and hardware).
ODF Support

Open Document Format (ODF) standards, as promulgated by the Organization for the Advancement of Structured Information Standards (OASIS), set international compatibility criteria for the electronic/digital storage of documents.

These standards recognize the importance of interoperability and intelligent information exchange and seek, for example, to ensure that office documents created today on any given computer system will be readable by other computer systems everywhere, including the technology of tomorrow.

OpenOffice.org 3.2 has made further strides in compliance with ODF 1.2, including closer conformance to OASIS ODFF/OpenFormula specifications.
As OpenOffice.org 3.2 currently requires a superset of the ODF 1.2 specification, the software now warns users when ODF 1.2 Extended features have been used.
The document integrity check now proves whether an ODF document conforms to the ODF specification (this mainly affects ODF 1.2 documents). If an inconsistency is found, the document is treated as a broken one, and OpenOffice.org offers to repair the document.
Proprietary File Support

OpenOffice.org 3.2 provides improved support for other common office document types.
Password protected Microsoft Office XML files (supported document types: MS Word 2007 documents (*.docx, *.docm); MS Word 2007 templates (*.dotx, *.dotm); MS Excel 2007 documents (*.xlsx, *.xlsm); MS Excel 2007 binary documents (*.xlsb); MS Excel 2007 templates (*.xltx, *.xltm); MS Powerpoint 2007 documents (*.pptx, *.pptm); MS Powerpoint 2007 templates (*.potx, *.potm)).
OLE objects, form controls and pivot tables can now be read from MS Excel 2007 documents (*.xlsx, *.xlsb).
Encryption support within the Microsoft Word 97/2000/XP filter allows password protected Microsoft Word documents to be saved (using the Microsoft Office standard RC4 algorithm).
Filters for AportisDoc and PocketWord now support type detection based on DocType. As a result, files in these formats can be loaded without explicitly selecting the document type in the file picker.
When writing string data to SYLK files, embedded double quotes are no longer escaped by doubling; semicolons are now escaped by doubling. This improves compatibility with files created by other applications.
Support for Postscript based OpenType fonts

There are many high quality commercial and free OpenType fonts that are based on Postscript outlines. They are now supported for formatting, printing, PDF-export and display.
Writer
Mediawiki support moved to an Extension

To avoid conflicts, the MediaWiki filter is no longer part of the OpenOffice.org installation. Instead it will be supplied as a part of Wiki Publisher extension, which will permit updates for the filter without having to wait for the next OpenOffice.org release.
Calc
Cell borders now support multiple selection

Previously it was only possible to apply cell borders to a single rectangular cell range. Now borders can be applied to any selection of cells. A list of rectangular ranges is determined from the selection, and inner/outer borders are applied to each of the ranges.
Autofill now handles additional cases

If the starting cell for AutoFill contains a number at the start and the end, and there's no space after the first number, the number at the end is now incremented. This allows easier creation of things like lists of IP addresses (10.0.0.1 is followed by 10.0.0.2).
Improvements to sort

If "Sort" is invoked with a selection that is likely not to be the range the user wants to address, a new dialog will ask if the selection should be extended to contain the additional cells.

When a cell range is sorted using the "Sort Ascending" or "Sort Descending" toolbar button, cell formats are now sorted with the cells.
Better handling of merged cells

Merged cells can now be pasted from the clipboard onto other merged cells. Instead of an error message, the old cells are unmerged.

Inserting or deleting cells, columns or rows into/from the middle of merged cells, which previously caused an error message, is now possible. The merged cell range is enlarged/reduced.
Complex copy and paste

This feature extends Calc's current copy and paste functionality, to allow copying of a set of multiple non-contiguous ranges. When pasted, all copied data get consolidated into a single range either horizontally or vertically. There are some restrictions when ranges are being copied, in order to ensure that the pasted range become a rectangular range.
Enhancements to statistical functions
NORMDIST's 4th parameter is now optional.
0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.
If omitted, 1 is written to files for backwards compatibility.
LOGNORMDIST's 2nd and 3rd parameters are now optional, an optional 4th parameter has been added.
The 2nd, mean, parameter has the default value 0 if omitted.
If omitted, 0 is written to files for backwards compatibility.
The 3rd, standard deviation, parameter has the default value 1 if omitted. If omitted, 1 is written to files for backwards compatibility.
The 4th, cumulative, parameter is defined as - 0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. - If a value was given, earlier releases reading the file cannot interpret the function and return an error.
These changes align with the definitions given in the OASIS ODFF/OpenFormula specification
Preservation of newline characters in formulae

Newline characters created with Control+Enter in multiline text cells are now preserved in spreadsheet formulas. Previously the newline character was replaced by a space character. The newline character can be searched for using the SEARCH or [HV]LOOKUP or MATCH functions with the \n regular expression.
Numeric conversion in strings

While interpreting a formula expression, string content is now converted to numeric values if conversion is unambiguous, or a #VALUE! error is set if no unambiguous conversion is possible. Leading and trailing blanks are ignored.

Note: conversion on the fly naturally is significantly slower than calculating with numeric values. Users may be prefer the Convert Text to Number (CTN) extension to interactively convert textual numbers to permanent numeric values.
Additional functionality in filters

The "Standard Filter" dialog now shows 4 instead of 3 conditions, and has a scroll bar which allows to access up to 8 conditions in total. It now supports the filter conditions 'Contains', 'Does not contain', 'Begins with', 'Does not begin with', 'Ends with' and 'Does not end with'.
Improved reference toggling

The Shift-F4 shortcut to toggle between relative and absolute references in formulas can now be used for a selection of cells, and handles all the formula cells in the selection.
Many new factors in CONVERT_ADD

The CONVERT_ADD spreadsheet function (known as CONVERT in other applications) has many more conversion factors implemented, as defined in OASIS ODFF/OpenFormula.
New UNICODE and UNICHAR functions

The new UNICODE and UNICHAR spreadsheet functions are implemented as defined in the OASIS ODFF/OpenFormula specification.
UNICODE returns the Unicode Standard / ISO 10646 code point corresponding to the first character of the text value;
UNICHAR (UNICODE CHARacter) returns Character for any valid Unicode code point.
Draw
New style comments

Draw now supports comments to support collaboration.
Page Count added to Draw

Draw now supports the text field "Page Count".
Impress
New style comments

Impress now support comments to support collaboration.
Page Count added to Impress

Impress now supports the text field "Page Count".
Math
Change to Math menus

The menu entry "View / Selection" in Math is now labeled "View / Formula Elements".
Base
Customising the Create Database Wizard

OpenOffice.org 3.2 introduces a configuration option to control the availability of the "Create new database" option in the "Create Database" wizard.

A new configuration option controls whether the "Create Database" wizard (started via File/New/Database) exposes the "Create a new database" option.
Simpler copying of queries between database documents

When copying queries between database documents, Base will no longer prompt for a target name, unless the copy operation would overwrite an existing table name.
Database forms can be zoomed

Database forms can now be zoomed just like other documents. The current <Ctrl+Scroll Wheel> functionality is supplemented by a View/Zoom menu item, and the zoom slider in the status bar.
More intelligent import into Base

The Copy Table Wizard now contains an additional check box which is enabled when RTF or HTML format data is to be copied into a database. The check box is labelled: Use first line as column names: when checked the first row is used to identify column names, when not checked the first row is treated as a normal data row.

For further details of Base new features, please see the wiki.
Chart
New Chart types

The Chart Wizard - used to create charts - now also includes Bubble and a new variant of Net - Filled Net (Radar) charts.
Usability improvements in Chart

The Chart user interface has been given a makeover to improve aspects of usability. Users will note the generic Object Properties tag has been replaced by more specific terms such as Format Legend.... Menus are more context aware, ensuring the tools they need are only a mouse click away. For full details, please see the GullFOSS blog posting.
Enhancements to data labels

The options for data labels have been extended. It is possible now to rotate data labels. This is useful especially for column charts to avoid overlap between the different labels.
Asian typography page for chart elements

A new tab page Asian Typography is now available for Title, Legend, Axes and Data Series. It contains an option to enable or disable the spacing between the different types of text.
Internationalization and Localizations
New Locale support

OpenOffice.org 3.2 adds locale data for Oromo_Ethiopia [om-ET], Uyghur_China [ug-CN], Ancient Greek [grc-GR], Somali_Somalia [so-SO], Sorbian, Lower [dsb-DE] and Upper [hsb-DE, Asturian_Spain [ast-ES], Yiddish_Israel [yi-IL], Arabic (Oman) [ar-OM], Sardinian_Italy [sc-IT, and Quechua (Ecuador) [qu-EC].

Typically, the locale is selectable for character attribution and spell-checking, as default locale and default document language, and is available for number formats and outline numbering - see the Release Notes for details.
Japanese Name Order

In a Japanese Locale the order of the FirstName / LastName fields in the user data tabpage is reversed. This feature is not bound to the UI language, but to the selected Locale.
Support for Graphite font technology

OpenOffice.org now supports Graphite font technology for better support of scripts and variants used by minorities. Using htis technology, the support for new minority scripts becomes manageable. Just one font needs to developed for the specific needs of that minority.

Više:
3.2.0 (build OOO320_m12) - Release Notes
http://development.openoffice.org/releases/3.2.0.html

http://download.openoffice.org/index.html

[Codiac]

moram priznati da na fedori jako dobro radi open office.

[Jelc]

Ja ga već dosta dugo koristim i za moje potrebe je čist ok.
A ide i na svaki komp na kojem radim reinstal windoza

[Codiac]

pa iskreno imao sam vise problema sa original 2007 officeom nego sa open ofisom...

moja preporuka svima.

Autor Codiac

pa iskreno imao sam vise problema sa original 2007 officeom nego sa open ofisom...

moja preporuka svima.

Ako su u pitanju unexpected random stvari onda se slažem. Od OO-a sam skoro uvijek dobio ono kaj sam oćekivao!

Živio ODF!

[-ELF]

preporuka...
btw, na net.hr sam citao da jedna od skandinavskih zemalja izbacuje microsoft office i stavlja open office...

[Codiac]

pa kad je freeware

Mislim. Za državnu administraciju (skupa sa gradskom...), sustav obrazovanja... korištenje bilo čega drugog je jednako krađi.

Toplo me zanima brojka u miljunima koliko je bačeno zadnjih 10 godina na Microsoft u HR.

[Codiac]

A cuj svatko ima svoj interes u necem.

Evo recimo ja usko suradjujem sa jednom drzavnom upravom i sad prelaze na windows 7 na to sam ih ja pitao zasto nebi presli na fedoru i open office (radi se o nekoliko tisuca racunala) dobio sam odgovor zasto kad windowsi 7 dobro rade

Autor Codiac

A cuj svatko ima svoj interes u necem.

Evo recimo ja usko suradjujem sa jednom drzavnom upravom i sad prelaze na windows 7 na to sam ih ja pitao zasto nebi presli na fedoru i open office (radi se o nekoliko tisuca racunala) dobio sam odgovor zasto kad windowsi 7 dobro rade

A moj je odgovor. Zato što ne trošite svoj novac. Ali, nebum više u OT!

[Hamm]

Ak vam se da raspravljati samo dajte ovdje:

http://forum.pcekspert.com/showthread.php?t=175339

[Jelc]

http://www.libreoffice.org/

On September 28, 2010, some members of the OpenOffice.org Project formed a new group called The Document Foundation, and made available a rebranded fork of OpenOffice.org which was based on OpenOffice.org 3.3 beta version. The fork was created over fears that Oracle Corporation, after buying out the project's former sponsor, Sun Microsystems, would discontinue OpenOffice.org as they had done with OpenSolaris. It was hoped that the LibreOffice name would be provisional, as Oracle was invited to become a member of the Document Foundation, and was asked to donate the OpenOffice.org brand to the project; therefore, LibreOffice uses the same version number as OpenOffice.org.[2] Oracle rejected the project and demanded that all members of the OpenOffice.org board involved with it step down. At the end of October 2010, 33 German volunteers, not involved with development, left OpenOffice.org and moved to The Document Foundation to support LibreOffice.[3][4][5]

The Go-oo project was discontinued in favour of LibreOffice.[6] Improvements made by the project are being merged into LibreOffice. Improvements made in other forks are expected to be incorporated into LibreOffice as well.[7][8]

Canonical, Novell and Red Hat plan to include LibreOffice in upcoming versions of their operating systems.[4] On 20 January 2011, the Ubuntu 11.04 daily builds changed the office suite to LibreOffice for alpha testing purposes.[9][10]

In developing their first release The Document Foundation developers made LibreOffice 3.3.0 beta 1 available on September 28, 2010 with beta 2 following on October 14. Beta 3 was released on November 17, 2010, with the first release candidate on December 5, the second just before Christmas, on December 23, 2010[11], third release candidate on January 13, 2011[12] and the fourth on January 20, 2011.[13] The first stable version was released on January 25, 2011.[14]

Pardus became the first Linux distribution to include LibreOffice as the default office suite with its January 20, 2011 major release.[15]

In reviewing LibreOffice 3.3.0 stable on the day of its release Ryan Paul of Ars Technica said, "It introduces a number of noteworthy new features and there are improvements throughout the included applications. More significantly, the release reflects the growing strength of the nascent LibreOffice project...The new features included in LibreOffice 3.3 improve the office suite's feature set, usability, and interoperability with other formats. For example, it has improved support for importing documents from Lotus Word Pro and Microsoft Works. Another key new feature is the ability to import SVG content and edit SVG images in LibreOffice Draw."[16]

Sve isto kao OpenOffice samo sa par poboljšanja i nadogradnji.
Sinoć sam skinuo i malo radio, zgleda čist ok

[Codiac]