Description: When applying an AUTOFILTER, sometimes it does not allow sorting with a warning saying "Ranges containing merged cells can only be sorted without formats" even when no merged cell is present in the range. Sorting manually via the STANDARD FILTER works on the very same range. Steps to Reproduce: 1. Apply the AUTOFILTER to a range of cells. 2. Select "Sort Ascending" or "Sort Descending" Actual Results: A pop up message may appear forbidding the sorting, saying that some cells are merged and have formates, hence they can't be sorted. Expected Results: As no merged cells are present in the range, it should sort as the STANDARD FILTER does. Reproducible: Sometimes User Profile Reset: Yes Additional Info: Version: 7.0.3.1 Build ID: 00(Build:1) CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.utf8); UI: en-GB 7.0.3-2 Calc: threaded
Is it possible to add an example file which demonstrates the described issue
Thank You for promptly acting on this. I had a file in which this was happening but I just made it working (albeit not sure that I have done as I have not merged/split any cell). I will keep an eye if it happens again in this or another file and send immediately. On a side note, this not the case here but in general, why is it not possible to sort merged cells with formats? Thank You.
(In reply to Gio from comment #2) > On a side note, this not the case here but in general, why is it not > possible to sort merged cells with formats? No clue :-). Not a developer myself; only a volunteer :P @Xisco Any idea who to ask here.. Or do you know the answer?
very WIP: investigating... https://opengrok.libreoffice.org/xref/core/sc/source/ui/docshell/dbdocfun.cxx?r=f3fc16f4#535
Thank You @Telesto & @Xisco
....sorry missed that: Thank You @himajin100000@hotmail.com, of course. 🙏🏽
(In reply to Gio from comment #2) > Thank You for promptly acting on this. > > I had a file in which this was happening but I just made it working (albeit > not sure that I have done as I have not merged/split any cell). > > I will keep an eye if it happens again in this or another file and send > immediately. Hi Gio, Did you reproduce this issue again? otherwise, it should be closed as RESOLVED WORKSFORME
Hi, I think I manged to find out what was happening. There are merged cells below the table but when I used the autofilter it took those cells into the table itself. When I made sure this would not happen again, the issue of which report here disappear. Thank YOU.
[Automated Action] NeedInfo-To-Unconfirmed
Closing as RESOLVED NOTABUG