News for hackers. Stuff that matters.
Re:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Friday November 24, 2023 @06:11PM (#38409396)
Did you try to enter a date? Any sample text, so that i can try to pinpoint this issue?
Re:React Spreadsheet 2 – Your Own Google Sheets by koito17 on Friday November 24, 2023 @06:13PM (#38409412)
Using Chrome 119, I see

  SyntaxError: Invalid regular expression: /^(?<year>\d{4})(\-)(?<month>\d{1,2})(\-)(?<year>\d{1,2})T(?<hour>\d{1,2})\:(?<minute>\d{1,2})\:(?<second>\d{1,2})(Z?)$/i: Duplicate capture group name
This happens whenever I insert text to any cell. I just tried inserting "TEST" to a cell on the first sheet, then pushed the Enter key. It also happens when I use arrow keys to move away from a cell I am editing.
Re:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Friday November 24, 2023 @06:16PM (#38409442)
Ah. Yes i figured out the issue. Could you share your current location? Are you in the US or Japan? We create a date pattern matching expression based on your current locale.
Re:React Spreadsheet 2 – Your Own Google Sheets by koito17 on Friday November 24, 2023 @06:20PM (#38409479)
Yeah, I am currently in the US, using a MacBook with Japanese locale set.
Re:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Friday November 24, 2023 @06:35PM (#38409586)
Awesome. I have fixed this issue for you.
Re:React Spreadsheet 2 – Your Own Google Sheets by eigenvalue on Friday November 24, 2023 @07:00PM (#38409746)
Cool, real-time debugging and deploying a fix in minutes. We've come a long way since the days of shrinkwrapped spreadsheet software sold in a store.
Re:React Spreadsheet 2 – Your Own Google Sheets by rowsncolumns on Friday November 24, 2023 @06:15PM (#38409427)
Thanks for the feedback. I will look into this.

Does the error go away if you just refresh the demo?

Re:React Spreadsheet 2 – Your Own Google Sheets by koito17 on Friday November 24, 2023 @06:16PM (#38409436)
Yeah, refreshing the page makes everything work again. I can see changes to the spreadsheet in real-time and I am capable of resizing cells, changing fonts, etc. The only problem is with editing the contents of a cell.