Folks, forgive me all the screenshots, but I spent all day frustrated becoz of this bug.
It's a little bug, I'm sure, but it's a subtle bug.
On the XLSForm.org page (http://xlsform.org/#relevant), in the section on Relevant, there is some sample code, which I took the time to load into a spreadsheet, and convert to an XML using this tool (http://opendatakit.org/xiframe/).
Now, the spreadsheet, test.xls, when loaded and submitted, crashes in a shower of sparks. Being an avid amateur firefighter, I found that removing the single quotes around 2 variables and saving the spreadsheet without the single quotes, produced a completely different result. No crash.
However, when I loaded the resultant test.xml onto my POS tablet, I was surprised to find that the behaviour described in the Relevant section did NOT occur.
I even passed the test.xml through the java validator tool and it produced no errors.
But, having read on this forum that the single quotes were NECESSARY, I edited test.xml directly and replaced the single quotes around the two variables in the attributes 'relevant=', etc.
The resulting test-WITH-SINGLE-QUOTES.xml, when loaded onto the POS tablet, did, in fact, produce the expected behaviour described in the Relevant section on the XLSForm.org page.
To my simple mind, this suggests that the tool (http://opendatakit.org/xiframe/) has a bug, which is excited by the particular circumstance described in the Relevant section.
As I KNOW that you guys are way better than me at this kind of stuff, I thought I'd bring it to your attention, in the hope that this could be corrected, as it might give others the idea that the online tool (and by association, ODK) does not work. That would be a great pity.
I personally think ODK is one of the best pieces of software I have had the great fortune to run across in my career. I can't stop talking about it.
Have a pleasant week, folks.
Seth
test.xls (8.5 KB)
