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:

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:

+

+

{{bluebox|Request refund}}

+

+

==Installation issues==

+

+

{{:Sierra_and_High_Sierra_Upgrade_Issues}}

==General issues==

==General issues==

-

===Hyperlinks do not open when clicked===

+

====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).

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).

Line 13:

Line 19:

* Select the {{menu|NeoOffice}} > {{menu|Preferences}} menu item

* Select the {{menu|NeoOffice}} > {{menu|Preferences}} menu item

* In the {{window|Options}} dialog that appears, select the {{menu|NeoOffice}} > {{menu|Security}} item and then press the {{button|Options}} button

* In the {{window|Options}} dialog that appears, select the {{menu|NeoOffice}} > {{menu|Security}} item and then press the {{button|Options}} button

-

* In the {{window|Security Options and Warnings}} dialog that appears, uncheck the {{button|Command-click required to follow hyperlinks}} checkbox and press the {{button|OK}} button.

+

* In the {{window|Security Options and Warnings}} dialog that appears, uncheck the {{button|Command-click required to follow hyperlinks}} checkbox and press the {{button|OK}} button

-

* After the {{window|Security Options and Warnings}} dialog closes, press the {{button|OK}} button.

+

* After the {{window|Security Options and Warnings}} dialog closes, press the {{button|OK}} button

+

+

==Writer issues==

+

+

====Mail merge adds blank pages when printing====

+

+

When printing some mail merge documents that were saved in NeoOffice 2015 or earlier, the LibreOffice 4.4 code used by NeoOffice 2017 may insert blank pages in the printed output.

+

+

To stop the insertion of blank pages when printing, use the following steps:

* In the {{window|Options}} dialog that appears, select the {{menu|NeoOffice Writer}} > {{menu|Print}} item and then uncheck the {{button|Print automatically inserted blank pages}} checkbox and press the {{button|OK}} button

+

* Save your mail merge document

+

+

====Custom starting page numbers are incorrect====

+

+

When opening some documents that have custom starting page numbers that were saved in NeoOffice 2015 or earlier, the LibreOffice 4.4 code used by NeoOffice 2017 may display the incorrect page number.

+

+

To correct the custom starting page numbers, use the following steps:

+

+

* Move the cursor into the first paragraph of your document. If a table is at the start of the first paragraph, insert a new blank line before the table by moving the cursor to the beginning of the top left cell in the table and then pressing the {{key|Return}} key, and then move the cursor to the new blank line.

+

* Select the {{menu|Format}} > {{menu|Paragraph}} menu item

+

* In the {{window|Paragraph}} dialog that appears, select to {{button|Text Flow}} tab and then, in the {{menu|Breaks}} section, check the {{button|Insert}} and the {{button|With page style}} checkboxes, enter the custom starting page number in the {{section|Page number}} field, and press the {{button|OK}} button

+

* If you have any page breaks in your document, move the cursor into the first paragraph after a page break and repeat the preceding 2 steps

+

* Save your document

==Spreadsheet issues==

==Spreadsheet issues==

-

===Spreadsheet formulas display #VALUE! instead of a number===

+

====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 <tt>#VALUE!</tt>. In contrast, the OpenOffice 3.3 code used by earlier versions of NeoOffice would behave as if such cells were empty cells.

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 <tt>#VALUE!</tt>. In contrast, the OpenOffice 3.3 code used by earlier versions of NeoOffice would behave as if such cells were empty cells.

Line 24:

Line 54:

To stop the display of <tt>#VALUE!</tt>, there are two options:

To stop the display of <tt>#VALUE!</tt>, there are two options:

-

# Put each cell reference in a mathematical formula into the <tt>N()</tt> function. The <tt>N()</tt> function will return <tt>0</tt> if the cell reference is non-numeric which is very similar to the OpenOffice 3.3 behavior.

+

# Put each cell reference in a mathematical formula into the <tt>N()</tt> function. The <tt>N()</tt> function will return <tt>0</tt> 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:

# 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:

* Set the {{prefName|Key Bindings}} listbox to {{button|OpenOffice.org legacy}}

* Set the {{prefName|Key Bindings}} listbox to {{button|OpenOffice.org legacy}}

-

* Press the {{button|OK}} button.

+

* Press the {{button|OK}} button

-

===No grid lines in spreadsheet cells that have a background color===

+

====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.

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.

====Macros and extensions that worked in NeoOffice 2015 do not work in NeoOffice 2017====

+

+

The macro runtime and extension APIs in the LibreOffice 4.4 code used by NeoOffice 2017 contains many security and syntax changes from the very old OpenOffice 3.1.1 code used by NeoOffice 2015. Because of these LibreOffice changes, many macros and extensions 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 or extensions written for NeoOffice 2015 to work in NeoOffice 2017. In such cases, the following options are available:

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:

We do not have any support staff. If NeoOffice does not work for you, you can request a refund using the steps in the following links:

If NeoOffice does not launch or NeoOffice Viewer launches, we recommend that you try these steps.

Step 2 - 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

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

Launch NeoOffice

Step 3 - 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.NeoOfficedefaults 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

Writer issues

Mail merge adds blank pages when printing

When printing some mail merge documents that were saved in NeoOffice 2015 or earlier, the LibreOffice 4.4 code used by NeoOffice 2017 may insert blank pages in the printed output.

To stop the insertion of blank pages when printing, use the following steps:

In the Options dialog that appears, select the NeoOffice Writer > Print item and then uncheck the Print automatically inserted blank pages checkbox and press the OK button

Save your mail merge document

Custom starting page numbers are incorrect

When opening some documents that have custom starting page numbers that were saved in NeoOffice 2015 or earlier, the LibreOffice 4.4 code used by NeoOffice 2017 may display the incorrect page number.

To correct the custom starting page numbers, use the following steps:

Move the cursor into the first paragraph of your document. If a table is at the start of the first paragraph, insert a new blank line before the table by moving the cursor to the beginning of the top left cell in the table and then pressing the Return key, and then move the cursor to the new blank line.

Select the Format > Paragraph menu item

In the Paragraph dialog that appears, select to Text Flow tab and then, in the Breaks section, check the Insert and the With page style checkboxes, enter the custom starting page number in the Page number field, and press the OK button

If you have any page breaks in your document, move the cursor into the first paragraph after a page break and repeat the preceding 2 steps

Save your document

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 and extension 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 and extensions that worked in NeoOffice 2015 do not work in NeoOffice 2017

The macro runtime and extension APIs in the LibreOffice 4.4 code used by NeoOffice 2017 contains many security and syntax changes from the very old OpenOffice 3.1.1 code used by NeoOffice 2015. Because of these LibreOffice changes, many macros and extensions 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 or extensions written for NeoOffice 2015 to work in NeoOffice 2017. In such cases, the following options are available: