SoftMaker.com

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.

I just tested the same file in the most recent, trial version of Microsoft 365's Excel, and there are no such delays there, and regardless of outlining status.

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 ...

In case another data point helps:
my attached file is about 3MB, takes around 13secs to save (on a laptop with 2-core, 2.13GHz, 4GB ram)

The file also has groups but removing the groupings did not make a difference for saving.
But interestingly, it did speed up general edits like inputing or ...

I have attached it.
To reproduce: go to the 2nd sheet, "test" and try copy a cell then paste. The "copy" op itself takes very long; while the "paste" op is fast.

Inside the 1nd sheet "large", not the "copy" but the "paste" operation takes very long.

EDIT:

I noticed that grouping (outlining) rows ...

Standard "copy" of a cell, after a "paste", takes about 4-5 seconds.
In a document with 2 sheets with about 117000 cells in total

Hi,
regarding Grouping of rows or cols, please consider this little enhancement:
Have the "-" button for closing/hiding the group at both beginning and end of the grouping-line.
Alternatively, make clicking on the group-line in the margin to close/hide the group (that is, make so that not only ...

Thank you

No it won't

Thank you

thank you

Hello SuperTech,
thanks for the reply.
How about allowing sorting inside Grouped (outline) rows and collapsed (hidden details)?

The motivation is that sometimes you have too many rows (or columns) of same kind and it's more convenient to work with them in grouped form, for example sort them, and ...

steps to reproduce:
1. In range A1:A10, create list 1..10
2. Hide rows 3-5 (context menu, Hide)
3. Select the range and sort Descending
4. Unhide the rows

Result: the hidden rows ' content is original,not sorted.

expected: to change the content, per sorting order

After more thinking, it's better to separate the cases with only numbers vs with numbers and empty cells.

Thus I'll focus first on number-only patterns.

Here's a pattern rule that I think it's one of the simplest but also more powerful than what's currently in use:

Start with the linear ...

I just noticed that Planmaker (and other popular spreadsheets) do have currently a behavior about formulas' references when selecting several cells, for example:
If in a column have the formulas:
=A1
=A3
Then at selecting both and dragging by the corner, you get next formulas to be:
=A3
=A5
=A5
=A7 ...