Bug 67525 - CRASH: EDITING: it is not possible to delete more then 600 sheets with one click
Summary: CRASH: EDITING: it is not possible to delete more then 600 sheets with one click
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2013-07-30 08:36 UTC by klausk
Modified: 2019-11-09 00:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
the ods file with more then 600 sheets an macros (2.51 MB, application/vnd.oasis.opendocument.spreadsheet)
2013-07-30 08:36 UTC, klausk
Details
file with macro to delete all sheets without the first one (16.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-15 16:05 UTC, klausk
Details

Note You need to log in before you can comment on or make changes to this bug.
Description klausk 2013-07-30 08:36:50 UTC
Created attachment 83280 [details]
the ods file with more then 600 sheets an macros

Problem description: 

Steps to reproduce:
1. select more then 600 sheets with context at the sheet-tab
2. say yes to delete these sheets
3. it is the same resul if i start a macro "DossierLoeschen"

Current behavior:
lo crashes
Expected behavior:
reduced sheets
              
Operating System: Windows 8
Version: 4.1.0.4 release
Comment 1 Jean-Baptiste Faure 2013-09-14 07:02:20 UTC
I do not reproduce with LO 4.1.3.0.0+ under Linux / Ubuntu 13.04 x86-64.

Please, could you try with the current 4.1.1 version or the RC1 of LO 4.1.2 available at http://dev-builds.libreoffice.org/pre-releases/win/x86/ ?

best regards. JBF
Comment 2 klausk 2013-09-15 16:05:16 UTC
Created attachment 85870 [details]
file with macro to delete all sheets without the first one
Comment 3 klausk 2013-09-15 16:06:45 UTC
Comment on attachment 85870 [details]
file with macro to delete all sheets without the first one

it is not possible to delete 600 sheets without the first one (=Tabelle2) via basic.
Comment 4 Jean-Baptiste Faure 2013-11-10 11:32:40 UTC
Ok, bug confirmed on French QA mailing-list : http://go.mail-archive.com/DY8HUSirmsTKMZy_G6iF9yHjBa0=

Seems similar to bug 45987 which has been fixed. 

Workaround: use the Dispatcher.

Best regards. JBF
Comment 5 QA Administrators 2015-10-14 19:57:03 UTC Comment hidden (obsolete)
Comment 6 Jean-Baptiste Faure 2015-10-18 16:54:26 UTC
Still reproducible with version 5.0.4.0+ under Ubuntu 15.04 x86-64
LibreOffice eat the whole RAM and the machine becomes unresponsive.

Best regards. JBF
Comment 7 Jean-Baptiste Faure 2015-10-18 16:55:38 UTC
(In reply to Jean-Baptiste Faure from comment #4)
> Ok, bug confirmed on French QA mailing-list :
> http://go.mail-archive.com/DY8HUSirmsTKMZy_G6iF9yHjBa0=

This link does not work anymore.
Correct link: https://www.mail-archive.com/qa%40fr.libreoffice.org/msg02263.html

Best regards. JBF
Comment 8 Jean-Baptiste Faure 2015-10-18 17:17:08 UTC
crash or unresponsive computer -> critical.

Best regards. JBF
Comment 9 QA Administrators 2016-11-08 11:17:23 UTC Comment hidden (obsolete)
Comment 10 Jean-Baptiste Faure 2016-11-11 09:22:20 UTC
Please, do not change the version number, it is intended to show the first version in which the bug has been observed.

I guess your version change means that you still reproduce the bug with LO 5.2.2

Best regards. JBF
Comment 11 Telesto 2017-01-08 19:08:06 UTC
Reproducible with
Version: 5.4.0.0.alpha0+
Build ID: 92a1ad1f36b6d3cc13135a8c0805508933011577
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-01-06_23:42:59
Locale: nl-NL (nl_NL); Calc: CL

when using the Macro
Comment 12 Buovjaga 2017-07-18 17:44:37 UTC
In bug 105105 the crash did not happen when reporter set the undo steps to 1 in Tools - Options - LibO - Advanced - Expert config: org.openoffice.Office.Common/Undo

klausk: do you confirm?
Comment 13 QA Administrators 2019-05-19 02:50:40 UTC Comment hidden (obsolete)
Comment 14 CarolineFlack 2019-10-18 10:48:57 UTC Comment hidden (spam)
Comment 15 Muhammet Kara 2019-11-09 00:08:33 UTC
The macro is poorly written, and buggy in itself too. It wouldn't remove all sheets (but first one) even if there were no performance issues.

(In reply to Buovjaga from comment #12)

> In bug 105105 the crash did not happen when reporter set the undo steps to 1
> in Tools - Options - LibO - Advanced - Expert config:
> org.openoffice.Office.Common/Undo
> 
> klausk: do you confirm?

I confirm this works with

Version: 6.2.8.2
Build ID: 6.2.8.2-2.fc30
CPU threads: 16; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded