https://bugs.documentfoundation.org/show_bug.cgi?id=90797
--- Comment #1 from Chris McKenna <[email protected]> --- When using copy/paste or fill down to populate two or more rows or columns with array formulae, the filled/destination formulae are all non-array formulae (and thus usually invalid). Steps to reproduce: 1. Create a spreadsheet with at least one array formula. Use cell C3 for this example, in reality the location is unimportant. 2. Select cells C3 and C4 and fill down. Expected and actual result: The array formula is copied and works as an array formula. 3. Select Cells C4 to C6 4. Copy down. Expected result: The array formula is copied to cells C5 and C6 as an array formula and works. Actual result: The formulas in cells C5 and C6 are copied identically except for the array status and thus break. Example from spreadsheet I discovered this in Array formula in cell C50: {=COUNTIF(DAY(Locations.$G50:$X50)=C$1,1)} Array formula in cell C51 if filled down to Cell C51 only: {=COUNTIF(DAY(Locations.$G51:$X51)=C$1,1)} Array formula in cell C51 if also copied down to more cells: =COUNTIF(DAY(Locations.$G51:$X51)=C$1,1) I'm using version 4.4.1.2 Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: en_GB on 64 bit linux. I haven't tested this in any other environment. -- 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
