Explore the API
Data validation
Install a Region dropdown and a whole-number units rule, then try a valid or invalid value from the panel.
ResultLive API output
An invalid update must leave C2 unchanged. The output includes the current rule definitions.
Preparing sample...
Keep exploringReset or save
Reset restores this sample's starting document. TXWB retains its spreadsheet, dashboard, and reporting definitions.
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
Data validation
Validation rules apply to typed API writes as well as editor entry. Whole-number limits reject fractional or out-of-range input. The sample catches rejected updates and reports the unchanged cell value.
APIs used
sheet.validation.set()
sheet.validation.choices()
Cell.setValue()
How to explore
Install a Region dropdown and a whole-number units rule, then try a valid or invalid value from the panel.
An invalid update must leave C2 unchanged. The output includes the current rule definitions.
Document ownership
The ready event supplies the initialized editor. Each action resolves document objects from the current workbook. Reset loads a clean TXWB snapshot; worksheet, range, chart, and dashboard handles must be acquired again after loading.
The Code panel shows this sample's actual implementation and the shared hosting code. Downloads contain the current document; changes are not stored on the server.
NuGet packages
TXTextControl.TXSheetControl.AspNetCore
2.0.0-beta.1
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0-beta.1
