Issue 18937 - #REF! appears in cell when column deleted in XLS spreadsheet (shared formula)
Summary: #REF! appears in cell when column deleted in XLS spreadsheet (shared formula)
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-02 06:49 UTC by kelvine
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
XLS spreadsheet shows #REF! when column B deleted (11.50 KB, application/octet-stream)
2003-09-02 06:52 UTC, kelvine 		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 kelvine 2003-09-02 06:49:18 UTC 
Hi,

Attached is an XLS spreadsheet which has been reduced but still contains the 
problem.

When column B is deleted the cells D10-D36 end up with #REF! in them.

The formula in one of the cells in the original E column (which becomes the D 
column) is: =TEXT(A8;"dddd")

However if the same thing is done in Excel XP no error occurs and the formula 
is adjusted correctly.

If I save the spreadsheet as a Calc spreadsheet, close and reopen the Calc 
spreadsheet, the spreadsheet now works like Excel XP.

If I save the spreadsheet as a Calc spreadsheet and then resave the 
spreadsheet as an XLS spreadsheet the problem also goes.

This is also not a new problem. I have tested this with OO1.0.3.1 and it does 
not work.

Hope this helps.

Kelvin
Comment 1 kelvine 2003-09-02 06:52:21 UTC 
Created attachment 8939 [details]
XLS spreadsheet shows #REF! when column B deleted
Comment 2 john.marmion 2003-09-02 12:23:50 UTC 
I can confirm this though I need to investigate it some more. It
appears that Excel stores the range E10-E36 as a shared formula and
this may offer an explanation why these cells are in error only.
Comment 3 john.marmion 2003-09-02 12:25:38 UTC 
taking ownership
Comment 4 john.marmion 2003-09-02 13:36:40 UTC 
reset to started
Comment 5 john.marmion 2003-09-02 13:37:25 UTC 
set the target
Comment 6 ooo 2003-09-11 14:20:53 UTC 
This is a problem of the routine that updates the cell references,
either the shared formula should be replaced by individual formulas in
this case, but apparently it isn't, or the shared formula itself
should be updated. My construction site, grabbing issue.
Comment 7 ooo 2003-09-11 14:21:40 UTC 
Accepted.
Comment 8 ooo 2004-11-05 11:30:21 UTC 
On branch cws_src680_calc25:
sc/source/core/data/cell2.cxx 1.21.78.2
Comment 9 ooo 2004-11-05 13:55:38 UTC 
Reopen to reassign.
Comment 10 ooo 2004-11-05 14:14:17 UTC 
Reassign to QA.
Comment 11 ooo 2004-11-05 14:15:59 UTC 
Restore status.
Comment 12 frank 2004-11-08 14:51:50 UTC 
found fixed using cws calc25 on Linux, Solaris and Windows
Comment 13 oc 2004-12-06 12:12:32 UTC 
closed because fix available in OOo1.9m65