Apollosg Posted January 12, 2021 Share Posted January 12, 2021 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 Link to comment Share on other sites More sharing options...
Chopsaw Posted January 12, 2021 Share Posted January 12, 2021 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. Link to comment Share on other sites More sharing options...
Apollosg Posted January 12, 2021 Author Share Posted January 12, 2021 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. Link to comment Share on other sites More sharing options...
Alaskan_Son Posted January 13, 2021 Share Posted January 13, 2021 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. Link to comment Share on other sites More sharing options...
Rich_Winsor Posted January 13, 2021 Share Posted January 13, 2021 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 Link to comment Share on other sites More sharing options...
Alaskan_Son Posted January 13, 2021 Share Posted January 13, 2021 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!! Link to comment Share on other sites More sharing options...
Ridge_Runner Posted January 13, 2021 Share Posted January 13, 2021 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? Link to comment Share on other sites More sharing options...
Apollosg Posted January 14, 2021 Author Share Posted January 14, 2021 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now