| Summary: | ARRAY FORMULA: Copying formula by draging bottom-right corner + CTRL doesn't work | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Mikeyy - L10n HR <mihovil> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | fdbugs, miguelangelrv, robinson.libreoffice |
| Priority: | medium | Keywords: | regression |
| Version: | 4.4.0.3 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=80137 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Test document | ||
Hi @Mikeyy, thanks for reporting. Reproducible. Win7x64 Version: 4.3.7.0.0+ Build ID: 32e7fc9e82e0e62e872611482d97f745bac3899a TinderBox: Win-x86@51-TDF, Branch:libreoffice-4-3, Time: 2015-01-27_09:26:49 Version: 4.4.0.3 Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7 Version: 4.4.1.0.0+ Build ID: 86df2b436d387ff1282089267e1837f17aff5cda TinderBox: Win-x86@51-TDF, Branch:libreoffice-4-4, Time: 2015-02-02_23:26:35 Last working for me: Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a With: Version: 4.2.8.0.0+ Build ID: 1fc1d0d7d38bb16832d0d78d78682ed2d5f8716f TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2015-01-08_03:10:08 doesn't result in error but different array copied to AH4 and AH6 than AH5. Whiteboard -> bibisectRequest Already fixed on bug 80137 commit 097a16b59884c777f724cec6c5d42734974ed44b Author: Henry Castro <hcvcastro@gmail.com> Date: Fri Mar 6 13:51:25 2015 -0400 Resolves tdf#80137 Paste array formula into range pastes as non-array formula *** This bug has been marked as a duplicate of bug 80137 *** |
Created attachment 113138 [details] Test document - Open test document. - Grab cell AH3 by bottom-right corner. - Press CTRL and drag cursor few cells down. RESULT: Error 504 EXPECTED: Copying array formula in cells bellow. If you don't press CTRL before dragging, then it will actually copy array formula, but exactly as it is in cell AH3. It will NOT change cells references which usualy should be changed, for example $B3 to $B4, $B5, $B6... Tested on: Windows 8.1 LibreOffice 4.4.0.3 It works properly on 4.2.8.2, so it's regression.