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: [email protected]
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
