On 2013-06-07 11:38 AM, Luuk <firstname.lastname@example.org> wrote:
This seems to be a bug.
The reference to you first sheet (Main.A2) should be to the same cell,
even after sorting your data in this first sheet.
It does, so no bug... but that is the problem.
I'll try a simpler and more specific example...
Assume a workbook containing multiple sheets: 'Main', Team1', 'Team2', etc.
Sheet 'Main' has the Sales numbers for all SalesReps, and each Rep is on
a single Team, with their numbers on their Team sheet referenced from/by
the numbers on the 'Main' sheet.
Sheet 'Team1' has SalesRep1 on row 4, with 'Team1.B4' having a reference
value of 'Main.B4', reflecting his January Sales numbers of $10,000,
with 'Main.C4' reflecting Feb Sales, etc, and with 'Main.N4' showing his
Year to Date numbers (summary of 'Main.B4:M4).
Now, I sort sheet 'Main' on Column N (Year to Date) in descending order
(so the top performing Sales Rep will be at the top).
'Main.B4' now contains the Sales Figures for some other Sales Rep, but
'Team1.B4', which is still the row for SalesRep1 on the Team1 sheet, is
showing the Sales Figures for 'Main.B4', which is NOT the Jan Sales
numbers for SalesRep1. The reference to 'Main.B4' did not change when
the data on Main sheet was sorted.
As I said, I believe this is by design, but it is certainly not what I
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy