|
This is a long-standing issue. See: http://www.openoffice.org/issues/show_bug.cgi?id=28799 [EMAIL PROTECTED] wrote: I'm working on a spreadsheet that will have some columns of data, and some charts to illustrate the data graphically. There are certain rows that I want to use (as essentially column headers) for the charts, which I don't want to show in the spreadsheet when printed. There's nothing secret about them, they're just not needed and would clutter up the printed spreadsheet to have them shown. I know I can keep the contents of the rows from printing, and in fact I did that, but the way things were laying out on the sheet, it would be desirable to hide the entire row (not have a blank row printed). So I went to to Format > Row > Hide, and the row was properly hidden. What I DIDN'T expect, and what was very undesirable, is that the hidden row was no longer used by the chart. I checked the data range, and it said that this row was still included in the data range. But once it was hidden, the chart acted like there were no contents to this row. A less desirable work-around was to make the rows very short (a height of 0.05" (about 1 mm) for example). Then they don't take up much space in the printout, and the chart still recognizes that they are there. It does not seem to me that hiding rows should make them invisible to a chart. It certainly doesn't make them invisible to formulas and functions, which is good. Does anyone know if this is intentional behavior (and if so, why?), or if it is a bug, or something else? ________________________________________________________________________ Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more. |
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
