Bug 106764 - Calc freezes when removing sheets programmatically
Summary: Calc freezes when removing sheets programmatically
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.1.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency treegraph
 
Reported: 2017-03-25 09:29 UTC by boerig
Modified: 2018-05-30 16:48 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
test file for calc freezing (18.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-25 14:15 UTC, boerig
Details

Note You need to log in before you can comment on or make changes to this bug.
Description boerig 2017-03-25 09:29:14 UTC
Description:
I have a large file with about 300 sheets. With the exception of 6 sheets, the others are copies of one master sheet (an invoice module). At the end of year the file will be copied and the all the invoices sheets will be removed. I've developed a smll vba macro to do that task, instead of manually delete each sheet.
When I stat the procedure (there is a button in the first sheet) the application freezes and the only two things that I can do are, waiting until windows tells me "application doesn't respond...." or remove the application  by using Windows task management.
I tried to trace the problem debugging the code and, proceeding step by step the problem doesn't arise.
The file is large (but not so large), about 2.1Mb.

Steps to Reproduce:
1.press the button ELININA LE FATTURE in ISTRUZIONI sheet
2.reply yes to messagebox "sei sicuro?"
3.the application freezes...

Actual Results:  
the application freezes

Expected Results:
all the FA_xxx_YYYY should be removed


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36 OPR/43.0.2442.1144
Comment 1 boerig 2017-03-25 09:31:24 UTC
I didn't read anything about the width of attachments. My file is about 2.1mb: it's a problem?
Comment 2 Xisco Faulí 2017-03-25 09:46:07 UTC
(In reply to boerig from comment #1)
> I didn't read anything about the width of attachments. My file is about
> 2.1mb: it's a problem?

Max size is 10mbs. You should be able to attach the file without any problem.

However, could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 3 boerig 2017-03-25 14:14:26 UTC
(In reply to Xisco Faulí from comment #2)
> (In reply to boerig from comment #1)
> > I didn't read anything about the width of attachments. My file is about
> > 2.1mb: it's a problem?
> 
> Max size is 10mbs. You should be able to attach the file without any problem.
> 
> However, could you please try to reproduce it with the latest version of
> LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' if the bug is still present in the latest version.

Thank you for your help.
I've installed latest fresh version of LibreOffice but the bug is still present.
In the meantime i've made other tests: I've removed all the sheets expect the first one (where is the button used to start the removing procedure); then I've created 100 new sheets and started the procedure: at 87th sheets Libreoffice freezed. 
Now I suppose that the problem is on my pc but without any indication of the error/problem from Windows of Libreoffice I don't know how to serch for.
Comment 4 boerig 2017-03-25 14:15:51 UTC
Created attachment 132141 [details]
test file for calc freezing
Comment 5 boerig 2017-03-25 14:22:53 UTC
(In reply to boerig from comment #3)
> (In reply to Xisco Faulí from comment #2)
> > (In reply to boerig from comment #1)
> > > I didn't read anything about the width of attachments. My file is about
> > > 2.1mb: it's a problem?
> > 
> > Max size is 10mbs. You should be able to attach the file without any problem.
> > 
> > However, could you please try to reproduce it with the latest version of
> > LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> > I have set the bug's status to 'NEEDINFO'. Please change it back to
> > 'UNCONFIRMED' if the bug is still present in the latest version.
> 
> Thank you for your help.
> I've installed latest fresh version of LibreOffice but the bug is still
> present.
> In the meantime i've made other tests: I've removed all the sheets expect
> the first one (where is the button used to start the removing procedure);
> then I've created 100 new sheets and started the procedure: at 87th sheets
> Libreoffice freezed. 
> Now I suppose that the problem is on my pc but without any indication of the
> error/problem from Windows of Libreoffice I don't know how to serch for.

My mistake:
... how to search for. is to be overwritten by
--- what to search for.
Comment 6 Buovjaga 2017-04-01 17:36:21 UTC
(In reply to boerig from comment #4)
> Created attachment 132141 [details]
> test file for calc freezing

I could eliminate all the fattures.

Version: 5.4.0.0.alpha0+ (x64)
Build ID: 193f8966135064a32164c9da08d01dab9c1fc15d
CPU threads: 4; OS: Windows 6.19; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-03-25_02:08:45
Locale: fi-FI (fi_FI); Calc: group

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 541b377a94fb1247dbf4c39b5bcf55deb8e5ef60
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 31st 2016

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.1.2
Build ID: 5.3.1-1
CPU Threads: 8; OS Version: Linux 4.10; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Comment 7 Carlos 2017-04-04 17:35:31 UTC
I can not reproduce the bug in
Version: 5.3.1.2 (x64)
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; 
Locale: en-US (en_US); Calc: group

It is a bit slow but it ends and does what is expected.
Comment 8 tommy27 2017-05-06 15:36:47 UTC
@boerig
you reported the bug with an obsolete LibO version (5.2.1)
you should retest with LibO 5.2.6 or even better with 5.3.2 and tell if issue is gone or persists.

status NEEDINFO until your feedback
Comment 9 QA Administrators 2018-05-02 15:47:06 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2018-05-30 16:48:00 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20180530