Re: [libreoffice-users] Re: Am I the only one with Err 522 problems?

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 <gurus.knugum@gmail.com>
> To: LibreOffice Användare <users@global.libreoffice.org>; users@openoffice.apache.org 
> 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 <tomdavies04@yahoo.co.uk>:
> > 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 <gurus.knugum@gmail.com>
> > To: LibreOffice Användare <users@global.libreoffice.org>;
> > users@openoffice.apache.org
> > 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 <gurus.knugum@gmail.com>:
> > > 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 3.6.5.2 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: users+help@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
> -- 
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted