Documentation pages
57
DocsVauSheet
VauSheet Documentation
Complete guide · Level 0–100Product version
1.0.1
Learning range
0 → 100
Guide stages
5
Implementation-backed VauSheet 1.0.1
From your first cell to production sync architecture.
These guides are written against the current VauSheet codebase instead of generic spreadsheet assumptions. Learn workbook creation, editing, formatting, the exact supported formula runtime, CSV/Excel/JSON import flows, SQL workspace, cloud save, multi-device synchronization, recovery, security and current limitations.
Documentation principles
Accurate before impressive
No false full-Excel compatibility claim
No false live-cursor collaboration claim
Exact current formula names documented
Cloud save and conflict behavior match current sync code
Import/export formats match the current editor menu
Current documentation: VauSheet 1.0.1Updated 2 Sep 2026
0–100 learning path
Move through five stages or jump directly to any reference topic.
6 guides
0–20 · Foundations
10 guides
21–40 · Editing & Formatting
10 guides
41–60 · Formulas & Data
10 guides
61–80 · Cloud & Productivity
21 guides
81–100 · Advanced Architecture & Support
Complete reference
All VauSheet guides
Every route below is indexable and can be opened directly from docs search or a saved link.
0–20 · Foundations
0/100
VauSheet Overview
Start here to understand what VauSheet is, how its workbook model works, and which parts of the product are available in version 1.0.1.
4/100
Access & Sign In
Understand VauSheet authentication, VauPrime account identity, session handling and what happens when a session expires.
8/100
Dashboard & Workbook List
Learn the VauSheet dashboard: profile identity, workbook list, create/open/delete actions and documentation entry points.
12/100
Create Your First Workbook
Create a named VauSheet workbook from the dashboard and understand what is created before you enter the editor.
16/100
Open, Rename & Delete Workbooks
Manage the lifecycle of a VauSheet workbook without confusing a workbook with the sheets inside it.
20/100
Spreadsheet Editor Tour
Understand the current VauSheet editor layout: application bar, grouped tool strip, formula bar, grid and bottom utility strip.
21–40 · Editing & Formatting
22/100
Your First Sheet
Enter values, move between cells and build a simple table on the initial worksheet.
24/100
Cells, Ranges & Selection
Learn single-cell focus, range selection and how selected ranges affect formatting, merge and border commands.
26/100
Edit Cell Values
Use direct editing, the formula bar and keyboard commit/cancel behavior correctly.
28/100
Formula Bar
Use the formula bar to inspect and edit the active cell without losing the grid context.
30/100
Keyboard Navigation
Move quickly through the grid and commit edits with keyboard-first spreadsheet behavior.
32/100
Row Options
Add or delete rows using the compact Row Options dialog in the editor tool strip.
34/100
Column Options
Add and remove columns from the grouped Columns section and understand column-level formatting metadata.
36/100
Sheet Tabs
Create, activate, rename, duplicate and delete worksheets inside a workbook.
38/100
Bottom Utility Strip & Zoom
Use the bottom strip for sheet tabs, zoom and LISHA AI without covering spreadsheet content.
40/100
Editor Toolbar Reference
A complete reference to the grouped VauSheet editor tool strip.
41–60 · Formulas & Data
42/100
Fonts, Size & Bold
Apply VauSheet text formatting to selected cells and columns.
44/100
Cell Alignment
Align selected content left, center or right from the Format group.
46/100
Text Color, Highlight & Fill
Use color without confusing cell highlight with column-level background formatting.
48/100
Column-Level Formatting
Understand how VauSheet can store formatting defaults at column level while preserving cell-specific overrides.
50/100
Borders
Apply precise borders using target, style, width and color controls in the Borders dialog.
52/100
Merge & Unmerge Cells
Merge a selected range or unmerge ranges that overlap the current selection.
54/100
Row & Column Sizing
Adjust visible sheet dimensions while keeping cell content and formulas intact.
56/100
Undo & Redo
Use workbook history controls while distinguishing local edit history from cloud versions.
58/100
Formula Basics
Write VauSheet formulas with =, A1 references, ranges, operators and supported functions.
60/100
References, Ranges & Operators
Use A1 references, rectangular ranges and VauSheet's supported arithmetic, text and comparison operators.
61–80 · Cloud & Productivity
62/100
Supported Formula Functions
Reference the functions implemented in the current VauSheet formula runtime instead of assuming full Microsoft Excel compatibility.
64/100
Math & Aggregation Functions
Use aggregation, rounding and numeric helper functions supported by the current VauSheet runtime.
66/100
SUMIF, COUNTIF & AVERAGEIF
Calculate condition-based totals, counts and averages over VauSheet ranges.
68/100
Logical Functions
Build conditional formulas with IF, AND, OR and NOT.
70/100
Text Functions
Clean, extract, find and combine text with VauSheet's implemented text functions.
72/100
Date & Time Functions
Work with current date/time and Excel-style serial dates in the VauSheet runtime.
74/100
VLOOKUP
Use the lookup function currently implemented by VauSheet and understand its exact-match behavior.
76/100
Formula Errors & Recalculation
Troubleshoot unsupported functions, invalid ranges, division errors and recomputation behavior.
78/100
Filters & Sorting
Use the Data tools to narrow or order visible sheet data while preserving the workbook's underlying sheet model.
80/100
Design Sheets for Structured Data
Prepare sheets that behave well with filters, formulas, SQL and export.
81–100 · Advanced Architecture & Support
82/100
Import CSV
Load a CSV file into the active VauSheet sheet using the Import / Export menu.
84/100
Import Excel Files
Import supported Excel files into VauSheet and understand that VauSheet converts workbook content into its own spreadsheet model.
86/100
Import & Export VauSheet JSON
Use VauSheet JSON as a portable representation of the VauSheet workbook model.
88/100
Export CSV & JSON
Choose the correct export format depending on whether you need a flat sheet or a VauSheet workbook document.
90/100
SQL Workspace
Open the SQL panel from the Data group and query sheet-shaped data without leaving the workbook workflow.
91/100
Shortcuts & Command Palette
Use keyboard shortcuts and Ctrl+K tool search to reach editor actions faster.
92/100
Search Workbook Content
Use the Search destination to find content in the current VauSheet workbook workflow.
93/100
Workspace & Insights
Understand the non-grid Workspace and Insights destinations in the VauSheet application shell.
94/100
LISHA AI in VauSheet
Open LISHA AI from the bottom utility strip and understand its current VauSheet-oriented assistance scope.
95/100
Profile & Settings
Manage VauSheet identity and settings while understanding which profile fields come from the shared VauPrime account.
96/100
Cloud Save
Understand VauSheet's local-first edit path, 400 ms recovery checkpoint, 5 second autosave debounce and manual Save action.
97/100
Multi-Device Sync
Learn how VauSheet detects newer workbook versions through Supabase Realtime while storing the workbook payload in AWS S3.
98/100
Offline & Local Recovery
Understand the browser checkpoint used to recover unsynchronized VauSheet changes after interruption or temporary connectivity loss.
99/100
Conflict Resolution
Resolve genuine same-path workbook conflicts using Keep Mine or Use Latest without discarding unrelated mergeable edits.
100/100
Workbook Storage Architecture
Understand the production VauSheet split between browser checkpoints, Supabase control metadata and AWS S3 workbook documents.
100/100
Workbook Data Model
Learn which spreadsheet concepts are represented in the VauSheet workbook document.
100/100
Storage & Sync Security
Understand owner-scoped workbook access and why synchronization control fields are server-managed.
100/100
Performance Model
Understand the design choices that keep VauSheet responsive as workbook complexity grows.
100/100
Current Limitations & Compatibility
Know what VauSheet 1.0.1 does not promise, especially around Excel compatibility and live collaboration.
100/100
Troubleshooting VauSheet
Diagnose sign-in, loading, saving, formula, import and conflict problems in the correct order.
100/100
VauSheet 1.0.1 Release Notes
Review the major product changes represented by the current VauSheet documentation set.