Strange code in labels ({u'Espa\xf1ol': u'....'}

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Create a large form in excel
2.Use XLSForm to convert it to xml
3.This generates sometimes a strange code in label of the XML form

What is the expected output? What do you see instead?
A strange code: e.g.: {u'Espa\xf1ol': u'Recordthe location again'}. Nothing 
seem to help to remove this strange code from the label (make a new excel 
sheet, smaller labels, remove strange signs, remove possible hidden text 
formating, etc.)

What version of the product are you using? On what operating system?
Mac

Please provide any additional information below.
See attached files

Original issue reported on code.google.com by 4estse...@gmail.com on 25 Jun 2014 at 11:14

Attachments:

• testing(1).xml
• testing.xlsx

[GoogleCodeExporter]

Note: The strange code can be seen in the Spanish label. The English label is 
showed without any error.

Original comment by 4estse...@gmail.com on 25 Jun 2014 at 11:17

[GoogleCodeExporter]

Couldn't even get the form to compile. I opened it in Excel 2011 for the Mac, 
pasted the content on the form into SublimeText (good text editor), copied and 
pasted it back, saved it and it compiles.

Original comment by yano...@nafundi.com on 25 Jun 2014 at 2:02

Attachments:

• testing-works.xlsx

[GoogleCodeExporter]

Here's what I'd recommend as a fix. 

Remove column: settings, default_language
Remove column: survey, label
Remove column: choices, label

Rename column: survey, label::Español to label
Rename column: survey, hint::Español to hint
Rename column: choices, label::Español to label

Basically, get rid of the extra language column. Have one default language 
column (label, hint) and have the second language column as the non-default 
(label::English, hint::English)

Original comment by yano...@nafundi.com on 25 Jun 2014 at 2:19

[GoogleCodeExporter]

Dear helper,

Great advise! It helped. I removed the default label (so the label without
a language setting). I converted this with MAC Excel 2008 (like I did
before) and the problem is solved! So the problem was related to the label,
not to the MAC Excel 2008 software.

Kind regards from happy Eddy

Original comment by 4estse...@gmail.com on 29 Jun 2014 at 11:47

[GoogleCodeExporter]

Dear helper,

Great advise! It helped. I removed the default label (so the label without a 
language setting). I converted this with MAC Excel 2008 (like I did before) and 
the problem is solved! So the problem was related to the label, not to the MAC 
Excel 2008 software.

Kind regards from happy Eddy

Original comment by 4estse...@gmail.com on 29 Jun 2014 at 11:47

[GoogleCodeExporter]

Original comment by mitchellsundt@gmail.com on 8 Aug 2014 at 12:36

• Changed state: Done