Tag: #v5
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.
-
Spreadsheet to PDF in C# — No Office, No Printer Driver, No PDF Library
"Email them the report as a PDF" is a one-line requirement that turns into a week. Office Interop is unsupported in a service, the Print to PDF driver needs a spooler, headless Chromium is a browser in your image, and a PDF library means re-laying-out the table by hand. ReoGrid V5 exports PDF from the same renderer that paints the grid — zero package dependencies, no System.Drawing, and it runs in a Linux container with a Japanese font already embedded.
-
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.