Explore the API
Add formulas and recalculate
Change the units and price inputs for an order, then recalculate its subtotal, tax, and total.
ResultLive API output
The report uses 19% tax. Output includes the formula text and the current total.
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
Add formulas and recalculate
Formula cells calculate from typed input cells and update their dependents when inputs change. Arithmetic and SUM can combine across a report. Formula text and calculated values are separate properties.
APIs used
Cell.setFormula()
Cell.setValue()
Workbook.recalculate()
How to explore
Change the units and price inputs for an order, then recalculate its subtotal, tax, and total.
The report uses 19% tax. Output includes the formula text and the current total.
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
