Page 1 of 1

Suppress Printed Row Numbers On Wide Spreadsheet

Posted: Fri May 25, 2012 5:33 am
by robglass
I Wish To Print A Wide Spreadsheet For Which The Column Headers Are Very Informative. The Row Numbers Are Both Superfluous And Redundant. OO 3.4 Allows " Format/Page/Sheet/Print/Column And Row Headers " either on or off. Checked Results In Both Column Titles And Row Numbers Printed / Unchecked Yields No Column Titles Or Row Numbers Printed. Printed Row Numbers On The Left Margin Of Each Sheet Interfere With The Appearance Of My Data.

Is There A Way To Eliminate Row Number Printing Only While Leaving Column Headers Intact ?

Thanks Very Much !

Rob Glass

PS: OO is way more than I need, but it sure is fun ! Congratulations on a very impressive tool !

Re: Suppress Printed Row Numbers On Wide Spreadsheet

Posted: Fri May 25, 2012 6:04 am
by acknak
Sorry, but there's no way to turn off only the row numbers.

The best workaround I can think of is to insert a row at the top of the sheet and enter your own letters there. You can even arrange for Calc to repeat the labels for each printed page.

The nice thing about doing it this way is that you aren't limited to using letters: you can enter more descriptive column headings, if you like.

If you don't want to type the labels and you have 26 columns or less, you can use a formula to get the letters:
=CHAR(CODE("A")+COLUMN()-1)

Re: Suppress Printed Row Numbers On Wide Spreadsheet

Posted: Fri May 25, 2012 7:26 am
by JohnSUN-Pensioner
+1
Another way to get the name of the column:

Code: Select all

=SUBSTITUTE(ADDRESS(1;COLUMN();4);"1";"")

Re: Suppress Printed Row Numbers On Wide Spreadsheet

Posted: Fri May 25, 2012 1:11 pm
by acknak
I like JS-P's formula: no character codes and it works for any number of columns. Nice!