|
|
NeoOffice 2017 Upgrade Issues
From NeoWiki
| Revision as of 23:19, 28 September 2017 (edit) ( | contribs) (→Macro issues - Add steps to enable recording macros) ← Previous diff |
Revision as of 23:20, 28 September 2017 (edit) (undo) ( | contribs) (→The Tools > Macros > Record Macro menu item is disabled= - Remove extraneous character) Next diff → |
||
| Line 63: | Line 63: | ||
| ==Macro issues== | ==Macro issues== | ||
| - | ====The Tools > Macros > Record Macro menu item is disabled | + | ====The Tools > Macros > Record Macro menu item is disabled==== |
| In the LibreOffice 4.4 code used by NeoOffice 2017, recording macros is disabled by default. | In the LibreOffice 4.4 code used by NeoOffice 2017, recording macros is disabled by default. | ||
Revision as of 23:20, 28 September 2017
NeoOffice 2017 is based on the LibreOffice 4.4 code. Because earlier versions of NeoOffice were based on the much older OpenOffice 3.3 code, users may find NeoOffice behaves differently after upgrading to NeoOffice 2017. Below are the most common issues that we have seen after upgrading to NeoOffice 2017:
Installation issues
Step 1 - Download and install the latest version of NeoOffice
Only NeoOffice 2017 will run on High Sierra, Mojave, Catalina, Big Sur, and Monterey. To upgrade to the latest version of NeoOffice 2017, use the following steps:
- NeoOffice Mac App Store:
- Ensure that Apple's App Store application has installed NeoOffice 2017.33 by launching Apple's App Store application and doing these steps
- macOS Sierra and High Sierra users: Install this patch to open PDF files and install extensions that worked in previous versions of NeoOffice 2017.
- If NeoOffice does not launch or NeoOffice Viewer launches, we recommend that you try these steps.
- NeoOffice Professional Edition:
- Install NeoOffice 2017.33 Professional Edition if you are running an older version of NeoOffice
- Optional: Some database features and wizards in NeoOffice Professional Edition require Java. If NeoOffice displays a dialog that says Java is required, install Java SE Development Kit (JDK) 8 from Oracle. Note: only Oracle's JDK 8 will work with NeoOffice 2017 Professional Edition. Neither Apple's Java nor Oracle's Java SE Runtime Environment (JRE) will work.
- If the NeoOffice download or installation fails, we recommend that you try these steps.
Step 2 - If NeoOffice cannot save, try these steps
To fix this problem, right-click or Control-click on the NeoOffice icon in the Dock while NeoOffice Viewer is still running. In the popup menu that appears, select the Options > Show in Finder menu item. A Finder window will appear. Quit NeoOffice, drag the NeoOffice application in that Finder window to the Trash, and empty the Trash.
If you have not already installed NeoOffice Professional Edition or Classic Edition or NeoOffice from the Mac App Store, install either now using the steps in Step 1 above.
Step 3 - If NeoOffice tells you to install a newer version, try these steps
To fix this problem, right-click or Control-click on the NeoOffice icon in the Dock while NeoOffice is still running. In the popup menu that appears, select the Options > Show in Finder menu item. A Finder window will appear. Quit NeoOffice, drag the NeoOffice application in that Finder window to the Trash, and empty the Trash.
If you have not already installed NeoOffice Professional Edition or Classic Edition or NeoOffice from the Mac App Store, install either now using the steps in Step 1 above.
Step 4 - If the Mac App Store tells you that NeoOffice is already installed, try these steps
To fix this problem, open a Finder window and go to the /Applications folder. Drag the NeoOffice application in that Finder window to the Trash, and empty the Trash. Then, go back to Apple's App Store application and click on the download icon to install NeoOffice.
Step 5 - If NeoOffice crashes or does not save, try these steps
The following steps will force NeoOffice to create new user preference files with default values:
- Quit NeoOffice
- NeoOffice Professional Edition:
- In the Finder, select the Go > Go to Folder menu item, copy the following path into the dialog that appears, and press the Go button:
~/Library/Preferences/NeoOffice-4.0 - Drag the selected NeoOffice-4.0 folder to the Trash
- In the Finder, select the Go > Go to Folder menu item, copy the following path into the dialog that appears, and press the Go button:
~/Library/Preferences/NeoOffice-3.0 - Drag the selected NeoOffice-4.0 folder to the Trash
- In the Finder, select the Go > Go to Folder menu item, copy the following path into the dialog that appears, and press the Go button:
- NeoOffice Mac App Store:
- In the Finder, select the Go > Go to Folder menu item, copy the following path into the dialog that appears, and press the Go button:
~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/Preferences/NeoOfficeSecureEdition-4.0 - Drag the selected NeoOfficeSecureEdition-4.0 folder to the Trash
- In the Finder, select the Go > Go to Folder menu item, copy the following path into the dialog that appears, and press the Go button:
~/Library/Containers/org.neooffice.NeoOfficeSecureEdition/Data/Library/Preferences/NeoOfficeSecureEdition - Drag the selected NeoOfficeSecureEdition-4.0 folder to the Trash
- In the Finder, select the Go > Go to Folder menu item, copy the following path into the dialog that appears, and press the Go button:
- Launch NeoOffice
Step 6 - If NeoOffice still has problems, try these steps
- Quit NeoOffice
- In the Finder, go to the /Applications/Utilities folder and launch the Terminal application
- Copy the following commands into the Terminal window and press the Return key:
defaults delete org.neooffice.NeoOffice
defaults delete org.neooffice.NeoOfficeSecureEdition - Launch NeoOffice
General issues
Hyperlinks do not open when clicked
In the LibreOffice 4.4 code used by NeoOffice 2017 (as well as all recent versions of OpenOffice and LibreOffice) hyperlinks only open when clicked while the Command key is pressed (Command-click).
To open hyperlinks with only a click, use the following steps:
- Select the NeoOffice > Preferences menu item
- In the Options dialog that appears, select the NeoOffice > Security item and then press the Options button
- In the Security Options and Warnings dialog that appears, uncheck the Command-click required to follow hyperlinks checkbox and press the OK button.
- After the Security Options and Warnings dialog closes, press the OK button.
Spreadsheet issues
Spreadsheet formulas display #VALUE! instead of a number
If a mathmatical formula references any cells that contain spaces or other non-numeric characters, the LibreOffice 4.4 code used by NeoOffice 2017 (as well as all recent versions of OpenOffice and LibreOffice) will display #VALUE!. In contrast, the OpenOffice 3.3 code used by earlier versions of NeoOffice would behave as if such cells were empty cells.
To stop the display of #VALUE!, there are two options:
- Put each cell reference in a mathematical formula into the N() function. The N() function will return 0 if the cell reference is non-numeric which is very similar to the OpenOffice 3.3 behavior.
- Delete cells with spaces or other non-numeric characters that are referenced by any mathematical formulas in your spreadsheet. You can delete most of the cells with spaces or other non-numeric characters using the following steps:
- Select the cell range which contains text strings.
- Choose the Edit menu then the Find & Replace… sub-menu.
- In the Find & Replace window, enter "^.*[^0-9\-.,].*$" (without quotes) in the Search For field.
- Set the Replace With field to empty.
- Click Other options or More options button.
- Check the Regular expressions checkbox.
- Set the Search in listbox to Values
- Press the Replace All button.
Deleting a cell in a spreadsheet always displays a dialog
To stop the display of this dialog, use the following steps:
- While in a Calc document, select the NeoOffice > Preferences menu item
- In the Options dialog that appears, select the NeoOffice Calc > Compatibility item
- Set the Key Bindings listbox to OpenOffice.org legacy
- Press the OK button.
No grid lines in spreadsheet cells that have a background color
The LibreOffice 4.4 code used by NeoOffice 2017 draws the cell background color on top of grid lines. In contrast, the OpenOffice 3.3 code used by earlier versions of NeoOffice would draw grid lines on top of the cell background color.
To display grid lines in cells that have a background color, use the following steps:
- While in a Calc document, select the NeoOffice > Preferences menu item
- In the Options dialog that appears, select the NeoOffice Calc > View item
- Set the Grid lines listbox to Show on colored cells
- Press the OK button.
Macro issues
The Tools > Macros > Record Macro menu item is disabled
In the LibreOffice 4.4 code used by NeoOffice 2017, recording macros is disabled by default.
To enable recording macros, use the following steps:
- Select the NeoOffice > Preferences menu item
- In the Options dialog that appears, select the NeoOffice > Advanced item, check the Enable macro recording checkbox, and press the OK button
Macros that work in NeoOffice 2015 do not work in NeoOffice 2017
The macro runtime in the LibreOffice 4.4 code used by NeoOffice 2017 contains many security and syntax changes from the very old OpenOffice 3.1.1 macro runtime used by NeoOffice 2015. Because of these LibreOffice changes, many macros that worked in NeoOffice 2015 and earlier versions may no longer work in NeoOffice 2017.
It may not be possible or practical to rewrite macros written for NeoOffice 2015 to work in NeoOffice 2017. In such cases, the following options are available:
- Try running your macros in OpenOffice 4.1.
- Downgrade to NeoOffice 2015.12 Classic Edition.
