Hi Niklas,
I can stop the routine and look at the actual value Hoch = Val(Hoch) and get
the correct result; it shows the
values after the comma (clicking at the field-Name "Hoch"); however, in the
table itself the values show after
the comma the value zero; I have the coded ZahlenFormatString =
"##.##0,000"; if I would code the
ZahlenFormatString = "##.##0,123", then I would get on each cell the correct
value before the comma and
after the comma I would get ,123 as value. Is it possible that I have an
incorrect version of OOo?
Regards,
Rudi
----- Original Message -----
From: "Niklas Nebel" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, October 09, 2008 11:51 AM
Subject: Re: [api-dev] NumberFormats with decimals after the comma in
calc-table
On 10/ 9/08 09:01 AM, Rudolf Huber wrote:
these are the the other statements:
Dim LokaleEinstellungen As New com.sun.star.lang.Locale
Dim ZahlenFormat As Object
Dim ZahlenFormatString As String
Dim ZahlenFormatID As Long
LokaleEinstellungen.Language = "de"
LokaleEinstellungen.Country = "de"
in the table itself I got:
Hoch = Val(Hoch)
Hoch = Tabelle3.getCellByPosition(5, Count1).String
Wert = Tabelle10.getCellByPosition(5, Start10)
Wert.Value = Hoch
Wert.NumberFormat = ZahlenFormatID
Did you take a closer look at the resulting document, to see if the cell
contains the value you expected, and what number format the cell format
dialog shows?
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
