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` --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
