Issue 101319 - Cached formula link results from old files loaded wrong with merged cells or row groups
Summary: Cached formula link results from old files loaded wrong with merged cells or ...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO310m9
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks: 101565
  Show dependency tree
 
Reported: 2009-04-24 10:31 UTC by niklas.nebel
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Example source file (7.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-04-24 10:32 UTC, niklas.nebel 		no flags Details
File with references to merge_and_group.ods (7.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-04-24 10:33 UTC, niklas.nebel 		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 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