The autofilter criteria remains with the column (e.g. B) when a column left of the column or the column itself is deleted instead of moving with the content (in this case to column A). How to reproduce: 1. Create a table in calc with 3 colums Col_A Col_B Col_C a 1 a1 b 2 a2 c 3 a3 a 1 a1 b 2 a2 c 3 1 2. Set autofilter to column B (e.g. "1") 3. Delete column A. 4. The filter setting "1" stays with column B. (The filter is not automatically updated. The tab stays as it was before column A was deleted.) Expected behaviour: The filter should stay with the content in this case column "Col_B" (in that case move to column A). Note: You can't insert columns when the autofilter is used, but you can delete. If would be nice if the solution would not be to also block deleting columns when the autofilter is in use ;-)
Thanks for bugreport Sorry, can not understand this place: > 4. The filter setting "1" stays with column B. (The filter is not automatically > updated. The tab stays as it was before column A was deleted.) Please, attach screenshot of this problem
Confirmed with: LO 3.5.4.2 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit Autofilter set on column B, when A is deleted, do not follow to column A, stays at B instead. (In reply to comment #0) > Note: You can't insert columns when the autofilter is used, but you can delete. Confirmed. Users migrating from Excel 2010 could be surprised.
Still can not reproduce in 3.5.4 on Fedora 64 bit. It is either Windows specific bug or I doing something wrong. Please, attach screenshot of this bug
Created attachment 70414 [details] File to test / reproduce the bug. This is the file of the mentioned example to reproduce the bug. I tested is with LibreOffice 3.6.3 on Windows XP (32-bit) and LibreOffice 3.6.1 and 3.6.3 on Linux (OpenSUSE 12.1, 64-bit).
Created attachment 70415 [details] Description of the bug with screenshots I added are more detailed description of the bug, including screenshots. If you need more information I will try to provide it. (And this time quicker.)
Thanks for attachments reproduced using first attachment and initial description in 3.4.2 on Windows XP 32 bit in 3.6.3 on RFR 17 64 bit
This bug still exists in LO 4.0.1.2
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.