Apache OpenOffice (AOO) Bugzilla – Issue 56034
Calulating with text-fields containing numbers
Last modified: 2005-10-14 22:05:49 UTC
In contrast to Microsoft EXCEL OOo does not compute fields that contain numbers entered as text with leading apostrophe (i.e. '753).
Created attachment 30460 [details] Test Spreadsheet
You are right, OOo will not calculate with text. Please see the discussion in issue 5658. *** This issue has been marked as a duplicate of 5658 ***
closing duplicate