[Libreoffice-bugs] [Bug 128914] New: Drag-copy of formulas referencing labels gives wrong result in rows (copying vertically); works in columns (copying horizontally)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128914
           Summary: Drag-copy of formulas referencing labels gives wrong
                    result in rows (copying vertically); works in columns
                    (copying horizontally)
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 155970
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155970&action=edit
Sample with labels

Given this in A1:C6:

> jan   feb   mar
>  1     2     3
>  2     3     4
>  3     4     5
>  4     5     6
>  5     6     7

defining labels in A1:C1 for columns in A2:C6 (Sheets->Named Ranges and
Expressions->Labels...)

and putting this formula into D2: `='jan'*'feb'*'mar'`

the result is correct 6. But drag-copying the formula down into D3:D6 produces
the column of 6s, while values must be different for each row (6, 24, 60, 120,
210). Hard recalc doesn't help, but minimal editing of the formula makes it
work OK; also if you try to drag the wrong value 6 from, e.g., D3 into D4, the
value in D4 would be 60; dragging the 6 from D3 into D4:D5 gives two 24s.

But the same works fine when the labels are for rows, not columns. Consider
this in A12:F14:

> apr   1   2   3   4   5   6
> may   2   3   4   5   6   7
> jun   3   4   5   6   7   8

set labels in A12:A14 for rows B12:F14; and put `='apr'*'may'*'jun'` into B15.
The cell then drag-copies fine into C15:F15.

See sample file with pre-configured data, where only drag-copy is left.

Version: 6.3.3.2 (x64)
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

-- 
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/20191120/09be6237/attachment.html>