Issue 123493

Summary: Line Insertion crash
Product: Calc Reporter: gmessag
Component: editingAssignee: AOO issues mailing list <issues>
Status: CLOSED DUPLICATE QA Contact:
Severity: Major    
Priority: P3 CC: elish, firstofnone, garden36, gmessag, issues, j.nitschke, rainerbielefeld_ooo_qa
Version: 4.0.1Keywords: crash
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=123166
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
the object of the bug none

Description gmessag 2013-10-18 10:12:34 UTC
Created attachment 81782 [details]
the object of the bug

I have a big CALC file made with  AOO V4.0.0. (70 kO)  3 Folios of 200 lines X 10 columns with mutual links (à kind of different sorting).
The problem is since i installed AOO 4.0.1 i cannot insert anymore lines in my table ether by LineInsert or by OOB Code.
The file is Linked
Comment 1 gmessag 2013-10-18 10:20:27 UTC
Comment on attachment 81782 [details]
the object of the bug

the bug causes the crash of AOO.
Windows show's the Message :
"OpenOffice 4.0.1 has shutdown" (my translation)
-Find a solution in line
-Close the program"
Comment 2 Rainer Bielefeld 2013-10-19 05:45:29 UTC
NOT reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions:

1. From AOO start center open reporter's sample document
2. Click row headin "1"
   > first row becomes selected
3. Menu 'Edit -> Insert -> Rows'
   > Row will be inserted without problems

DUP of "Bug 123166 - CRASH when Insert>row in particular way in particular document"? I think so

@gmessag@wanadoo.fr:
Thank you for your feedback – unfortunately important information we will 
need to reproduce your problem is missing.
Please feel free to reopen this Bug if you find evidence that we have an independent issue here  (for example because the fix for the other bug does not work for you) and add all information requested in following:
a) Write a meaningful Summary describing exactly what the problem is
c) Contribute a sample document related step by step instruction 
   containing every key press and every mouse click how to reproduce 
   your problem 
e) if possible contribute an instruction how to create a sample document 
  from the scratch
f) add information 
  f3) concerning your PC (video card, ...)
  f4) concerning your Operating System (Version, Language)
  f5) concerning your AOO version (with Build/revision ID if it's not a 
     public release) and localization (UI language, Locale setting)
  f6) AOO settings that might be related to your problems 
     (video hardware acceleration,  ...)
  f7) how you launch AOO and how you opened the sample document
  f8) Whether your problem persists when you renamed your user profile 
     (Quit Quickstart before!) before you launch AOO (please see
     <http://www.openoffice.org/development/releases/3.4.1.html#AOO3.4.1ReleaseNotes-KnownIssues>)

*** This issue has been marked as a duplicate of issue 123166 ***
Comment 3 gmessag 2013-10-19 13:16:38 UTC
when adding a line in the last linked file for example :
select line 77 of "plan de bornier" spreadsheet and try a line insertion. On my computer this causes the crash of AOO (with or without the macro authorization).
Comment 4 gmessag 2013-10-19 13:45:50 UTC
computer description :
Alienware M17X R3
Intel Core i7 2720QM 2.2GHz
8Go Ram (6.5 Usable)
Windows 7 Home Premium 64 bits SP1
Graphic card : AMD RADEON HD 6890M
HDD :2 x 300 Go HDD Raid 0
Comment 5 Rainer Bielefeld 2013-10-19 16:01:49 UTC
Still NOT reproducible proceeding as per Comment 2 for line 77

@gmessag@wanadoo.fr:
What evidence do you see that we have an independent problem here?

Please answer ALL questions with the precision I asked for. You don't believe how many ways to "try a line insertion" I know, I do not have the time to try them all.
Comment 6 Prosper Uniger 2013-10-19 17:14:15 UTC
(In reply to gmessag from comment #3)
> when adding a line in the last linked file for example :
> select line 77 of "plan de bornier" spreadsheet and try a line insertion. On
> my computer this causes the crash of AOO (with or without the macro
> authorization).

I could reproduce your bug.
AOO crashed when I inserted a line in rows 1 to 91 but not the following lines.
It didn't matter how, right click row header -> insert rows or tools toolbar ->insert cells -> insert rows.
I noticed in above line 91 is a row break.

Then I went to page break view and right clicked in the sheet "delete all manual breaks". After that I could insert lines without crashed.

I tried to reproduce the crash in a new spreadsheet without any luck.
Now the odd thing: I can't reproduce the crash with your document anymore.
So row breaks could be completely unrelated.

Hope this makes any sense to you. I thought it could help.
Comment 7 Edwin Sharp 2013-10-19 18:54:25 UTC
Insert line OK.

AOO401m5(Build:9714)  -  Rev. 1524958
2013-09-20 11:54 - Linux x86_64
Debian
Comment 8 Prosper Uniger 2013-10-27 16:33:24 UTC
stack trace of crash:

 # Args to Child              
00 7799a7d7 00000002 00abe2bc ntdll!KiFastSystemCallRet
01 00000002 00abe2bc 00000001 ntdll!ZwWaitForMultipleObjects+0xc
02 00abe2bc 00abe358 00000000 kernel32!WaitForMultipleObjectsEx+0x11d
03 00000002 00abe358 00000000 kernel32!WaitForMultipleObjects+0x18
04 00abe490 00000001 00000001 kernel32!WerpReportFaultInternal+0x16d
05 00abe490 00000001 9702e52d kernel32!WerpReportFault+0x70
06 00000000 00000001 c0000417 kernel32!UnhandledExceptionFilter+0x1b5
07 00000000 00000000 00000000 msvcr90!_invoke_watson+0xf9
08 00000006 089adfb0 53da676e msvcr90!_invalid_parameter_noinfo+0xc
09 000fffff 0899ac40 00000000 sc!ScUsedAreaIterator::GetNext+0x2eb
0a 00000000 000003ff 00000006 sc!ScTable::GetRowHeight+0x3564
0b 00000000 00000000 000003ff sc!ScDocument::DeleteTab+0x67f
0c 00abec78 089cc3fc 00000002 sc!ScDocFunc::SetWidthOrHeight+0x473a
0d 00000002 00000001 00000000 sc!ScTabView::RefreshZoom+0x451e
0e 00abf28c 00abf0cc 021e9a02 sc!ScValidityRefChildWin::RegisterChildWindow+0x8882
0f 08cda948 00abf28c 97de86f1 sc!ScValidityRefChildWin::RegisterChildWindow+0x31f8

could be related to fix of bug 119707 in revision 1391286
and possible regression
Comment 9 Rainer Bielefeld 2013-11-01 14:18:25 UTC
Due to results of Prosper Uniger CONFIRMED for now, I still think that this one has the same roots like Bug 123166
Comment 10 Prosper Uniger 2013-11-27 21:46:24 UTC
I can reproduce the issue without fail (so far):

* reset profile
* open attachment 81782 [details]
* scroll down to rows 70 to 80 
* insert a row (right click a row number, insert rows)

If you want to reproduce it again you have to reset the profile otherwise it might not trigger the bug.
It might not crash on the first row but on the second or third.
I could reproduce it at least 10 times with this method foolproof.
Comment 11 Renate 2013-12-04 00:04:50 UTC
Windows 8.1, 64-bit, English USA
Calc 4.0.1 Insert row crashes ODS Calc. 

My spreadsheet consist of 17 Sheets and has a mixed Page Format for Orientation of  Portrait and Landscape for each sheet.  Paper format for all sheets is the same: Letter, Width 8.5", Height 11.00".

When inserting a row, crashes occure only on sheets with the Orientation Portrait and if there is a Manual Break.  My manual break is always less than 99 rows. When I Delete All Manual Breaks I am able to insert a row without a crash. 

Sheets with the Orientation Portrait and Automatic Page Break do not crash when inserting a rows.  The page ends at 99 rows.

I was always able to insert rows in sheets with the Orientation Portrait and Manual Breaks in previous versions. For now, I am happy to be able to make it work by deleting all manual breaks, inserting rows and putting the manual break back. This has to be a bug.
Comment 12 j.nitschke 2014-03-11 09:56:45 UTC
attachment 81782 [details] has a manual break in row 91

(In reply to Renate from comment #11)
> When inserting a row, crashes occure only on sheets with the Orientation
> Portrait and if there is a Manual Break.  My manual break is always less
> than 99 rows. When I Delete All Manual Breaks I am able to insert a row
> without a crash. 

same workaround as described in bug 123166, Comment 39

*** This issue has been marked as a duplicate of issue 123166 ***