https://bugs.documentfoundation.org/show_bug.cgi?id=167692
Bug ID: 167692
Summary: [enhancement] Pattern continuation for relative
formula copying
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Currently, if drag(copy) a cell down 1 cell, the references in the formula
inside the cell get their row index increased by 1.
It would be useful to have an easy way to change this behaviour and specify
that row index be increased by an arbitrary number, n.
It would make, for example, skipping cells/ranges in source range much easier,
removing the need for "index" or "offset" functions for such use. As well as
referencing from a different direction than the one dragging to. Many
possibilities.
One intuitive way to specify that could be by using a sequential linear
pattern, similar to how the spreadsheet figures that if you have: 1,3, then
after selecting both and dragging, the next number should be 5.
Examples are given in Steps below.
It should work for any step/difference in index in references in formulas of
the 2 selected cells, even negative, and even across a different dimension
(row/col) than the one we are dragging along.
It can be generalized to also work if each of the selected cells contains 2 or
more references, and there may be a different pattern (index difference) for
each corresponding pair across the 2 selected cells.
Steps to Reproduce:
In cells A1,A2, put, in turn, each of the following pairs; then select both
cells then drag by the corner downward:
1) =C3, =C5
2) =c9, =c7
3) =c1, =d1
4) =d1, =c1
Actual Results:
1) =C5, =C7, =C7, =C9...
2)=c11, =c9, =c13, =c11...
3) =C3, =D3, =C5, =D5...
4) =D3,=C3,=D5,=C5,...
Expected Results:
1) =C7, =C9, =C11...
2) =c5, =c3, =c1, #name?...
3) =e1, =f1,...
4) =b1, =a1, #name?..
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
