|
|
NeoOffice 3.0.1 Upgrade Issues
From NeoWiki
(Difference between revisions)
| Revision as of 18:27, 6 April 2009 (edit) ( | contribs) (→Calc issues - added how to select R1C1 formula syntax) ← Previous diff |
Revision as of 14:37, 29 April 2009 (edit) (undo) ( | contribs) (→Base issues -added Base issue odb files saved in 3.0 will not open in 2.2.5) Next diff → |
||
| Line 24: | Line 24: | ||
| == Base issues == | == Base issues == | ||
| * Some users have reported crashes when creating or saving Reports in Base in NeoOffice 3.0 | * Some users have reported crashes when creating or saving Reports in Base in NeoOffice 3.0 | ||
| + | * .odb files saved in NeoOffice 3.0 cannot be opened in NeoOffice 2.2.5, even if they were created in NeoOffice 2.2.5. | ||
| [[Category:NeoOffice]][[Category:Tips and Hints]] | [[Category:NeoOffice]][[Category:Tips and Hints]] | ||
Revision as of 14:37, 29 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.
Contents |
General issues
- Some users have reported that NeoOffice 3.0 runs considerably slower than NeoOffice 2.2.5 on PowerPC Macs.
- Not all preferences are copied from NeoOffice 2.2.5 to NeoOffice 3.0. Follow the steps in the Recovering Settings from Old or Corrupt Preferences page to copy NeoOffice 2.2.5 preferences to NeoOffice 3.0.
- NeoOffice 3.0's underlying OpenOffice.org 3.0.1 code has a new "non-exclusive document file locking" feature. OpenOffice.org 3.0.1 and NeoOffice 3.0 create a file lock that is only recognized by OpenOffice.org and NeoOffice and do not use Mac OS X's native file locking. This allows other users and other applications, such as Microsoft Office, to write to a file that NeoOffice 3.0 has a file lock without warning.
Writer issues
- Some dictionaries and thesauri that were available in NeoOffice 2.2.5 are no available in NeoOffice 3.0 or OpenOffice.org 3.0.1. List of currently available dictionaries and thesauri.
- Zotero must be upgraded. A new plugin is needed for Zotero. Even with the 1.0b4 plugin the toolbar does not install. Select the Tools :: Macros :: Run Macro menu and navigation down to the relevant macro must be used instead.
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.
- R1C1 is no longer set for individual sheets using in the Sheet menu, under Format, and checking Use R1C1. Beginning with NeoOffice 3.0 R1C1 is set globally using the following steps: go to the NeoOffice menu and choose Preferences. Click on the disclosure triangle next to NeoOffice Calc to expand it and then click on Calculate. Set the Formula syntax drop-down menu to Excel R1C1. Click OK.
Base issues
- Some users have reported crashes when creating or saving Reports in Base in NeoOffice 3.0
- .odb files saved in NeoOffice 3.0 cannot be opened in NeoOffice 2.2.5, even if they were created in NeoOffice 2.2.5.
