GNOME Bugzilla – Bug 750271
Adding rows breaks conditional formatting
Last modified: 2015-12-01 12:36:35 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.
Confirmed. 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
If I try to open the file with Gnumeric 1.12.6 I get a segmentation fault.
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.
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.
Excellent! Thank you for fixing it.