gridcn2.0.0
Support and upgrades

2.0 add-on breaking changes

Each import, export, find and replace, and presence breaking change from 1.3 to 2.0 with the 1.3 form, the 2.0 form, and the change to make.

Each row is one Breaking: entry of the changelog. 2.0 breaking changes lists the core grid rows. Migrate to 2.0 gives the order of the steps.

AreaRows
Import and exportDelimiters, limits, XLSX
Find and replace and presenceFind, presence
Pinned rowsReducers

Import and export

Change1.32.0What to change
Import on a readOnly gridRuns when onImport is setDisabled, with labels.io.importReadOnlyClear readOnly to allow an import.
CSV delimiter detectionU+001E and U+001F tooComma, semicolon, tab, or pipeParse such a file in parseFile.
autoDetectDelimiterautoDetectDelimiter: falseRemovedSet defaultDelimiter.
parseImportFile signalparseImportFile(file, options, signal)parseImportFile(file, { ...options, signal })Move signal into the options.
XLSX part capThe lower of maxDecompressedBytes and the maxCells capmaxDecompressedBytes as givenCheck a high value that you set.
buildImportedRows resultA value or a PromiseAlways a PromiseUse await on it and on build().
Dropzone propssrc, onErrorfiles. A throw from onDrop propagates.Rename src. Catch errors in onDrop.
Empty drop zone captionlabels.io.noFileChosenlabels.io.emptyDropzoneCaption(maxSize)Override emptyDropzoneCaption.
XLSX sheet nameworkbookNamesheetNameRename the option.
buildXlsxReturns the XLSX BlobRemoved. The output option of exportGrid receives the Blob.Call exportGrid with format: "xlsx" and output.
rowsToCsv argumentsrowsToCsv(rows, ";", false)rowsToCsv(rows, { delimiter: ";", sanitizeFormulas: false })Pass an options object.
printGrid paper sizepageSize: "A3"paperSize: "A3"Rename it.
Two import columns on one grid columnThe later column winsThe first winsMap a grid column once.
printGrid resultvoidPromise<{ rowCount, truncated }>Await it to catch a rejection.
XLSX cell typesEvery cell is textnumber, date, and checkbox columns write typed cellsFor text, set formatCell: ({ text }) => text.

Find and replace and presence

Change1.32.0What to change
useDataGridFindReplace().open()Opens the replace modeOpens the find mode, as Mod+FCall open("replace").
Presence onExcessRects(entry, kept, total) in render({ entry, kept, total }) after the commitTake one object.
PresenceHighlightExportedViewRangePresenceHighlightRename.

Pinned rows

Change1.32.0What to change
Reducers of useDataGridAggregate and aggregateRowcount counts "". A reducer with no number gives undefined.count skips "". A reducer with no counted value gives null.Test for null where you tested for undefined.
DataGridViewState of data-grid-viewsFields sorts, filters, searchText, searchOptions, columnLayout.Adds the field groupBy: string[]. A stored view without it reads as [].Add groupBy: [] where your code builds a DataGridViewState.

On this page