Hi Niklas,

it is version 2.1.9095. Should I install the newest version and which would you suggest?

The ZahlenstringFormat =,123 was only test to check the function.

Thanks.

Regards,

Rudi

----- Original Message ----- From: "Niklas Nebel" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, October 09, 2008 6:31 PM
Subject: Re: [api-dev] NumberFormats with decimals after the comma in calc-table


On 10/ 9/08 01:59 PM, Rudolf Huber wrote:
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?

123 in the format string is read as a string literal.
You should really look at the resulting, filled spreadsheet document.
I'm not aware of any version that had such problems, but which version are you using?

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]

Reply via email to