NeoOffice 3.0.1 Upgrade Issues

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 17:37, 26 May 2009 (edit)
Sardisson (Talk | contribs)
(Writer issues - add hyphenation in here)
← Previous diff
Revision as of 16:15, 5 June 2009 (edit) (undo)
James3359 (Talk | contribs)
(Writer issues - Change to default setting for Number recognition in tables)
Next diff →
Line 16: Line 16:
* Zotero must be upgraded. A new plugin is needed for [http://www.zotero.org 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. * Zotero must be upgraded. A new plugin is needed for [http://www.zotero.org 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.
 +
 +* Number recognition in Tables is turned '''on''' by default in NeoOffice 3.0 where it was '''off''' by default in NeoOffice 2.2.5 To reverse this behaviour pull down the {{menu|NeoOffice}} menu and choose {{menu|Preferences}} (or pull down the {{menu|Tools}} menu and choose {{menu|Options…}}). Then in the {{Window|Options}} window, click the disclosure triangle next to "NeoOffice Writer" in the left hand panel of the window, then select "Tables" and at the top right of the window, in the {{section| Input in Tables}} section, deselect the {{prefName | Number recognition}} checkbox. This will not alter any cells retrospectively - it only applies as you type.
== Calc issues == == Calc issues ==

Revision as of 16:15, 5 June 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.
  • 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.
  • Clicking on a hyperlink will no longer activate it and, by default, only Command-clicking will activate a hyperlink. To make clicking activate a hyperlink, select the Tools :: Options menu and in the dialog that appears, select the NeoOffice :: Security item and press the Options button. In the dialog that appears, uncheck the "Ctrl+click required to follow hyperlinks" checkbox and press the OK button in both dialogs.

Writer issues

  • 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.
  • Number recognition in Tables is turned on by default in NeoOffice 3.0 where it was off by default in NeoOffice 2.2.5 To reverse this behaviour pull down the NeoOffice menu and choose Preferences (or pull down the Tools menu and choose Options…). Then in the Options window, click the disclosure triangle next to "NeoOffice Writer" in the left hand panel of the window, then select "Tables" and at the top right of the window, in the Input in Tables section, deselect the Number recognition checkbox. This will not alter any cells retrospectively - it only applies as you type.

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.
Personal tools