Skip to content
GitLab
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 390
    • Issues 390
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 2
    • Merge requests 2
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and 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
  • GNOMEGNOME
  • gnumericgnumeric
  • Issues
  • #503
Closed
Open
Issue created 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
Time tracking