Re: [libreoffice-users] Setting format code in macro

On 08/31/2011 11:37 AM, Kristian Benoit wrote:
> Hi all,
>
> I'm trying to set the format of a column to 3 decimals from a macro.

You should specify the desired number format

Look in AndrewMacro.odt

Search for the function: FindCreateNumberFormatStyle


The example InsertDateIntoCell demonstrates one method to do this.

> I found that after changing the number of decimal by hand, the NumberFormat
> property is set to 106, but setting the NumberFormat property on a fresh
> column is not enough. I guess I must set a format code to "0.000" as in
> right-click on column/Format Cells.../Numbers/Format Code, but cant find the
> object/method to set that.
>
> Anyone can help ?
> Thanks,
> Kristian

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted