https://bugs.freedesktop.org/show_bug.cgi?id=80137
--- Comment #4 from Wolfgang <[email protected]> --- Created attachment 108122 --> https://bugs.freedesktop.org/attachment.cgi?id=108122&action=edit ODS file demonstrating the state after step 13 of above instructions It is not an issue of Copy/Paste but an issue of Fill Up/Down. My description: [Subject[Array formula: FillUp, FillDown only working for the immediately adjacent cell]] LibreOffice Calc 3.6 worked correctly so far. Versions 4.x contain the error. Problem description: Array formula should fill into as many adjacent cells as wanted by dragging the "little square" Up, Down, Left, Right simultaneously pressing Ctrl. The same for using Ctrl+D or related menu items. It works correctly for Left, Right. It works for one row (1 row) per step Up, Down. Filling Up, Down more than one rows in a single step does not carry the "array formula property". Steps to reproduce: 1. Create a new spreadsheet 2. Enter the array formula {=COUNTIF(ISBLANK(B11:C11);TRUE())} into A11. 3. Enter numbers or letters into some cells of the range B1:C21 4. 'FillUp' the formula from A11 into A10 dragging with Ctrl. 5. 'FillDown' the formula from A11 into A12 dragging with Ctrl. 6. 'FillDown' the formula from A12 till A13 now dragging with Ctrl. 7. Copy the formula from A11 and paste it into A1. 8. Make sure to note everything was as expected so far. 9. 'FillDown' the formula from A12 till A16 now dragging with Ctrl. 10. 'FillUp' the formula from A10 till A8 now dragging with Ctrl. 11. Make sure to note "Err:504" reported in A8:A9, A13:A16. 12. Delete the formulae in column A and start anew in A11. Repeat steps 4 through 11 with Ctrl+D or the appropriate menu item. 13. Copy A10:A12, select A19 and paste. Current behavior: Filling up or down an array formula using a well established method does only work correctly if performed for exactly 1 cell to get the formula. Performed for more than one cells in a single step the formula lose its array-formula property. In cases where the formula is only correct as an array formula we get an error (504 in the above described case). In other cases we may get wrong results. Using Copy/Paste no errors occur. Expected behavior: Correctly copied array formulae returning correct results. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
