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 750271 - Adding rows breaks conditional formatting
Adding rows breaks conditional formatting
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Reported: 2015-06-02 10:29 UTC by Traumflug
Modified: 2015-12-01 12:36 UTC
See Also:
GNOME target: ---
GNOME version: ---

Demo spreadsheet (12.04 KB, application/x-gnumeric)
2015-06-02 10:29 UTC, Traumflug

Description Traumflug 2015-06-02 10:29:46 UTC
Created attachment 304420 [details]
Demo spreadsheet

Steps to reproduce:

1. Open the attached spreadsheet.

2. Right click on row 55 header.

3. Select "Add 1 row" (might be worded differently, it's "1 Zeile einfügen" in German translation).

4. See how all the white and pink cells above change to the same color, dark green.

Did some investigation already:

Conditional formatting for all the colored cells in this area is the same. Looking at cell D52, the third condition is related to D51. After the row insert, it changes to #BEZUG! (unknown). Restoring it to D51 manually also restores the expected function.
Comment 1 Morten Welinder 2015-06-02 17:26:50 UTC

Unrelated, I also see warnings on load:

** (/home/welinder/gnome-src/gnumeric/src/.libs/gnumeric:830): CRITICAL **: go_data_vector_get_str: assertion '(int)i < vec->len' failed

** (/home/welinder/gnome-src/gnumeric/src/.libs/gnumeric:830): CRITICAL **: go_data_vector_get_markup: assertion '(int)i < vec->len' failed
Comment 2 Andreas J. Guelzow 2015-06-19 18:47:40 UTC
If I try to open the file with Gnumeric 1.12.6 I get a segmentation fault.
Comment 3 Morten Welinder 2015-07-17 12:54:54 UTC
Looking at H54, the conditional format depends on two other cells.

1. H$56
2. H53

When we insert a row before current row 55, these get updated to

1. H$57               [correct]
2. #REF               [not even close]

The second reference should have stayed unchanged.
Comment 4 Morten Welinder 2015-12-01 01:44:40 UTC
This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.
Comment 5 Traumflug 2015-12-01 12:36:35 UTC
Excellent! Thank you for fixing it.