Bug 97902 - Speadsheet crashes when I copy formatting and formulas of many columns a the same time.
Summary: Speadsheet crashes when I copy formatting and formulas of many columns a the ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.3 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace
Depends on:
Blocks:
 
Reported: 2016-02-16 14:23 UTC by dtsirikos
Modified: 2017-05-22 14:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Zip file containing two attachments (demo file to replicate the bug and a stack trace) (27.72 KB, application/zip)
2016-02-16 14:23 UTC, dtsirikos
Details

Note You need to log in before you can comment on or make changes to this bug.
Description dtsirikos 2016-02-16 14:23:48 UTC
Created attachment 122689 [details]
Zip file containing two attachments (demo file to replicate the bug and a stack trace)

I have an ods file with formulas at columns N to T (see attachment 1). 

Imagine I am at row 5 and I want to apply the formulas of each column to all the other rows below. I do these actions 
- place the cursor in cell 5N
- hold the shift key and then click on cell 5T to highlight the 7 consecutive cells in row 5
- place the cursor above the bottom right corner of cell 5T so it transforms to a cross
- press the right mouse button as I start dragging the cross down.

At this point the program crashes.

You can also find the detailed report that is automatically generated and sent to apple (see attachment 2)
Comment 1 Buovjaga 2016-02-16 14:42:39 UTC
No crash here. Might be OS X only.

Win 7 Pro 64-bit, Version: 5.1.0.3 (x64)
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: fi-FI (fi_FI)
Comment 2 Thibault Molleman 2016-02-16 15:50:57 UTC
No crash on my mac
OS X El Capitan Mac Mini late 2012 i5 hd graphics 4000 1536mb

LO Version: 4.1.5.1
Build ID: e0a1805d063a472a7b281ae3977a26d42a48b20

and 

LO Version: Version: Version: 5.1.0.3
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: -; UI Render: default; 
Locale: en-US (en.UTF-8)
Comment 3 Buovjaga 2016-02-16 16:04:15 UTC
dtsirikos: you could try, if this helps: https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile
Comment 4 dtsirikos 2016-02-16 16:39:03 UTC
(In reply to Beluga from comment #3)
> dtsirikos: you could try, if this helps:
> https://wiki.documentfoundation.org/
> UserProfile#Resolving_corruption_in_the_user_profile

I did remove the old user profile directory, and it automatically created a new one when I opened LibreOffice. However the problem still persists, doing exactly the steps I have described in my original bug report.

I just tested this on an iMac and it still crashes, exactly at the moment when I pull the cross downwards, to apply the formatting to the other cells, starting at row 5.

Thanks very much for your support!
Comment 5 Thibault Molleman 2016-02-16 17:19:47 UTC
Tried to reproduce again just to test and now it actually crashed

I made a mistake when trying to reproduce it the first time. You have to drag it down when the crosshair is showing BUT I could only produce it every now and then when pressing both left and right mouse buttons at the same time and then dragging. It's really hard to reproduce on your first try. See video: 
https://youtu.be/AjeVL1nhXPQ (MAKE SURE TO HAVE ANNOTATIONS ON TO SEE MY COMMENTARY)

My debug info during the recording:
http://pastebin.com/aateXKgx

My debug info from another crash:
http://pastebin.com/NwVM7NTH
Comment 6 (OPTIONAL) Real Name: 2016-03-31 23:13:43 UTC
When you click the bottom right of a field and drag left, the tooltip says "delete content". When you drag further left/top it however gives you the normal functionality of dragging the formula to other fields. So far so good

 I have encountered a bug 2-3 times already where after dragging a formula to different fields left/top of it and then copy and pasting (I think with the special "insert special" function) the application freezes, then crashes and afterwards my spreadsheet is completely emtpy or doesn't exist if I haven't saved previously (no backup is restored)

Possibly the 2 are related/the same ?

I had this bug on windows xp,7 and linux already
Comment 7 QA Administrators 2017-05-22 13:39:05 UTC Comment hidden (obsolete)
Comment 8 dtsirikos 2017-05-22 14:50:25 UTC
Just tested it on Mac OS X El Capitain with LibreOffice 5.2.7.2 and it works fine.