XML Marker Spereadsheet calculator products
Home Overview More details Examples Download Faq
Overview
Entering data
The project window
The base row
Overriding the base row
Color coding
Hide Repeating values
The summary row.
Sorting
Referring to other cells
Range formula
Circular dependency
View source
Using more than one table
Import, export, and delete
Windowing: Optimized Mode
Windowing: Solution layout
Overriding the base row
A formula at the base row controls all the values of the column. You can override this behavior for a specific cell. To do this, you can type your overriding formula at the desired cell - see the following animated screenshot for an example.


Animated Screenshot: Overriding by entering a formula at a cell.

After we entered the formula at the cell, NumericBase uses this formula, instead of the formula at the base row, to calculates the value for the cell, as shown in the following screenshot.


Screenshot: NumericBase uses the overriding formula.

Remove the overriding formula.
To remove this overriding formula, simply delete the formula from the cell - as shown in the following animated screenshot.


Animated screenshot: removing the overriding formula from the cell
(back) (Next - Color coding)
Contact info Copyright © 2001-2003 by Symbol Click