close
 
Service - FAQ

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.

Plattforms Plattforms Plattforms

CHOISISSEZ VOTRE SUPPORT!

SiDiary pour la maison et mobile »»»
Meters, pumps, scales, pedometers

UN OUTIL UNIVERSEL!

SiDiary lit plus de 300 appareils »»»
Auszeichnungen

CERTIFIÉ 5 ÉTOILES!

SiDiary parmi les mieux notés »»»