Hi all. Is there a way to set the displayed time in the time widget in ODK
Collect? Right now, it show the time when the
form is started. I thought filling in the "default" column in XLSForms
would work.
Advance thanks.
Chien-Li Chung
Hi Chien-Li,
Looking into this I discovered that Excel stores dates and times as
floating point numbers, and in order to use them in XLSForm I will need to
convert them back into text. I'll try to add that conversion next time I
update the code, but chances are I won't get it completely right as there
are a number of problems with Excel dateshttp://www.lexicon.net/sjmachin/xlrd.html.
In the mean time, you can set default times by tricking Excel into thinking
the times you enter are just text by placing spaces before them. You can
also do this by highlighting a cell, selecting 'format cell' from its
right-click menu, and changing the category to text. Times are expected to
be of the format hh:mm on a 24 hour clock.
Regards,
-Nathan
ยทยทยท
On Sunday, September 30, 2012 1:58:22 PM UTC-7, Chien-Li Chung wrote: > > Hi all. Is there a way to set the displayed time in the time widget in ODK > Collect? Right now, it show the time when the > form is started. I thought filling in the "default" column in XLSForms > would work. > > Advance thanks. > > Chien-Li Chung > >Waylon pointed out to me that you can also put single quotes before
dates/times to make Excel treat them as text.