[Bug 167674] Provide means to set a hard limit for the number of rows and columns

[bugzilla-daemon at bugs.documentfoundation.org]

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

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |108252
           Keywords|needsUXEval                 |
             Status|NEEDINFO                    |NEW
                 OS|macOS (All)                 |All
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=13
                   |                            |3764
            Summary|Excessive number of rows    |Provide means to set a hard
                   |and columns                 |limit for the number of
                   |                            |rows and columns

--- Comment #20 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
We discussed the topic in the design meeting.

Whether hiding is easy and flexible doesn't matter for calculations, hidden
content, and performance. The majority accepted the use case and welcomes an
option to set a hard limit for rows and cols.

Could be a radio button at Tools > Options > Calc > Defaults with

Spreadsheet Size:
 (o) Standard (1M rows)
 ( ) Very Large Spreadsheets (16M rows)
 ( ) Limit Size
     Rows: <1048576>
     Columns: <16384>

(maximum for both)

The scrollbar issue should be handled in a different ticket.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108252
[Bug 108252] [META] Cell-related bugs and enhancements (including formatting)
-- 
You are receiving this mail because:
You are on the CC list for the bug.