[Libreoffice-bugs] [Bug 139304] New: WAY too many rows. It gives performance problems.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139304

            Bug ID: 139304
           Summary: WAY too many rows. It gives performance problems.
           Product: LibreOffice
           Version: 7.1.0.1 rc
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mennop at deds.nl

Description:
The 1 million rows gives both logistical as speed issues.
Please give the users an option to physically LIMIT the number of rows and
columns. If I copy mark up to all cells below with ctrl+shift+end, it is ALSO
unwanted copied to all hidden rows. Then scalc hangs for a short time. It does
NOT hang for a short time if I copy the mark up only to the visable number of
rows.
So... HIDING the rows is NOT a solution.
Of course, there are some power users who use many rows. But for 99% of users,
1 million is WAY too much. 1 k Would be MORE than enough in most usage.

Calc version: 7.0.4.2

Steps to Reproduce:
1. Hide rows 100 to 2^20.
2. Copy mark up of some cells to far below with ctrl+shift+end.
3. Then there is the wait. There is NO WAIT of you would copy it only to 1000
cells. But... There's no easy way to quickly copy the mark up to only 1000
rows.

Actual Results:
Waiting time.

Expected Results:
Waiting time. But... the 'Expected Results' would be NO waiting time, if there
weren't so many rows.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Offer a possibility to limit the number of rows and columns; or add the option
for a 'slimmed down' sheet with 32 columns and 1024 rows.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201229/d7f94cd9/attachment.htm>