Cell formats allow you to change the way cell data appears in the spreadsheet. It is important to keep in mind that it only alters the way the data is presented, and does not change the value of the data.
The formatting options allows for monetary units, scientific options, dates, times, fractions,and more. Positive and negative values can have different colors and formats for aiding in keeping track of values. There are also a large variety of date and time formats for virtually any time and date format one can think of.
To change the formatting style for a cell or a range of cells, you only need to select the range of cells (see the section called Editing cells using the selection in Chapter 1) where you want to apply/change the format and then select from the Format/Cells/Numbers menu (or from the context sensitive popup menu bound to the right mouse button) the appropriate format.
The quickest way to access the cell format dialog is to use its keyboard shortcut, Ctrl-1. This is equivalent to selecting the cell format item from the menus.
Gnumeric provides a wide range of predetermined formatting styles. These formatting styles are shown by category in the Cell/Style dialog box. Just choose one of the display formats and accept the changes to change the display format for your cells.
If none of the predetermined formatting styles fits your needs, you can define your own number formatting style by using a custom formatting expression: the custom formatting expressions give you more flexibility in number display.
The number formatting dialog (see Figure 3-1 ) provides a wide range of options for formatting numbers. The primary use of the dialog is to select from one of the many preset number formatting rules. These formatting styles should be more than adequate for the vast majority of cases. If none of these meet the needs of the user, it is possible to create your own formats.
The main dialog is split into two list, a list of formatting categories, and a list of formats in each category.
There is also a Sample output of what the new formatting should look like, and the example of what the formatting code looks like.
Any cell can use any font that is availble to Gnumeric. This includes font attributes like bold, italics, etc as well as font size.
To change the font for cells, simply open the file format dialog (see the section called The Format Dialog), and select the font tab. This will open the standard Gnome font selection dialog.
Reference docs on how to use the font dialog here.
To change a cells font
Select the cell or range of cell that the font needs to be changed in.
Open the cell format dialog. This dialog can be opened from the FormatCells menu, with the Ctrl-1, or from right-clicking (MB3) and choosing the Cell Format menu option.
Select the font tab in the dialog box notebook. This will open the font selection part of the dialog. See Figure 3-2 for a look at the dialog.
TELL PEOPLE HOW TO USE THE FONT DIALOG HERE
For simply changing a cell's format to be Bold or Italics, there are buttons on the toolbar for doing this quickly. See the section called Cell Formatting options on the buttonbar.
Any cell in gnumeric can be assigned a color for the text, the background, or the border. It is also possible to add a pattern to the background of the cell. FIXME: Setting the color and pattern for the background currently is not enabled.
The Text color area is use to set an optional color for the cell contents. The default is to not assign a color to the cell and rely on the global defaults. To give a cells contents a color, select the Use This Color and then click on the Color Selector Button to open the Gnome color dialog. Select a color and press Okay to return to the cell color dialog.
Changing a cell's text color
Select the cell or range of cell that the color needs to be changed in.
Open the cell format dialog. This dialog can be opened from the FormatCells menu, with the Ctrl-1, or from right-clicking (MB3) and choosing the Cell Format menu option.
Select the Color tab in the dialog box notebook. This will open the font selection part of the dialog. See Figure 3-3 for a look at the dialog.
TELL PEOPLE HOW TO USE THE COLOR PICKER HERE
The background configuration includes options for setting the cells background to either a solid color or a pattern.
To set the background of the cell to a solid color, click on the use solid color, and choose a color from the color selector dialog.
To set a pattern for the cell background, click on the use a pattern button and select a pattern by clicking on the pattern the user wants. there is a solid black border that should outline the currently selected pattern.
Note: the background options are not implemented yet.
The contents of cell can be justified and aligned as needed. There are several justification options. See Figure 3-4.
Changing a cells justification.
Select the cell or range of cell that the justification needs to be changed in.
Open the cell format dialog. This dialog can be opened from the FormatCells menu, with the Ctrl-1, or from right-clicking (MB3) and choosing the Cell Format menu option.
Select the Alignment tab from the notebook tabs. This will open the font selection part of the dialog. See Figure 3-5 for a look at the dialog.
Choose a horizontal and Vertical justification type by clicking on one of the buttons. Only one choice from each option group is allowed.
Horizontal justitfication options.
The standard default justification. This equates to right justifying numbers and formulas, and left justifying strings and labels.
Left justitify all cell contents.
Center all cell contents.
Right justify all cell contents.
Fill the cell with the contents. This will repeat the cells contents to fill the space.
Left justify and verticaly center the cells contents.
Vertical Justification options.
Align the top of the cells contents with the top of the cell.
Center the cells contents vertically. Equally space between the top and bottom
Align the contents of the cell with the bottom of the cell.
FIXME FIXME
For frequently applied formats, there are some quick access buttons on the button bar.
See the section called The Button Bar in Chapter 4 for more detail one what these buttons do.