Edits like just writing a cell (ex, typing a number over a cell) or deleting a cell ("Del" key) take very long (5 secs on my computer) when many rows/columsn are grouped and collapsed ("Outliner" tool).
Ungrouping same rows, or removing the grouping entirely, makes the same edits very fast (well under 1 sec on my computer).
See attached files; go to sheet "large", column CN and type in cells, delete cells... while groupings are collapsed or not
very slow edits when rows/columns are Grouped with Outliner.
very slow edits when rows/columns are Grouped with Outliner.
- Attachments
-
- theFileWithNoGroups.xlsx
- (3.06 MiB) Downloaded 31 times
-
- theFileWithGroups.xlsx
- (3.07 MiB) Downloaded 33 times
Re: very slow edits when rows/columns are Grouped with Outliner.
I just tested the same file in the most recent, trial version of Microsoft 365's Excel, and there are no such delays there, regardless of outlining status.
Re: very slow edits when rows/columns are Grouped with Outliner.
Thank you for posting your issue.
We were able to reproduce, although there was some delay in excel as well.
We have forwarded your file for further investigation.
We were able to reproduce, although there was some delay in excel as well.
We have forwarded your file for further investigation.
