On Thursday 07 April 2005 11:33 am, Ennio-Sr wrote:
> Hi all!
>
> as my previous post on this item remains unanswered I feel as being
> the only one having this problem. OTOH, if this is the 'normal
> behaviour' it falls beyond my capacity to grasp its rationale and I
> couldn't find a clue in the User_guide.pdf either.
>
> So I would appreciate it if somebody could confirm that, when moving
> to a particular address in a spreadsheet, the requested address will
> be shown right in the middle of the window and not in the upper left
> corner.
>
> Regards,
> Ennio.
I get the exact same behavior as you do. As to why Calc would put
the cell to which you have moved in the middle row, perhaps it is to
provide you with a view of what is in the cells surrounding it. In your
previous post, you mentioned only being able to see part of list of
times that began at a particular cell. How long is that list? What cell
does the list begin in?
Here is a suggestion. Add the beginning row number of this list to
the last row number. Divide this sum by 2. Ignore any remainder. Use
this quotient as the row number to move to. This will place the list on
the spreadsheet with the middle row of the list in the middle of the
window. Divide the number of column in the list by 2. The quotient is
how far over the middle column is from the first column.
For example, a list begins at C550. There are 8 filled columns in
each row. The list runs from row 550 to row 577. The math produces a
middle row: 563 and a column F (4 columns over from column C). Entering
F563 puts the list in the middle of the screen in both directions.
This may not be what you want either, but let me know.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
