Instability problem in CALC

users
#1

I have a fairly large and very complex spreadsheet:

Number of sheets 12
Number of cells 123562
Number of pages 55

size 1.23 Mb

much calculation (typically about 200 cells aren't formulas) and many array formulas.

[4.0.5.2 on Windows]

Usually, but not always, when I add a formula to this spreadsheet, CALC crashes saying Calc has an unexpected error and is saving. I can then recover the spreadsheet and adding the new formula now works. There appears to be no dump or other information to aid diagnosis.

How can I best report this intermittent bug? (There's nothing sensitive or private in the spreadsheet.)

David Lynch

#2

David,

You can file a bug report with the spreadsheet attached. Also, you can
post the spreadsheet either with Nabble or elsewhere and provide a link
so others can inspect it.

#3

Hi :slight_smile:
The instructions at
https://wiki.documentfoundation.org/BugReport
help you get more information from your system. Strace and whatnot
(as Amiko Kauderer at NASA says)

The simplest way to get info is to run LibreOffice from a
command-line. So open a command-line, perhaps by using
Ctrl T
and then type in

soffice

I would then open the spreadsheet by grabbing it with a mouse and drag
it onto the splash-screen, around the edges where its a bit
grey-background rather than in the middle white area. You could use
File - Open
or back when you were on the command-line maybe could have typed in
the path-name/file-name but that's all getting tooo fancy so i'd
click&drag.

Take care NOT to close the command-line's little window or it will
close LibreOffice for you. When LO crashes the command-line should
show some interesting reports about what happened. many programs
allow you to run with a -v to get more verbose output

soffice -v

might not work but it might be worth trying just to see.

Remember you can't copy and paste to/from the command-line using the
normal keyboard shortcuts but mouse paste always works (or add Shift
into the usual keyboard combo)
Regards from
Tom :slight_smile:

#4

Guess what, it's stopped crashing ... about it crashed about 6 times yesterday before I wrote, and none since. I'll wait until it starts again.

David Lynch

#5

Hi :slight_smile:
Ahhh, a classic! Is it Windows perchance?

If so then it might be a good idea to run defrags until the defrag
process becomes reasonably fast. First time typically takes hours if
it's not been done before but mere minutes if it's done 1/month or
1/week on machines that have a lot of file transfers going on.

Regards from
Tom :slight_smile:

#6

I have filed bug #71943 with an attached spreadsheet.

David Lynch