Explore the API
Named ranges
Create the business names NetAmounts and TaxRate, then change the tax rate and inspect the calculated tax.
ResultLive API output
Look at the formula in B12 and compare its value after changing TaxRate.
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
Named ranges
Workbook names make formulas readable and can describe constants or absolute references. Case-insensitive names follow workbook and worksheet scope. A saved TXWB retains these definitions.
APIs used
Workbook.names.set()
Cell.setFormula()
How to explore
Create the business names NetAmounts and TaxRate, then change the tax rate and inspect the calculated tax.
Look at the formula in B12 and compare its value after changing TaxRate.
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
