https://bugs.documentfoundation.org/show_bug.cgi?id=99485
Elmar <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #3 from Elmar <[email protected]> ---
could someone write some help text on what is supposed to happen when the
option "update references when sorting range of cells" is ticked (Calc Options
General)?
in Version: 5.2.0.0.alpha1+
Build ID: b871a97d35a4160b7403c07bfac10aaa744fbbfd
CPU Threads: 4; OS Version: Linux 3.19; UI Render: default;
TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:master, Time: 2016-05-11_01:00:26
Locale: en-ZA (en_GB.UTF-8)
If I have the following:
cell: content
5D: amtA (intended as a cumulative figure)
6C: amtB (transaction amount)
6D: = 5D + 6C
If I sort in another order, it does not maintain the cumulative nature of the
adding operation but changes 6C to the row it has been sorted into, but keeps
the 5D (i.e. the original amount it was adding to)
This is useful, but not if one is running a cum in col D. Then one would have
to re-establish the topmost formula and copy the formula down again.
Why would I want the both references to change?
This is useful if say I am capturing items from random slips of paper, and then
want to sort them into date sequence when I have finished capturing them.
This is the approach used in MS Excel and the Calc approach would thus create
confusion for people who migrate from MS.
But I do see the value of the current implementation (although I would use $ to
fix this.)
--
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
