Skip to content
GitLab
  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 380
    • Issues 380
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 2
    • Merge requests 2
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOME
  • gnumericgnumeric
  • Issues
  • #547
Closed
Open
Created Dec 15, 2020 by JohnDenker@JohnDenker

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.

conditional-format.gnumeric

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
Assignee
Assign to
Time tracking