If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell alignment in rows breaking across pages
If I allow a row to break across a page, then the alignment of cells results
in an alignment as if the row were in fact two rows. I have the following in a table: cells with large paragraphs of text, then the next column is a "yes" or "no" answer. Restricting the row in breaking across pages, then my "answer" is correctly aligned vertically in the middle of the cell; permitting the row to break has the answer aligned in that part of the cell above the page break. Any ideas please? |
#2
|
|||
|
|||
Hi =?Utf-8?B?QWw=?=,
If I allow a row to break across a page, then the alignment of cells results in an alignment as if the row were in fact two rows. I have the following in a table: cells with large paragraphs of text, then the next column is a "yes" or "no" answer. Restricting the row in breaking across pages, then my "answer" is correctly aligned vertically in the middle of the cell; permitting the row to break has the answer aligned in that part of the cell above the page break. Where would you expect it to be? Word won't break across the middle of the letters... Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
I grant that describing questions is sometimes not so easy to convey the
problem, however please read what I've written more carefully please. If I select a "centre vertically" alignment in a cell, then I would expect the text to be centred vertically in the cell. Simple! As it is at the moment it becomes vertically centred only in that part of the cell that remains above the break. (It's only 1 cell after all, so why not have the vertical centre-ing at the "half-way height?") Let's put some "numbers" by way of example, and to try to avoid further confusion. Say my row is 10 cm deep resulting from the content in column "A": if by breaking the row across the page, if I then get 4 cm above the break and 6 cm below, then "centre vertically" in a cell in column "B" places the single word that I have in this cell at the 2cm level above the break, whereas the centre of the cell is actually half of ten, i.e. 5 cm, and therefore it should be 1cm below the break!) "Cindy M -WordMVP-" wrote: Hi =?Utf-8?B?QWw=?=, If I allow a row to break across a page, then the alignment of cells results in an alignment as if the row were in fact two rows. I have the following in a table: cells with large paragraphs of text, then the next column is a "yes" or "no" answer. Restricting the row in breaking across pages, then my "answer" is correctly aligned vertically in the middle of the cell; permitting the row to break has the answer aligned in that part of the cell above the page break. Where would you expect it to be? Word won't break across the middle of the letters... Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
|
|||
|
|||
Hi =?Utf-8?B?QWw=?=,
Word doesn't really know how tall a table cell is; there's no way to get back a cell or row height using programming code if the cell hasn't been assigned an exact height. What Word does is lay out things on the fly; right-to-left, top-to-bottom. And as soon as a table cell breaks to the next page, it has no way of knowing how tall the cell is, in total. Only the available space on the current page for that cell. So Word can't do what you envision. If I select a "centre vertically" alignment in a cell, then I would expect the text to be centred vertically in the cell. Simple! As it is at the moment it becomes vertically centred only in that part of the cell that remains above the break. (It's only 1 cell after all, so why not have the vertical centre-ing at the "half-way height?") Let's put some "numbers" by way of example, and to try to avoid further confusion. Say my row is 10 cm deep resulting from the content in column "A": if by breaking the row across the page, if I then get 4 cm above the break and 6 cm below, then "centre vertically" in a cell in column "B" places the single word that I have in this cell at the 2cm level above the break, whereas the centre of the cell is actually half of ten, i.e. 5 cm, and therefore it should be 1cm below the break!) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#5
|
|||
|
|||
Thanks for your explanation..now I understand. Shame Word isn't smarter!
"Cindy M -WordMVP-" wrote: Hi =?Utf-8?B?QWw=?=, Word doesn't really know how tall a table cell is; there's no way to get back a cell or row height using programming code if the cell hasn't been assigned an exact height. What Word does is lay out things on the fly; right-to-left, top-to-bottom. And as soon as a table cell breaks to the next page, it has no way of knowing how tall the cell is, in total. Only the available space on the current page for that cell. So Word can't do what you envision. If I select a "centre vertically" alignment in a cell, then I would expect the text to be centred vertically in the cell. Simple! As it is at the moment it becomes vertically centred only in that part of the cell that remains above the break. (It's only 1 cell after all, so why not have the vertical centre-ing at the "half-way height?") Let's put some "numbers" by way of example, and to try to avoid further confusion. Say my row is 10 cm deep resulting from the content in column "A": if by breaking the row across the page, if I then get 4 cm above the break and 6 cm below, then "centre vertically" in a cell in column "B" places the single word that I have in this cell at the 2cm level above the break, whereas the centre of the cell is actually half of ten, i.e. 5 cm, and therefore it should be 1cm below the break!) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Excel pages ea cell as one page | Mary Elliott | Setting up and Configuration | 1 | December 10th, 2003 08:52 AM |
Breaking apart a number in a cell into seperate cells | Ron Lichtman | Worksheet Functions | 1 | November 19th, 2003 05:00 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |