openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tom Davies <>
Subject Re: [libreoffice-users] Re: Am I the only one with Err 522 problems?
Date Tue, 23 Apr 2013 18:21:06 GMT
Hi :)
Lol, that does sound a tad weird.  Have you made a copy and tried opening it with Gnumeric? 

Regards from 
Tom :)  

> From: Johnny Rosenberg <>
>To: LibreOffice Användare <>;

>Sent: Tuesday, 23 April 2013, 18:54
>Subject: Re: [libreoffice-users] Re: Am I the only one with Err 522 problems?
>2013/4/23 Tom Davies <>:
>> Hi :)
>> That has all sounded like a tfn tbh.  I've never heard of the Err 522
>> before.
>It means circular references, but in my case it probably means
>something else, because I have more than double checked: There are no
>circular references! Well, I said that before, didn't I? I think so.
>> I was hoping it was something trivial such as memory or something.
>> I guess you have already posted a bug-report and just got nothing back yet?
>> It's going to be a tad weird here if you do go over to AOO completely.
>> Apols and regards from
>> Tom :)
>I always used to file bug reports, but since I switched to LibreOffice
>they are just too many. I wouldn't have time for anything else if I
>wrote a bug report every time I found a new bug. Maybe I file every
>tenth bug or so, so it's not that I'm doing absolutely nothing, but
>no, I don't think I filed this particular one. I was going to, but I
>would need to attach that particular document, with a lot of data that
>I need to rename first and so on, just too much work, especially at
>that speed…
>Anyway, now that I saved the document with Apache OpenOffice,
>LibreOffice opened it much faster and that several minutes wait after
>every cell entry was suddenly gone, it now takes approximately one
>second. Maybe Apache OpenOffice fixed it somehow?
>And even funnier, Apache OpenOffice now takes a few seconds coffee
>break for every cell entry in that file (at least it's not minutes)!
>If I am going to file a bug report, I am not really sure what to
>write, I'm just too confused right now, I don't know what happens;
>maybe I'm just dreaming all this…
>Johnny Rosenberg
>> ________________________________
>> From: Johnny Rosenberg <>
>> To: LibreOffice Användare <>;
>> Sent: Tuesday, 23 April 2013, 18:21
>> Subject: [libreoffice-users] Re: Am I the only one with Err 522 problems?
>> 2013/4/2 Johnny Rosenberg <>:
>>> A few spreadsheets of mine, those with a lot of formulas with
>>> references to other cells, sometimes (or rather often in some cases)
>>> throw error 522 (circular reference) at me.
>>> In most cases, Ctrl+Shift+F9 cures the problem. Another way is to look
>>> for the first Err 522 occurance, highlight it, Ctrl+c, then Ctrl+v at
>>> the same cell.
>>> Did anyone else see those false Err 522 messages?
>>> I have seen them for quite a while now, for years, I think. I use
>>> LibreOffice at the moment.
>>> Johnny Rosenberg
>> Another problem with that sheet is that everything takes unbelievable
>> long time. If I enter something in a cell, then hit Enter, I need to
>> wait for something like a minute (yes, minute! Not second!) or two
>> before anything happens, so the whole sheet is just a waste of time.
>> Today I installed LibreOffice 3.6.6, but my problems with that file
>> persists.
>> The Ctrl+Shift+F9 thing cures the problem (the Err:522 messages
>> disappears and are replaced with correct cell values) sometimes, maybe
>> once out of 5 or 10 in average, but sometimes when I do that,
>> LibreOffice crash. However, so far, when I ”repair” the file, there
>> are never any error messages. So I continue entering new values, save
>> and close. Next day, when I open the file again, those Err:522
>> messages are back again. That's what my life looks like every day
>> these days.
>> Just for fun, I installed Apache OpenOffice 3.4.1 a few minutes ago
>> and I tried to open the file with it. After fiddling with macro
>> security (adding the path where the file is located), the spreadsheet
>> opened, and opened very much faster than LibreOffice. Unfortunately,
>> the Err:522 messages was there again, but Apache OpenOffice seems a
>> lot faster than LibreOffice, so it doesn't waste my time as much.
>> After copying the first one of the Err:522 cells and pasting it to
>> itself, all the Err:522 messages were gone again. And that also
>> happened much faster than with LibreOffice.
>> So now I started to enter new values. As I said above, from hitting
>> Enter until LibreOffice stop freezing (it works with something, I
>> don't have a clue what) it typically takes a minute or two, maybe
>> more. With Apache OpenOffice it took way less than a second.
>> I realise that nobody will ever even move a finger to investigate what
>> could possible be wrong with the combination ”My Err:522-file” and
>> LibreOffice, so I will just run away from the problem and use Apache
>> OpenOffice for that particular spreadsheet (and maybe all other office
>> documents in the future, but that's too early to say after trying out
>> Apache OpenOffice for only half an hour or so…).
>> Solved. At least for now.
>> One difference between my installations of Apache OpenOffice and
>> LibreOffice, is that I didn't ”import” my LibreOffice settings to
>> Apache OpenOffice yet (settings of different kinds), so it's quite
>> possible, I guess, that when I do that, I will experience the same
>> problems with Apache OpenOffice. The only thing I iknow right now, is
>> that with the settings I have now and with those two office suites, I
>> just don't have time to wait for LibreOffice doing weird things in the
>> background, freezing for minutes for every cell entry.
>> Johnny Rosenberg
>> --
>> For unsubscribe instructions e-mail to:
>> Problems?
>> Posting guidelines + more:
>> List archive:
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>For unsubscribe instructions e-mail to:
>Posting guidelines + more:
>List archive:
>All messages sent to this list will be publicly archived and cannot be deleted
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message