Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
gnumeric
gnumeric
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 376
    • Issues 376
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 2
    • Merge Requests 2
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • CI / CD
    • Repository
    • Value Stream
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • GNOME
  • gnumericgnumeric
  • Issues
  • #503

Closed
Open
Opened Jul 02, 2020 by Bark Mallard@markjballard

Gnumeric cannot format range of cells if they already contain inconsistent formats

Cannot alter set the format for a range of cells if the range already contains cells with differing formats.

Say you have two rows of cells, both formatted to Number. But you have a few rows formatted to General. You decide to format all cells in both columns as General. So you select the columns and choose Format Columns. The Number tab will be greyed out, and its value shown as General. Since it is greyed out, it is not possible to set the format.

The result is that the cells must be formatted individually or subranges of like cells must be selected to change their formats. But since the underlying format might not be visible without opening the format dialog, it makes changing the format extremely onerous.

Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: GNOME/gnumeric#503