Widgets
Samples
Demos
Forum
Services
Documentation
addCheckbox
addFormat
addImage
addRadio
addSheet
addSparkline
addStyle
adjust
alert
attachEvent
bind
blockEvent
callEvent
changeDecimals
clearRange
clearSheet
combineCells
compactStyles
confirm
define
deleteColumn
deleteRow
destructor
detachEvent
disable
eachSelectedCell
editSheet
enable
filterSpreadSheet
freezeColumns
freezeRows
getActiveSheet
getCellEditor
getCellFilter
getCellValue
getChildViews
getColumn
getFormView
getFormat
getNode
getParentView
getRangeValue
getRow
getSelectedId
getSelectedRange
getSheetData
getSheetState
getStyle
getTopParentView
groupUndo
hasEvent
hide
hideColumn
hideGridlines
hideHeaders
hideRow
ignoreUndo
innerId
insertColumn
insertRow
isCellLocked
isColumnVisible
isEnabled
isRowVisible
isVisible
load
lockCell
mapEvent
markCheckbox
markRadio
parse
posToRef
queryView
recalculate
redo
refToPos
refresh
registerMathMethod
removeFilters
removeFormat
removeSheet
renameSheet
reset
resetUndo
resize
saveCell
serialize
setCellEditor
setCellFilter
setCellValue
setColumnWidth
setFormat
setFormatName
setPlaceholder
setRangeStyle
setRangeValue
setRowHeight
setSheetState
setStyle
show
showCell
showFormulas
showPrintBorders
showSheet
sortRange
splitCell
ui
unbind
unblockEvent
undo
zoom
Start
API Reference
ui.spreadsheet
Methods
addFormat
adds a format and returns its name
string
addFormat
(
string
format
);
format
string
conditions for formatting the cell content, separated by semi-colons
string
the name of the format
Example
$$
(
"ssheet"
)
.
addFormat
(
"[green]0.0"
)
;
Related samples
Spreadsheet: Number Format API
Details
Check
the format details
.
See also
API
getFormat
setFormatName
removeFormat
setFormat
Articles
Number Formatting
Back to top