Calc bug: insert row before page break crash

Discuss the spreadsheet application
Post Reply
kukaesko
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Calc bug: insert row before page break crash

Post by kukaesko »

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)
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Calc bug: insert row before page break crash

Post by acknak »

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?
AOO4/LO5 • Linux • Fedora 23
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Calc bug: insert row before page break crash

Post by gerard24 »

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 6.4.5 on Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Calc bug: insert row before page break crash

Post by acknak »

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?
AOO4/LO5 • Linux • Fedora 23
kukaesko
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Post by kukaesko »

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

Post by kukaesko »

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)
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc bug: insert row before page break crash

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
kukaesko
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Post by kukaesko »

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)
disaacs
Posts: 1
Joined: Wed Sep 18, 2013 9:23 am

Re: Calc bug: insert row before page break crash

Post by disaacs »

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc bug: insert row before page break crash

Post by RoryOF »

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.1.15 on Xubuntu 22.04.4 LTS
dllondon
Posts: 1
Joined: Wed Sep 18, 2013 11:30 pm

Re: Calc bug: insert row before page break crash

Post by dllondon »

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
kukaesko
Posts: 5
Joined: Fri Sep 13, 2013 10:13 am

Re: Calc bug: insert row before page break crash

Post by kukaesko »

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)
corapeake
Posts: 4
Joined: Tue Mar 18, 2008 5:24 am

Re: Calc bug: insert row before page break crash

Post by corapeake »

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: 4
Joined: Tue Mar 18, 2008 5:24 am

Re: Calc bug: insert row before page break crash

Post by corapeake »

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
Olym
Posts: 24
Joined: Sat Sep 21, 2013 4:27 am

Re: Calc bug: insert row before page break crash

Post by Olym »

no problem on my set up
ApacheOpeOffice 4.1.1 on iMac7,1 OS X 10.10.2
rmstevensiii
Posts: 1
Joined: Sat Jan 25, 2014 4:36 pm

Re: Calc bug: insert row before page break crash

Post by rmstevensiii »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc bug: insert row before page break crash

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
tomtomh
Posts: 1
Joined: Sun Jun 01, 2014 9:34 pm

Re: Calc bug: insert row before page break crash

Post by tomtomh »

I have the same bug.
Trying to insert a column before a manual column break causes a crash.
The auto save then changes some of the formulas after the break and shifts cells in the formula to the right.

PS: the new update to 4.1.0 seems to have fixed this.
OpenOffice 4.0.1 on Windows 7
Post Reply