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.knu...@gmail.com> >To: LibreOffice Användare <us...@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 <tomdavie...@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.knu...@gmail.com> >> To: LibreOffice Användare <us...@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.knu...@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+h...@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+h...@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 > > >
