Bug 137625 - EDITING Autofill of merged cells with user list content incorrect, series detection does not work
Summary: EDITING Autofill of merged cells with user list content incorrect, series det...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Attila Szűcs
URL:
Whiteboard: target:7.1.0
Keywords:
Depends on:
Blocks: AutoFill
  Show dependency treegraph
 
Reported: 2020-10-20 14:29 UTC by NISZ LibreOffice Team
Modified: 2020-12-02 13:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc with merged cells filled with user list items (9.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-20 14:29 UTC, NISZ LibreOffice Team
Details
Screenshot of the problem in Calc (36.90 KB, image/png)
2020-10-20 14:29 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-10-20 14:29:41 UTC
Created attachment 166548 [details]
Example file from Calc with merged cells filled with user list items

When autofilling adjacent merged cells containing user list items in Calc, the results are incorrect compared to non-merged cell results.

Steps to reproduce:
    1. Open attached file
    2. In A2:A3 is the first two month names in the Hungarian default user list, also in the merged cells in A5:D5.
    3. C2:F2 is autofilled after selecting A2:A3 and the user list is detected correctly, subsequent month names are filled.
    4. E5:L5 is autofilled after selecting A5:D5, and the cell merging now happens correctly but the user list items are not detected, so only the first two month names repeat.

Actual results:
As above.

Expected results:
Series detection should work in merged cells, giving the same results as with non-merged cells. Cell range E8:L8 illustrates this.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 586f6abee92af3cdabdce034b607b9a046ed3946
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL
Comment 1 NISZ LibreOffice Team 2020-10-20 14:29:55 UTC
Created attachment 166549 [details]
Screenshot of the problem in Calc
Comment 2 Commit Notification 2020-10-30 17:50:38 UTC
Attila Szűcs committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/e8a88d6129948227b46d734a7eba999ec9d1a025

tdf#137625 sc: autofill user list sequences in merged cells

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 3 NISZ LibreOffice Team 2020-11-18 09:30:55 UTC
Verified in:

Version: 7.1.0.0.alpha1+ (x64)
Build ID: 72056f39e01e36afac36c62988331b6813c8214f
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

Thanks for fixing!
Comment 4 Jadeja. R 2020-12-02 13:53:33 UTC
I too has the same problem, and it still persists, any comments?

https://hometone.com/making-it-all-come-together-with-an-interior-concrete-block-wall-finish.html