https://bugs.documentfoundation.org/show_bug.cgi?id=145995
--- Comment #3 from Colin <[email protected]> --- Created attachment 176861 --> https://bugs.documentfoundation.org/attachment.cgi?id=176861&action=edit Additional Examples I'm attaching another sheet demonstrating some more unexpected results. In all honesty, I was experimenting to see just what would break it and how. Initially, the sheet was created as defined with the array A3:D18 included within the scope of the DB Range "Assorted" I then created the SUM() on row 2. Initially, I attempted to create the autofilters on row 4 - the numbers, but the process arbitrarily moved this to row 3 - the characters. Could be reasonable as that was the "top" of the defined DB Range I then edited the range to A1:D18 and it automatically created the autofilter on row 1 but did not erase the filter from row 3 - Maybe not quite so reasonable. I then consolidated B1:C1 into a merged cell then the same for B3:C3 - KEEPING the hidden cell contents. I then "froze" row 3 Any attempt to activate any filter creates the information message "Ranges containing merged cells can only be sorted without formats. Unmerging the cells permits filtering on any "active" filter but note that the filter has now been removed from B3:C3 Repeated attempts to re-filter either B3:C3 or A3:D3 with the autifilter MENU button toggles row 1 on & off. The results of any filter activation without the "merged" cells providing a "veto" Reflect the "unusual" structure. and as per the initial report - all the rows become sortable elements within the array. Interestingly, the SUM() function now includes itself with the appropriate circular reference error. -- You are receiving this mail because: You are the assignee for the bug.
