Issue 101319

Summary: Cached formula link results from old files loaded wrong with merged cells or row groups
Product: Calc Reporter: niklas.nebel
Component: open-importAssignee: oc
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO310m9   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 101565    
Attachments:
Description Flags
Example source file
none
File with references to merge_and_group.ods none

Description niklas.nebel 2009-04-24 10:31:19 UTC 
If a file was saved with 3.0.1 or older, that has a formula reference to a cell
in another file, with merged cells or grouped rows on the source sheet, the last
result (shown before updating the link) is wrong after loading the file into
3.1. See attached example files. After updating the link, the result is correct,
and if the file is saved again with 3.1, it's also correct after loading.
Comment 1 niklas.nebel 2009-04-24 10:32:35 UTC 
Created attachment 61774 [details]
Example source file
Comment 2 niklas.nebel 2009-04-24 10:33:20 UTC 
Created attachment 61775 [details]
File with references to merge_and_group.ods
Comment 3 niklas.nebel 2009-04-24 13:19:49 UTC 
Fixed in CWS "calclinkfixes".
Comment 4 niklas.nebel 2009-04-27 11:45:07 UTC 
reassigning to QA for verification
Comment 5 niklas.nebel 2009-05-19 15:35:20 UTC 
taking the issue back for fixing in 3.1.1
Comment 6 niklas.nebel 2009-05-19 16:42:34 UTC 
Also fixed in CWS "calc311fixes", for 3.1.1.
Comment 7 niklas.nebel 2009-05-26 18:56:35 UTC 
reassigning to QA for verification
Comment 8 oc 2009-05-28 09:04:30 UTC 
verified in internal build cws_calc311fixes (OOo311) and 
verified in internal build cws_calclinkfixes (OOo32)
Comment 9 gibi 2009-09-03 18:40:20 UTC 
Verified with 3.1.1 final Linux X64
Comment 10 thorsten.ziehm 2010-06-07 11:49:13 UTC 
This issue is closed automatically. It is in state 'verified/fixed' since 2
releases (OOo 3.1.1 and OOo 3.2). The policy [1] indicates that such older
issues should be closed.

If this issue still occur in a current build (OOo 3.2.1 or >DEV300m80) please
reopen the issue and set the target accordingly.

[1] : http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues