https://bugs.documentfoundation.org/show_bug.cgi?id=160018
--- Comment #8 from Colin <[email protected]> --- (In reply to m_a_riosv from comment #7) > BTW, the issue happens in sorting with the filter option, that also change > corrupt the Menu/Data/Define Range for Veg, modifying it. > Seems option Menu/Tools/Options/LibreOffice Calc/General - Expand references > when new columns/rows are inserter, doesn't affect here. > > Sorting with Menu/Data/Sort, I think works fine and doesn't corrupt the > ranges. I'm just getting signs that it's far worse than that. I have a project going back to October 2020 with 8 data rows per day with cluster calculations over 14 columns. It wasn't immediately apparent that the sorting corruption affects the relationships - it somehow reset the parameter to have references updated by the sort so now I have 11000 rows with scrambled precedents. I hope I can recover from the last backup prior to March 4th and only have to re-source 250+ entries. If I can properly identify the impact (downgrading may have reset some of the user prferences) I can update the bug report or write up some new reports but I reiterate my earlier observation in comment 6 ###### As it's agreed that it is indeed a bug I think it deserves a higher rating than medium. The crashing occurred randomly when I was removing a sheet to submit a sample. It was reproduced by everybody who assessed the report and a bandaid applied almost immediately. The broken autofilter makes it impossible to work with almost all of my projects in anything later than 7.5.9 ALL of the time - not just when I try to submit a "doctored" sample to demonstrate the critical corruption. ###### Clearly it isn't an isolated incident. It looks like any file using autofilter that was even activated during the corrupt phase is suspect. Anybody still using 7.6.5 and experiencing sort problems may already have irrepearably corrupted workfiles. -- You are receiving this mail because: You are the assignee for the bug.
