🐛 Bug: date cell copy paste related

[dstala]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

Copy paste doesn't work for following format date cell (date tried was 20 Dec 2023). PG was root DB

• DD-MM-YYYY
• DD/MM/YYYY
• DD MM YYYY
• YYYY MM (source cell had 2023 05; after paste, 2023 01 was displayed)

Error

index.ts:917 Error: Not a valid date
    at convertCellData (convertCellData.ts:64:17)
    at HTMLDocument.handlePaste (index.ts:855:30)

Issue is noticed with dateTime cell as well

Desired Behavior

copy paste contents appropriately

Project Details

202.9 + wkw DD YYYY PR (issue noticed in develop as well)

Attachments

No response

[gauravruhela07]

@dstala @wingkwong I want to work on this issue, can you please assign it to me? Thank you.

[wingkwong]

@gauravruhela07 I'm working on it. Please ask for those issues with no assignees instead.

[wingkwong]

@dstala I couldn't reproduce in develop branch. Have you run pnpm run bootstrap first?

[harijoe]

I confirm the bug exists on 0.204.0

For example it happens when the date field format is set to DD-MM-YYYY (e.g. french notation).