After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 82931 - Sorting relative refs should be invariant if it has a sheet
Sorting relative refs should be invariant if it has a sheet
Status: RESOLVED DUPLICATE of bug 59144
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Normal minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2002-05-24 20:38 UTC by Jon Kåre Hellan
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Example spreadsheet. (1.39 KB, application/x-gnumeric)
2002-05-24 20:39 UTC, Jon Kåre Hellan 		Details
More complicated example (2.45 KB, application/x-gnumeric)
2002-05-26 08:56 UTC, Jon Kåre Hellan 		Details

Description Jon Kåre Hellan 2002-05-24 20:38:44 UTC 
Here's the example sheet:

2  =A1
1  =A2

Select B1:B2 and sort it in ascending order. It should change from
    2
    1
to
    1
    2
but doesn't.

In 1.0.6, this works as expected.
Comment 1 Jon Kåre Hellan 2002-05-24 20:39:55 UTC 
Created attachment 8713 [details]
Example spreadsheet.
Comment 2 Jody Goldberg 2002-05-25 03:50:48 UTC 
This is not a bug.
I have intentionally removed this functionality and intend to disable it in
1.0.7.  An extra flag was introduced to solve exactly this report, which looks
completely rational.  However, later on a bug came in where relative reference
were changing unexpectedly that stemed from this.  After much head scratching
we decided that sorting a relative reference should not do anything special.

See 59144 for details.
Comment 3 Jon Kåre Hellan 2002-05-26 08:56:20 UTC 
Created attachment 8731 [details]
More complicated example
Comment 4 Andreas J. Guelzow 2002-05-27 14:18:02 UTC 
The complicated example definitely does show a bug. Whatever we are
doing to the formulas in the first column doesn't make any sense.
Comment 5 Jody Goldberg 2002-05-28 14:52:28 UTC 
head is now the same as 1.0
Comment 6 Jody Goldberg 2002-06-04 14:32:41 UTC 
It looks like we do need the relative reference relocation patch.  The trick is
that we only need it _sometimes_.  As far as I can tell XL uses the heuristic
that sorting relative references keeps them invariant if they select a sheet.

eg
    A1 is not corrected for motion (and changes)
but
    foo!A1 is corrected to remain invariant.

I'll look into supporting this in 1.1
Comment 7 Jody Goldberg 2002-06-13 17:27:57 UTC 

*** This bug has been marked as a duplicate of 59144 ***