NeoOffice 3.0.1 Upgrade Issues

From NeoWiki

Revision as of 02:59, 3 April 2009 (edit) ( | contribs) (→Calc issues - added info on INDIRECT_XL and ADDRESS_XL no longer being available) ← Previous diff		Revision as of 03:03, 3 April 2009 (edit) (undo) ( | contribs) (→Writer issues - changed text regarding dictionary/thesaurus) Next diff →
Line 4:		Line 4:
	== Writer issues ==		== Writer issues ==
-	* Dictionaries and thesauri are handled differently in NeoOffice 3.0 compared to earlier versions of NeoOffice. To install a dictionary or thesaurus other than those bundled with the application, the Extension Manager must be used. To install a thesaurus, launch NeoOffice and select the Tools :: Language :: More Dictionaries Online... menu.	+	* Not all dictionaries and thesauri that were available in NeoOffice 2.2.5 are available in NeoOffice 3.0. [http://extensions.services.openoffice.org/dictionary?cid=926385 List of currently available dictionaries and thesauri].
	== Calc issues ==		== Calc issues ==

---

Revision as of 03:03, 3 April 2009

NeoOffice 3.0 is based on the OpenOffice.org 3.0.1 code. In constrast, all of the NeoOffice 2.2.x releases were based on the older OpenOffice 2.2.1 code. While Sun Microsystems' OpenOffice.org engineers added many enhancements and new features in OpenOffice.org 3.0.1, they also implemented many small feature changes that were requested by OpenOffice.org users.

Since we released NeoOffice 3.0 Early Access back in January 2009, we have found several OpenOffice.org feature changes that NeoOffice 2.2.5 users did not expect when upgrading to NeoOffice 3.0. This article contains a list of the issues that NeoOffice 2.2.5 users are likely to encounter from the unexpected changes that we have found as well as suggested workarounds for those issues.

Writer issues

• Not all dictionaries and thesauri that were available in NeoOffice 2.2.5 are available in NeoOffice 3.0. List of currently available dictionaries and thesauri.

Calc issues

• NeoOffice defines empty cells differently in formulas from OpenOffice.org. This is seen in the following functions SUMIF(), COUNTIF(), COUNTBLANK(), DCOUNT(), DSUM() when the "<>" condition is used. See this trinity forum post for more information.

• INDIRECT_XL() and ADDRESS_XL() functions are no longer recognized. #NAME? will appear in a cell containing one of those functions. Workaround: change to INDIRECT() and ADDRESS() respectively.