[Libreoffice-ux-advise] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

V Stuart Foote <vsfoote at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |145509

--- Comment #10 from V Stuart Foote <vsfoote at libreoffice.org> ---
Pretty clearly the move to 16K columns necessitated this shift.

Past practice of applying per cell attribute to a <Ctrl>+A selection of the
entire sheet instantly became non-performant with sheets of a billion cells.

For acceptable performance the *reasonable* solution of ShrinkToDataArea()
requires minor adjustment to work flows, acceptable UX.

As noted, styling of sheet cells is the only way to efficiently apply
formatting to entire sheets--not selecting all cells on a sheet and applying
DF.

This is not a bug, nor a regression, as implementing 16K columns necessitates
retraining to keep sheet manipulations efficient.

As to some edit engine cyclic application of the <Ctrl>+A selection--seems
overly complex, and you'd never be sure what you'd selected (you can't see the
last cell selected).

No, seems best to just accept that the <Ctrl>+A selection will encompass only
the sheets active cells as implemented for bug 147842 keeping the UX for Calc
performant.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=145509
[Bug 145509] [META] Bugs Related to Liborcus
-- 
You are receiving this mail because:
You are on the CC list for the bug.