Impossible Problem...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Robinson - 22 Aug 2007 00:09 GMT

Okay... I have a problem that I think is impossible to solve:

I have text written over 4 horizontally merged cells (a short paragraph of
4-5 sentences). When I view them in "normal" view, they looked fine (text
wrapped, left aligned, etc.). However, When I print the worksheet out, the
text is formatted improperly: it is centered and half of the text can't be
seen. Help!

You can download the problem spreadsheet here:
http://www.avatarrecords.com/audio/problem.xls

The problem text cells are highlighted in yellow.

What's frustrating is the spreadsheet looks one way on the computer and
another way when I print.

:-( thanks, larry

Reply to this Message

jpdphd - 22 Aug 2007 05:14 GMT

> Okay... I have a problem that I think is impossible to solve:
>
[quoted text clipped - 12 lines]
>
> :-( thanks, larry

Larry,
It certainly IS frustrating. Don't see any excel-lent way around it. A
cheat would be to take a screenshot (or more than 1 if needed) and
pretty it up with Photoshop or whatever.
One odd thing: checking the cell formatting with Format > Cells...
shows that it is in General format, but the Sample box shows a string
of # signs (it would normally show the text itself. Then, when I tried
to format the problem cell as "text", the cell shows a string of #
signs.
Maybe there's some sort of corruption in the file. :-(
Why not try copying the text (not the formats) of the cells to a blank
sheet and redo the formatting? If you use Styles, it might not be too
terribly tedious.
Good luck!
jpdphd

Reply to this Message

CyberTaz - 22 Aug 2007 06:59 GMT

<snip>
On 8/22/07 12:14 AM, in article
1187756075.178427.152510@l22g2000prc.googlegroups.com, "jpdphd"
<jimdilger@gmail.com> wrote:

> One odd thing: checking the cell formatting with Format > Cells...
> shows that it is in General format, but the Sample box shows a string
> of # signs (it would normally show the text itself. Then, when I tried
> to format the problem cell as "text", the cell shows a string of #
> signs.

<snip>

I believe that's simply because of the amount of content in the merged
cells. The #'s show up if the cell contains more than 255 characters. Oddly
enough, if you select Number or Currency - anything but General, Accounting
or Text - the actual text content displays.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Reply to this Message

jpdphd - 22 Aug 2007 05:28 GMT

> Okay... I have a problem that I think is impossible to solve:
>
[quoted text clipped - 12 lines]
>
> :-( thanks, larry

Larry,
I just noticed that you also have a column F that is hidden. Maybe
this screws things up?
jpdphd

Reply to this Message

CyberTaz - 22 Aug 2007 06:17 GMT

It appears to be corruption in the sheet - specifically with those cells.
Merging cells can cause problems & that may be the case here.

I copied the content & pasted to a different sheet in the same book - had to
do some reformatting (mostly row height) but the print problem was resolved.

Regards |:>)
Bob Jones
[MVP] Office:Mac

On 8/21/07 7:09 PM, in article C2F0BEB2.25525%larry@avatarrecords.com,

> Okay... I have a problem that I think is impossible to solve:
>
[quoted text clipped - 13 lines]
>
> :-( thanks, larry

Reply to this Message

Mac Forum / Applications / Excel / August 2007

Impossible Problem...