Calc bug: insert row before page break crash

Discuss the spreadsheet application

Calc bug: insert row before page break crash

Postby kukaesko » Fri Sep 13, 2013 11:03 pm

Found a repeatable bug in OpenOffice 4.0.0 Calc: Insert a page break in a spreadsheet - insert row above the page break - OO crashes.

Windows 8.
OpenOffice 4.0.0 (Finnish)
kukaesko
 
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Postby acknak » Fri Sep 13, 2013 11:42 pm

Welcome to the community forum!

Sorry, I'm not sure I understand what you're doing. I'm not sure how you insert a "page break" in a spreadsheet. Can you give us the exact steps, menus, keys, etc. that you've used?
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17399
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Calc bug: insert row before page break crash

Postby gerard24 » Sat Sep 14, 2013 10:15 am

I think he means Insert > Page break > Row break (insert a page break for printing)
then Insert new row just before the row break.

Cannot test with AOO, no bug in LibreOffice.
LibreOffice 4.1.3 on Windows Vista
gerard24
Volunteer
 
Posts: 538
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Calc bug: insert row before page break crash

Postby acknak » Sat Sep 14, 2013 1:17 pm

Ahh, right, Insert > Manual Break > Row Break

No crash here.

It could be something specific to the document; kukaesko, can you attach your document here so we could try it?
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17399
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Calc bug: insert row before page break crash

Postby kukaesko » Tue Sep 17, 2013 12:25 am

For me this happens with a new empty document as well as my old ones. Never happened before version 4. And you don't need to insert row just above the row break - anywhere above the break will do.
OpenOffice 4.0.0 (Finnish)
kukaesko
 
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Postby kukaesko » Tue Sep 17, 2013 12:29 am

Also crashes with column breaks! Add break, then try to add a column anywhere to the left of the break.
OpenOffice 4.0.0 (Finnish)
kukaesko
 
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Postby Villeroy » Tue Sep 17, 2013 11:52 am

I can't reproduce the issue.
Shut down the office including the "quick starter".
Go to %APPDATA%\OpenOffice\4\ and rename the user folder.
Start the office and try to reproduce the crash.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17281
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc bug: insert row before page break crash

Postby kukaesko » Tue Sep 17, 2013 7:14 pm

OK, I tried this with an old XP machine - no crash. Mine is Lenovo Thinkpad X301 Windows 8 64 bit, maybe someone with Windows 8 could try this out?

Clearing user data does not help.
OpenOffice 4.0.0 (Finnish)
kukaesko
 
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Postby disaacs » Wed Sep 18, 2013 9:36 am

I too have found this problem on a windows 7 machine, although it can be intermittent and I've yet to discover what set of circumstances causes it. I had OO3.4 on the same machine and no problem. I set up a macro so that a particular key combination would first save my work, then insert a row, having got fed up with losing everything each time this happens (the document recovery process being a pointless waste of time, it just recovers from the last autosave, that's the same as happens when I open the document again myself, only without the silly extra windows). The odd thing is, it still crashes at the initiation of the macro, before saving. It's like it knows it's going to add a row next and crashes anyway.
Open Office 4 on windows 7
disaacs
 
Posts: 1
Joined: Wed Sep 18, 2013 9:23 am

Re: Calc bug: insert row before page break crash

Postby RoryOF » Wed Sep 18, 2013 10:03 am

It is worth remembering that the shortcut to Save a file in most (all?) applications is Ctrl S. If one uses a computer regularly, this should become instinctive.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14346
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc bug: insert row before page break crash

Postby dllondon » Wed Sep 18, 2013 11:33 pm

Same issue here. It appears that I cannot insert a row anywhere on any worksheet that has a manually inserted page (row) break in it.
OpenOffice 4.0 on Windows 8
dllondon
 
Posts: 1
Joined: Wed Sep 18, 2013 11:30 pm

Re: Calc bug: insert row before page break crash

Postby kukaesko » Tue Oct 01, 2013 6:48 pm

Ha! Just installed 4.0.1 and the bug is still there. Not many comments here after more people confirmed the issue...
OpenOffice 4.0.0 (Finnish)
kukaesko
 
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Postby corapeake » Mon Oct 07, 2013 11:34 pm

I have this problem too with AOO 4.0.1 and Win7


Problem signature:
Problem Event Name:
BEX Application Name: soffice.bin
Application Version: 4.0.9714.500
Application Timestamp: 5237a093
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6161
Fault Module Timestamp: 4dace5b9
Exception Offset: 0006ccd5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 1033
Additional Information 1: cc39
Additional Information 2: cc393de18fc40b891783eca834ff0f37
Additional Information 3: 38b3
Additional Information 4: 38b32bbfd386bcde339fa1f7aba16b91
corapeake
 
Posts: 3
Joined: Tue Mar 18, 2008 5:24 am

Re: Calc bug: insert row before page break crash

Postby corapeake » Mon Oct 07, 2013 11:44 pm

and again, this time with the print range deleted

Problem Event Name: BEX
Application Name: soffice.bin
Application Version: 4.0.9714.500
Application Timestamp: 5237a093
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6161
Fault Module Timestamp: 4dace5b9
Exception Offset: 0006ccd5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 1033
Additional Information 1: cc39
Additional Information 2: cc393de18fc40b891783eca834ff0f37
Additional Information 3: 38b3
Additional Information 4: 38b32bbfd386bcde339fa1f7aba16b91
corapeake
 
Posts: 3
Joined: Tue Mar 18, 2008 5:24 am

Re: Calc bug: insert row before page break crash

Postby Olym » Tue Oct 08, 2013 12:14 pm

no problem on my set up
ApacheOpeOffice 4.0.1 on iMac7,1 OS X 10.9.2
Olym
 
Posts: 14
Joined: Sat Sep 21, 2013 4:27 am

Re: Calc bug: insert row before page break crash

Postby rmstevensiii » Sat Jan 25, 2014 5:09 pm

Running OO 4.0.1 with Win 8.1 Pro and bug is still there.

Interestingly, if OO only seems to crash if I am inserting a row near the top of the spreadsheet. Inserting rows toward the end of the sheet (100+ rows down), it seems to work just fine. :?

The problem is repeatable.
OpenOffice 4.0.1
Windows 8.1 Pro
rmstevensiii
 
Posts: 1
Joined: Sat Jan 25, 2014 4:36 pm

Re: Calc bug: insert row before page break crash

Postby Villeroy » Sat Jan 25, 2014 6:18 pm

rmstevensiii wrote:The problem is repeatable.

... on your system. So you are the one to fix it. A programmer can not fix a problem he doesn't see. If it is related to Win8 I'd think it would be time to say good bye to MS Windows and let all Windows users alone with their native office suite.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17281
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: jakemun and 12 guests