I just filed a bug report about this one, and it can be found at: http://www.openoffice.org/issues/show_bug.cgi?id=104659
I also attached (to the bug report, not here) an example spreadsheet where this problem occurs. J.R. Den 30 augusti 2009 09.39 skrev Johnny Rosenberg<[email protected]>: > I have a semi complicated (or something like that) spreadsheet which > works great on my laptop with dual core 1.6 GHz 2 GiB. I run Ubuntu > and OpenOffice.org 3.1 and I also do on my Eee PC 900, which is a > single core 0.9 GHz, 1 GiB. > The problem is on my Eee PC. In my spreadsheet there are several > sheets, but all input is done on one of them. That sheet also has some > somewhat complicated formulas calculating things as I fill cells with > mostly numbers. > Almost every time I input something, one ore more of the cells display > Err:522, and I KNOW there are nocircular references what so ever on > any of the sheets. How do I know that? Well, because when I hit > Ctrl+Shift+F9 to recalculate all the cells, the error message is > replaced by the appropriate value. > > Actually I was experimenting with this as I wrote the above and I > found a clue why it works on one computer but not on the other one: > The Eee has a rather small screen, so I always use that sheet in full > screen mode, otherwise I have to scroll often, since the order of > input to the cells are kind of random. If I don't use fullscreen mode, > there are no errors… So I tested this on my bigger lap top (mentioned > above), setting it to full screen mode, and then the errors appears on > that one too! > > First I though that the probolem was that the Eee is a weaker machine > with less memory, which could mess things up, but it seems to be the > full screen mode that cause my problems! > > Well, mayhbe I just should report this then… > > The cells that display the error messages (they don't always do it, > but some times when I input something a few of them do, but others > don't, and so on…) are not too complicated. A few of them are like > =if(blah;something;countif(blahblah;blah)+blah) and some of them are > even more simple, like =sum(blah;freekin;blaha;aha). > > Thanks for listening… > > Johnny Rosenberg > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
