I see what the problem is in the code but this seems to be an old bug and I have the same problem in 0.9.3 so I would like to understand whether we are talking about the same bug or if it's two different ones.
The problem is that it is writing the value with the comma as decimal separator in the XML. The spreadsheet expects it with a dot. This issue is specific to the angle tool.
One confounding factor is that in 0.9.3 and prior versions the angle tool doesn't show decimals in the user interface.
I only have LibreOffice Calc on this machine and I import the MS-Excel file into it so this may be a factor as well. I get the same results when exporting to ODF anyway.
For reference:
Windows settings: Control panel > Region > Formats > Additional settings > "Decimal symbol".
LibreOffice settings: Tools > Options > Language settings > Languages > "Locale setting" and "Decimal separator key".
Experiment 1:
- Windows regional settings: ,
- LibreOffice settings: Locale=French (France), Decimal separator: Same as locale setting (,).
- Kinovea 0.9.3.
- Export to MS-XML.
- Opened in LibreOffice: BUG. The data is stored with a comma which is interpreted as thousand separator by the spreadsheet.
Experiment 2:
- Windows regional settings: .
- LibreOffice settings: Locale=French (France), Decimal separator: Same as locale setting (,).
- Kinovea 0.9.3.
- Export to MS-XML.
- Opened in LibreOffice: GOOD. The data is stored with a dot. The spreadsheet then display it with commas.
In summary:
- The bug is triggered when using comma as decimal separator in Windows (I will fix this).
- Using dot as decimal separator in Windows works around the bug.
- Changing the spreadsheet option only impacts the spreadsheet display and doesn't trigger the bug.
I get the same problem using 0.8.27, 0.9.3, 0.9.5.
Can you describe your configuration where it was working in 0.9.3?
Thanks