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]
