On Mon, 2007-04-23 at 14:52 +0100, Brian Barker wrote:
> As it happens, I'm not sure what you are doing here.  I don't know 
> where you are when you say you are "brows[ing] the bug reports", and 
> I can't re[produxe any of this behaviour.  If I search the support 
> pages on the web site or the help text in the application, I don't 
> see any such restriction.
http://user-faq.openoffice.org/issues/query.cgi Fill in the top and near
the bottom put in key words of full screen.


> Again, I can't reproduce this.  Does this happen whatever you enter 
> into a cell? 
The sheet has columns to enter quantities which then get multiplied by
prices to produce costs for the quantity. If I enter a quantity it
errors out in the cell that does the calcs. This works on a brand new
invocation of scalc, then open the spreadsheet, go full screen, enter 1
quantity - error.

Do the same thing but don't go full screen and it works fine.

>  If you just type a single text character or a digit, 
> for instance?  Or is it that the particular nature of what you need 
> to enter is causing the problem?  You know - do you? - that error 522 
> means that the spreadsheet thinks you are trying to define the 
> contents of a cell recursively, in other words, in terms of itself, 
> though possibly indirectly.  Is it possible that you are doing this?
There is no looping back on itself. Besides - why would that not error
out in the regular screen and only in full screen?
> 
> >Is there something flat wrong with full screen mode ...
> 
> Apparently not.
> 
> >... or is there something I'm supposed to do to get rid of these errors?
> 
> I would suggest that you first try this out on a new, very simple 
> spreadsheet, to see if the problem occurs with, perhaps, a one- or 
> two-sheet spreadsheet with the minimum of entries.  If that works OK, 
> you could then work gradually up to something of the same complexity 
> as your actual, spreadsheet and see what aspect first creates the problem.
> 
Thats a bit problematic in that the spreadsheet has 17 sheets. If I knew
what was causing it I'd test it, but I've got so much going on in the
spreadsheet that its tough to guess what might be the cause.

> Otherwise you could send the list a lot more detail of the problem, 
> for example, your operating system and the version of OpenOffice you 
Fedora Core 4 and 6 with OO 2.0
> are using, as well as what sort of data you are entering
I enter the number 1 in a cell to have it get multiplied by a price.
>  and what is 
> in any referenced cells.  Oh, and what language version you are using 
> and your locality.
Language version? - US English

-- 
Bill Gradwohl


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to