Bug 137625

Summary:	EDITING Autofill of merged cells with user list content incorrect, series detection does not work
Product:	LibreOffice	Reporter:	NISZ LibreOffice Team <libreoffice>
Component:	Calc	Assignee:	Attila Szűcs <attila.szucs>
Status:	VERIFIED FIXED
Severity:	normal	CC:	attila.szucs, nemeth
Priority:	medium
Version:	7.1.0.0.alpha0+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=88782
Whiteboard:	target:7.1.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	113499
Attachments:	Example file from Calc with merged cells filled with user list items Screenshot of the problem in Calc

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