Verify if there are overlapped data ranges in Menu/Data/Ranges.
Nope. There’s only one database range defined via Menu/Data for the file. I have several named ranges via Menu/Insert/Names…, but none of them are in the sheet where my Autofilter problem is.
I tried Autofilter on another sheet in the file and it works fine, without defining a range or any sort options (Menu/Data/Sort - Options defaults are the same as for the uncooperative sheet though). So, the problem is only within the one sheet; not the whole file—not a global setting).
Some cell in the problematic sheet with a different language?
All set to “Default-English (USA)” via Menu/Format/Cells… - Numbers.
But…I have two columns with custom formats, wherein the cells that are column labels are formulae whose formats include label text ("$00.00 Pending", where ‘Pending’ is format code; not label text). Oddly, deleting the columns fixes Autofilter, but clearing or changing the cell formats to currency (not custom) or deleting everything in the label cells does not solve the Autofilter problem! Nothing else odd in those columns…
Would be of interest to know the source of the issue, but seems it doesn’t want to show their face :).
Can you do a file minimal file sample with the issue?
link text
The offending sheet is Expenses and I replaced all personal data with garbage text. The two column label cells with custom formats are highlighted yellow.
Thanks for having a look.
Looking forward to learning what obvious thing I overlooked or misunderstood:P
You can’t reproduce it? So, in that screenshot you posted, if you select Sort Ascending the column labels in row 1 don’t end up replaced by a row of data in row 1 and the labels don’t end up sorted into the data? If it doesn’t do that for you with the same file and version… then… it’s the user!?
Sorry @stuckfly, I can see now, it happens even with new versions. Please can you report a bug Reporting a bug and inform here the number FDO#NNNNN
FDO#? …bug number is 76715
I am having exactly this same set of issues with Version 4.4.0.3 for Mac in April 2015. Exactly the same behavior as scootersooz—worked yesterday, didn’t today, can’t figure out how to create a version that works. Yes I do have column labels set in my Data Range. This is extremely frustrating.
Update, August 2015—this bug (and other annoying bugs) have finally caused me to throw money at Microsoft. I have successfully avoided using MS software for 20 years or more. Today I am purchasing Office 360 and uninstalling LibreOffice.
I’m having the same issue. But wasn’t just yesterday, it worked fine then. Cannot understand why all of a sudden, without any change from me, the column headings are now filtered in with the rest of the column data. Am using the latest version on Mac – Version: 4.1.5.3.
Same issue over here on linux fedora 20 with Version: 4.2.5.2 Build ID: 4.2.5.2-1.fc20
Sorting via Data-Sort and checking the column labels option works fine.
Sorting via autofilter does not, it also sorts the column headings.
Opening Data-Sort-Options, checking the column headings checkbox and clicking OK crashses libreoffice calc…
This is on a file that originally was an excel file and was converted to ods, nothing fancy, just a big table. However, if a new blank workbook is opened and some data manually inserted, everything works fine.
Next thing I tried was opening an blank workbook and copy paste from the excel file, again not working…
I have a minimal file that exhibits the behavior for me.
Instructions:
- Select “Sort Ascending” from the “Start” column pulldown
- Observe that the column headers, and pulldown controls, get sorted with the data.
Version 4.0.0.3.
Screenshot:
In My case the problem was that the top row contained some labels with numbers and % sign (actually cell’s format was Percent)
I had to name that cell with the word (along with numbers, cause I need it so), and everything works fine. When sorting ranges, the Labels stays up top.
Make sure that all the headings are filled in. Blank headings do cause this problem for me.
+1
I have been pulling my hair out over this as well. A bit of tinkering suggests that headings must contain non-empty text. E.g a numeric entry that just happens to look OK isn’t good enough. It has to be '-prefixed to make it text.
I wanted to upvote this, but I have no rep.
I was having this same problem today. I was working on data imported from html in one worksheet, and on data exported to xlsx in a second worksheet. The former would sort the headers with the data, the latter did not.
As it turns out, when Calc imports data from html, it does strange stuff with columns - for example, a column of data would show as being in both column C and column D. Once I got rid of the phantom columns and deleted any remaining columns with no data in them, the column headers stopped being sorted.
You could try to import html tables trough Menu/Insert/Link to external data, after enter the url wait a bit, then you can select the table to import.