Bug 89132 - ARRAY FORMULA: Copying formula by draging bottom-right corner + CTRL doesn't work
Summary: ARRAY FORMULA: Copying formula by draging bottom-right corner + CTRL doesn't ...
Status: RESOLVED DUPLICATE of bug 80137
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2015-02-05 08:12 UTC by Mikeyy - L10n HR
Modified: 2015-03-17 09:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Test document (11.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-05 08:12 UTC, Mikeyy - L10n HR 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mikeyy - L10n HR 2015-02-05 08:12:50 UTC 
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.
Comment 1 m_a_riosv 2015-02-05 23:37:33 UTC 
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.
Comment 2 Robinson Tryon (qubit) 2015-03-05 17:25:01 UTC 
Whiteboard -> bibisectRequest
Comment 3 Matthew Francis 2015-03-17 09:54:57 UTC 
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 ***