@univerjssheets-hyper-linkfacadeclassesFworkbookhyperlinkmixin

@univerjs/sheets-hyper-link v0.5.0-beta.1Docs


Class: FWorkbookHyperLinkMixin

FBase is a base class for all facade classes. It provides a way to extend classes with static and instance methods. The _initialize as a special method that will be called after the constructor. You should never call it directly.

Extends

Implements

  • IFWorkbookHyperlinkMixin

Constructors

new FWorkbookHyperLinkMixin()

new FWorkbookHyperLinkMixin(
   _workbook, 
   _injector, 
   _resourceLoaderService, 
   _selectionManagerService, 
   _univerInstanceService, 
   _commandService, 
   _permissionService, 
   _logService): FWorkbookHyperLinkMixin

Parameters

ParameterType
_workbookWorkbook
_injectorInjector
_resourceLoaderServiceIResourceLoaderService
_selectionManagerServiceSheetsSelectionsService
_univerInstanceServiceIUniverInstanceService
_commandServiceICommandService
_permissionServiceIPermissionService
_logServiceILogService

Returns

FWorkbookHyperLinkMixin

Inherited from

FWorkbook.constructor

Defined in

sheets/src/facade/f-workbook.ts:27

Properties

PropertyModifierTypeInherited fromDefined in
_commandServicereadonlyICommandServiceFWorkbook._commandServicesheets/src/facade/f-workbook.ts:33
_injectorreadonlyInjectorFWorkbook._injectorsheets/src/facade/f-workbook.ts:29
_logServicereadonlyILogServiceFWorkbook._logServicesheets/src/facade/f-workbook.ts:35
_permissionServicereadonlyIPermissionServiceFWorkbook._permissionServicesheets/src/facade/f-workbook.ts:34
_resourceLoaderServicereadonlyIResourceLoaderServiceFWorkbook._resourceLoaderServicesheets/src/facade/f-workbook.ts:30
_selectionManagerServicereadonlySheetsSelectionsServiceFWorkbook._selectionManagerServicesheets/src/facade/f-workbook.ts:31
_univerInstanceServicereadonlyIUniverInstanceServiceFWorkbook._univerInstanceServicesheets/src/facade/f-workbook.ts:32
_workbookreadonlyWorkbookFWorkbook._workbooksheets/src/facade/f-workbook.ts:28
idreadonlystringFWorkbook.idsheets/src/facade/f-workbook.ts:25

Methods

_initialize()

_initialize(): void

Returns

void

Inherited from

FWorkbook._initialize

Defined in

core/src/facade/f-base.ts:33


create()

create(
   name, 
   rows, 
   column): FWorksheet

Create a new worksheet and returns a handle to it.

Parameters

ParameterTypeDescription
namestringName of the new sheet
rowsnumberHow may rows would the new sheet have
columnnumberHow many columns would the new sheet have

Returns

FWorksheet

The new created sheet

Inherited from

FWorkbook.create

Defined in

sheets/src/facade/f-workbook.ts:94


createSheetHyperlink(sheetId, range?): string

create a hyperlink for the sheet

Parameters

ParameterTypeDescription
sheetIdstringthe sheet id to link
range?string | IRangethe range to link, or define-name id

Returns

string

the hyperlink string

Implementation of

IFWorkbookHyperlinkMixin.createSheetHyperlink

Overrides

FWorkbook.createSheetHyperlink

Defined in

sheets-hyper-link/src/facade/f-workbook.ts:40


deleteSheet()

deleteSheet(sheet): void

Deletes the specified worksheet.

Parameters

ParameterTypeDescription
sheetFWorksheetThe worksheet to delete.

Returns

void

Inherited from

FWorkbook.deleteSheet

Defined in

sheets/src/facade/f-workbook.ts:189


getActiveRange()

getActiveRange(): null | FRange

Returns the selected range in the active sheet, or null if there is no active range.

Returns

null | FRange

the active range

Inherited from

FWorkbook.getActiveRange

Defined in

sheets/src/facade/f-workbook.ts:303


getActiveSheet()

getActiveSheet(): FWorksheet

Get the active sheet of the workbook.

Returns

FWorksheet

The active sheet of the workbook

Inherited from

FWorkbook.getActiveSheet

Defined in

sheets/src/facade/f-workbook.ts:72


getId()

getId(): string

Returns

string

Inherited from

FWorkbook.getId

Defined in

sheets/src/facade/f-workbook.ts:42


getName()

getName(): string

Returns

string

Inherited from

FWorkbook.getName

Defined in

sheets/src/facade/f-workbook.ts:46


getSheetByName()

getSheetByName(name): null | FWorksheet

Get a worksheet by sheet name.

Parameters

ParameterTypeDescription
namestringThe name of the sheet to get.

Returns

null | FWorksheet

The worksheet with given sheet name

Inherited from

FWorkbook.getSheetByName

Defined in

sheets/src/facade/f-workbook.ts:139


getSheetBySheetId()

getSheetBySheetId(sheetId): null | FWorksheet

Get a worksheet by sheet id.

Parameters

ParameterTypeDescription
sheetIdstringThe id of the sheet to get.

Returns

null | FWorksheet

The worksheet with given sheet id

Inherited from

FWorkbook.getSheetBySheetId

Defined in

sheets/src/facade/f-workbook.ts:125


getSheets()

getSheets(): FWorksheet[]

Gets all the worksheets in this workbook

Returns

FWorksheet[]

An array of all the worksheets in the workbook

Inherited from

FWorkbook.getSheets

Defined in

sheets/src/facade/f-workbook.ts:81


getSnapshot()

getSnapshot(): IWorkbookData

Returns

IWorkbookData

{IWorkbookData}

Deprecated

use ‘save’ instead.

Memberof

FWorkbook

Inherited from

FWorkbook.getSnapshot

Defined in

sheets/src/facade/f-workbook.ts:63


insertSheet()

insertSheet(): FWorksheet

Inserts a new worksheet into the workbook. Using a default sheet name. The new sheet becomes the active sheet

Returns

FWorksheet

The new sheet

Inherited from

FWorkbook.insertSheet

Defined in

sheets/src/facade/f-workbook.ts:167


onBeforeCommandExecute()

onBeforeCommandExecute(callback): IDisposable

Register a callback that will be triggered before invoking a command targeting the Univer sheet.

Parameters

ParameterTypeDescription
callbackCommandListenerthe callback.

Returns

IDisposable

A function to dispose the listening.

Inherited from

FWorkbook.onBeforeCommandExecute

Defined in

sheets/src/facade/f-workbook.ts:215


onCommandExecuted()

onCommandExecuted(callback): IDisposable

Register a callback that will be triggered when a command is invoked targeting the Univer sheet.

Parameters

ParameterTypeDescription
callbackCommandListenerthe callback.

Returns

IDisposable

A function to dispose the listening.

Inherited from

FWorkbook.onCommandExecuted

Defined in

sheets/src/facade/f-workbook.ts:230


onSelectionChange()

onSelectionChange(callback): IDisposable

Parameters

ParameterType
callback(selections) => void

Returns

IDisposable

Inherited from

FWorkbook.onSelectionChange

Defined in

sheets/src/facade/f-workbook.ts:240


parseSheetHyperlink(hyperlink): ISheetHyperLinkInfo

parse the hyperlink string to get the hyperlink info

Parameters

ParameterTypeDescription
hyperlinkstringthe hyperlink string

Returns

ISheetHyperLinkInfo

the hyperlink info

Implementation of

IFWorkbookHyperlinkMixin.parseSheetHyperlink

Overrides

FWorkbook.parseSheetHyperlink

Defined in

sheets-hyper-link/src/facade/f-workbook.ts:50


redo()

redo(): Promise<boolean>

Returns

Promise<boolean>

Inherited from

FWorkbook.redo

Defined in

sheets/src/facade/f-workbook.ts:205


save()

save(): IWorkbookData

save workbook snapshot data, including conditional formatting, data validation, and other plugin data.

Returns

IWorkbookData

Inherited from

FWorkbook.save

Defined in

sheets/src/facade/f-workbook.ts:53


setActiveRange()

setActiveRange(range): void

Sets the active selection region for this sheet.

Parameters

ParameterTypeDescription
rangeFRangeThe range to set as the active selection.

Returns

void

Inherited from

FWorkbook.setActiveRange

Defined in

sheets/src/facade/f-workbook.ts:274


setActiveSheet()

setActiveSheet(sheet): FWorksheet

Sets the given worksheet to be the active worksheet in the workbook.

Parameters

ParameterTypeDescription
sheetFWorksheetThe worksheet to set as the active worksheet.

Returns

FWorksheet

The active worksheet

Inherited from

FWorkbook.setActiveSheet

Defined in

sheets/src/facade/f-workbook.ts:153


setEditable()

setEditable(value): void

Used to modify the editing permissions of the workbook. When the value is false, editing is not allowed.

Parameters

ParameterTypeDescription
valuebooleaneditable value want to set

Returns

void

Inherited from

FWorkbook.setEditable

Defined in

sheets/src/facade/f-workbook.ts:261


undo()

undo(): Promise<boolean>

Returns

Promise<boolean>

Inherited from

FWorkbook.undo

Defined in

sheets/src/facade/f-workbook.ts:200


extend()

static extend(source): void

Parameters

ParameterType
sourceany

Returns

void

Inherited from

FWorkbook.extend

Defined in

core/src/facade/f-base.ts:35