Migrating from ReoGrid V3 to V4 — A Practical Guide

· unvell team
Migrating from ReoGrid V3 to V4 — A Practical Guide

Why this post exists

We’ve been getting the same question from existing ReoGrid V3 users:

“Can I just swap the V3 DLL for the V4 DLL and rebuild?”

Short answer: a few code changes are needed, and they are mechanical. V4 introduced a handful of class renames, removed a few exception types, and reorganized the data-binding and filtering APIs. Old names were removed outright rather than marked [Obsolete], and most projects can be migrated with find-and-replace plus a few structural fixes.

We’ve published a full migration guide in the docs:

➡️ Migrate from V3 to V4

This blog post is the 90-second summary.


What breaks at compile time

Seven categories of rename / removal that your V3 code will hit:

  • Action base class — BaseWorksheetAction → WorksheetAction
  • Outline types — ReoGridOutline → BaseOutline, IReoGridOutline → IOutline
  • Header type — ReoGridHeader → WorksheetHeader
  • Dropdown hierarchy — DropdownListCell now extends a new DropdownListBaseCell
  • Formula exceptions removed — FormulaEvalutionException, FormulaNoNameException, FormulaParameterMismatchException, FormulaTypeMismatchException are gone; check Cell.FormulaStatus instead
  • Validation rename — RangePosition.IsValidAddress → IsValidAddressFormat (V4.3.0)
  • ConditionalStyleApplyCells removed — use Cell.HasConditionalStyles or Worksheet.HasConditionalStyle(...) (V4.4)

The core API surface — Workbook, Worksheet, Cell, RangePosition, CellPosition, WorksheetRangeStyle — stays the same as in V3.


What changes at runtime (compiles, but behaves differently)

These are Excel-alignment improvements. Most users will want the new behavior, but they’re worth being aware of:

  • Sort moves formulas with rows. V3 sorted only the data; V4 keeps formulas attached to their row (Excel-compatible).
  • Conditional styles are evaluated at render time, which makes them much faster on large sheets.
  • Excel-compatible formula parsing. Unary plus (=+D25-...), quoted sheet names with parentheses ('BS(USD)'!B3), IF(0, ...) evaluating the FALSE branch, and =A1/0 returning #DIV/0! all behave like Excel now.
  • String multiplication coercion. ="10"*2 returns 20 instead of erroring.
  • VLOOKUP / HLOOKUP / MATCH / XMATCH / XLOOKUP are implemented.

New APIs worth adopting

Once your V3 code compiles cleanly under V4, these are the V4-only features most worth integrating:

  • Lazy loading for million-row datasets via Worksheet.AddDataSource(...) with DataSourceLoadMode.LazyLoading
  • Multi-row column headers via Worksheet.ExtensionColumnHeader
  • Conditional styles via the Rule class
  • Conditional filters via ConditionalDataFilter
  • Three-level cell locking via the new CellLock enum
  • Workbook-wide highlighted text search via HighlightTextSearchSession
  • Excel-compatible custom number formats (e.g. "#,##0;[Red]-#,##0")
  • WinAppDriver UI automation via ReoGridControl.EnableUIAutomation = true

See the What’s New in V4 page for the full feature catalog.


Distribution and licensing

V4 is currently delivered as DLLs through the customer portal after purchase. (NuGet packages will be released later.) The namespace and the assembly name stay the same as in V3, so on the build-configuration side, swapping the DLL reference is all it takes. V4 runs on .NET Framework 4.8 and .NET 8 (Windows).

V4 is offered as Professional (up to 3 devices, 1 month support) and Enterprise (unlimited devices, 3 months support). See Pricing for current rates.

V3 remains available as MIT-licensed open source on GitHub.


Read the full guide

The migration guide in our documentation has all the details — diff-style code samples for each rename, a step-by-step checklist, and notes on edge cases:

➡️ Migrate from V3 to V4 — full guide

If you hit a migration issue not covered there — especially around custom cell types, custom actions, or large data binding flows — please contact us. We can advise on the best V4 equivalents for your V3 patterns.

Try ReoGrid in your own project

The Excel-compatible spreadsheet component for .NET WinForms and WPF. 30-day free trial — no credit card required.

Newsletter

New releases, straight to your inbox

Occasional updates on ReoGrid releases, features, and technical articles. Unsubscribe anytime.

Related articles