Issue 107631 - Values in array formula do not appear after editing.
Summary: Values in array formula do not appear after editing.
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m19
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa, regression
Depends on:
Reported: 2009-12-12 08:48 UTC by cassioneri
Modified: 2017-05-20 11:11 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description cassioneri 2009-12-12 08:48:25 UTC
Also found in OOO310m19 for Windows Vista.

To reproduce:
1. On a blank spreadsheet disable auto calculation (uncheck Tools - Cells
contents - AutoCalculate);
2. Enter numbers in cells A1 and A2;
3. Select range A3:B3;
4. Press F2 and enter the array formula =transpose(A1:A2) (recall to press Shift
+Ctrl+Enter to tell OOo that's an array formula).

At this point in A2:B3 we should see the transpose of A1:A2 but instead we see 
blanks. However the formula content is still there, only the values are not 
shown in the sheet. If you press now F9 you will get the values.

One more exercise:

5. Change content of A2;
6. Select range A3:B3;
7. Press F2 followed by Left Arrow and Shift+Ctrl+Enter (to force OOo to 
recalculate only this formula).

Again, values of A3:B3 disappear. Press F9 to get them.

a. It does not seem to be a transpose issue since it happens to any function 
including scalar ones (e.g. sum). The only requirement seems to be finishing 
the editing with Shift+Ctrl+Enter.
b. Thanks to one add-in function of mine which logs every call I could see that 
the function is not called after the editing.

Given a. and b. I guess this is an editing issue.
Comment 1 Regina Henschel 2009-12-12 13:05:42 UTC
I see described behavior too in DEV300m66 on WinXP. I think too, that after
editing an initial value should be shown. In OOo2.4.3 the value is not
calculated, but a zero is shown.
Comment 2 ooo 2009-12-14 13:07:34 UTC
The same happens if a formula is entered into a selected range using Alt+Enter.
Both worked in OOo3.1, the values were shown.
Comment 3 mariosv 2010-10-23 00:07:34 UTC
Remains in 3.3rc2
Comment 4 ooo 2011-02-15 12:58:38 UTC
Grabbing issue.
Comment 5 ooo 2011-03-14 11:43:45 UTC
To display an initial value for matrix formulas (and formulas entered over a range) would involve a bit more than just a small change, retargeting.
Comment 6 Marcus 2017-05-20 11:11:45 UTC
Reset assigne to the default "".