I am running Mac OS 15.2 Sequoia on a M2 Pro Chip. LibreOffice version 24.8.4.2. I have reviewed most of the posts that discuss issues with Autofilter but I am unable to correct my issue. I have multiple columns that are independent of each other to use Autofilter when needed. I did learn that for each column I must define the range and name it before I apply the Autofilter. At first it seemed to work. I had 4 independent autofilters on the same sheet. Tested each and worked like a champ. Saved it and came back to it on a different day to find that only one Filter existed. When I attempted to add another one the one that was there disappeared. When attempting to add the filter again I noticed that all the defined data ranges still existed in the dialog box that were created initially. I selected the one that it was originally and hit enter. It created it but the other one disappeared. Is there a setting or something to keep all of them active at the same time? Your help is appreciated.
And, what file format do you use?
All my spreadsheets came over from OO calc and have the extension .ods. I’m a recent convert and no longer use OO Calc.