Issue 90230 - Cell Naming Anomelies due to Maximum Spreadsheet Size Increase
Summary: Cell Naming Anomelies due to Maximum Spreadsheet Size Increase
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0 Beta
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://www.sciactive.com/betaerror.ods
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-02 00:32 UTC by guywithcable
Modified: 2013-01-29 21:43 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
This is a copy of the example real life situation. (15.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-06-02 00:34 UTC, guywithcable 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.