Issue 110008 - Formula changes on column/cell insert
Summary: Formula changes on column/cell insert
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: DEV300m73
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2010-03-10 11:56 UTC by kpalagin
Modified: 2017-05-20 10:33 UTC (History)
3 users (show)

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

Attachments
problematic file (101.50 KB, application/vnd.ms-excel)
2010-03-10 11:57 UTC, kpalagin 		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 kpalagin 2010-03-10 11:56:50 UTC 
Open attached file and note that EF6 contains formula "=F6*7".
Now insert column after EL or row after 6 - formula changes to "=JB6*7".
Comment 1 kpalagin 2010-03-10 11:57:44 UTC 
Created attachment 68267 [details]
problematic file
Comment 2 bormant 2010-03-10 12:48:34 UTC 
Reprodused on OOO320m12 and DEV300m71.
Comment 3 frank 2010-03-10 18:38:11 UTC 
Hi Olli,

reproducible using 3.2 therefore keyword regression.

Target 3.2.1 ?

Please re-assign accordingly
Comment 4 Oliver Brinzing 2010-03-11 11:43:57 UTC 
.
Comment 5 niklas.nebel 2010-03-11 12:42:14 UTC 
This was broken since 2.0 or similar, so it's not really something for 3.2.1.
Comment 6 niklas.nebel 2010-03-11 12:45:43 UTC 
Fixed in CWS "dr73".
Comment 7 vzhik 2010-03-15 11:27:28 UTC 
Fixed? I have OOo-Dev_DEV300_m75_Win32Intel_install_en-US.exe, download
problematic file , insert row in Calc  and formula changes to "=JB6*7".
Then:  Save as..(in .xls), close, open and formula changes to "=#REF!#REF!*7". 
This problem there in 2.4 stable version also.
Comment 8 niklas.nebel 2010-03-15 11:35:06 UTC 
You don't see the fix in m75 because the CWS "dr73" hasn't been integrated yet,
see http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdr73
Comment 9 vzhik 2010-03-15 11:36:55 UTC 
If I misunderstood, sorry
Comment 10 niklas.nebel 2010-03-17 17:19:47 UTC 
reassigning to QA for verification
Comment 11 oc 2010-04-08 13:21:36 UTC 
verified in internal build cws_dr73