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
The three cell types.
The structure of a NumericBase solution is determined by the formulas that resides in the cells of the solution. Cells can be:
  • Cell with a formula.
  • Cell without a formula - unlike other spreadsheets, this does not prevent the cell from having a value.
  • Cell with a formula that overrides the default formula for the cell. The default formula for the cell is usually the formula at the base row at same column. Other  types of default formula are due to table inheritance, and due to base row formula.
Color coding.
This distinction is important for a quick understanding of the solution. The color coding features enable you to quickly distinguish between the three cell types. The color-coding feature is illustrated in the following screenshot:


Screenshot: The color coding feature.

More color coding
Another color (yellow), is reserved to overridden columns in instantiated tables.
(back) (Next - Hide Repeating values)
Contact info Copyright © 2001-2003 by Symbol Click