Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

On Sun, 2 Jul 2023 at 09:47, David Carter <dcarter204040@gmail.com> wrote:

<snip>

> I have previously selected a column and clicked the "background
> highlight" icon with color of yellow selected - that would turn the
> entire column yellow - it no longer works!

No answer, but doing this is a Very Bad Idea.

Spreadsheets to save file size and memory usage, only 'open' sections
of a spreadsheet as each section gets used (you don't want nearly 17.2
*billion* cells [16,384 × 1,048,576] being tracked all the time —
performance would be horribly degraded). Formatting over a million
cells at once opens a *huge* amount of area — are you *really* going
to use over a million rows in your spreadsheet??? — and will degrade
performance.

I understand wanting to highlight cells before usage. But I suspect
highlighting the first few thousand cells in a column will be
sufficient in almost all cases and will result in improved performance
and a smaller file size.


-- 
T. R. Valentine
A rich heart may be under a poor coat.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy