To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=63151
------- Additional comments from [EMAIL PROTECTED] Wed Mar 15 18:11:22 -0800 2006 ------- 1. Open any saved spreadsheet file whose name is "ref.ods"(has data: value 1 is in the cell A1, value 2 is in the cell A2) and then new a spreadsheet file "Untitled1"; 2.In the "Untitled1" document, Input the function SUM in the cell A1 whose reference range is data range "A1:A2" in the "ref.ods"(seen the image reference1.jpg),the formula result is 3, the correct answer; 3.Input value 3 in the cell B1 and value 4 in the cell B2 in the "ref.ods", then save it. In the "Untitled1" document, Input the function SUM in the cell B1 which reference range is "A3:A4" of the document "ref.ods"(seen the image reference2.jpg). The formula result isn't 7, but 0! It's wrong. --------------------------------------------------------------------- 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]