OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

how to change note's background color

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
briglia23
OOo Enthusiast
OOo Enthusiast


Joined: 24 Jun 2008
Posts: 121

PostPosted: Mon Jul 07, 2008 6:24 am    Post subject: how to change note's background color Reply with quote

What is the method or the property to change the note's background color?
I think that it is the oShape but i can't find it.

Thank you
Back to top
View user's profile Send private message
davidh182
OOo Advocate
OOo Advocate


Joined: 01 Apr 2004
Posts: 413

PostPosted: Thu Jul 10, 2008 8:14 am    Post subject: Reply with quote

This should work provided there is already a note in cell 0,0
Code:

sub notecolor
oDoc = StarDesktop.CurrentComponent
oCurSheet = oDoc.CurrentController.ActiveSheet

r=255
g=128
b=128

oCurSheet.getCellByPosition(0,0).Annotation.AnnotationShape.fillColor=65536*r+256*g+b

end sub
Back to top
View user's profile Send private message Send e-mail
briglia23
OOo Enthusiast
OOo Enthusiast


Joined: 24 Jun 2008
Posts: 121

PostPosted: Thu Jul 10, 2008 11:18 pm    Post subject: Reply with quote

Thank you
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group