You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello! I write this issue to comment about some findings while developing with jspreadsheet.
When using a "calendar" cell, one can give it the "time" boolean option to show the Hours and Minutes in the picker.
For some situations, I believe it's important to also be able to modify the seconds.
For example, precise data entry. I believe this would be a good feature, and something we need to use.
Also, we've tried to modify the value of the calendar by writing on the field either numbers or text, but it seems the only way to interface it is through the interface provided (as shown above). Is there a way to be able to modify the value of the cell outside this interface that we might be missing?
And meanwhile, there's another detail I would like to point out. This one is about masking.
When one uses the mask "h:mm:ss" and write "111111" on it, the result is "11:11:11";
When one uses the mask "dd.mm.yyyy" and write "111111" on it, the result is "11.11.1111";
Both results are what it's expected. However, when we try the following mask:
"dd.mm.yyyy h:mm:ss", we get the result "11.11.1111 15:35:11"
We would like to understand why this happens, that the time changes to this value. And how might we achieve the behavior I'm describing.
We've realized that when changing the cell mask to be a number, it returns "-287861.35" which it's the timestamp, but this doesn't really explain the change from "11:11:11" to "15:35:11".
Thanks in advance!
The text was updated successfully, but these errors were encountered:
We will added the seconds for the roadmad. This should be the hour of your computer, which normally is the default when no other time is default to the component.
Hello! I write this issue to comment about some findings while developing with jspreadsheet.
When using a "calendar" cell, one can give it the "time" boolean option to show the Hours and Minutes in the picker.
For example, precise data entry. I believe this would be a good feature, and something we need to use.
And meanwhile, there's another detail I would like to point out. This one is about masking.
When one uses the mask "h:mm:ss" and write "111111" on it, the result is "11:11:11";
When one uses the mask "dd.mm.yyyy" and write "111111" on it, the result is "11.11.1111";
Both results are what it's expected. However, when we try the following mask:
We would like to understand why this happens, that the time changes to this value. And how might we achieve the behavior I'm describing.
We've realized that when changing the cell mask to be a number, it returns "-287861.35" which it's the timestamp, but this doesn't really explain the change from "11:11:11" to "15:35:11".
Thanks in advance!
The text was updated successfully, but these errors were encountered: