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 <villeroy@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+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
-- 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