[Libreoffice-bugs] [Bug 125626] fill down command calculates illogical series

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|Windows (All)               |All
            Version|6.2.3.2 release             |Inherited From OOo
           Hardware|x86-64 (AMD64)              |All
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #7 from Eike Rathke <erack at redhat.com> ---
Calc is not filling a calculated series when dragging down formulas, it's like
copy&paste instead. That's also how other major spreadsheet implementations
work. In the attached example, as only J8 is chosen as endpoint, it's the same
as copy-pasting J6 to J8. It becomes clearer when drag filling J6:J7 down until
J9, then J8:J9 are a copy-paste of J6:J7 with keeping the relative references
(and thus making them point to 2 rows below). There is no calculation of
relative differences between two selected formulas, and there shouldn't be as
it would be utterly confusing. Furthermore things would get unpredictable if a
third cell was selected that again differs from the previous difference, or if
formula cells were "incompatibly" different.

-- 
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/20190808/e62fb9df/attachment.html>