Tag: #.net
23 articles
-
When Your Nested IFs Go Three Levels Deep, Switch to IFS — Sorting Out IF / AND / OR / IFERROR
Pass/fail checks, letter grades, achievement-rate rankings — business spreadsheets are full of conditional logic. Everyone's first tool is IF, but once the nesting gets deep the parentheses become unreadable. This guide sorts out IFS for flattening nested IFs, AND / OR for combining conditions, and IFERROR for turning errors into sensible defaults — then shows how ReoGrid (IFS / IFERROR supported since V4.5) runs the same formulas inside a WinForms / WPF app, no Office required.
-
Split Full Names, Parse Codes, Join Columns — Text Manipulation with LEFT, MID, FIND, SUBSTITUTE and TEXTJOIN in C#
Splitting full names into first and last, pulling the domain out of an email address, breaking a product code apart at the hyphens — string cleanup is one line of C# with Split, but if users need to see and fix the results on screen, spreadsheet formulas are the better tool. This guide covers the workhorse recipes built from LEFT, MID, FIND, SUBSTITUTE, and TEXTJOIN, the classic traps (stray spaces, the missing SEARCH function), and how ReoGrid (supported in V4.5) runs the same formulas inside a WinForms / WPF app — no Office required.
-
EDATE, EOMONTH, WORKDAY, NETWORKDAYS — Business Date Calculations with Spreadsheet Formulas in C#
"Due at the end of next month," "ship within 5 business days," "remind 3 business days before the deadline" — business apps are full of date rules that are surprisingly fiddly to hand-code with DateTime. Excel solved them long ago with EDATE, EOMONTH, WORKDAY, and NETWORKDAYS. This guide sorts out what each one does, the classic off-by-one traps, and how ReoGrid (supported in V4.5) runs the same formulas inside a WinForms / WPF app — no Office required.
-
MATCH vs XMATCH — The Lookup Functions That Return a Position, and When to Use Each
MATCH and XMATCH both return "where a value sits (its position)" rather than the value itself. They differ in their default match mode, reverse search, and wildcard handling. This guide sorts out the differences with examples, shows how to combine them with INDEX to pull values more flexibly than VLOOKUP, and demonstrates how ReoGrid (supported in V4.5) runs the same formulas inside a WinForms / WPF app — no Office required.
-
VLOOKUP vs HLOOKUP vs XLOOKUP — Knowing the Difference and Using Them in a C# Spreadsheet
VLOOKUP, HLOOKUP, and XLOOKUP look alike, but they differ in which direction they search, how you point at the value to return, and what happens when nothing is found. This guide sorts out the differences with tables and examples, shows why XLOOKUP fixes VLOOKUP's weak spots, and demonstrates how ReoGrid (supported in V4.5) runs the very same formulas inside a WinForms / WPF app — no Office required.
-
GrapeCity SPREAD vs ReoGrid — Choosing a .NET Spreadsheet for Light Weight, Speed, and Large Data
GrapeCity SPREAD (now MESCIUS / SPREAD.NET) is a proven, full-featured .NET spreadsheet suite. ReoGrid is a lightweight, fast alternative. This is an honest comparison — SPREAD wins on breadth of features and ecosystem maturity; ReoGrid wins on a single-DLL footprint, rendering speed, large-data handling, and a free-to-start path. Here's how to pick for a given project.
-
When Search and Deduplication Quietly Fail on Japanese Data — Normalizing Full-Width / Half-Width Text in a C# App
An address in half-width kana, a phone number in full-width digits, the same company filed twice as "(株)" and "（株）" — Japanese input data mixes full-width and half-width characters, and as-is, search, deduplication, and totals all silently break. With ReoGrid you can bulk-convert using the Excel-compatible JIS / ASC functions, and auto-normalize on entry via AfterCellEdit. Build business data in C# that doesn't break on width inconsistency.
-
Stop Invoice Totals From Drifting by a Yen — Currency Formatting, Consumption Tax, and Rounding in C# with ReoGrid
Hold money in a double and you get rounding error; turn it into a string and totals and sorting break; round consumption tax in the wrong place and your invoice is off by a yen. Money breaks in business apps for predictable reasons. With ReoGrid, cell data stays numeric while it displays as ¥1,234,567 — and reduced-rate (8%/10%) subtotals and invoice-compliant rounding are just formulas.
-
Announcing ReoGrid 4.5 — 47 Excel-Compatible Functions and Point-Mode Formula Editing
ReoGrid 4.5 adds 47 Excel-compatible formula functions, point-mode formula editing, XLSX outline (grouping) import/export, and major XLSX load-time performance and memory improvements.
-
Stop CSV Data From Being 'Fixed' When Opened in Excel — Control Encoding and Column Types in Your C# App
ZIP code 01950 becomes 1950, product code 1-2-3 becomes a date, and a UTF-8 file shows up as garbled text — CSV breaks because the file carries no type information and whatever opens it guesses. In your own app, you declare the encoding and the per-column types. Build a CSV viewer / importer in C# with ReoGrid that doesn't corrupt your data.
-
Japanese Era (Wareki) Date Cells in C# — Display 令和8年6月6日 While the Data Stays a DateTime
Invoices, contracts, birthdates — apps for the Japanese market must show dates in the era calendar (Reiwa, Heisei, Showa). Convert to strings and you break sorting and formulas. With ReoGrid, one format pattern shows wareki while every cell keeps a real DateTime.
-
Build a Receipt Generator in About 30 Lines of C# — Excel Template + ReoGrid
Don't lay out a receipt in code. Design it once in Excel, then let ReoGrid load the template, fill the blanks, save a copy, and print. A complete WinForms app in about 30 lines of C#.
-
Printing a Spreadsheet in C# — Print, Preview, and PDF in WinForms and WPF
How to print a worksheet from a .NET desktop app — print preview, the system print dialog, printing straight to PDF, plus paper size, margins, orientation, scaling, and page breaks. Working C# code for WinForms and WPF.
-
Adding Custom Cells to a WinForms or WPF Spreadsheet — Progress Bars, Sliders, and Dropdowns with CellBody
How to use ReoGrid's CellBody API to build cells with custom rendering and interaction in WinForms and WPF apps. Practical C# examples including a progress bar, an interactive slider, and a status badge cell.
-
Reading, Writing, and Displaying Excel Files in VB.NET
A practical guide to working with .xlsx files in VB.NET — reading data, generating reports, and embedding a live spreadsheet viewer inside a WinForms or WPF desktop app. No Office required.
-
Displaying Large Datasets Efficiently in WPF — When DataGrid Stops Scaling
WPF DataGrid is virtualized out of the box, but virtualization isn't the same as "fast." This article walks through where DataGrid stalls on 100k+ rows, how far tuning gets you, and the lazy-data-source pattern that handles a million rows without freezing the UI.
-
Migrating from ReoGrid V3 to V4 — A Practical Guide
A short overview of what changes when upgrading an existing ReoGrid V3 application to V4 — what breaks at compile time, what changes at runtime, and the new APIs worth adopting.
-
Display and Edit an Excel File in a WinForms or WPF App with C#
How to embed a working Excel viewer inside a .NET desktop app — load .xlsx, let users edit cells and formulas, save back to disk. Minimal WinForms and WPF examples in C#.
-
Export a DataTable to Excel (.xlsx) in C# Without Office Interop
How to write a DataTable out as a real .xlsx file from C# — headers, formats, multiple sheets, and the ASP.NET Core download pattern. Side-by-side examples with ClosedXML, EPPlus, and ReoGrid.
-
Announcing ReoGrid 4.4 — Performance Improvements for Large-Scale Data
ReoGrid 4.4 maintains full API compatibility while delivering ~11,700× faster bulk data loading with conditional formatting, ~10× faster sorting of 10,000 rows, and ~3× faster bulk loading via SetRangeData.
-
Excel-Style Conditional Formatting in .NET Applications
How to add conditional formatting — color highlights, data bars, icon sets — to a .NET WinForms or WPF spreadsheet. Covers the rule model, performance pitfalls when applied to large ranges, and patterns that round-trip cleanly to Excel.
-
Choosing the Right Editable Grid for WinForms and WPF Apps
A pragmatic guide to picking a data grid for desktop .NET apps. Compares DataGridView, WPF DataGrid, third-party grids, and full spreadsheet components — and explains which problems each one is actually built to solve.
-
Reading and Writing Excel Files in C# Without Office Interop
A practical guide to handling .xlsx files from C# without installing Microsoft Office. Compares the main approaches — OpenXML SDK, ClosedXML, EPPlus, NPOI, and ReoGrid — and shows working code for the common cases.