To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107631 Issue #|107631 Summary|Values in array formula do not appear after editing. Component|Spreadsheet Version|OOO310m19 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|cassioneri
------- Additional comments from cassion...@openoffice.org Sat Dec 12 08:48:25 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
