| View previous topic :: View next topic |
| Author |
Message |
rmn
Newbie
Joined: 22 Jun 2004
Posts: 1
|
 Posted: Tue Jun 22, 2004 8:32 am Post subject: Is it possible to increase "show note" window size |
 |
|
| There aren't any options to do it. Do you agree with me ? |
|
| Back to top |
|
 |
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Tue Jun 22, 2004 5:35 pm Post subject: Re: Is it possible to increase "show note" window |
|
|
| rmn wrote: | | There aren't any options to do it. Do you agree with me ? |
Yes. This is also my problem  . I hope this would be fixed in later version of OpenOffice.
_________________
# : - ) |
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Wed Jun 23, 2004 4:58 am Post subject: |
|
|
also it would be nice to be able to reposition a note
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
antonbijl
OOo Advocate
Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa
|
| Posted: Thu Jun 24, 2004 1:16 am Post subject: |
|
|
| I agree completely. Does anyone know if an issue has been logged for this yet? |
|
| Back to top |
|
|
ftack
Moderator
Joined: 27 Jan 2003
Posts: 3102
Location: Belgium
|
| Posted: Fri Jun 25, 2004 5:03 am Post subject: |
|
|
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 |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Fri Jun 25, 2004 1:59 pm Post subject: |
|
|
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 |
|
|
|
