ianscriven
commented
7 years ago This is actually a wider-reaching feature request. There are a bunch of other formats that don't work as expected (there are probably more):
- Currency ($100 should be saved as the number 100, with a currency format)
- Scientific notation
On the other hand, percentage works (10% is saved as 0.1, with a percent format), so there must be some support/framework for doing this type of parsing when values are entered.
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).