Calendar Date-Time Picker

[jramirez-struc]

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.

1. 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.
2. 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!

[hodeware]

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.