Bug 90675 - LO Calc crashes calculating difficult BASIC function
Summary: LO Calc crashes calculating difficult BASIC function
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
4.4.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-17 12:53 UTC by Viktor Mileikovskyi
Modified: 2015-05-17 07:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
It is the problematic workbook. (95.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-17 12:53 UTC, Viktor Mileikovskyi
Details
THis is my LOG. The first number of any line is the run idintifier and the Level is the level of the run. (16.74 KB, text/plain)
2015-04-17 12:57 UTC, Viktor Mileikovskyi
Details
After user profile change Apport reports this information (74.68 KB, image/png)
2015-04-21 06:43 UTC, Viktor Mileikovskyi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Viktor Mileikovskyi 2015-04-17 12:53:32 UTC
Created attachment 114858 [details]
It is the problematic workbook.

Dear Developers!
After upgrading to 4.4.2.2 LO Calc starts to crash any time I open my workbook. One of the columns (BP) may calculate a BASIC function (DELTAT1) that solves an equation (Dteqn). This procedure is not so quick but before upgrading it was not cause any problem. Now it crashes after opening. No messages running LO from a terminal.
For the test I include LOG file recording to the basic code (commented in the attachment. Please open LO Basic and uncomment if You want to create it. Tested on Ubuntu. The destination folder is the home folder). The behavior is unusual. It runs my solver (Deltat1) first time, performs only 2 iterations and run the solver again for a different cell. The second level run performs all required iterations, find a solution and returns. But the first run does not continue and LO Calc crashes without any message or APPORT call.
I found only one workaround. Open this workbook and disable macros. Edit the module and cut-paste it to a text file. Save and close. Open it, enable macros. Because of missing macros some cells contain errors. Edit the module and past the code back. Manually edit cells in BP column to add and remove a space in the formula. It performs without any error. After that I can open the workbook only some times. And the problem reappears...

How to reproduce

1. Save and close all documents (if opened)!!!
2. Run the attached workbook. Enable macros. If this bug affect You the LO Calc will close.

Tested on Lenovo Ideapad Z580A with Core I7 processor 2,9 GHz.
Comment 1 Viktor Mileikovskyi 2015-04-17 12:57:25 UTC
Created attachment 114859 [details]
THis is my LOG. The first number of any line is the run idintifier and the Level is the level of the run.
Comment 2 raal 2015-04-17 15:43:14 UTC
I can not confirm with Version: 4.5.0.0.alpha0+
Build ID: 51e0d789c344547956764c3b5f0ef5a304f4e0aa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-13_16:58:45
No crash when open file, macros enabled.
Comment 3 Viktor Mileikovskyi 2015-04-17 16:51:05 UTC
Tested on Windows 8.1.
Version 4.4.1.2 - No crash
Version 4.4.2.2 - No crash
Comment 4 Buovjaga 2015-04-18 12:39:56 UTC
(In reply to Viktor Mileikovskyi from comment #3)
> Tested on Windows 8.1.
> Version 4.4.1.2 - No crash
> Version 4.4.2.2 - No crash

Maybe you should try renaming your user profile in your Linux system: https://wiki.documentfoundation.org/User_Profile#Resolving_corruption_in_the_user_profile

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
Comment 5 Viktor Mileikovskyi 2015-04-21 05:59:54 UTC
I have 5 different user profiles for multiple instances of LO. When I delete the corresponding.lock file (after the previous crash) and open the test.ods from a different profile it cause the same crash.
Comment 6 raal 2015-04-21 06:17:35 UTC
(In reply to Viktor Mileikovskyi from comment #5)
> I have 5 different user profiles for multiple instances of LO. When I delete
> the corresponding.lock file (after the previous crash) and open the test.ods
> from a different profile it cause the same crash.

Please try with new profile. You can delete/rename profile, LO then create new one. After test you can give old profile back.
Comment 7 Viktor Mileikovskyi 2015-04-21 06:43:57 UTC
Created attachment 114979 [details]
After user profile change Apport reports this information

After user profile change apport tried to report the information in my attachment.
The field "Unreportable reason" says in Ukrainian:
"This package is not official. Please uninstall all non-official packages and try again"
Comment 8 Viktor Mileikovskyi 2015-05-06 14:15:00 UTC
Tested on LO 4.4.3.2 on Ubuntu. Before testing the user profile was deleted and automatically created by LO. After opening test.ods LO crashes without any message or APPORT activity.
Comment 9 Buovjaga 2015-05-06 14:19:28 UTC
(In reply to Viktor Mileikovskyi from comment #8)
> Tested on LO 4.4.3.2 on Ubuntu. Before testing the user profile was deleted
> and automatically created by LO. After opening test.ods LO crashes without
> any message or APPORT activity.

Maybe try getting a backtrace: https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#GNU.2FLinux:_How_to_get_a_backtrace
Comment 10 Viktor Mileikovskyi 2015-05-16 18:38:54 UTC
Documents created or saved on the new office version are free of the bug. To correct old document it is enough to open it, disable macros, change anything (for example add anything to an empty cell and remove it, don't undo) and save the document. After that the document will not cause the crash.
Appear to be solved.
Comment 11 Buovjaga 2015-05-17 07:52:29 UTC
Thanks for testing, Viktor! I will set the status to WFM, as we don't know any commit that fixed the problem.