- GC
- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.DataCharts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.DataRange
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Sheets.GanttSheet
- Collaboration
- GC.Spread.Excel
GC.Spread.Sheets.CellTypes.HyperLink
Class: HyperLink
Hierarchy
-
↳
HyperLink
Table of contents
Constructors
Properties
Methods
- activateEditor
- activeOnClick
- createEditorElement
- deactivateEditor
- focus
- format
- fromJSON
- getAutoFitHeight
- getAutoFitWidth
- getEditorValue
- getHitInfo
- isEditingValueChanged
- isImeAware
- isReservedKey
- linkColor
- linkToolTip
- onClickAction
- paint
- paintContent
- parse
- processKeyDown
- processKeyUp
- processMouseDown
- processMouseEnter
- processMouseLeave
- processMouseMove
- processMouseUp
- selectAll
- setEditorValue
- target
- text
- toJSON
- updateEditor
- updateEditorContainer
- updateImeMode
- visitedLinkColor
Constructors
constructor
• new HyperLink()
Represents the hyperlink cell.
example
var cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FF2235");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
activeSheet.getCell(1, 1).cellType(cellType).value("http://www.spreadjs.com/");
activeSheet.getCell(1, -1).height(30);
example
var cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FF2235");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
activeSheet.getCell(0, 2).cellType(cellType).value("formula.html");
Overrides
Properties
typeName
• typeName: string
Represents the type name string used for supporting serialization.
Inherited from
Methods
activateEditor
▸ activateEditor(editorContext, cellStyle, cellRect, context?): void
Activates the editor, including setting properties or attributes for the editor and binding events for the editor.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
cellStyle |
Style |
The cell's actual style. |
cellRect |
Rect |
The cell's layout information. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
activeOnClick
▸ activeOnClick(value?): any
Gets or sets whether to move to the active cell when clicked.
example
//This example uses the activeOnClick method.
var h1 = new GC.Spread.Sheets.CellTypes.HyperLink();
h1.text("SpreadsJS");
h1.linkToolTip("link to SpreadJS Web page");
h1.linkColor("rgb(0, 100, 200)");
h1.visitedLinkColor("rgb(0, 200, 100)");
h1.activeOnClick(true);
activeSheet.setCellType(1, 1, h1);
activeSheet.getCell(1, 1, GC.Spread.Sheets.SheetArea.viewport).value("http://www.spreadjs.com/").hAlign(GC.Spread.Sheets.HorizontalAlign.center);
Parameters
| Name | Type | Description |
|---|---|---|
value? |
boolean |
Whether to move to the active cell when clicked. |
Returns
any
If no value is set, returns a value that indicates whether to move to the active cell; otherwise, returns the hyperlink cell type.
createEditorElement
▸ createEditorElement(context?): HTMLElement
Creates a DOM element then returns it.
Parameters
| Name | Type | Description |
|---|---|---|
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
HTMLElement
Returns a DOM element.
Inherited from
deactivateEditor
▸ deactivateEditor(editorContext, context?): void
Deactivates the editor, such as unbinding events for editor.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
focus
▸ focus(editorContext, context?): void
Focuses the editor DOM element.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
format
▸ format(value, format, formattedData?, context?): string
Formats a value with the specified format to a string.
Parameters
| Name | Type | Description |
|---|---|---|
value |
any |
The object value to format. |
format |
string | GeneralFormatter |
The format. |
formattedData? |
FormattedData |
the formatted data. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
string
Returns the formatted string.
Inherited from
fromJSON
▸ fromJSON(settings): void
Loads the object state from the specified JSON string.
Parameters
| Name | Type | Description |
|---|---|---|
settings |
any |
The cell type data from deserialization. |
Returns
void
Inherited from
getAutoFitHeight
▸ getAutoFitHeight(value, text, cellStyle, zoomFactor, context?): number
Gets a cell's height that can be used to handle the row's automatic fit.
Parameters
| Name | Type | Description |
|---|---|---|
value |
any |
The cell's value. |
text |
string |
The cell's text. |
cellStyle |
Style |
The cell's actual value. |
zoomFactor |
number |
The current sheet's zoom factor. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
number
Returns the cell's height that can be used to handle the row's automatic fit.
Inherited from
getAutoFitWidth
▸ getAutoFitWidth(value, text, cellStyle, zoomFactor, context?): number
Gets a cell's width that can be used to handle the column's automatic fit.
Parameters
| Name | Type | Description |
|---|---|---|
value |
any |
The cell's value. |
text |
string |
The cell's text. |
cellStyle |
Style |
The cell's actual value. |
zoomFactor |
number |
The current sheet's zoom factor. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
number
Returns the cell's width that can be used to handle the column's automatic fit.
Inherited from
getEditorValue
▸ getEditorValue(editorContext, context?): any
Gets the editor's value.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
any
Returns the editor's value.
Inherited from
getHitInfo
▸ getHitInfo(x, y, cellStyle, cellRect, context?): IHitTestCellTypeHitInfo
Gets the cell type's hit information.
Parameters
| Name | Type | Description |
|---|---|---|
x |
number |
x-coordinate of pointer's current location relative to the canvas. |
y |
number |
y-coordinate of pointer's current location relative to the canvas. |
cellStyle |
Style |
The current cell's actual style. |
cellRect |
Rect |
The current cell's layout information. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
Returns an object that contains the x, y, row, col, cellRect, and sheetArea parameters, and a value to indicate isReservedLocation.
isReservedLocation is true if the hit test is in a special area that the cell type needs to handle; otherwise, false.
Inherited from
isEditingValueChanged
▸ isEditingValueChanged(oldValue, newValue, context?): boolean
Whether the editing value has changed.
Parameters
| Name | Type | Description |
|---|---|---|
oldValue |
any |
Old editing value. |
newValue |
any |
New editing value. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
true if oldValue equals newValue; otherwise, false.
Inherited from
isImeAware
▸ isImeAware(context?): boolean
Whether this cell type is aware of IME.
Parameters
| Name | Type | Description |
|---|---|---|
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
true if the cell type is aware of IME; otherwise, false.
Inherited from
isReservedKey
▸ isReservedKey(e, context?): boolean
Whether the cell type handles the keyboard event itself.
Parameters
| Name | Type | Description |
|---|---|---|
e |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
Returns true if the cell type handles the keyboard event itself; otherwise, false.
Inherited from
linkColor
▸ linkColor(value?): any
Gets or sets the color of the hyperlink.
example
//This example creates a hyperlink cell.
cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FF2235");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
activeSheet.getCell(1, 1).cellType(cellType).value("http://www.spreadjs.com/");
activeSheet.getCell(1, -1).height(30);
Parameters
| Name | Type | Description |
|---|---|---|
value? |
string |
The hyperlink color. |
Returns
any
If no value is set, returns the hyperlink color; otherwise, returns the hyperLink cell type.
linkToolTip
▸ linkToolTip(value?): any
Gets or sets the tooltip for the hyperlink.
example
//This example creates a hyperlink cell.
cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FF2235");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
activeSheet.getCell(1, 1).cellType(cellType).value("http://www.spreadjs.com/");
activeSheet.getCell(1, -1).height(30);
Parameters
| Name | Type | Description |
|---|---|---|
value? |
string |
The tooltip text. |
Returns
any
If no value is set, returns the tooltip text; otherwise, returns the hyperLink cell type.
onClickAction
▸ onClickAction(value?): any
Gets or sets the callback of the hyperlink, If execute the function will represent the context for the callback.
example
//This example sets the tab color when selecting the hyperlink.
var h2 = new GC.Spread.Sheets.CellTypes.HyperLink();
h2.text("set sheet tab style");
h2.linkToolTip("set sheet tab style");
h2.linkColor("blue");
h2.visitedLinkColor("#FF2235");
activeSheet.getCell(2, 1).cellType(h2).value("set sheet tab style").hAlign(GC.Spread.Sheets.HorizontalAlign.center);
h2.activeOnClick(true);
h2.onClickAction(function () {
var setSheetTabColor = {
canUndo: true,
execute: function (context, options, isUndo) {
activeSheet.name("Hyperlink");
activeSheet.options.sheetTabColor = "red";
}
};
var commandManager = spread.commandManager();
var commandName = "setSheetTabStyle";
commandManager.register(commandName, setSheetTabColor, null, false, false, false, false);
commandManager.execute({cmd: commandName})
});
Parameters
| Name | Type | Description |
|---|---|---|
value? |
Function |
The callback of the hyperlink. |
Returns
any
If no value is set, return a value that indicates the callback of the hyperlink; otherwise, returns the hyperlink cell type.
paint
▸ paint(ctx, value, x, y, w, h, style, context?): void
Paints a cell on the canvas.
Parameters
| Name | Type | Description |
|---|---|---|
ctx |
CanvasRenderingContext2D |
The canvas's two-dimensional context. |
value |
any |
The cell's value. |
x |
number |
x-coordinate relative to the canvas. |
y |
number |
y-coordinate relative to the canvas. |
w |
number |
The cell's width. |
h |
number |
The cell's height. |
style |
Style |
The cell's actual style. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
paintContent
▸ paintContent(ctx, value, x, y, w, h, style, context?): void
Paints the cell content area on the canvas.
Parameters
| Name | Type | Description |
|---|---|---|
ctx |
CanvasRenderingContext2D |
The canvas's two-dimensional context. |
value |
any |
The cell's value. |
x |
number |
x-coordinate relative to the canvas. |
y |
number |
y-coordinate relative to the canvas. |
w |
number |
The cell content area's width. |
h |
number |
The cell content area's height. |
style |
Style |
The cell's actual style. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
parse
▸ parse(text, formatStr, context?): any
Parses the text with the specified format string to an object.
Parameters
| Name | Type | Description |
|---|---|---|
text |
string |
The parse text string. |
formatStr |
string |
The parse format string. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
any
The parsed object.
Inherited from
processKeyDown
▸ processKeyDown(event, context?): boolean
Processes key down in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
event |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processKeyUp
▸ processKeyUp(event, context?): boolean
Processes key up in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
event |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseDown
▸ processMouseDown(hitInfo): boolean
Processes mouse down in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseEnter
▸ processMouseEnter(hitInfo): boolean
Processes mouse enter in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseLeave
▸ processMouseLeave(hitInfo): boolean
Processes mouse leave in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseMove
▸ processMouseMove(hitInfo): boolean
Processes mouse move in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
processMouseUp
▸ processMouseUp(hitInfo): boolean
Processes mouse up in display mode.
Parameters
| Name | Type | Description |
|---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
Returns
boolean
Returns true if the process is successful; otherwise, false.
Inherited from
selectAll
▸ selectAll(editorContext, context?): void
Selects all the text in the editor DOM element.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
setEditorValue
▸ setEditorValue(editorContext, value, context?): void
Sets the editor's value.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
value |
any |
The value returned from the active cell. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
target
▸ target(value?): any
Gets or sets the type for the hyperlink's target.
example
//This example creates a hyperlink cell.
var cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FFFF00");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
cellType.target(GC.Spread.Sheets.CellTypes.HyperLinkTargetType.self);
activeSheet.getCell(0, 2).cellType(cellType).value("http://www.spreadjs.com/");
Parameters
| Name | Type | Description |
|---|---|---|
value? |
HyperLinkTargetType |
The hyperlink's target type. |
Returns
any
If no value is set, returns the hyperlink's target type; otherwise, returns the hyperLink cell type.
text
▸ text(value?): any
Gets or sets the text string for the hyperlink.
example
//This example creates a hyperlink cell.
var cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FFFF00");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
cellType.target(GC.Spread.Sheets.CellTypes.HyperLinkTargetType.self);
activeSheet.getCell(0, 2).cellType(cellType).value("http://www.spreadjs.com/");
Parameters
| Name | Type | Description |
|---|---|---|
value? |
string |
The text displayed in the hyperlink. |
Returns
any
If no value is set, returns the text in the hyperlink; otherwise, returns the hyperLink cell type.
toJSON
▸ toJSON(): any
Saves the object state to a JSON string.
Returns
any
The cell type data.
Inherited from
updateEditor
▸ updateEditor(editorContext, cellStyle, cellRect, context?): Rect
Updates the editor's size.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
cellStyle |
Style |
The cell's actual style. |
cellRect |
Rect |
The cell's layout information. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
Returns the new size for cell wrapper element, it should contain two properties 'width' and 'height'.
Inherited from
updateEditorContainer
▸ updateEditorContainer(editorContext, editorBounds, cellStyle): void
Updates the cell wrapper element size.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
editorBounds |
Rect |
The cell wrapper element's new size. |
cellStyle |
Style |
The cell's actual style. |
Returns
void
Inherited from
updateImeMode
▸ updateImeMode(editorContext, imeMode, context?): void
Updates the editor's ime-mode.
Parameters
| Name | Type | Description |
|---|---|---|
editorContext |
HTMLElement |
The DOM element that was created by the createEditorElement method. |
imeMode |
ImeMode |
The ime-mode from cell's actual style. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
Returns
void
Inherited from
visitedLinkColor
▸ visitedLinkColor(value?): any
Gets or sets the color of visited links.
example
//This example creates a hyperlink cell.
var cellType = new GC.Spread.Sheets.CellTypes.HyperLink();
cellType.linkColor("blue");
cellType.visitedLinkColor("#FFFF00");
cellType.text("SpreadJS");
cellType.linkToolTip("Company Web Site");
cellType.target(GC.Spread.Sheets.CellTypes.HyperLinkTargetType.self);
activeSheet.getCell(0, 2).cellType(cellType).value("http://www.spreadjs.com/");
Parameters
| Name | Type | Description |
|---|---|---|
value? |
string |
The visited link color. |
Returns
any
If no value is set, returns the visited link color; otherwise, returns the hyperLink cell type.