Spread 8.0 Documentation
SetTextTipAppearance Method
Support Options
ActiveX Reference > ActiveX Methods > SetTextTipAppearance Method

Glossary Item Box

SetTextTipAppearance Method


See Also    DLL    Example

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.

See Also

Specifying the Appearance of Text Tips
Providing Cell Notes

CellNote, CellNoteIndicator, TextTip, TextTipDelay properties

TextTipFetch event

GetTextTipAppearance, IsFetchCellNote methods

DLL Correspondence

SSSetTextTip function

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