Explore the API
Custom formula functions
Price an eight-customer subscription portfolio with volume tiers and support policies. Change the first quote or compare tier boundaries.
ResultLive API output
At 50 Business seats, the seat price is $28.80 and Priority support is $99: $1,539 per month. Tier comparisons are added at A21.
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
Custom formula functions
SEATPRICE is an application-defined function with all-seat volume discounts: 10% from 50 seats and 20% from 200 seats. SUPPORTFEE applies service percentages with minimum fees. Ordinary formulas build license charges, monthly fees, annual contracts, and portfolio totals from these custom results. The functions are registered again after reset because executable callbacks are not saved inside workbook files.
APIs used
Workbook.calculation.registerFunction()
Workbook.calculation.recalculateAsync()
Cell.setFormula()
How to explore
Price an eight-customer subscription portfolio with volume tiers and support policies. Change the first quote or compare tier boundaries.
At 50 Business seats, the seat price is $28.80 and Priority support is $99: $1,539 per month. Tier comparisons are added at A21.
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
