Text from Excel

[Apollosg]

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

 

Solar B.layout

[Chopsaw]

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. 

[Apollosg]

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.

[Alaskan_Son]

 

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. 

 

[Rich_Winsor]

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.  

 

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

[Alaskan_Son]

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.  

 

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!!  

[Ridge_Runner]

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.  

Rich, is work "slow" on Mars?

[Apollosg]

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