Getting Started
User Guide
:colorscheme
File Formats
Plotting
Scripting
Reference
VimSheetApp
VimSheetApp.CSS
VimSheetApp.__init__()
VimSheetApp.compose()
VimSheetApp.on_mount()
VimSheetApp.on_unmount()
VimSheetApp.grid
VimSheetApp.formula_bar
VimSheetApp.status_bar
VimSheetApp.sheet_tabs
VimSheetApp.mode
VimSheetApp.cursor_row
VimSheetApp.cursor_col
VimSheetApp.cursor
VimSheetApp.on_key()
VimSheetApp.open_in_external_editor()
VimSheetApp.on_grid_widget_cursor_moved()
VimSheetApp.on_sheet_tabs_sheet_selected()
VimSheetApp.on_sheet_tabs_add_sheet()
CommandCompleter
CommandCompleter.__init__()
CommandCompleter.reset()
CommandCompleter.tab()
register_section()
register_help()
get_tabs()
get_entries()
get_func_categories()
build_section()
section_lines()
build_func_category()
build_search_index()
search_matches()
EditHandler
EditHandler.__init__()
EditHandler.enter()
EditHandler.handle()
InsertHandler
InsertHandler.__init__()
InsertHandler.handle()
MacroRecorder
MacroRecorder.__init__()
MacroRecorder.start_recording()
MacroRecorder.stop_recording()
MacroRecorder.record_key()
MacroRecorder.get_macro()
MacroRecorder.replay_last()
MacroRecorder.is_recording
MacroRecorder.recording_register
MacroRecorder.has_macro()
Mode
Mode.NORMAL
Mode.INSERT
Mode.EDIT
Mode.COMMAND
Mode.SEARCH
Mode.VISUAL
Mode.VISUAL_LINE
Mode.VISUAL_BLOCK
Mode.label()
Mode.css_class()
Mode.is_visual()
can_transition()
NormalHandler
NormalHandler.__init__()
NormalHandler.handle()
SearchState
SearchState.pattern
SearchState.replace
SearchState.case_sensitive
SearchState.use_regex
SearchState.whole_cell
SearchState.current_match
SearchState.matches
SearchState.__init__()
Searcher
Searcher.__init__()
Searcher.find_all()
Searcher.find_next()
Searcher.find_prev()
Searcher.replace_one()
Searcher.collect_replacements()
Searcher.replace_all()
Searcher.replace_in_cols()
Searcher.replace_in_range()
Searcher.replace_in_rows()
VisualHandler
VisualHandler.__init__()
VisualHandler.handle()
FetchEntry
FetchEntry.url
FetchEntry.interval
FetchEntry.json_path
FetchEntry.headers
FetchEntry.method
FetchEntry.last_value
FetchEntry.status
FetchEntry.timer
FetchEntry.spill_cells
FetchEntry.__init__()
FetchManager
FetchManager.__init__()
FetchManager.get_cached()
FetchManager.schedule()
FetchManager.fetch_now()
FetchManager.cancel()
FetchManager.cancel_all()
FetchManager.all_entries()
FetchResult
FetchResult.raw
FetchResult.status_code
FetchResult.error
FetchResult.ok
FetchResult.__init__()
parse_curl_command()
do_fetch()
parse_response()
extract_json_path()
NumberNode
NumberNode.value
NumberNode.__init__()
StringNode
StringNode.value
StringNode.__init__()
BoolNode
BoolNode.value
BoolNode.__init__()
CellRefNode
CellRefNode.ref
CellRefNode.__init__()
RangeRefNode
RangeRefNode.ref
RangeRefNode.__init__()
SheetCellRefNode
SheetCellRefNode.sheet
SheetCellRefNode.ref
SheetCellRefNode.__init__()
SheetRangeRefNode
SheetRangeRefNode.sheet
SheetRangeRefNode.ref
SheetRangeRefNode.__init__()
ColRangeRefNode
ColRangeRefNode.ref
ColRangeRefNode.__init__()
NameNode
NameNode.name
NameNode.__init__()
UnaryNode
UnaryNode.op
UnaryNode.operand
UnaryNode.__init__()
BinaryNode
BinaryNode.op
BinaryNode.left
BinaryNode.right
BinaryNode.__init__()
PercentNode
PercentNode.operand
PercentNode.__init__()
FuncCallNode
FuncCallNode.name
FuncCallNode.args
FuncCallNode.__init__()
CycleError
DependencyGraph
DependencyGraph.__init__()
DependencyGraph.set_dependencies()
DependencyGraph.remove_cell()
DependencyGraph.dependents_of()
DependencyGraph.dependencies_of()
DependencyGraph.evaluation_order()
DependencyGraph.iter_edges()
EvalError
EvalError.__init__()
Evaluator
Evaluator.__init__()
Evaluator.eval_formula()
Evaluator.collect_deps()
recalculate()
ParseError
Parser
Parser.__init__()
Parser.parse()
parse_formula()
TokenizeError
tokenize()
TT
TT.NUMBER
TT.STRING
TT.BOOL
TT.CELL_REF
TT.RANGE_REF
TT.SHEET_CELL_REF
TT.SHEET_RANGE_REF
TT.COL_RANGE_REF
TT.NAME
TT.OP
TT.LPAREN
TT.RPAREN
TT.COMMA
TT.AT
TT.COLON
TT.PERCENT
TT.EOF
Token
Token.type
Token.value
Token.pos
Token.__init__()
fn_today()
fn_now()
fn_date()
fn_time()
fn_year()
fn_month()
fn_day()
fn_hour()
fn_minute()
fn_second()
fn_datedif()
fn_edate()
fn_eomonth()
fn_weekday()
fn_weeknum()
fn_networkdays()
fn_if()
fn_ifs()
fn_and()
fn_or()
fn_not()
fn_xor()
fn_iferror()
fn_ifna()
fn_switch()
fn_true()
fn_false()
fn_isblank()
fn_isnumber()
fn_istext()
fn_iserror()
fn_vlookup()
fn_hlookup()
fn_index()
fn_match()
fn_xlookup()
fn_choose()
fn_row()
fn_col()
fn_rows()
fn_cols()
fn_offset()
fn_indirect()
fn_sum()
fn_avg()
fn_count()
fn_counta()
fn_min()
fn_max()
fn_prod()
fn_stddev()
fn_stdevs()
fn_var()
fn_vars()
fn_median()
fn_mode()
fn_percentile()
fn_sumif()
fn_countif()
fn_averageif()
fn_subtotal()
fn_abs()
fn_ceil()
fn_floor()
fn_round()
fn_roundup()
fn_rounddown()
fn_sqrt()
fn_pow()
fn_exp()
fn_log()
fn_log10()
fn_ln()
fn_sin()
fn_cos()
fn_tan()
fn_asin()
fn_acos()
fn_atan()
fn_atan2()
fn_hypot()
fn_mod()
fn_rand()
fn_randbetween()
fn_sign()
fn_int()
fn_trunc()
fn_fact()
fn_gcd()
fn_lcm()
fn_pi()
fn_e()
fn_dtr()
fn_rtd()
fn_fetch()
FunctionMeta
FunctionMeta.__init__()
FunctionMeta.fn
FunctionMeta.names
FunctionMeta.category
FunctionMeta.desc
FunctionMeta.__getattr__()
register()
get()
all_names()
all_functions()
register_script_function()
fn_concat()
fn_len()
fn_upper()
fn_lower()
fn_proper()
fn_trim()
fn_left()
fn_right()
fn_mid()
fn_find()
fn_replace()
fn_substitute()
fn_text()
fn_value()
fn_rept()
fn_exact()
fn_char()
fn_code()
FormatAdapter
FormatAdapter.supported_extensions
FormatAdapter.can_read_formulas
FormatAdapter.can_write_formulas
FormatAdapter.multi_sheet
FormatAdapter.read()
FormatAdapter.write()
CSVAdapter
CSVAdapter.supported_extensions
CSVAdapter.read()
CSVAdapter.write()
HTMLAdapter
HTMLAdapter.supported_extensions
HTMLAdapter.read()
HTMLAdapter.write()
JSONAdapter
JSONAdapter.supported_extensions
JSONAdapter.can_read_formulas
JSONAdapter.can_write_formulas
JSONAdapter.multi_sheet
JSONAdapter.read()
JSONAdapter.write()
LaTeXAdapter
LaTeXAdapter.supported_extensions
LaTeXAdapter.read()
LaTeXAdapter.write()
MarkdownAdapter
MarkdownAdapter.supported_extensions
MarkdownAdapter.read()
MarkdownAdapter.write()
get_adapter()
get_adapter_by_name()
XLSAdapter
XLSAdapter.supported_extensions
XLSAdapter.multi_sheet
XLSAdapter.read()
XLSAdapter.write()
XLSXAdapter
XLSXAdapter.supported_extensions
XLSXAdapter.can_read_formulas
XLSXAdapter.can_write_formulas
XLSXAdapter.multi_sheet
XLSXAdapter.read()
XLSXAdapter.write()
CellFormat
CellFormat.bold
CellFormat.italic
CellFormat.underline
CellFormat.align
CellFormat.fg_color
CellFormat.bg_color
CellFormat.num_decimals
CellFormat.num_format
CellFormat.thousands_sep
CellFormat.copy()
CellFormat.__init__()
Cell
Cell.row
Cell.col
Cell.formula
Cell.value
Cell.display
Cell.fmt
Cell.locked
Cell.comment
Cell.history
Cell.is_empty()
Cell.record_history()
Cell.format_value()
Cell.copy()
Cell.__init__()
Config
Config.autosave
Config.autosave_interval
Config.default_col_width
Config.theme
Config.show_grid_lines
Config.show_row_headers
Config.show_col_headers
Config.formula_bar_visible
Config.status_bar_visible
Config.max_undo
Config.history_size
Config.message_history_size
Config.autocalc
Config.scroll_speed
Config.tab_size
Config.enter_moves
Config.decimal_separator
Config.thousands_separator
Config.scripts_dir
Config.functions_file
Config.save_cursor
Config.theme_overrides
Config.get_scripts_dir()
Config.get_functions_file()
Config.load()
Config.save()
Config.default_path()
Config.__init__()
col_letters_to_index()
col_index_to_letters()
a1_to_rowcol()
rowcol_to_a1()
CellRange
CellRange.start_row
CellRange.start_col
CellRange.end_row
CellRange.end_col
CellRange.from_a1()
CellRange.to_a1()
CellRange.num_rows
CellRange.num_cols
CellRange.iter_cells()
CellRange.contains()
CellRange.__init__()
NamedRangeRegistry
NamedRangeRegistry.define()
NamedRangeRegistry.delete()
NamedRangeRegistry.resolve()
NamedRangeRegistry.all_names()
NamedRangeRegistry.__init__()
CondFormatRule
CondFormatRule.range_str
CondFormatRule.operator
CondFormatRule.value
CondFormatRule.value2
CondFormatRule.fmt
CondFormatRule.matches()
CondFormatRule.__init__()
FilterRule
FilterRule.operator
FilterRule.value
FilterRule.matches()
FilterRule.__init__()
SortState
SortState.sort_keys
SortState.__init__()
Sheet
Sheet.name
Sheet.cells
Sheet.col_widths
Sheet.row_heights
Sheet.hidden_rows
Sheet.hidden_cols
Sheet.row_groups
Sheet.col_groups
Sheet.freeze_rows
Sheet.freeze_cols
Sheet.named_ranges
Sheet.cond_formats
Sheet.filters
Sheet.sort_state
Sheet.max_row
Sheet.max_col
Sheet.validation
Sheet.cursor_row
Sheet.cursor_col
Sheet.autocalc
Sheet.get_cell()
Sheet.cell()
Sheet.set_cell_value()
Sheet.clear_cell()
Sheet.set_cells_batch()
Sheet.clear_cells_batch()
Sheet.get_range_values()
Sheet.insert_row()
Sheet.delete_row()
Sheet.insert_col()
Sheet.delete_col()
Sheet.DEFAULT_COL_WIDTH
Sheet.get_col_width()
Sheet.set_col_width()
Sheet.auto_fit_col()
Sheet.used_range()
Sheet.sort_by_col()
Sheet.sort_by_cols()
Sheet.sort_range_columns()
Sheet.apply_filters()
Sheet.__init__()
YankedCell
YankedCell.value
YankedCell.formula
YankedCell.fmt
YankedCell.locked
YankedCell.comment
YankedCell.__init__()
Command
Command.description
Command.execute()
Command.undo()
SetCellCommand
SetCellCommand.description
SetCellCommand.__init__()
SetCellCommand.execute()
SetCellCommand.undo()
ClearCellCommand
ClearCellCommand.description
ClearCellCommand.__init__()
ClearCellCommand.execute()
ClearCellCommand.undo()
DeleteRangeCommand
DeleteRangeCommand.description
DeleteRangeCommand.__init__()
DeleteRangeCommand.execute()
DeleteRangeCommand.undo()
ValidationCommand
ValidationCommand.description
ValidationCommand.__init__()
ValidationCommand.execute()
ValidationCommand.undo()
SortRangeCommand
SortRangeCommand.description
SortRangeCommand.__init__()
SortRangeCommand.execute()
SortRangeCommand.undo()
FillRangeCommand
FillRangeCommand.description
FillRangeCommand.__init__()
FillRangeCommand.execute()
FillRangeCommand.undo()
InsertRowCommand
InsertRowCommand.description
InsertRowCommand.__init__()
InsertRowCommand.execute()
InsertRowCommand.undo()
DeleteRowCommand
DeleteRowCommand.description
DeleteRowCommand.__init__()
DeleteRowCommand.execute()
DeleteRowCommand.undo()
InsertColCommand
InsertColCommand.description
InsertColCommand.__init__()
InsertColCommand.execute()
InsertColCommand.undo()
DeleteColCommand
DeleteColCommand.description
DeleteColCommand.__init__()
DeleteColCommand.execute()
DeleteColCommand.undo()
PasteCommand
PasteCommand.description
PasteCommand.__init__()
PasteCommand.execute()
PasteCommand.undo()
LockCommand
LockCommand.description
LockCommand.__init__()
LockCommand.execute()
LockCommand.undo()
FormatCommand
FormatCommand.description
FormatCommand.__init__()
FormatCommand.execute()
FormatCommand.undo()
SortCommand
SortCommand.description
SortCommand.__init__()
SortCommand.execute()
SortCommand.undo()
ShiftCellsCommand
ShiftCellsCommand.description
ShiftCellsCommand.__init__()
ShiftCellsCommand.execute()
ShiftCellsCommand.undo()
CompositeCommand
CompositeCommand.description
CompositeCommand.__init__()
CompositeCommand.execute()
CompositeCommand.undo()
UndoStack
UndoStack.__init__()
UndoStack.can_undo
UndoStack.can_redo
UndoStack.push()
UndoStack.undo()
UndoStack.redo()
UndoStack.clear()
ValidationRule
ValidationRule.rule_type
ValidationRule.operator
ValidationRule.choices
ValidationRule.formula
ValidationRule.error_message
ValidationRule.allow_blank
ValidationRule.value1
ValidationRule.value2
ValidationRule.validate()
ValidationRule.__init__()
SheetValidation
SheetValidation.rules
SheetValidation.add()
SheetValidation.remove()
SheetValidation.get()
SheetValidation.validate()
SheetValidation.__init__()
Workbook
Workbook.sheets
Workbook.active_sheet_idx
Workbook.filepath
Workbook.modified
Workbook.global_named_ranges
Workbook.active_sheet
Workbook.get_sheet()
Workbook.get_sheet_index()
Workbook.add_sheet()
Workbook.delete_sheet()
Workbook.rename_sheet()
Workbook.duplicate_sheet()
Workbook.set_autocalc()
Workbook.go_to_next_sheet()
Workbook.go_to_prev_sheet()
Workbook.go_to_sheet()
Workbook.blank()
Workbook.__init__()
ChartSpec
ChartSpec.chart_type
ChartSpec.data_range
ChartSpec.title
ChartSpec.x_label
ChartSpec.y_label
ChartSpec.width
ChartSpec.height
ChartSpec.series_names
ChartSpec.__init__()
render_chart()
ScriptResult
ScriptResult.commands_run
ScriptResult.errors
ScriptResult.ok
ScriptResult.__init__()
ScriptError
ScriptEngine
ScriptEngine.__init__()
ScriptEngine.workbook
ScriptEngine.run_file()
ScriptEngine.run_string()
ScriptEngine.run_lines()
BuffersScreen
BuffersScreen.DEFAULT_CSS
BuffersScreen.__init__()
BuffersScreen.compose()
BuffersScreen.can_focus
BuffersScreen.can_focus_children
ChartScreen
ChartScreen.DEFAULT_CSS
ChartScreen.__init__()
ChartScreen.compose()
ChartScreen.can_focus
ChartScreen.can_focus_children
FetchListScreen
FetchListScreen.DEFAULT_CSS
FetchListScreen.__init__()
FetchListScreen.compose()
FetchListScreen.can_focus
FetchListScreen.can_focus_children
FormulaBar
FormulaBar.DEFAULT_CSS
FormulaBar.cell_address
FormulaBar.formula_text
FormulaBar.cursor_pos
FormulaBar.mode
FormulaBar.is_modified
FormulaBar.is_locked
FormulaBar.__init__()
FormulaBar.set_palette()
FormulaBar.compose()
FormulaBar.watch_cell_address()
FormulaBar.watch_formula_text()
FormulaBar.watch_cursor_pos()
FormulaBar.watch_mode()
FormulaBar.watch_is_modified()
FormulaBar.watch_is_locked()
FormulaBar.update_cell()
FormulaBar.can_focus
FormulaBar.can_focus_children
FuncsScreen
FuncsScreen.DEFAULT_CSS
FuncsScreen.__init__()
FuncsScreen.compose()
FuncsScreen.can_focus
FuncsScreen.can_focus_children
GridWidget
GridWidget.BINDINGS
GridWidget.DEFAULT_CSS
GridWidget.CursorMoved
GridWidget.cursor_row
GridWidget.cursor_col
GridWidget.mode
GridWidget.visual_anchor_row
GridWidget.visual_anchor_col
GridWidget.show_visual
GridWidget.__init__()
GridWidget.set_search_state()
GridWidget.on_mount()
GridWidget.sheet
GridWidget.get_col_width()
GridWidget.update_config()
GridWidget.set_palette()
GridWidget.set_preview()
GridWidget.collapse_row()
GridWidget.expand_row()
GridWidget.get_content_width()
GridWidget.get_content_height()
GridWidget.render_line()
GridWidget.move_cursor()
GridWidget.move_by()
GridWidget.move_to_row_start()
GridWidget.move_to_first_nonempty_in_row()
GridWidget.move_to_row_end()
GridWidget.move_to_first_row()
GridWidget.move_to_last_row()
GridWidget.move_to_first_cell()
GridWidget.move_to_last_cell()
GridWidget.jump_next_nonempty_right()
GridWidget.jump_next_nonempty_left()
GridWidget.jump_next_nonempty_down()
GridWidget.jump_next_nonempty_up()
GridWidget.page_down()
GridWidget.page_up()
GridWidget.half_page_down()
GridWidget.half_page_up()
GridWidget.go_to_visible_top()
GridWidget.go_to_visible_middle()
GridWidget.go_to_visible_bottom()
GridWidget.start_visual()
GridWidget.visual_selection()
GridWidget.scroll_cell_to_top()
GridWidget.scroll_cell_to_center()
GridWidget.scroll_cell_to_bottom()
GridWidget.watch_cursor_row()
GridWidget.watch_cursor_col()
GridWidget.watch_mode()
GridWidget.refresh_grid()
GridWidget.can_focus
GridWidget.can_focus_children
HelpScreen
HelpScreen.DEFAULT_CSS
HelpScreen.__init__()
HelpScreen.compose()
HelpScreen.on_mount()
HelpScreen.on_key()
HelpScreen.action_next_tab()
HelpScreen.action_prev_tab()
HelpScreen.on_tabs_tab_activated()
HelpScreen.action_next_match()
HelpScreen.action_prev_match()
HelpScreen.can_focus
HelpScreen.can_focus_children
SheetTabs
SheetTabs.DEFAULT_CSS
SheetTabs.SheetSelected
SheetTabs.AddSheet
SheetTabs.__init__()
SheetTabs.set_palette()
SheetTabs.set_sheets()
SheetTabs.render()
SheetTabs.on_click()
SheetTabs.on_mouse_scroll_down()
SheetTabs.on_mouse_scroll_up()
SheetTabs.can_focus
SheetTabs.can_focus_children
MessageEntry
MessageEntry.text
MessageEntry.timestamp
MessageEntry.level
MessageEntry.__init__()
StatusBar
StatusBar.DEFAULT_CSS
StatusBar.mode
StatusBar.sheet_name
StatusBar.cell_address
StatusBar.row
StatusBar.col
StatusBar.used_rows
StatusBar.filename
StatusBar.file_modified
StatusBar.message
StatusBar.__init__()
StatusBar.message_history
StatusBar.set_history_size()
StatusBar.compose()
StatusBar.on_mount()
StatusBar.watch_mode()
StatusBar.watch_sheet_name()
StatusBar.watch_cell_address()
StatusBar.watch_row()
StatusBar.watch_col()
StatusBar.watch_used_rows()
StatusBar.watch_filename()
StatusBar.watch_file_modified()
StatusBar.watch_message()
StatusBar.show_message()
StatusBar.set_persistent_message()
StatusBar.update_cursor()
StatusBar.can_focus
StatusBar.can_focus_children
VimModalScreen
VimModalScreen.BINDINGS
VimModalScreen.action_scroll_down_line()
VimModalScreen.action_scroll_up_line()
VimModalScreen.action_scroll_down_half()
VimModalScreen.action_scroll_up_half()
VimModalScreen.action_scroll_down_page()
VimModalScreen.action_scroll_up_page()
VimModalScreen.action_scroll_top()
VimModalScreen.action_scroll_bottom()
VimModalScreen.can_focus
VimModalScreen.can_focus_children
Advanced Topics
.vsheet
Development
Examples
Project Info
Mode enum and state-machine transitions.
Bases: Enum
Enum
Application editing modes, mirroring vim modal behaviour.
Return the display label shown in the formula bar / status bar.
str
Return a CSS class name for theme-dependent mode colour.
Return True for any Visual sub-mode.
bool
Return True if a direct mode transition is valid.
from_mode (Mode)
to_mode (Mode)