Hallo,
I tried various options to get the correct declaration for NumberFormat in
calc. The LocalSetting.Language and Country is "de" for Germany.
In my table I get the value before the comma correctly, however, the after
comma values show zeros. Below, you see the code for the format:
ZahlenFormat = oTabellenDokument.NumberFormats
ZahlenFormatString = "##.##0,000"
ZahlenFormatId = ZahlenFormat.QueryKey(ZahlenFormatString,
LokaleEinstellungen, True)
If ZahlenFormatID = -1 Then
ZahlenFormatID = ZahlenFormat.addNew(ZahlenFormatString,
LokaleEinstellungen)
EndIf
Your help would be appreciated. Thanks.
Rudi
