jspreadsheet / jspreadsheet/ce
Paste dirty string to dropdown column
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 7.2k
- Forks
- 890
- PR merge metrics
- No merged PRs in 30d
Description
How to reproduce:
- Go to https://bossanova.uk/jexcel/v4/examples/date-and-datetime-picker
- Copy to clipboard some random string, like "Test test test"
- Paste it to cell B1 (Region dropdown). Cell looks empty. It is ok.
- In browser console exec:
document.getElementById('spreadsheet').jexcel.getData();
Result is:
0: Array(3) [ "Flag Fen", "Test test test", "2020-04-19" ]
1: Array(3) [ "Bristol Aero Collection (BAC)", "South West", "2019-04-03" ]
...
Table don't show me unexpected value, but may send it to server.
What I expect? - Empty value will be ok, I think.
Screenshot attached.
I see the same thing on calendar type with any format settings.
How do you recommend to bypass this trouble?
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the date-and-datetime-picker example at the linked URL and reproduce the paste through cell B1. Use document.getElementById('spreadsheet').jexcel.getData() to compare the displayed value with the stored value, including the calendar type. Done means an invalid pasted string is not retained in the returned data, with the same behavior across the mentioned format settings.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript
- Domain
- frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100