d3d1y Blue Pill
Joined: May 27, 2008 Posts: 1
|
Posted: Tue May 27, 2008 6:59 pm Post subject: Spreadsheet Data Filter hides column headings and fails |
|
I'm using Data Filter - > standard filter + contains to filter a large data set. The filter works fine at first. I select all the filtered cells and copy to a new sheet. Sometimes when I return to the original, filtered data set, the autofilter arrow appears to be turned off even though only the filtered cells are showing. By clicking Data Filter off and on again, the autofilter arrow shows again, and I can click the "all" option to see all the cells again. But sometimes when I go back to the original filtered data set to set up the next filter, row one is not visible, and the data set appears to start at row 2. When this happens, clicking Data Filter on and off again doesn't do anything. When I try to add in a new row one with the missing headers, the new row is inserted as row two.
I'm using Tiger on an Intel MacBook. I have the latest patch of neooffice.
Thanks. |
|