To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90230 Issue #|90230 Summary|Cell Naming Anomelies due to Maximum Spreadsheet Size |Increase Component|Spreadsheet Version|OOo 3.0 Beta Platform|All URL|http://www.sciactive.com/betaerror.ods OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|open-import Assigned to|spreadsheet Reported by|guywithcable
------- Additional comments from [EMAIL PROTECTED] Sun Jun 1 23:32:47 +0000 2008 ------- Cell K21 is supposed to include the sum of several cells, including cell K19, however cell K19 is not added. K19 is named SC2 (Store Credit 2) and this label is used in the calculation. Cell D19 (named SC1) has the same issue. The issue is caused because SC1 and SC2 now refer (since 3.0 Beta) to real cell numbers, because of the increase in size of the spreadsheet. It would be helpful to have the importer check the names of cells for anything that now refers to real cell numbers. The result is, it adds up correctly in OOo 2.4, but not in 3.0 Beta. The document can be downloaded from http://www.sciactive.com/betaerror.ods Thank You, Hunter --------------------------------------------------------------------- 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]