Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On 2013-06-07 11:38 AM, Luuk <> 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 want/need...


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.