Formula Language Server
VisiGrid treats formulas like code, providing IDE-like assistance as you type.
Autocomplete
Section titled “Autocomplete”When you type = and start typing a function name, suggestions appear automatically. Use:
Arrow Up/Downto navigate suggestionsTaborEnterto acceptEscapeto dismiss
Signature Help
Section titled “Signature Help”When you type ( after a function name, a tooltip appears showing:
- The function signature with all parameters
- The current parameter highlighted
- Updates as you type commas between arguments
Error Validation
Section titled “Error Validation”VisiGrid checks your formulas in real-time:
- Syntax errors appear as red messages below the formula bar
- Validates parenthesis matching, operators, and function syntax
- Shows specific error messages before you even press Enter
Context-Sensitive Help (F1)
Section titled “Context-Sensitive Help (F1)”Press F1 while editing a formula to see detailed help for the function at cursor position:
- Function name and syntax
- Full description
- Category
Press Escape to dismiss the help popup.