To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105130 Issue #|105130 Summary|OO0 3.1 Calc: wrong result in formula referencing cell |s in other file. Component|Spreadsheet Version|OOO310m19 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|cornix
------- Additional comments from [email protected] Wed Sep 16 17:07:45 +0000 2009 ------- This problem raises in the 3.1 version. My speadsheet (aa.ods) has formulas (in colum B)referencing values in two different sheets of another .ods file (bb2009.ods). The value result is wrong (see correct values in column C, differences are marked red)). Trying to correct the problem I have re-written the link in the formula and I have noticed some improvement, but only the first time, still having errors anyway. Another attempt was to rename sheets without embedded blanks. This worked only for a while. --------------------------------------------------------------------- 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]
