Glossary

  A

active sheet

a worksheet in the FpSpread component that currently has focus

See also Working with the Active Sheet.

AJAX (Asynchronous JavaScript and XML)

AJAX is a term that refers to the use of a group of technologies together to provide smarter client-side pages; it is a type of programming architecture for creating interactive Web applications that can update data on a client page by making direct calls to a server without needing to go to the server for the entire page using HTML, CSS, and JavaScript. For more details, refer to the entry in Wikipedia: http://en.wikipedia.org/wiki/AJAX. FarPoint Spread supports AJAX in Microsoft Internet Explorer and Mozilla Firefox browsers.

See also Wikipedia:AJAX.

alternating rows

a style or appearance feature that alternates the background color of rows, as in a ledger.

See also Creating Alternating Rows.

anchor cell

the first cell in a cell span, or in a cell range, which extends from the anchor to the extent

See also span and range.

appearance

the look of the FarPoint Spread component to the user. Sometimes this word is used in a limited sense, as in referring to only the settings in the Appearance class; other times it is used broadly to describe the style and other aspects of the look of the interface.

See also Appearance class, NamedStyle class, StyleInfo class, and Customizing the Appearance.

application tag

See cell tags.

automatic text

the text that appears in header automatically generated by the component; for rows it is typically numbers, for columns it is letters, but you can customize it.

See also Customizing the Default Header Labels.

axis

aspects of the models relating to rows and columns.

See also Understanding the Axis Model and Customizing Rows or Columns.

- letters -                    

  B

binding; bound

See data bound.

block

See range.

border

See cell borders or Spread border.

- letters -                    

  C

cell

the unit of the spreadsheet that contains data.

See also Customizing Appearance of the Cell, Customizing Interaction with Cells, and Cell class.

cell border

border around the individual cell (as opposed to gridlines for the sheet, and an outline around the whole FarPoint Spread component).

See also Customizing Cell Borders and Spread border.

cell note

human-readable information that is useful to the end user that appears when the user leaves the cursor over a cell.

See also Adding a Note to a Cell.

cell span

See spanning.

cell tag

computer-readable information that is useful to the application that is accessing the cell. Sometimes called the application tag. (As cell notes are for human users, cell tags are for applications.)

See also Adding a Tag to a Cell.

cell type

The way a cell handles the cell contents, referring to a specific class in the FarPoint.Web.Spread.CellType namespace; somewhat equivalent to the cell format in Excel.

See also editor, formatter, and renderer. Together, these three define a cell type. See also Managing Cell Types.

child sheet, child view

In a hierarchical spreadsheet, the child sheet or child view is a separate spreadsheet, though it appears under an expanded row of a parent spreadsheet.

See also hierarchy and Displaying Data as a Hierarchy.

column

a vertical set of cells in the spreadsheet. There is a shortcut Column object to allow you to quickly specify members of that object.

See also Customizing the Appearance of Rows and Columns and Column class.

composite (as in style); composing styles

the composition of the inherited or merged styles; as opposed to "direct". GetCompositeInfo returns the style properties "composed" or "merged" into one StyleInfo object that contains all the settings to paint and edit the cell, column, or row, including inherited settings.

See also named styles, direct, and GetCompositeInfo.

conditional format; conditional formatting

setting up the spreadsheet so that the data is either hidden or presented in a particular appearance style based on specified conditions.

See also Conditional Formatting of Cells and ConditionalFormat class.

control

See FpSpread component.

corner

The corner cell in the top left corner of a spreadsheet between the column headers across the top and the row headers along the side.

See also Customizing the Sheet Corner.

cross-sheet reference; cross-sheet referencing

in a multiple-sheet FarPoint Spread component, a formula in a cell can refer to a cell in an entirely different sheet. This allows calculations to make use of data and formulas on any of the sheets in a FarPoint Spread component.

See also Sheet References in a Formula and FpSpread.EnableCrossSheetReference property.

custom function

function defined by you as opposed to a built-in function that is predefined in the product.

See also Creating and Using a Custom Function.

custom name

name defined by you. (There are no built-in names.)

See also Creating and Using a Custom Name.

- letters -                    

  D

data bound (data binding)

describing the connection of FarPoint Spread component to data in a data set (typically a database).

See also Managing Data Binding.

designer

See Spread Designer.

direct (as in styles)

styles that are not inherited or merged, but assigned directly; as opposed to composite. GetDirectInfo returns the style properties that have been set for the specified cell, column, or row directly and does not return any settings that are set for higher levels.

See also named styles, composite, and GetDirectInfo.

- letters -                    

  E

edit mode

when a text editor is open in a cell, and the end user is editing text in that cell, this is edit mode, as opposed to simply display mode.

See also EditModeReplace property, EditRow property, OperationMode property, OperationMode enumeration.

editor

The control in the cell that allows the user to edit the cell contents.

See also formatter and renderer. Together, these three define a cell type. See also Managing Cell Types.

expando

The ability to extend objects by adding abitrary properties (called expando properties).

See also IExpandoSupport interface.

expression

a string consisting of operands and operators for performing a calculation or other operation.

See also Expression class.

external reference

a pointer to a cell (or range of cells) that explicitly states the sheet name, so that the reference can be to a location on an entirely different sheet. While the reference may be a sheet external to the one on which the reference appears, it does not have to be. By adding the sheet name to the reference, the external reference allows cross-sheet references of cells and ranges. External references can be cell references (for individual cells) and range references (for a contiguous range of cells).

See also reference and Cell References in a Formula.

- letters -                    

  F

formatter

The control in the cell that formats the contents.

See also editor and renderer. Together, these three define a cell type. See also Managing Cell Types.

formula

an expression in a cell that can be made up of functions, operators, and constants.

See also Formula Reference.

FpSpread component

the ASP.NET component that is the heart of the FarPoint Spread product.

See also FpSpread class and Product Overview.

frozen columns; frozen rows

columns or rows of cells that are not scrollable by the user, as if "frozen".

See also Freezing Rows or Columns.

function

either a built-in function or a custom function, that performs a specified calculation.

See also Formula Reference.

- letters -                    

  G

gray area

the area of the spreadsheet that is not defined by cells or headers, the empty area

See also Setting the Background Color for the Sheet.

grid lines

the horizontal and vertical lines that are drawn to delimit cells; different than cell borders.

See also Displaying Grid Lines on the Sheet.

grouping

a way arranging the display of rows of data in a spreadsheet based on a selected column; a feature that allows users to control that specific display of data. Often referred to as Outlook-style grouping.

See also Grouping Rows and the Grouping event.

- letters -                    

  H

header

the cells that are either at the top or the far left that label the rows and columns in a spreadsheet

See also Customizing the Appearance of Headers.

hierarchy

the nesting of spreadsheets, or at least rows of data within a row.

See also child sheet and Working with Hierarchical Data Display.

- letters -                    

  I

image

See picture.

iteration

the way or number of times the FarPoint Spread component recurses on (recalculates) a function to obtain an optimal value.

See also Using a Circular Reference in a Formula.

- letters -                    

  L

locked cells

cells in the spreadsheet that are unavailable for editing by the end user. You must use both Cell.Locked property and SheetView.Protect property.

See also Locking a Cell.

- letters -                    

  M

merge, merging

automatic spanning of cells with identical content

See also span, spanning and Allowing Cells to Merge Automatically.

model, models

underlying structures in FarPoint Spread that allow you flexibility and customization by allowing you to manage the underlying objects

See also Using Sheet Models.

- letters -                    

  N

name

See custom name.

named style

collection of appearance settings of a cell or range of cells defined by you; distinct from the default styles that are pre-defined and built into Spread.

See also Creating and Applying a Style for Cells.

note

See cell note.

- letters -                    

  O

operator

in a formula, that performs an operation between two operands, such as multiplication of two numbers or expressions.

See also Formula Reference.

order of precedence

See precedence.

- letters -                    

  P

parent, parent object

higher-level (in terms of inheritance) of a object

See also Object Parentage and Working with Hierarchical Data Display.

parent style

higher-level (in terms of inheritance) of a style, a set of appearance properties of a cell

See also parent and named style.

picture

an image or graphic that is used in the cell or as a background to a cell

See also

precedence

the order in which cell appearance properties are set.

See also Object Parentage.

- letters -                    

  R

range

specific contiguous group of cells.

See also Creating a Range of Cells.

reference

a pointer to a cell (or range of cells) typically to another location on this sheet (unless it is an external reference. References can be cell references (for individual cells) and range references (for a contiguous range of cells).

See also external reference, reference style, and Cell References in a Formula.

reference style

the way to reference another cell in a formula; either absolute or relative.

See also Specifying a Cell Reference in a Formula and Cell References in a Formula.

renderer

The control that renders or paints the display of the cell contents.

See also editor and formatter. Together, these three define a cell type. See also Managing Cell Types.

row

a horizontal set of cells in the spreadsheet. There is a shortcut Row object to allow you to quickly specify members of that object.

See also Customizing the Appearance of Rows and Columns and Row class

- letters -                    

  S

selection, selecting

a range of cells that are chosen by the user for a common operation or action.

See also Customizing Selection of Cells.

sheet

a worksheet in a FarPoint Spread component that can have its own appearance and user-interaction settings; a spreadsheet; denoted by a sheet name tab in the component

See also Customizing the Appearance of a Sheet.

sheet corner

See corner.

sheetview

See sheet.

shortcut objects

a built-in set of code objects in the FarPoint Spread namespace for easily accessing the FarPoint Spread objects.

See also Using Shortcut Objects.

skin

collection of appearance settings for a whole sheet defined by you; distinct from the default skins that are pre-defined and built into Spread.

See also Creating a Custom Skin for a Sheet.

span, spanning

joining of multiple cells into one cell.

See also merge, merging and Creating a Span of Cells.

Spread border

the outline around the entire FarPoint Spread component on the form (as distinct from the border around individual cells).

See also Customizing the Outline of the Component.

Spread Designer

the designer application with a user interface that allows you to set up many of the appearance settings of a FarPoint Spread component and preview them as well.

See also Working with Spread Designer.

spreadsheet

See sheet.

.SS7

File type for saving a FarPoint Spread to the proprietary Spread XML format

See also Saving to a Spread XML File and Opening a Spread XML File.

style

See named style.

- letters -                    

  T

tag

See cell tags.

text

formatted data, ready for presentation to the user, as opposed to unformatted data (value) that is stored in Spread.

See also value and Formatted versus Unformatted Data .

- letters -                    

  V

value

unformatted data that is stored in Spread, as opposed to formatted data (text) ready for presentation to the user.

See also text and Formatted versus Unformatted Data .

validating, validation

in a cell in Spread, what is done to data to check that the user input matches the allowed input of a particular cell type.

volatile function

a particular type of built-in function that is recalculated when there is any change to the Spread.

See also Formula Reference.

- letters -                    

  W

word wrap; wrap

a property of cells that allow lines of text to break automatically to succeeding lines when they exceed the width of the editor control.

See also AllowWrap property.

worksheet

See sheet or Working with Hierarchical Data Display.

  .NET

.NET Glossaries

For .NET terminology that is assumed in the use of this product, refer to these third-party glossaries available on the Web:

See also Developer.com .NET Glossary.

See also Microsoft .NET Glossary.

  Web

Web Glossaries

For Web terminology that is assumed in the use of this product, refer to these third-party glossaries available on the Web:

See also W3C Schools Glossary.