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

Is it possible to increase "show note" window size

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


Joined: 22 Jun 2004
Posts: 1

PostPosted: Tue Jun 22, 2004 8:32 am    Post subject: Is it possible to increase "show note" window size Reply with quote

There aren't any options to do it. Do you agree with me ?
Back to top
View user's profile Send private message
r_vinoya
Super User
Super User


Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines

PostPosted: Tue Jun 22, 2004 5:35 pm    Post subject: Re: Is it possible to increase "show note" window Reply with quote

rmn wrote:
There aren't any options to do it. Do you agree with me ?


Yes. This is also my problem Sad . I hope this would be fixed in later version of OpenOffice.
_________________
# : - )
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Wed Jun 23, 2004 4:58 am    Post subject: Reply with quote

also it would be nice to be able to reposition a note
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
antonbijl
OOo Advocate
OOo Advocate


Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa

PostPosted: Thu Jun 24, 2004 1:16 am    Post subject: Reply with quote

I agree completely. Does anyone know if an issue has been logged for this yet?
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Fri Jun 25, 2004 5:03 am    Post subject: Reply with quote

Right, this is a curious limitation I did not yet came across (not an intensive note user myself). Calc sets the note with a width between two or three columns.

An issue has been filed back in october 2002 for exactly that issue, although it was admittendly a bit hard to find

http://www.openoffice.org/issues/show_bug.cgi?id=8342

It apparently did not receive a lot of attention, but indeed there mey be more serious issues to fix first. Depending on your exact needs, you may consider other possibilities to have text displayed adjecent to cells.

* Text can be added and formatted using the text tool on the drawing bar
* A Writer document (or any other OLE object) can be anchored to the cell.
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Fri Jun 25, 2004 1:59 pm    Post subject: Reply with quote

The Notes are known as Annotations within the API and are actually shapes (SvxShapeText) anchored to the cell. You can therefore address them from macros and do whatever you like to them (providing the shape service supports it).
Unfortunately you cannot locate the shape directly from the cell, you have to look at the shapes and see which one is anchored on the cell)
The code below is an example hardcoded for cell A1 but you can easily change that to operate on the active cell. Sets fill colour and allows the width to grow.
Code:
Sub setnotecharacteristics()
odoc=thiscomponent
ocell=odoc.getsheets().getbyindex(0).getcellbyposition(0,0)  ' the cell with the annotation
opage=odoc.getdrawpages().getbyindex(0)
i=0
do while i < opage.count

   oshape=opage.getbyindex(i)
      if oshape.getanchor().supportsservice("com.sun.star.sheet.SheetCell") and _
         oshape.getanchor().celladdress().sheet=oCell.celladdress().sheet and _
         oshape.getanchor().celladdress().row=oCell.celladdress().row and _
         oshape.getanchor().celladdress().column=oCell.celladdress().column then
      ' the shape is anchored to the cell that you want
      
         oshape.TextAutoGrowWidth="true" 
      
         oshape.FillColor=16711935
         exit do
      end if
   i=i+1
loop
End Sub
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