how to print at least 1 cm of row before break

A

anita

I need to insert a table and allow rows break across pages. but I want
to print at least 1 cm of each row before break and if empty space is
less than 1 cm complete rows breaks to other page in vba. Is there a
solution or not?
 
J

Jean-Guy Marcil

anita was telling us:
anita nous racontait que :
I need to insert a table and allow rows break across pages. but I want
to print at least 1 cm of each row before break and if empty space is
less than 1 cm complete rows breaks to other page in vba. Is there a
solution or not?

This would require really complex VBA code.

Basically, you would need to scan every table in the document, check each
row and its page location, as soon as you hit a row in a table that is no
longer on the same page as the previous row you would have to go back to the
previous row. Now you would have to check if the content of this row is
spread over two pages (no simple method for this that I know of), if it is
spread over tow pages, you would have to check the text in each cell, find
the first one that has content spreading two pages. Then check the font size
of that cell content that is at the bottom of the page. Having measured this
font size (and having added the cell padding to the equation) you would know
how high the content is. Then you could apply or disable row breaking.

Unless I have simply overlooked something amazingly simple.... I have often
been unable to see the tree for the forest...
I am not sure anyone here has the time to write it for you, unless someone
already did for a project and is willing to share.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
J

Jean-Guy Marcil

Jean-Guy Marcil was telling us:
Jean-Guy Marcil nous racontait que :
anita was telling us:
anita nous racontait que :


This would require really complex VBA code.

And I forgot to mention that it might be further complicated by the presence
of merged cells, especially cells merged vertically in this particular case.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top