Issue 90230

Summary: Cell Naming Anomelies due to Maximum Spreadsheet Size Increase
Product: Calc Reporter: guywithcable <hunter>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 3.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://www.sciactive.com/betaerror.ods
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
This is a copy of the example real life situation. none

Description guywithcable 2008-06-02 00:32:47 UTC 
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
Comment 1 guywithcable 2008-06-02 00:34:12 UTC 
Created attachment 54140 [details]
This is a copy of the example real life situation.
Comment 2 amy2008 2008-07-04 09:52:41 UTC 
It's reproducible on DEV300_m21_en WinXP.
Comment 3 clytie 2008-07-09 10:31:32 UTC 
I'm confirming this issue, since Mei Ying has reproduced it.