[Solved] Hide rows in printing

[jenteh]

Lotus 1-2-3 allows rows with "|::" on the left most cell of the print range to be omitted from printing.

Is there similar feature in OO?

Thanks

[keme]

I don't believe you can easily set a row to display but not print in Calc. In any case, that's a layout property, so in Calc it would be based on cell/row properties ("format" or similar properties), not content.

Workaround: You can use data - group and outline to make collapsible row groups, and then collapse individual groups or an entire level before printing. I find that both easier and more flexible than the 1-2-3 approach, but it's a matter of habit, I guess. There's an additional step in that you have to remember to hide the selected rows before printing.

[jenteh]

Thanks, keme for your suggestion on the use of group and outline.

I use the feature in Lotus 1-2-3 for a few reasons. One is for remarks purpose. Another is to hide the row if a certain criteria is met, e.g. if the line total is zero.

Any other suggestions?

[eric_mcdonald]

Any other suggestions?

Have you tried right-clicking (assuming you are using Windows or Linux) on the row number along the left edge of the sheet, and then selecting "Format Cell..." from the context menu that pops up? If you do, you should see a "Cell Protection" tab in the window that appears. Select that tab. You should then see a "Print" pane in the lower portion of the window. In that pane there is a "Hide when printing" checkbox. Checking this suppresses the row from being printed.

(This works for me on Open Office 3.0; I don't know about other versions.)

[jenteh]

Thanks, eric! Another good suggestion!

But, is there anyway to hide an entire row without leaving an empty line?

[mriosv]

Use a filter to hide the rows, then is possible to enable or not the filter to see the rows.
Insert a row in the first row range to print, fill with column heads, set the range to filter as database range, and then set the filter as you need.

[Dave]

I don't find that "hidden" rows [columns] are printed. It's simple enough to hide rows, or unhide them for visual appearance onscreen before or after printing. Not both at the same time, but where's the real difficulty in that?

David.

[jenteh]

Use a filter to hide the rows, then is possible to enable or not the filter to see the rows.
Insert a row in the first row range to print, fill with column heads, set the range to filter as database range, and then set the filter as you need.

Fantastic! That's an excellent suggestion! Thanks, mrosv! You save me lots of time!

[jenteh]

I don't find that "hidden" rows [columns] are printed. It's simple enough to hide rows, or unhide them for visual appearance onscreen before or after printing. Not both at the same time, but where's the real difficulty in that?

David.

My worksheet has some 1,000 rows of data. These data change everyday.

What I want is to suppress printing for any rows with zero sum. Today, rows 1, 3, 5, 8 etc may be zeros but tomorrow rows 2, 3, 7, 10 etc may be zeros.

So, as what mriosv suggested, I have now added a column on the left most and put in a formula to sum up the rows. With the filter option, with the click of a mouse, I can easily hide those rows with zero sum and send the report for printing!