Issue 101162

Summary: Resizing import range corrupts adjacent array formulas
Product: Calc Reporter: villeroy <villeroy>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.0.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
Spreadsheet with db-range Bibliography.biblio and adjacent array formulas none

Description villeroy 2009-04-17 13:28:41 UTC 
There is a handy option to expand adjacent formula ranges to imported database
ranges. I encountered a strange issue when I tried this feature with a database
range. I'll attach a spreadsheet where I could reproduce the issue with a
db-range bound to the infamous Bibliography.biblio.
It has no data stored but 2 versions of the same array formula with relative and
absolute references. 
When you open the file you are prompted for update.
After updating, the first calculated field looks right, but has many overlapping
array formulas, the second field shows only the first result in all rows while
showing the expected array formula.
Comment 1 villeroy 2009-04-17 13:31:10 UTC 
Created attachment 61639 [details]
Spreadsheet with db-range Bibliography.biblio and adjacent array formulas
Comment 2 Edwin Sharp 2014-01-15 19:38:39 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Debian