W
Wayne Knazek
With wrap function on, the text wraps as expected. When a line wraps, and
you leave the cell, you get a line of " # " signs. ( ######### ) I'm sure
that's to let viewer know there is wrapped text.
Single click the cell, read the text in the upper view field. No problem.
Double click the cell and read the text "in" the cell. No problem.
But when you print the sheet, you get the #'s in the field instead of the
text.
We have a "Notes" field that almost always requires several text lines in
each row.
What I'd like is for the entire row to "open up" in size as the text wraps
so the text always stays visible, and the entire row size "goes along" with
the size of the Notes cell.
EX: 2nd column is Notes. 1st is item No. The other columns contain data.
When we enter a long text line in column 2, I'd like the entire row size to
"grow" along with the note cell. And when I hit ENTER or leave the cell,
have that row stay larger, showing the entire note. Kinda like this . . .
|-------|---------------------------------------|---------|---------|----------|
| 4 | Text here . . . korere[trotoopt]ot | 0.125 | .244 | .0015 |
| |opfop[o] fok f]]opf]qre[kf]offo]f[[ | | |
|
| | [poi[ofpokf]pokf]opkf]okf[pof]po | | |
you leave the cell, you get a line of " # " signs. ( ######### ) I'm sure
that's to let viewer know there is wrapped text.
Single click the cell, read the text in the upper view field. No problem.
Double click the cell and read the text "in" the cell. No problem.
But when you print the sheet, you get the #'s in the field instead of the
text.
We have a "Notes" field that almost always requires several text lines in
each row.
What I'd like is for the entire row to "open up" in size as the text wraps
so the text always stays visible, and the entire row size "goes along" with
the size of the Notes cell.
EX: 2nd column is Notes. 1st is item No. The other columns contain data.
When we enter a long text line in column 2, I'd like the entire row size to
"grow" along with the note cell. And when I hit ENTER or leave the cell,
have that row stay larger, showing the entire note. Kinda like this . . .
|-------|---------------------------------------|---------|---------|----------|
| 4 | Text here . . . korere[trotoopt]ot | 0.125 | .244 | .0015 |
| |opfop[o] fok f]]opf]qre[kf]offo]f[[ | | |
|
| | [poi[ofpokf]pokf]opkf]okf[pof]po | | |