
NeoOffice 2017 Upgrade Issues
From NeoWiki
Revision as of 21:08, 20 August 2017 (edit) Pluby (Talk  contribs) (Initial article creation) ← Previous diff 
Revision as of 21:40, 20 August 2017 (edit) (undo) Pluby (Talk  contribs) (→Spreadsheet formulas display #VALUE! instead of a number  Add steps for fixing the #VALUE! issue) Next diff → 

Line 5:  Line 5:  
===Spreadsheet formulas display #VALUE! instead of a number===  ===Spreadsheet formulas display #VALUE! instead of a number===  
  If a mathmatical formula references any nonnumeric  +  If a mathmatical formula references any cells that contain spaces or other nonnumeric 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. 
+  
+  To stop the display of <tt>#VALUE!</tt>, you will need to delete cells with spaces or other nonnumeric characters that are referenced by any mathematical formulas in your spreadsheet. You can delete such cells using the Find & Replace dialog using [[Converting_a_Text_String_to_a_Number_in_Calc#Using_the_Find_.26_Replace_Functionthese steps]]. 
Revision as of 21:40, 20 August 2017
Contents 
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:
Spreadsheet formulas display #VALUE! instead of a number
If a mathmatical formula references any cells that contain spaces or other nonnumeric 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!, you will need to delete cells with spaces or other nonnumeric characters that are referenced by any mathematical formulas in your spreadsheet. You can delete such cells using the Find & Replace dialog using these steps.