change number format in cell via macro to one decimal place?

PsychoticBoredom

Hi,

If I have a value in cell A1 of 9, and I want to use macro code to make sure it displays as 9.0, what do I do? How can I set numberFormat or numberFormatValue for that once cell to show one place after the decimal? I want to do this in a Star Basic macro, not via right clicking and using cell format.
_________________
"Think like a genius. Act like a fool."

noranthon · Super User Joined: 07 Jul 2005 Posts: 3318

This will set the number format of the cell/s selected. This is for the format you mention. To use for another format, change the value of sFormat. I used information in Andrew Pitonyak's document.

PsychoticBoredom · Posted: Fri Apr 14, 2006 12:46 pm Post subject:

Thanks for the suggestion. I tried it out, but it didn't work in my case. After playing around a bit, what finally did work was to select the cells and format them to show once place after the decimal like this:

dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
args1(0).Value="$CV$20:$CW$21"
' for some reason using #.0 worked
dispatcher.executeDispatch(document, ".uno:GoToCell", "", #.0, args1())
_________________
"Think like a genius. Act like a fool."