Apollosg

Text from Excel

Recommended Posts

Hoping someone can help figure out how to change this.  I did this a while ago, by pasting excel cells into a regular text box.  I am not sure how I manipulated the grid to allow for more than one line of text in the header box, but can't seem to recreate it in another similar table.  Also, if I try to shrink the last column "Length" it reverts to one line.  What are the controlling factors for this? 

 

I have attached a Layout and the table pic in question.

Solar B.layoutSolar B.layout

Thanks,

Gary

 

image.thumb.png.0322dbb8d0efce70e4bd497eac282d06.png

Solar B.layout

Share this post


Link to post
Share on other sites

You will need to compress the columns to create the multi line column headers but there is a problem which I would consider a bug in that once the width of the first or last column's is established it can not be reduced without collapsing the other columns to a single line which just makes a mess of your schedule, so if for instance if you wanted to reduce your text size you are in a heap of trouble.

 

Hoping it will be fixed in X13 but you know how that works......   An undisclosed number of people need to send in the same report. :wacko:

Share this post


Link to post
Share on other sites

Thanks, I thought I was doing something wrong when the end column kept messing it up.  I didn't try the middle columns after that.

 

I appreciate your time to look at it.

Share this post


Link to post
Share on other sites

 

15 hours ago, Apollosg said:

I am not sure how I manipulated the grid to allow for more than one line of text in the header box

 

This only works if you have Auto Width checked.

 

15 hours ago, Apollosg said:

Also, if I try to shrink the last column "Length" it reverts to one line.  What are the controlling factors for this?

The factors are many and as Chopsaw alluded to above, seem to be somewhat controlled by the initially pasted text.  That being said, the main controlling factors are the Tab Stops and the Margins, and you can gain quite a bit of control by individually adjusting those. Also...

 

13 hours ago, Chopsaw said:

once the width of the first or last column's is established it can not be reduced without collapsing the other columns to a single line

Not quite correct.

 

First...The first column can indeed be resized.  Don't do it using the left side of the column though.  Do it using the right side.

Second...Just a quick power tip, but you can reset the seemingly uncontrollable width of the column on the far right to its minimum width by unchecking Auto Height and Auto Width, changing both those settings to zero and then immediately rechecking both. 

 

Share this post


Link to post
Share on other sites
27 minutes ago, Alaskan_Son said:

Not quite correct.

First...The first column can indeed be resized.  Don't do it using the left side of the column though.  Do it using the right side.

Second...Just a quick power tip, but you can reset the seemingly uncontrollable width of the column on the far right to its minimum width by unchecking Auto Height and Auto Width, changing both those settings to zero and then immediately rechecking both. 

Michael, the depths to which you have

explored this software are almost beyond

belief and I am duly impressed.

 

Please don't take this in the wrong way

but the above description triggered the 

following vision in my mind.  B)

 

You put your right foot in

You take your right foot out

You put your right foot in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your left foot in

You take your left foot out

You put your left foot in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your right hand in

You take your right hand out

You put your right hand in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your left hand in

You take your left hand out

You put your left hand in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your whole self in

You take your whole self out

You put your whole self in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

Share this post


Link to post
Share on other sites
5 minutes ago, Rich_Winsor said:

Michael, the depths to which you have

explored this software are almost beyond

belief and I am duly impressed.

 

Please don't take this in the wrong way

but the above description triggered the 

following vision in my mind.  B)

 

You put your right foot in

You take your right foot out

You put your right foot in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your left foot in

You take your left foot out

You put your left foot in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your right hand in

You take your right hand out

You put your right hand in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your left hand in

You take your left hand out

You put your left hand in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about

 

You put your whole self in

You take your whole self out

You put your whole self in

And you shake it all about

You do the hokey pokey

And you turn yourself around

That's what it's all about


I can’t believe you just typed that whole song!!  :lol:

Share this post


Link to post
Share on other sites
7 hours ago, Rich_Winsor said:

Please don't take this in the wrong way

but the above description triggered the 

following vision in my mind.  B)

Rich, is work "slow" on Mars?:D

Share this post


Link to post
Share on other sites

Thank you everyone, it was both changing the middle column width to get the text wrap and workaround of the "known issue" of the end column that helped me.  I appreciate your taking time to help.

 

Gary

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

  • Member Statistics

    28891
    Total Members
    9156
    Most Online
    fhedzsky
    Newest Member
    fhedzsky
    Joined