[Libreoffice-bugs] [Bug 137205] New: EDITING Autofill of merged cells with date content incorrect, series detection does not work

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137205

            Bug ID: 137205
           Summary: EDITING Autofill of merged cells with date content
                    incorrect, series detection does not work
           Product: LibreOffice
           Version: 7.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, szucs.attila3 at nisz.hu
            Blocks: 113499

Created attachment 166025
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166025&action=edit
Example file from Calc

incorrect compared to non-merged cell results.

Steps to reproduce:
    1. Open attached file
    2. In A2:B2 there are dates with 1 day difference. Selecting these and
autofilling to the right gives dates with 1 day difference too.
    3. In A7:B7 the same dates are in merged cells. Selecting these and
autofilling to the right now creates merged cells but the dates are incremented
separately and not as a series.
    4. In A3:B3 there are dates with 1 month difference, and the same dates in
A8:B8 in merged cells. Autofilling to the right increases the month number in
row 3 but the day number in row 8.
    5. In A4:B4 there are dates with -1 year difference and the same dates in
the A9:B9 in merged cells. Autofilling to the right decreases the year number
in row 4 but increases the day number in row 8.

Actual results:
As above.

Expected results:
Series detection should work in merged cells, giving the same results as with
non-merged cells. Cell range E10:L13 illustrates this. 
Excel also gives the same results as in the non-merged case.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: dda71436b8594fb0669b3ac06c02a3997a0674be
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113499
[Bug 113499] [META] AutoFill bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201002/fc3bb697/attachment.htm>