UNVELL Inc.UNVELL
ARTICLES

ReoGrid Web 1.2.1 Released — Major Formula and Editing Enhancements

reogridreogrid-webspreadsheetreleasejavascript
May 15, 2026·UNVELL Inc.
ReoGrid Web 1.2.1 Released — Major Formula and Editing Enhancements

UNVELL Inc. has released ReoGrid Web 1.2.1, the latest version of our Excel-like spreadsheet library for web applications. The 1.2.x series, built up since the official launch in March, has pushed the formula and editing experience to a level that genuinely feels like Excel. There are no breaking changes to the public API.

1.2.1 highlights

1.2.1 extends the drag interaction on the formula reference highlights that appear on the grid while editing a formula.

  • Drag the dashed border to move a range: dragging the dashed edge of a reference rectangle translates the entire range.
  • Drag a corner grip to resize: dragging one of the four corner grips resizes the range. Resize uses cell-center boundaries — a cell only joins or leaves the range once the pointer passes its midpoint — matching Excel and our .NET edition.
  • When the same reference appears multiple times in the formula text, every occurrence is rewritten in step, preserving each token's absolute-reference ($) flags.
  • Small colored corner squares are drawn on each highlight to make the resize hot-zone discoverable, with hover cursors (move, nwse-resize, nesw-resize) on the border and corners.

The result: you can adjust a formula's reference ranges intuitively, entirely with the mouse.

What the 1.2.x series added

Leading up to 1.2.1, the 1.2.x series shipped these headline features.

Formula library expanded to 109 functions

ReoGrid Web now supports 109 Excel-compatible built-in functions spanning lookup/reference, multi-criteria aggregation, dates, math/trig, statistics, text, and reference categories. Formulas inside imported .xlsx files work out of the box.

CategoryExamples
Lookup / referenceVLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, XMATCH
Multi-criteria aggregationSUMIFS, COUNTIFS, AVERAGEIFS, SUMPRODUCT
DateTODAY, NOW, YEAR, MONTH, DAY, WEEKDAY, EDATE, EOMONTH, DATEDIF
Math / trigEXP, LN, LOG, SIN, COS, TAN, ATAN2, RAND, RANDBETWEEN
StatisticsMEDIAN, LARGE, SMALL, RANK, CEILING, FLOOR, MROUND
TextSEARCH, EXACT, PROPER, CHAR, CODE

Argument order and the gotchas follow Excel. For example, Excel's ATAN2(x, y) reverses the argument order of JavaScript's Math.atan2(y, x) — the library follows Excel.

Excel-like formula reference editing

When you edit a formula starting with =, every reference you enter (A1, B2:D10, etc.) is color-coded inline from a shared 8-color palette, and the grid draws a matching dashed rectangle around each referenced range. Clicking another cell inserts its address at the caret; drag extends it into a range. When a reference overlaps a merged region, the highlight expands to enclose the full merged area.

Autofill (fill handle)

A small square at the bottom-right of the selection lets you drag to extend values up, down, left, or right.

  • Single cell: tile-copies the value.
  • Two or more numeric cells: extrapolates as an arithmetic progression (1, 2 → 3, 4, 5).
  • Date-formatted cell: increments by one day per step.
  • Formula cells: shift relative references like Excel; absolute $ references are preserved.

Styles, number formats, and cell types propagate to the new region, with full undo/redo support.

Idiomatic React / Vue event props

Worksheet events are now exposed as React props and Vue emits. You can wire up onSelectionChange, onCellValueChange, onScrollChange, and more declaratively, with no imperative worksheet.on*() calls.

import { Reogrid } from '@reogrid/pro/react';

<Reogrid
  onReady={({ worksheet }) => worksheet.cell('A1').setValue('Hello')}
  onSelectionChange={(range) => console.log('selected', range)}
  onCellValueChange={({ row, column, newValue }) => save(row, column, newValue)}
  style={{ width: '100%', height: 500 }}
/>

Per-side border overrides in conditional formatting

Conditional format rules can now carry a border payload that overrides cell borders per side (right / top / bottom / left) on matching cells. These round-trip through xlsx <dxf><border>, so formatting survives an Excel load-and-save.

Faster rendering engine (~70% fewer Canvas calls)

The Canvas render path now caches ctx.font, ctx.fillStyle, and measureText, plus wrapped/multi-line text layout, on a per-frame basis — cutting Canvas API calls during scroll by roughly 70%+ per frame on text-heavy sheets. Frame rates stay stable even on dense sheets.

Getting started

The Lite edition requires no license key and is available on npm.

npm install @reogrid/lite

The Pro edition adds the 109-function formula library, xlsx export, the full set of cell types, and more.

Back to articles