Sorry, I forget to point that out, currently using Basic for a macro in LibreOffice Calc 3.3.3 running under Ubuntu 11.04.
So I guess I should do like you say (oCol.CellStyle = "MyStyle"). But how do I find out how to format MyStyle ? Currently, the value of oCol.CellStyle is "Default" whether I change the style by hand or not or even after I set oCol.CellStyle programmatically: sVal = oCol.CellStyle 'sVal = "Default" oCol.CellStyle = "MyStyle" sVal = oCol.CellStyle 'sVal = "Default" On Wed, Aug 31, 2011 at 1:27 PM, Andreas Säger <ville...@t-online.de> wrote: > Numeric Writer field? Writer table cell? Base field? Form control? System? > Software? Version Number? Programming Language? > In case of a Basic macro with a reference to a spreadsheet cell in any > version of LibreOffice, you should simply do the same as a professional > user > would do in the GUI: > > oCell.CellStyle = > > "MySpecialCellStyleWithLocaleColorNumberFormatAndManyOtherFormattingAttributes" > > -- > View this message in context: > http://nabble.documentfoundation.org/Setting-format-code-in-macro-tp3298838p3298989.html > Sent from the Users mailing list archive at Nabble.com. > > -- > For unsubscribe instructions e-mail to: users+h...@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 > > -- For unsubscribe instructions e-mail to: users+h...@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