Can I "repeat first column on each page" using page set-up?

Hello

I have a view with many columns and I'd like to print (either to PDF or to paper) the view. As there are many columns, the printed document will be split across multiple pages. Is there a way to repeat the first column on each page (like one can do with the col headings)? There does not appear to be a "built-in" option for this using Page Setup.

I should also mention that I can export to Excel and accomplish this, however because Excel has a display limitation some of my text gets cut-off in the cells that exceed this limit.

Any help would be appreciated.
Thank you kindly.

(user on DOORS 8.1)
SystemAdmin - Tue Sep 08 18:54:17 EDT 2009

Re: Can I "repeat first column on each page" using page set-up?
SystemAdmin - Wed Sep 09 01:43:26 EDT 2009

Hi,

This possible solution is going to sound clunky, but given that Excel is no good, this maybe the only way to do it using built in menu functions.

Use the module File\Page Set-up menu option to define the layout you want, I would recommend using a large page size, for example, use A3 instead of A4 in Landscape - reason for this is outlined later. Run File\Print Preview to see where the column breaks are between each page. DOORS will make sure that a column that sits on a page break is wrapped cleanly onto the next page.

To make the first column appear on each page, define\insert a duplicate column in between the columns where the first page break appeared, run Print Preview again to see where the second page is and repeat. Save the view as a special variant just for printing. It's ugly, but it does work.

BTW - if your printing directly to PDF, select a large page size in Landscape format so that you can fit more into a page and have less page breaks. For example, use A3 instead of A4. When you print to PDF format, you can usually change the PDF print settings so that A3 is reduced to A4. Even though this effectively zooms down the size of the print job, I've always found that the text is still quite legible.

Paul Miller

Re: Can I "repeat first column on each page" using page set-up?
llandale - Thu Sep 10 11:55:37 EDT 2009

If you take care of TABs and EOLs in the cells you want to display; i.e. convert all "\n" you find to spaces, you can export to a TSV file. Open an empty Excel spread sheet. Select all rows you will use and adjust the cell properties; I don't recall (is it 'general' or 'text'), but that will force Excel to accept the entire cell and not truncate. Open the TSV in notepad, select all, copy; select cell A1 in Excel and paste, and then format.

  • Louie