Regina Henschel wrote:
HI Paolo,
Paolo schrieb:
After a while away, I'm back "playing" with OO Base and Sun Report
builder.
Now I have one question: is it possible to have variable height
report fields?
That is, every report line I'm printing includes a "memo" text, and
the content here could be empty, one single word, or a few lines of
text.
It seems to me that you have to draw a bounding box trying to foresee
the worst case, that is the maximum lenght of the text, or it could
be truncated during the output.
So I wonder, is it possible to have a text field to automatically
change its own height according to the real lenght of the content?
that would allow for a nicer layout on the page and save a lot of
blank space.
It sounds like issue
http://www.openoffice.org/issues/show_bug.cgi?id=77605
which is still "OOo later".
kind regards
Regina
Well, this isn't really a 'solution' - but.
You can't grow the control size, but you can shrink the text at runtime
based on the length of the string being printed.
To do this you would use conditional formatting along with the built in
function LEN( [Field Name] )
Conditional formatting allows you to setup a list of conditions, each
can have a unique format - this format setting allows you to set the
Font Name, Face, Size, Spacing and Width. Now you couldn't get to
carried away or you would have something illegible - but still it would
allow you to handle some reasonable overflow.
For example
LEN([Field]) < 50 = Tahoma, 10pt, 100% width, normal spacing
LEN([Field]) =>50 AND LEN([Field]) < 70 = Tahoma, 9pt, 100% width,
normal spacing
LEN([Field]) => 70 AND LEN([Field]) < 100 = Tahoma, 8pt, 100% width,
normal spacing
LEN([Field]) =>100 = Tahoma, Tahoma, 8pt, 90% width, condensed .5
Just a thought
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
