[Libreoffice] limiting maximum sheet number to 10000 in 32 bit builds

Jean-Baptiste Faure jbf.faure at orange.fr
Fri Jan 6 06:06:55 PST 2012

Hi Markus,

Le 06/01/2012 14:52, Markus Mohrhard a écrit :
> Hello Jean-Baptiste,
>> I have tried to reproduce the crash on Linux 64 bits by setting the
>> option value to 30000 and the creation of a new speadsheet took several
>> minutes. No crash but 5 Go of RAM. I killed LibO instead of closing the
>> file. Problem: when creating another spreadsheet I had still the same
>> option. Knowing that you can't access Calc options without having a Calc
>> document opend, how do you kill this vicious circle? Ok, easy for an
>> experienced user: open a small existing Calc document and modify the
>> option. I am not sure whether a new user can find the solution easily.
>> My proposition:
>> 1/ Maximum number of sheets : 10000
>> 2/ Limit on the number of sheets created by default: 20
> I won't implement that. We can't protect every user from his mistakes
> and IMHO we shouldn't even try to do that. If a user thinks he needs
> to set his initial number of sheets to 10000 he has to live with that.
> Calc is not foolproof and I don't plan to make it.

I would agree if the end-user was aware that an empty spreadsheet is not
so empty than that.
If you don't want limit the option, we should make the text of the
option more informative about the possible problem with a too big value.

Best regards.

Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

More information about the LibreOffice mailing list