Excel gives me incorrect decimal values for exported data. How can I get this fixed?
SiDiary accepts both the comma and either the dot as a decimal char and doesn't matter, what is configured in your language settings. This is possible because SiDiary does not has to calculate with values in a range above from thousand and it is interpreting both characters as decimal characters. Unfortunately Excel does not.
If you have problems that SiDiary is showing a decimal value like 5.1 but Excel displays 51 you can setup a fixed decimal character for the export functionality of SiDiary. Just add the following key to your SiDiary.ini file:
[Einstellungen]
:
:
DecimalChar=
Valid characters are comma and dot. SiDiary will now convert (after a restart) each decimal value before it is sent to Excel. You have to try out (it's dependant to your country), if the comma or the dot will help you - but one of them should make Excel display the correct values.