Apache OpenOffice (AOO) Bugzilla – Issue 107631
Values in array formula do not appear after editing.
Last modified: 2017-05-20 11:11:45 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. Remarks: 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.
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.
The same happens if a formula is entered into a selected range using Alt+Enter. Both worked in OOo3.1, the values were shown.
Remains in 3.3rc2
Grabbing issue.
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.
Reset assigne to the default "issues@openoffice.apache.org".