Support Color Column in Worksheet


Version: 2021

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-22137


In Column Properties dialog, set column format as Color.

  • support HTML color code. Cell background will be colored accordingly.

  • Mini toolbar to set color

  • Mini toolbar of column to save Color List or palette (system variable @MPS is the threshold to save as palette. E.g. default is 20. So if there are more than 20 colors in the column, it will be saved as palette. If less than 20 colors, it will be saved as color list.)

  • Set column as Color to show calculated color based on R, G and B values.

  • Add Display Color Value checkbox under Format in column property dialog if column format is Color.

  • Add Create Color List from Column… in Custom dropdown list under Color fly-out single tab.