Spread 8.0 Documentation
CellNote Property
Support Options
ActiveX Reference > ActiveX Properties > CellNote Property

Glossary Item Box

CellNote Property


See Also    DLL    Example

A pplies To

fpSpread control

Description

Sets or returns a comment for the cell. This property is available at run time only.

Syntax

C++

CString CSpreadsheet::GetCellNote( );
void CSpreadsheet::SetCellNote(LPCTSTR Value);

Visual Basic

[form.]fpSpread.CellNote[ = text$]

Remarks

Cells with notes display a cell note indicator, a red square in the upper right corner of the cell, as shown in the following figure.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

Notes:
  • Use caution in choosing a red color as the background for a cell that could contain a cell note. The red cell note indicator could be invisible against a red background.
  • If you set the CellNoteIndicator property to either 0 (ShowAndFireEvent) or 1 (ShowAndDoNotFireEvent) and the AllowCellOverflow property to True, the cell note indicator will appear in the cell that contains the original text.

Cell notes are displayed in a similar manner as text tips. When the pointer is over the cell note indicator, the cell note text displays.

When the control displays the cell note, the TextTipFetch event occurs. To display the cell note, set the TextTip property to a value other than 0 (Off). You can display both text tips and cell notes for a cell. You can use the IsFetchCellNote method within the TextTipFetch event to determine if the event was fired for a cell note or a text tip and to show and modify the cell notes or text tips accordingly. You can use the SetTextTipAppearance method to further customize the cell notes.

The cell note indicator does not appear when the cell is in edit mode. You can use the CellNoteIndicator property to hide the cell note indicator and to control whether the TextTipFetch event occurs when the pointer is over the cell note indicator.

Spread Designer

Choose the Cell menu, then the Note menu, and then the Cell Note tab, and then type in the Note edit box in the Cell Settings dialog box.

Note: You must turn text tips on to display cell notes. For more information, see Providing Cell Notes.

Data Type

String

See Also

Providing Cell Notes

AllowCellOverflow, CellNoteIndicator, Sheet, TextTip properties

TextTipFetch event

GetTextTipAppearance, IsFetchCellNote, SetTextTipAppearance methods

DLL Correspondence

SSGetCellNote, SSSetCellNote, SSSetCellNoteRange functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.