Delete Visible Rows in Large Data
Is there a way to delete visible rows when dealing with large data sets aside from selecting all and hitting the delete button on the keyboard? That seems to clock for a long time.
I wish there was in Quantrix a shortcut that would select all visible rows similar to alt+; in a traditional spreadsheet. I’ve noticed performance take a hit when deleting large rows of data when they are filtered or sorted; furthermore, the result is rarely what I want as it deletes the hidden rows as well.
I agree that it would be helpful to have a way to select all visible rows just like in Excel.
I haven’t been able to delete-step. I’m still new to this
Eduardo Ramirez
CCO flores Espana
Hi Jim,
Did you try to do the delete-step with “Autocalculate = Off”. I suppose (but not 100% sure) that deleting is step by step process, so it will eventually trigger recalculations and verifications during the delete. This may lead to heavy recursion, explaining what you see.
So to be sure: try to switch off autocalculate, delete, turn it on. Does this help?
Gilbert
Hi Jim – is this a repetitive activity you’re doing? It is indeed a slow process and performance heavy. I’m wondering if the data you’re hoping to filter and delete is coming from an external source (and if we should be doing a Data Import instead – where we could quickly filter and remove datasets without manual selection). Let me know and we can take a look separately if you like – feel free to send me an email at lweber@quantrix.com . — Lyndsey