https://bugs.documentfoundation.org/show_bug.cgi?id=154114
--- Comment #7 from [email protected] --- I just want to reiterate that IMO Calc is UNUSABLE solely because of this very bug. Today, once again, I forgot about this bug, fired up Calc to work on a sheet and "stupidly" clicked select all, did some formatting to the cells, then I selected a column and added data validation (DV) to create a drop down menu, then saved and closed. Later I reopened the file and low and behold: every cell has the drop down menu, instead of only the selected column. But that's not the real reason why I'm ranting here. I thought I can easily fix this mess by selecting all and resetting data validation to allow for any value. I've always done many times beforehand whenever I needed to correct or remove data validation options. But guess what. Calc 7.5.2 instead of removing DV from all cells (just like it added it to all cells) it only removed the setting in the cells from the "content area" (you know, the rectangular area Calc "thinks" the data are stored, deaming everything else nonexistant apparently), but it has NOT removed DV from cells outside that area. Meaning, the mess got even worse, because now I'm left with DV in every empty cell, which is just... too much. It is possible though to remove it, by selecting all the EMPTY cells and resetting their data validation options. To do this you "just" have to select every single empty cell in your sheet, and gues what, you can't just "select all" and deselect cells containing stuff, because once you "select all" Calc does NOT select ALL at all! And to top it off, even if you somehow manage to do it and you know have no DV anywhere, once you clicked "select all" and then repeated adding DV to any cell, Calc adds it everywhere AGAIN. This is such a major bug. To wrap it up, I've noticed multiple bugs like this since version 7.3 I literally can't use LO any more. Versions 7.2.4 had its many problems but holy moly it was never that unstable. I'm sticking with 7.2.4 until this is sorted out. -- You are receiving this mail because: You are the assignee for the bug.
