[Libreoffice-bugs] [Bug 137654] New: EDITING Autofill with userlist items in reversed order does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137654
           Summary: EDITING Autofill with userlist items in reversed order
                    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 166585
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166585&action=edit
Example file from Calc

Calc can autofill cells with items in user lists but only if these are in
ascending/ order.
Excel however can autofill cells with user list items if they are in reversed
order so so migrating users can expect this feature from Calc too.


Steps to reproduce:
    1. Open attached file
    2. The range A2:C2 contains month names in reversed order from December.
This range was selected and autofilled to the D2:G2 range. New values are in
increasing order and start from October in C2.
    3. The range A3:C3 contains month names in reversed order from December
with a 2 month gap between them. This range was selected and autofilled to the
D3:G3 range. New values are in increasing order and start from July in C3.
    4. The same source lists are copied to A5:C5 and A6:C6 ranges and D5:G5 /
D6:G6 ranges demonstrate the expected result, i.e. what Excel would do in a
similar setup.

Actual results:
As above.

Expected results:
Calc should detect user list items in reversed order when autofilling with two
or more selected cells and apply user list items according to the difference
between items position found in the selected cells.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: e0c72e31c1d455c26110c35e8780d420e17cdea6
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
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/20201021/d780261f/attachment-0001.htm>