[]
↳ HyperLink
• 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");
• typeName: string
Represents the type name string used for supporting serialization.
▸ activateEditor(editorContext
, cellStyle
, cellRect
, context?
): void
Activates the editor, including setting properties or attributes for the editor and binding events for the editor.
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. |
void
▸ 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);
Name | Type | Description |
---|---|---|
value? |
boolean |
Whether to move to the active cell when clicked. |
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(context?
): HTMLElement
Creates a DOM element then returns it.
Name | Type | Description |
---|---|---|
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
HTMLElement
Returns a DOM element.
▸ deactivateEditor(editorContext
, context?
): void
Deactivates the editor, such as unbinding events for editor.
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. |
void
▸ focus(editorContext
, context?
): void
Focuses the editor DOM element.
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. |
void
▸ format(value
, format
, formattedData?
, context?
): string
Formats a value with the specified format to a string.
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. |
string
Returns the formatted string.
▸ fromJSON(settings
): void
Loads the object state from the specified JSON string.
Name | Type | Description |
---|---|---|
settings |
any |
The cell type data from deserialization. |
void
▸ getAutoFitHeight(value
, text
, cellStyle
, zoomFactor
, context?
): number
Gets a cell's height that can be used to handle the row's automatic fit.
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. |
number
Returns the cell's height that can be used to handle the row's automatic fit.
▸ getAutoFitWidth(value
, text
, cellStyle
, zoomFactor
, context?
): number
Gets a cell's width that can be used to handle the column's automatic fit.
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. |
number
Returns the cell's width that can be used to handle the column's automatic fit.
▸ getEditorValue(editorContext
, context?
): any
Gets the editor's value.
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. |
any
Returns the editor's value.
▸ getHitInfo(x
, y
, cellStyle
, cellRect
, context?
): IHitTestCellTypeHitInfo
Gets the cell type's hit information.
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 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
.
▸ isEditingValueChanged(oldValue
, newValue
, context?
): boolean
Whether the editing value has changed.
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. |
boolean
true
if oldValue equals newValue; otherwise, false
.
▸ isImeAware(context?
): boolean
Whether this cell type is aware of IME.
Name | Type | Description |
---|---|---|
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
boolean
true
if the cell type is aware of IME; otherwise, false
.
▸ isReservedKey(e
, context?
): boolean
Whether the cell type handles the keyboard event itself.
Name | Type | Description |
---|---|---|
e |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
boolean
Returns true
if the cell type handles the keyboard event itself; otherwise, false
.
▸ 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);
Name | Type | Description |
---|---|---|
value? |
string |
The hyperlink color. |
any
If no value is set, returns the hyperlink color; otherwise, returns the hyperLink cell type.
▸ 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);
Name | Type | Description |
---|---|---|
value? |
string |
The tooltip text. |
any
If no value is set, returns the tooltip text; otherwise, returns the hyperLink cell type.
▸ 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})
});
Name | Type | Description |
---|---|---|
value? |
Function |
The callback of the hyperlink. |
any
If no value is set, return a value that indicates the callback of the hyperlink; otherwise, returns the hyperlink cell type.
▸ paint(ctx
, value
, x
, y
, w
, h
, style
, context?
): void
Paints a cell on the canvas.
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. |
void
▸ paintContent(ctx
, value
, x
, y
, w
, h
, style
, context?
): void
Paints the cell content area on the canvas.
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. |
void
▸ parse(text
, formatStr
, context?
): any
Parses the text with the specified format string to an object.
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. |
any
The parsed object.
▸ processKeyDown(event
, context?
): boolean
Processes key down in display mode.
Name | Type | Description |
---|---|---|
event |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ processKeyUp(event
, context?
): boolean
Processes key up in display mode.
Name | Type | Description |
---|---|---|
event |
KeyboardEvent |
The KeyboardEvent. |
context? |
any |
The context associated with the cell type. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ processMouseDown(hitInfo
): boolean
Processes mouse down in display mode.
Name | Type | Description |
---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ processMouseEnter(hitInfo
): boolean
Processes mouse enter in display mode.
Name | Type | Description |
---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ processMouseLeave(hitInfo
): boolean
Processes mouse leave in display mode.
Name | Type | Description |
---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ processMouseMove(hitInfo
): boolean
Processes mouse move in display mode.
Name | Type | Description |
---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ processMouseUp(hitInfo
): boolean
Processes mouse up in display mode.
Name | Type | Description |
---|---|---|
hitInfo |
IHitTestCellTypeHitInfo |
The hit test information returned by the getHitInfo method. See the Remarks for more information. |
boolean
Returns true
if the process is successful; otherwise, false
.
▸ selectAll(editorContext
, context?
): void
Selects all the text in the editor DOM element.
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. |
void
▸ setEditorValue(editorContext
, value
, context?
): void
Sets the editor's value.
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. |
void
▸ 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/");
Name | Type | Description |
---|---|---|
value? |
HyperLinkTargetType |
The hyperlink's target type. |
any
If no value is set, returns the hyperlink's target type; otherwise, returns the hyperLink cell type.
▸ 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/");
Name | Type | Description |
---|---|---|
value? |
string |
The text displayed in the hyperlink. |
any
If no value is set, returns the text in the hyperlink; otherwise, returns the hyperLink cell type.
▸ toJSON(): any
Saves the object state to a JSON string.
any
The cell type data.
▸ updateEditor(editorContext
, cellStyle
, cellRect
, context?
): Rect
Updates the editor's size.
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 the new size for cell wrapper element, it should contain two properties 'width' and 'height'.
▸ updateEditorContainer(editorContext
, editorBounds
, cellStyle
): void
Updates the cell wrapper element size.
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. |
void
▸ updateImeMode(editorContext
, imeMode
, context?
): void
Updates the editor's ime-mode.
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. |
void
▸ 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/");
Name | Type | Description |
---|---|---|
value? |
string |
The visited link color. |
any
If no value is set, returns the visited link color; otherwise, returns the hyperLink cell type.