Issue 21716 - spoiled array-formulas
Summary: spoiled array-formulas
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
: 24145 24499 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-10-26 00:48 UTC by villeroy
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

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


Attachments
required buggy spreadsheet (6.09 KB, application/octet-stream)
2003-10-27 22:05 UTC, villeroy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2003-10-26 00:48:24 UTC
I created a spreadsheet-doc with one data-sheet (mainly constants from a
database), some (hidden) sheets (looking up and  calculating things from the
first sheet in different ways) and there is a pretty formatted result sheet,
which shows some results from the hidden sheets. The results are linked to the
hidden calculations by arrays. So I have a sheet with some array-formulas
referring to  other sheets (more than one!). This is no problem until I add any
additional array-formula.
Before I lose myself in describing things, please reproduce the bug:
1. Create a new spreadsheet-document (sheet1, sheet2, sheet3)
2. Constant in sheet1.C1                sheet2
3. Constant in sheet1.C6                sheet3
4. Array-formula in sheet1.A2:E5        { =INDIRECT("$"&$C1&".$R$1:$V$4" }
5. Array-formula in sheet1.A7:E10       copied from A2:E5
Shows values of ranges R1:V4 from the sheets specified in C1 and C6.
6.Formula in sheet1.F1:         =SUMIF(G1:G9;">0")
7.Save and re-open the document and everything is fine.
8.Add an additional array-formula to sheet1.F2: { =SUM(G1:G9>0) }
9.Save and re-open.
The array-formula in A7:E10 is broken.

With this test-document I tried so far:
1."Hard coding" the sheet-names within the array-formulas:
A2:E5           { =$sheet2.$R$1:$V$4 }
and A7:E10      { =$sheet3.$R$1:$V$4 }
Without positive effect.
2.Changing the array-formulas to normal ones: =$sheet2.R1 copied to A2:E5 and
likewise with reference to sheet3:
This helps.
3.Using the additional array-formula  (F2) on some other sheet (also containing
arrays, but without references to other sheets):
Everything's fine
4.Omititng step 5, so there is only one array-reference to sheet2 and a second
array formula in F2:
This is no problem.
5.Using references to the same sheet within all arrays:
OK
6.Copy the array to the right side (to H2:L5 and to H6:L10) instead of downwards:
No problem.
My original document can do with solution 2., but I think it's worth to report
this bug.
Comment 1 frank 2003-10-27 11:25:51 UTC
Hi,

Please attach a document showing your problem. It makes work much
easier for us.

Thanks

Frank
Comment 2 villeroy 2003-10-27 22:05:57 UTC
Created attachment 10697 [details]
required buggy spreadsheet
Comment 3 frank 2003-10-28 11:17:57 UTC
Hi Sascha,

as discussed this one is for you.

Frank
Comment 4 frank 2003-10-28 14:26:56 UTC
set the target
Comment 5 sascha.ballach 2003-10-28 15:06:24 UTC
I take it.
Comment 6 niklas.nebel 2003-11-07 09:26:41 UTC
Review done.
Comment 7 sascha.ballach 2003-11-07 09:29:30 UTC
fixed in sab009 in file xmlsubti.cxx
Comment 8 sascha.ballach 2003-12-08 16:42:25 UTC
please verify
Comment 9 frank 2003-12-09 15:51:05 UTC
reset to fixed
Comment 10 frank 2003-12-09 15:52:39 UTC
verified on CWS ab009 using Linux, Solaris and Windows
Comment 11 frank 2004-01-12 10:17:09 UTC
*** Issue 24145 has been marked as a duplicate of this issue. ***
Comment 12 frank 2004-01-19 09:47:01 UTC
*** Issue 24499 has been marked as a duplicate of this issue. ***
Comment 13 frank 2004-01-19 14:16:56 UTC
Found integrated on srx645m25s1-1 using Linux, Solaris and Windows