Issue entering new values in date/time cells
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 50
- Forks
- 53
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 1
Description
Referring to the "Collaborative features" spreadsheet in the demo (https://demo.vaadin.com/spreadsheet/):
If you enter the value "1/1/17" in D7 (currently "1/1/15"), the new value becomes a String (not a numeric date), and so the formulas in column B no longer work.
This new value should be detected as a date, and converted to the appropriate number (42,736 in this case).
The same issue occurs for time. If you enter a time (say, "9 PM"), this value is saved as a String, not as the number 0.875).
Contributor guide
No contributing guide indexed for this repository
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
Reproduce the issue in the Collaborative features spreadsheet demo at https://demo.vaadin.com/spreadsheet/ by replacing D7 with 1/1/17 and entering 9 PM in a time cell. Trace how edited date and time values are classified and stored, then verify that they become numeric values and that the formulas in column B continue to work.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100