Autofit in cells with multiple lines of wrapped text.

I have seen a lot posted about this but 99% of the discussion goes into
merged cells. I am not using merged cells.

What I am attempting to do is put error messages (that are short sentences
seperated with the CHAR(10) to force where I want the line to break.) from
code I am building a formula...

="SiteID must be numeric."&char(10)&"ItemPrice must be currency."

Which I want to put the result in 2(or more depending on how many error
messages are required) lines in the cell. But Autofit seems to randomly pick
where it wants to break the line which make the cell 3-7 lines in height.

How do I force the cells to autosize and properly break the lines where I
specify?

* Is there some way to calculate the required cell width of the longest
sentence in the column of cells? Perhaps I could force the column width =
to that value then. Of course that would require knowing the font size and
how much space is needed for the porportional font's characters.
* Is there some character (not a space or special character) that would
mimic a space in the text for calculating size then doing a replace on that
character back to a space after the column width is set. (special characters
seem to have a higher probability of causing a line break)
* Is there some trick to using autofit that I am missing?


--
Regards,
John

But it didn't work for that other poster (who knows why???).

John Keith wrote:
>
> Just saw a post from Dave Peterson that suggested to widen the column to 255,
> then autofit...
> that worked exactly like I want.
> --
> Regards,
> John
>
> "John Keith" wrote:
>
> > I have seen a lot posted about this but 99% of the discussion goes into
> > merged cells. I am not using merged cells.
> >
> > What I am attempting to do is put error messages (that are short sentences
> > seperated with the CHAR(10) to force where I want the line to break.) from
> > code I am building a formula...
> >
> > ="SiteID must be numeric."&char(10)&"ItemPrice must be currency."
> >
> > Which I want to put the result in 2(or more depending on how many error
> > messages are required) lines in the cell. But Autofit seems to randomly pick
> > where it wants to break the line which make the cell 3-7 lines in height.
> >
> > How do I force the cells to autosize and properly break the lines where I
> > specify?
> >
> > * Is there some way to calculate the required cell width of the longest
> > sentence in the column of cells? Perhaps I could force the column width =
> > to that value then. Of course that would require knowing the font size and
> > how much space is needed for the porportional font's characters.
> > * Is there some character (not a space or special character) that would
> > mimic a space in the text for calculating size then doing a replace on that
> > character back to a space after the column width is set. (special characters
> > seem to have a higher probability of causing a line break)
> > * Is there some trick to using autofit that I am missing?
> >
> >
> > --
> > Regards,
> > John

--

Dave Peterson

Dave, could the other poster have been having issues with a font?

See my post titled: "Autofit Issues" on 2/14/2006 (how do you link these?)

Seems the arial font sometimes does wierd things.

--
Regards,
John


"Dave Peterson" wrote:

> But it didn't work for that other poster (who knows why???).
>
> John Keith wrote:
> >
> > Just saw a post from Dave Peterson that suggested to widen the column to 255,
> > then autofit...
> > that worked exactly like I want.
> > --
> > Regards,
> > John
> >
> > "John Keith" wrote:
> >
> > > I have seen a lot posted about this but 99% of the discussion goes into
> > > merged cells. I am not using merged cells.
> > >
> > > What I am attempting to do is put error messages (that are short sentences
> > > seperated with the CHAR(10) to force where I want the line to break.) from
> > > code I am building a formula...
> > >
> > > ="SiteID must be numeric."&char(10)&"ItemPrice must be currency."
> > >
> > > Which I want to put the result in 2(or more depending on how many error
> > > messages are required) lines in the cell. But Autofit seems to randomly pick
> > > where it wants to break the line which make the cell 3-7 lines in height.
> > >
> > > How do I force the cells to autosize and properly break the lines where I
> > > specify?
> > >
> > > * Is there some way to calculate the required cell width of the longest
> > > sentence in the column of cells? Perhaps I could force the column width =
> > > to that value then. Of course that would require knowing the font size and
> > > how much space is needed for the porportional font's characters.
> > > * Is there some character (not a space or special character) that would
> > > mimic a space in the text for calculating size then doing a replace on that
> > > character back to a space after the column width is set. (special characters
> > > seem to have a higher probability of causing a line break)
> > > * Is there some trick to using autofit that I am missing?
> > >
> > >
> > > --
> > > Regards,
> > > John
>
> --
>
> Dave Peterson
>

I don't have a guess to whether it's font related.

And from the lack of responses to your other post, it looks like no one has seen
this or knows the answer.

John Keith wrote:
>
> Dave, could the other poster have been having issues with a font?
>
> See my post titled: "Autofit Issues" on 2/14/2006 (how do you link these?)
>
> Seems the arial font sometimes does wierd things.
>
> --
> Regards,
> John
>
> "Dave Peterson" wrote:
>
> > But it didn't work for that other poster (who knows why???).
> >
> > John Keith wrote:
> > >
> > > Just saw a post from Dave Peterson that suggested to widen the column to 255,
> > > then autofit...
> > > that worked exactly like I want.
> > > --
> > > Regards,
> > > John
> > >
> > > "John Keith" wrote:
> > >
> > > > I have seen a lot posted about this but 99% of the discussion goes into
> > > > merged cells. I am not using merged cells.
> > > >
> > > > What I am attempting to do is put error messages (that are short sentences
> > > > seperated with the CHAR(10) to force where I want the line to break.) from
> > > > code I am building a formula...
> > > >
> > > > ="SiteID must be numeric."&char(10)&"ItemPrice must be currency."
> > > >
> > > > Which I want to put the result in 2(or more depending on how many error
> > > > messages are required) lines in the cell. But Autofit seems to randomly pick
> > > > where it wants to break the line which make the cell 3-7 lines in height.
> > > >
> > > > How do I force the cells to autosize and properly break the lines where I
> > > > specify?
> > > >
> > > > * Is there some way to calculate the required cell width of the longest
> > > > sentence in the column of cells? Perhaps I could force the column width =
> > > > to that value then. Of course that would require knowing the font size and
> > > > how much space is needed for the porportional font's characters.
> > > > * Is there some character (not a space or special character) that would
> > > > mimic a space in the text for calculating size then doing a replace on that
> > > > character back to a space after the column width is set. (special characters
> > > > seem to have a higher probability of causing a line break)
> > > > * Is there some trick to using autofit that I am missing?
> > > >
> > > >
> > > > --
> > > > Regards,
> > > > John
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson