Apache OpenOffice (AOO) Bugzilla – Issue 101162
Resizing import range corrupts adjacent array formulas
Last modified: 2014-01-15 19:38:39 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.
Created attachment 61639 [details] Spreadsheet with db-range Bibliography.biblio and adjacent array formulas
Confirmed with AOO410m1(Build:9750) - Rev. 1557669 2014-01-14_04:11:13 - Rev. 1557927 Debian