Explore the API
Freeze rows and columns
Navigate a 120-SKU inventory plan while keeping headings and product identifiers on screen.
ResultLive API output
Scroll vertically and horizontally, or jump to K85. The title, headers, SKU, and description remain visible with the default freeze settings.
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
Freeze rows and columns
SheetView.freeze persists frozen data-row and data-column counts independently of the editor's fixed row/column headings. This report freezes four report/header rows and two identifier columns. The long table contains four weekly demand columns and calculated availability and reorder decisions. Change freeze counts, jump to K85, and compare with an unfrozen view.
APIs used
sheet.viewport.freeze()
sheet.viewport.reset()
sheet.viewport.settings
editor.ui.selectRange()
How to explore
Navigate a 120-SKU inventory plan while keeping headings and product identifiers on screen.
Scroll vertically and horizontally, or jump to K85. The title, headers, SKU, and description remain visible with the default freeze settings.
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
