https://bugs.freedesktop.org/show_bug.cgi?id=85490
--- Comment #14 from Eike Rathke <er...@redhat.com> ---
Status update and explanations for attachment 109652
metabug_fdo85490_v6.ods per sheet:
* Ranking_Columns: fixed with bug 83765
* Bug43004: fixed with bug 83765, was erroneously indicated to be some
case of bug 43004 but is not.
* Bank_Account: there's nothing wrong with it, with
UpdateReferenceOnSort=TRUE the references are adjusted to point to the
same data they did before, which for the "classic" column shifts
references around within the same column, and of course in the "new"
column the OFFSET() function still calculates the offsets as it is
told so it differs from the "classic" column.
* Indicator_2: range references usually can't be adjusted if they are of
the same direction as the reordering and within data, imagine the
content of A1:A3 was not {1,2,3} but {4,2,6} instead, where should it
point to after reordering? Doing it here in this case would be
a special special case.
* abs / absData: the observed behavior is exactly the difference of
UpdateReferenceOnSort=TRUE, references that point into the reordered
range are updated to keep a reference to the same data. If that is not
wanted then UpdateReferenceOnSort=FALSE must be used. So it is not
correct to say that the behavior would be wrong in the TRUE case. This
is why the option was implemented.
* Average: updating in the case of UpdateReferenceOnSort=FALSE is a bug,
references within the reordered range that are pointing to ranges
within the reordered range of the same reordering direction must be
kept relative to the reordered data. This is fixed in master, 4.3.4,
4-3 (to-be 4.3.5) and does not yet occur in 4.2.7, but did occur in
4-2 (to-be 4.2.8 if released at all). Cherry-picking another commit
from bug 85215 resolved that.
* RefInside: same reason as on the Average sheet, fixed with the commits
for bug 85215.
* Indicator: I didn't wrap my head around that one yet.. but it appears
to me that the expectations are wrong.
* Stock_Management: a case of why UpdateReferenceOnSort=TRUE was
invented. It is misleading to title the other cases as wrong. If
a reference updated is wanted for UpdateReferenceOnSort=FALSE then
absolute references must be used, i.e. =C$3+C$4, this is the same in
all major spreadsheet implementations.
* Bug62490: same as Stock_Management, use absolute references, as
a workaround if already relateive references are used then use
UpdateReferenceOnSort=TRUE.
* Ubuntu: apparently Ubuntu for 4.2.7 applied a patch of 4-2 that needs
two other patches to follow-up, namely the ones already mentioned
above for bug 85215 that also went into 4-2
* Users: so we're fine here? GREAT!
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
