To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116916 Issue #|116916 Summary|certain calculations fail simple test Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|kacubuntu
------- Additional comments from [email protected] Thu Feb 10 16:59:53 +0000 2011 ------- i have found that when a list of values is summed , then the result is manually typed in to another cell, that there can be a discrepancy of enormous magnitude. this is regardless of the cell used, the sheet used, the file used (even if copied from a csv file.) the error is not replicated in OOffice 3.2 in Vista, only Ubuntu 10.10 . I am using the OOffice packaged with Ubuntu. I have tried to use an alternative, in Ubuntu, but TNA (i cant seem to find a downgrade , and i have failed to install OO 3.3). It is most odd , as the calculation works for smaller values and larger values, and appears to be restricted to a certain subset of values. I can email a summary file. You might like to try the following calc on you versions to see if it works for you: ROW1:76 73 72 78 74 71 75 77 79 675(sum) 675(user defined) 0(difference calc) ROW2:=2^A1 …... (sum) (manual entry of sum value) (I.e.1,206,564,636,373,190,000,000,000) (difference value reported as 4429185024) all other columns give correct answer of zero. Formulae are entered in first column or row respectively then dragged across. Manual entry checked several times and re-entered several times. If first value of A2 is changed, a similar error occurs. I think OOfice is amazing apart from this . Thanks very much keep up the good work. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
