https://bugs.documentfoundation.org/show_bug.cgi?id=139681
Bug ID: 139681
Summary: CALC AUTOFILL EDIT applies existing pattern
inconsistently when source cell range contents are
formulae
Product: LibreOffice
Version: 7.0.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: that.man.co...@gmail.com
Description:
When a predefined incremental pattern is used as a template with simple numbers
it fills according to the template but if the predefined pattern is cell
references then the autofill produces two patterns.
One pattern increments the first cell in the range + count of intervening cells
to the first empty cell, the second pattern then increments the subsequent
predefined values to the following relative number of empty cells also
incremented by three. The pattern persists and cells are auto-filled in blocks
of three.
I imagine the "offset" is consistently defined by the number of "filled" cells
in the selection.
Steps to Reproduce:
Sample sheet attached.
Column A has been auto-filled from 1 - 70 to identify the target "count" for
the formulae in Column C.
Initially, columns C & D only had the first three rows manually entered
Column C: observe the formulae in the first three rows increment the preceding
cell by 8 rows
Column D observe the numbers in the first three rows increment the preceding
cell by 8
Observe the subsequent formulae and values in cells C9 to D14
The auto-fill was the result of selecting the range C6:D8 and auto-filling down
to D14.
To recreate, either erase C9:D14 or simply reselect C6:D8 and autofill to D14
overwriting the existing entries.
Observe column D correctly increments by 8
Observe the formulae in column C where all the cells are incremented by three
RELATIVE to the original source cells.
I'm convinced the rationale for following the predefined pattern is far more
logical than an inconsistency that will vary depending upon the number of
filled cells encountered before the available target range.
Obviously, there's no problem when a single cell is replicated by auto-fill as
it logically increments by one.
Actual Results:
Formulae cells are not incremented according to the selected "template" cells
Expected Results:
Formulae incremented according to the selected "template" cells.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
