SetTextTipAppearance Method

Applies To

fpSpread control

Description

Specifies the appearance of text tips and cell notes.

Syntax

C++

BOOL CSpreadSheet::SetTextTipAppearance(LPCTSTR FontName, short FontSize, BOOL FontBold, BOOL FontItalic, long BackColor, long ForeColor);

Visual Basic

fpSpread.SetTextTipAppearance(ByVal FontName As String, ByVal FontSize As Integer, ByVal FontBold As Boolean, ByVal FontItalic As Boolean, ByVal BackColor As Long, ByVal ForeColor As Long) As Boolean

Parameters

The following parameters are available:

Parameter	Description
FontName	Font name
FontSize	Font size
FontBold	Whether font is boldface
FontItalic	Whether font is italic
BackColor	Background color
ForeColor	Foreground (text) color

Remarks

Use the TextTip property to specify whether and when text tips and cell notes are displayed and how they are positioned. Text tips are displayed for headers or cells in the control when the pointer is over a header or cell. Cell notes are displayed for cells or headers in the control when the pointer is over a cell note indicator, a red square in the upper right corner of the cell.

This method is applied to the entire workbook, including all sheets in the control.

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 specify that the control delays displaying text tips by specifying the number of milliseconds to delay using the TextTipDelay property.

Note: The Spread control uses the Windows ToolTip colors as the default colors for the background and text.

Spread Designer

Choose the Book menu, then the Text Tip menu, select the Text Tip tab, and then choose an item in the Color group box or Font button in the Book Display Settings dialog.

Parameter	Items on Text Tip tab
FontName	Font button; Font combo box in the Font dialog
FontSize	Font button; Size drop-down combo box in the Font dialog
FontBold	Font button; Font Style drop-down list box in the Font dialog
FontItalic	Font button; Font Style drop-down list box in the Font dialog
BackColor	Select BackColor from the drop-down list box under Color
ForeColor	Select ForeColor from the drop-down list box under Color

Return Type

True if successful; otherwise, False.

DLL Correspondence

SSSetTextTip function