Bug 77459 - Other: "Insert Rows Above" produces crash with "vector::_M_range_check" error
Summary: Other: "Insert Rows Above" produces crash with "vector::_M_range_check" error
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA (target:4.2.4) (target:4.3.0)
Keywords:
: 78387 (view as bug list)
Depends on:
Blocks:
 
Reported: 2014-04-15 00:32 UTC by SmarterAlec
Modified: 2014-06-08 17:26 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
sample spreadsheet producing crash (166.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-29 00:15 UTC, SmarterAlec
Details
replacement spreadsheet producing crash (217.09 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-29 17:05 UTC, SmarterAlec
Details

Note You need to log in before you can comment on or make changes to this bug.
Description SmarterAlec 2014-04-15 00:32:53 UTC
Current Build ID: 420m0(Build:3)

Problem description: 
Have an existing spreadsheet, year-plus old.

Steps to reproduce:
1. On page with a largish table database, data in rows and columns, attempt to insert a new row.
2. Select existing row.
3. Right-click, select "Insert Rows Above"

Current behavior:
Libreoffice gives error message:
"Libreoffice 4.2 - Fatal Error
 vector::_M_range_check"
Pressing [OK] button in error window, completely closes Libreoffice

Expected behavior:
This was working fine until last weekend's update.
Note: This is only intending to insert a blank row, not data.
Operating System: Ubuntu
Version: 4.2.3.3 rc
Comment 1 Jean-Baptiste Faure 2014-04-18 07:11:08 UTC
wrong component.

Same error message as bug 76607.

Best regards. JBF
Comment 2 Julien Nabet 2014-04-27 11:36:19 UTC
It might be a dup of fdo#76470 or fdo#76607 as Joren indicated, however without any file to reproduce the problem, quite difficult to know.

Anyway, could you give a try to 4.1.4 RC1 and/or attach a file to reproduce this?
Comment 3 SmarterAlec 2014-04-29 00:15:50 UTC
Created attachment 98145 [details]
sample spreadsheet producing crash

Here is a sample page that produces this crash.
Pick a row, right-click to insert row = crash.
Comment 4 Jean-Baptiste Faure 2014-04-29 07:57:50 UTC
No crash for me with my own build of LO 4.2.5.0.0+ (just updated, last commit: http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-2&id=c624eea0e46e84c68d1a1ad79ef217390bd28ef3) under Ubuntu 14.04 x86-64.

Set status back to unconfirmed.

Best regards. JBF
Comment 5 SmarterAlec 2014-04-29 17:05:31 UTC
Created attachment 98184 [details]
replacement spreadsheet producing crash

Full spreadsheet producing crash. Previous one was only one page; only crashed when original was also loaded. "Food" page is the problematic one.
Comment 6 Jean-Baptiste Faure 2014-04-29 17:36:38 UTC
(In reply to comment #5)
> Created attachment 98184 [details]
> replacement spreadsheet producing crash

No crash for me with this new file under LO 4.2.5.0.0+ and Ubuntu 14.04 x86-64.
Did you try with LO 4.2.4 RC1 ?

Best regards. JBF
Comment 7 Julien Nabet 2014-04-29 18:35:59 UTC
On pc Debian x86-64 with master sources updated today or with 4.2 sources updated some days ago, I don't reproduce the crash.

Waiting for your feedback about 4.2.4RC1.
Comment 8 SmarterAlec 2014-04-30 18:37:32 UTC
Just tried and crash not occurring with 4.2.4 RC1 x86-64 Deb binaries.
Version: 4.2.4.1
Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515

Cheers!
Comment 9 Julien Nabet 2014-04-30 19:09:55 UTC
Thank you for your feedback, I put WFM + precise OK targets.
Comment 10 Laurent Balland 2014-05-05 20:46:18 UTC
Hello,

Using procedure of comment #3
I DO reproduce with Version: 4.2.3.3
Build ID: 6c3586f855673fa6a1576797f575b31ac6fa0ba3

I do NOT reproduce with Version: 4.2.4.1
Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515

This bug seems duplicate of bug 76470
Comment 11 F.H. 2014-05-07 19:08:32 UTC
I'm experiencing this crash on a clean installation of Ubuntu 14.04 64-bit, with the current packaged version of LibreOffice (4.2.3.3).  

Steps to reproduce:

1. Download economist Robert Shiller's popular spreadsheet with historical stock market data: http://www.econ.yale.edu/~shiller/data/ie_data.xls

2. In the tab containing data, select a *rectangular* region of the spreadsheet.

3. Click Edit -> Delete Cells -> Delete entire row(s).


I've experienced the error numerous times with other spreadsheets, making LibreOffice Calc virtually unusable on Ubuntu out of the box.
Comment 12 Julien Nabet 2014-05-07 19:24:03 UTC
F.H: as indicated in Whiteboard, the bug is fixed from 4.2.4 LO version.
Comment 13 Julien Nabet 2014-05-07 22:16:18 UTC
*** Bug 78387 has been marked as a duplicate of this bug. ***
Comment 14 Rocket99 2014-05-16 18:41:47 UTC
As of 2014 05 16 the fatal error still occurs MOST of the time when inserting rows on large worksheets.

Is very frustrating. 

Switching to Open Office until resolved.

No, it doesn't "work for me."
Comment 15 Julien Nabet 2014-05-16 18:43:50 UTC
Rocket: what's your LO version? (It's fixed from 4.2.4)
Comment 16 Nils Eric Bergstrom 2014-06-05 10:03:05 UTC
Here is a workaround for inserting a new line:

1.  Copy the line just below the position you want to insert a line in to a free
    position in the spresdsheet.

2.  Remove the contents of the cells in the line you copied in step 1.

3.  Now you can hopefully insert an new emty line above the line that you made
    empty in step 2. 

4.  Copy back the line moved in step 1 to its original position.

5.  Now you have one free line where you can insert your new data.

6.  Remove the the line in the "free" position.

This procedure might save a lot of work but if many new linse are needed
might be useless. 

I think that the fault depends on that you have too much dta in the lines in 
your spreadsheet.