https://bugs.documentfoundation.org/show_bug.cgi?id=125626
Eike Rathke <[email protected]> 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 <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
