Instability with LO 4.1.2

I upgraded from 4.1.1 to 4.1.2 this week (on Windows 8).

I have a fairly complex spreadsheet that worked well on 4.1.1.

In 4.1.2:

Whenever I try to add a column, Calc crashes with an "unexpected error" (no further detail). I can recover the file and usually a second attempt at adding a column works.

Some formulae involving names give incorrect results. If I rewrite them using A1:B2 notation they work.

It is significantly slower.

I have tried increasing the memory allocated, with no change in behaviour.

Help would be welcome, please.

David Lynch

Hi :slight_smile:
Err, can you try renaming the User Profile too? Sudden unexpected errors
between different versions within the same branch really shouldn't be
happening. So it might be something to do with some odd change in the User
Profile.

On the other hand, in life there is often a huge chasm between what "should
be" and "what is".
Regards from
Tom :slight_smile:

david_lynch wrote:

I upgraded from 4.1.1 to 4.1.2 this week (on Windows 8).

I have a fairly complex spreadsheet that worked well on 4.1.1.

In 4.1.2:

Whenever I try to add a column, Calc crashes with an "unexpected error"
(no further detail). I can recover the file and usually a second attempt
at adding a column works.

Some formulae involving names give incorrect results. If I rewrite them
using A1:B2 notation they work.

It is significantly slower.

I have tried increasing the memory allocated, with no change in behaviour.

Help would be welcome, please.

David Lynch

Unless you have a particular reason for sticking to 4.1.x versions, it's probably best to upgrade to the latest "still" (4.3.6) or "fresh" (4.4.1) version from http://www.libreoffice.org/

The 4.1.x versions are quite old now. If you must stick to that line, the latest is 4.1.6, and can be downloaded from:
   http://downloadarchive.documentfoundation.org/libreoffice/old/4.1.6.2/
Even that's almost a year old though. There won't be any more releases on that line to fix bugs, and any bug reports raised against it are likely to be closed unless they can be easily reproduced with a recent version.

Mark.

Mark,

Sorry, I meant I upgraded from 4.4.1.1 to 4.4.1.2.

Tom,

A fresh user profile doesn't help.

David

Hi :slight_smile:
Thanks for trying that out! Sorry it didn't work :frowning:

Can you go back to the version that did work? There is an archive of older
versions somewhere but i never seem to be able to find it.

It used to be that the main cause of crashes was a Java version suddenly
misbehaving but it is easier to check it's not the User Profile first even
if it was only the 2nd most likely cause of crashing.

Ramping the memory up was a good plan because that is even easier than
renaming the user-profile and seems to be another highly likely cause. I
wish the defaults were changed to suit more modern machines and then
versions in the repos of some distros could be reset to default to
something suitable for the types of machines they are usually run on -
rather than all of us being given default settings for ancient machines or
tiny netbooks. Hmmm, maybe i should write a "feature request" for it!
Better than my just grumbling pointlessly right!?

So can you check the version of Java and maybe see if you can turn it off?

Tools - Options - Advanced

on Gnu&Linux but the mac path is a little different although it does follow
their usual path.

Regards from
Tom :slight_smile: