thanks oliver however I dont see how to get the borders and width since is
not color based is nowhere to be found near that IDL. The only border I
found was for table which I am not sure is the same as the spreadsheet
borders.
On Tue, 23 Oct 2007 11:14:45 -0500, Oliver Brinzing
<[EMAIL PROTECTED]> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Alexandro
REM ***** BASIC *****
OPTION EXPLICIT
Sub Main
Dim oDoc as Object
Dim oCell as Object
Dim oRange as Object
Dim oStyles as Object
oDoc = ThisComponent
'direct (hard) cell formating ...
oCell = oDoc.getSheets().getByIndex(0).getCellByPosition(0,0)
oCell.CellBackColor = 256
'direct range formating ...
oRange = oDoc.getSheets().getByIndex(0).getCellRangeByPosition(2,2,4,4)
oRange.CellBackColor = 128
' soft format via a cell style
oStyles = oDoc.StyleFamilies.getByName("CellStyles")
' change color of build in cell style "Result"
oStyles.getByName("Result").CellBackColor = 192
' apply to a range ...
oRange = oDoc.getSheets().getByIndex(0).getCellRangeByPosition(2,6,4,8)
oRange.CellStyle = "Result"
End Sub
Oliver
Am 23.10.2007 17:50 schrieb Alexandro Colorado:
Hi I want to know how to style cells in a spreadsheet, things like
background color, border and width.
I am not sure if this is the best list to ask OOoBasic questions but
there it goes. If there is a better list for this, please let me know.
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFHHh31TiyrQM/QSkURArOdAJ0bgbsdZGNh3MBpJwRowAVDQSkGKQCfXg8b
vyhxJyPIP2TOUSP4nX3cyvA=
=dYkK
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]