Tag: #avalonia
4 articles
-
Excel Tables in C# — What "Format as Table" Actually Saves, and How to Create One
Excel's "Format as Table" looks like formatting — a coloured header, striped rows — yet not one cell in the saved file carries a fill. What Excel stores is an object: a range, a header row and a style name. This guide opens up the table part of an .xlsx, explains what the 60 built-in styles really contain, and names the three details that decide whether Excel will open the file at all — then builds a table with filter buttons and a totals row in C# with ReoGrid V5.1.
-
SUBTOTAL vs AGGREGATE — The Totals That Follow the Filter, and When to Use Each
A plain SUM counts rows the filter just hid, which is why a filtered list so often shows a total nobody asked for. SUBTOTAL is the Excel answer, and AGGREGATE is its superset — it can also step over the one
-
Building an Input Sheet Users Can't Break — Data Validation, Cell Notes, and Sheet Protection in ReoGrid V5
The moment you put a grid on screen, someone deletes a formula and types "12,000 USD" into a price column. ReoGrid V5 ships the three Excel tools that stop that — data validation, cell notes, and sheet protection — and they do genuinely different jobs. We build a quotation template in C# and cover the Excel-compatible gotchas along the way — paste is never validated, the password is not encryption, and two permission flags default the other way.
-
ReoGrid V5 Is Coming — A Next-Generation Rebuild, and a New Licensing Model from August 19, 2026
ReoGrid V5 is a next-generation release rebuilt from the core around a fully virtualized architecture — faster and lighter on memory in both WinForms and WPF, with support for a new platform, Avalonia. Alongside the V5 release on August 19, 2026, we will move to a new licensing and pricing model. Full details will be published when V5 goes on sale.