conditional formatting recalculation
Setup:
Use the latest .gnumeric to open the attached simple spreadsheet file.
It has two examples of conditional formatting;
for example, cell D2 is red if its value is ≥ E$1.
Observed behavior 1:
Change the value in cell E1.
Observe no change in the formatting, contrary to expectations.
Evidently the formatting is not being recalculated.
Observed behavior 2:
Hit the F9 key.
Observe no change in the formatting, contrary to expectations.
Evidently the formatting is still not being recalculated.
Observed behavior 3:
Select all of column D.
Copy and paste it onto itself.
Observe that this does cause the formatting to get updated.
File save, file quit.
At this point observe two copies of the following warning:
** (/usr/src/gnome/gnumeric/src/.libs/gnumeric:355970): WARNING **: 03:40:04.446: We're confused with sheet condition usage.
Observed behavior 4:
Reopen the file.
Select column C, which is completely empty and should be irrelevant.
Edit delete column.
Observe many copies of the following warning:
** (/usr/src/gnome/gnumeric/src/.libs/gnumeric:356809): WARNING **: 03:43:40.656: Removing conditional style we don't have?
Circumstances and dependencies:
This is not observed using the gnumeric version that came with my distro:
gnumeric version '1.12.38'
datadir := '/usr/local/share/gnumeric/1.12.38'
libdir := '/usr/local/lib/gnumeric/1.12.38'
It is however observed using a version compiled from freshly-pulled git sources, in which case it is 100% reproducible.
:; uname -srmo
Linux 5.9.13+ x86_64 GNU/Linux
:; lsb_release -a
LSB Version: core-11.1.0ubuntu2-noarch:cxx-3.0-amd64:cxx-3.0-noarch:cxx-3.1-amd64:cxx-3.1-noarch:cxx-3.2-amd64:cxx-3.2-noarch:cxx-4.0-amd64:cxx-4.0-noarch:cxx-4.1-amd64:cxx-4.1-noarch:graphics-2.0-amd64:graphics-2.0-noarch:graphics-3.0-amd64:graphics-3.0-noarch:graphics-3.1-amd64:graphics-3.1-noarch:graphics-3.2-amd64:graphics-3.2-noarch:graphics-4.0-amd64:graphics-4.0-noarch:graphics-4.1-amd64:graphics-4.1-noarch:printing-11.1.0ubuntu2-noarch:security-11.1.0ubuntu2-noarch
Distributor ID: Ubuntu
Description: Ubuntu 20.04.1 LTS
Release: 20.04
Codename: focal
:; GG --version
gnumeric version '1.12.49'
datadir := '/usr/src/gnome/install/share/gnumeric/1.12.49'
libdir := '/usr/src/gnome/gnumeric'
:; git log
commit 5277f1254eee8ade81cf075aebaaa39bafc94dd3
Date: Mon Dec 14 13:55:48 2020 -0700