Skip to content

Pasting dates from Excel or Google Sheets does not work in date cells #541

@syedsajjadkazmii

Description

@syedsajjadkazmii

When pasting dates from Excel, SharePoint Excel, or Google Sheets into a ReactGrid date column, none of the dates are recognized. The pasted cells show blank or Invalid Date.

This occurs regardless of whether the day is single-digit or double-digit.

To Reproduce

Steps to reproduce the behavior:

  • Copy a column of dates from Excel, SharePoint Excel, or Google Sheets (example below).

11/6/2025
11/10/2025

  • Paste them into a ReactGrid date column.

  • Observe that the cells remain blank or contain Invalid Date.

Environment:

ReactGrid version: 4.1.17
Browser: Chrome
OS: macOS

Additional context / Notes

The root cause seems to be how handlePaste parses clipboard data:
https://github.com/silevis/reactgrid/pull/525/files -> clearly the regex doesn't accept 1 digit months.

Screen.Recording.2025-10-02.at.5.50.25.PM.mov

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions