Twayne wrote:
Dotan Cohen wrote:
Adjust the width of the column to be wide enough to display the
longest entry in the column.
Thank you for the workaround, Joe, however that is not practical.
I take it that OOo cannot be configured to _not_ overflow or wrap
text.
AFAIK that is a true statement.
When I came across that in Excel a long time ago, I solved it by writing
a macro to travel the whole sheet and for every empty cell, place a
space in it. I often wanted to go back and change the space to a NULL,
but never got the chance; my job was to start projects and then move on
and start another one<g>. I think it would work though, and would get
rid of the space at the beginning or each cell.
In our case it only had to be run once, but if columns/rows were added,
it might have to be run perioidically. Or, you could create something
that worked column by colum and then row by row to the limits of the
program, but that might be rather time consuming. It was slow as it was
because we were on sub-GHz cpu speeds.
Don't try to simply use non-displaying characters; they can royally
screw up some printers as I found out! < G > .
HTH,
Twayne`
It just occurred to me, that maybe changing to a smaller font for the
overflow cells will allow the text to fit. Even if it is too small to
read, the text can be viewed from the input window by selecting the
cell. I consider this a very poor work around, but it remains an option.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
