Bug 67655 - EDITING: delete more than 180 sheets via macro
Summary: EDITING: delete more than 180 sheets via macro
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Macro
  Show dependency treegraph
 
Reported: 2013-08-02 08:18 UTC by klausk
Modified: 2019-08-11 11:03 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
a calc file with a macro thats delete all sheets with the prefix "Tabe" (8.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-02 08:18 UTC, klausk
Details
an ods-file with macro and about 500 sheets (15.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-03 13:21 UTC, klausk
Details
Backtrace of crash on Windows, LibO 5.2 (9.98 KB, text/plain)
2016-01-29 16:09 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description klausk 2013-08-02 08:18:21 UTC
Created attachment 83507 [details]
a calc file with a macro thats delete all sheets with the prefix "Tabe"

Problem description: 

Steps to reproduce:
1. put 180 sheets into the ods-file
2. start the macro, which delete all sheets with the prefix "Tabe"
3. liberoffie crashes
4. with 100 sheets libroffice works fine

Current behavior:
liberoffie crashes
Expected behavior:
no sheet with the prefix "Tabe" in the calc-file
              
Operating System: Windows 8
Version: 4.1.0.4 release
Comment 1 Thomas van der Meulen [retired] 2013-08-02 18:01:33 UTC
Hello Klausk, I tested it with 180 sheets an run the macro but nothing happend so maybe it is the marco or the file.. so could you please include a file with 180 were the crash acure so I can test it. thank you in advance.

Version: 4.1.0.4
Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28 
os: mac osx 10.8.4 

btw if you use a lot of sheets it is better to use Base instaed.
Comment 2 klausk 2013-08-03 13:21:15 UTC
Created attachment 83582 [details]
an ods-file with macro and about 500 sheets

hallo thomas,

here is the file. for me it is no alternative to use base.

thanks a lot klaus
Comment 3 Thomas van der Meulen [retired] 2013-08-03 17:49:14 UTC
Thank you for the test file, I can reproduce this bug running LibreOffice Version: 4.1.0.4
Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28 on Mac osx 10.8.4.
Comment 4 Caolán McNamara 2014-09-16 12:40:43 UTC
caolanm->erack: this is the one I mentioned where we get killed with OOM
Comment 5 QA Administrators 2015-10-14 19:57:29 UTC Comment hidden (obsolete)
Comment 6 Buovjaga 2016-01-29 16:09:46 UTC
Created attachment 122278 [details]
Backtrace of crash on Windows, LibO 5.2

Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+
Build ID: 259c1ed201f4277d74dfd600fed8c837cbf56abc
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-01-27_00:45:12
Locale: fi-FI (fi_FI)

Somehow complained about missing symbols again and "Stack unwind information not available" :(
Comment 7 QA Administrators 2017-03-06 14:32:55 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2019-08-11 11:03:27 UTC
No crash anymore

Version: 6.4.0.0.alpha0+ (x86)
Build ID: c738be4de6886a0c96b7d10df7e78c8b2964c135
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded

Arch Linux 64-bit
Version: 6.4.0.0.alpha0+
Build ID: 37fc9f51a8de11d40632e8cda17ccf1fa4b1f503
CPU threads: 8; OS: Linux 5.2; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 6 August 2019