At 09:16 23/04/2007 -0600, Bill Gradwohl wrote:
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
The "keywords" at the URL you quote are not search items, I think,
but a small range of defined keywords to enable classification of
issues. "Full" and "Ctrl" are indeed not in the list, so they cannot
be found. That is not really the place to search for help on this issue.
Indeed: full-screen and regular display should presumably behave in
the same way.
I realise that your spreadsheet is probably complex and large. But
that's precisely why I suggested testing a simpler case, to see if
the complexity of your actual spreadsheet was contributing to the
problem. Either you or someone else will probably have to do this.
I don't have any experience with OpenOffice under your operating
system, so I'll leave others to contribute.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
