Release Notes

Version history and changelog for ReoGrid.

v4.3.0 2025

Renamed IsValidAddress to IsValidAddressFormat for clearer naming.
Added Worksheet.IsValidAddress for stricter address string validation.
Added IsValidCellAddress and IsValidRangeAddress to safely generate coordinate objects while validating address validity, with improved performance.
Enhanced robustness by utilizing IsValidCellAddress / IsValidRangeAddress in ReoGrid internal processing.
Fixed an issue where cells were not loaded correctly when zooming during Lazy Loading.
Enhanced the ADDRESS function to dynamically generate addresses from referenced cell values.
Enhanced the INDIRECT function for more accurate cell reference management and proper interpretation of lowercase addresses.
Fixed an issue where row number text was not scaled during zoom operations.
Fixed an issue where Excel files containing certain RichFormatText became corrupted when loaded and saved.

Changed target framework from net8.0-windows7.0 to net8.0-windows, supporting more general .NET 8 Windows environments.

v4.2.4

Improved recalculation after worksheet cloning — resolved cases where calculation results became inconsistent or outdated immediately after cloning sheets containing shared formulas and dependency chains. In most cases, additional Recalculate calls are no longer necessary after cloning.
Improved reliability of border Excel output — normalized to avoid writing empty/transparent borders as unnecessary "thin" styles. Fixed mapping for Dotted / DashDot / DashDotDot / medium border styles to prevent shape corruption during re-import. Resolved an issue where unnecessary opposite lines appeared in corner cells when the "outside only" setting was applied.

If you were using inner lines that were unintentionally added after setting "outside only" in previous versions, you will need to explicitly set them again.
Code that called Recalculate immediately after cloning may become redundant (it can be kept for performance tuning purposes).

v4.2.3

Enhanced Excel compatibility — 0 is now interpreted as FALSE in IF functions and similar contexts.
Implemented lookup functions: VLOOKUP, HLOOKUP, MATCH, XMATCH, and XLOOKUP.
Multiplication operator (*) can now convert numeric strings to numbers (e.g., "10"*2 → 20).
Division by zero is now processed as InvalidValue (Excel-compatible #DIV/0!).

When using approximate matching, data must be sorted in ascending or descending order, the same as Excel.

v4.2.0

v4.1.0

v4.0.0 Major Release