Issue 53570

Summary:	Option to start on A1 + show edge differently
Product:	Calc	Reporter:	david
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 2.0 Beta
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

Description david 2005-08-21 02:44:49 UTC

TOO many times I've been confused with spreadsheets looking wrong (and yesterday 
in a hurry lost 1066 EURO on a studio session with part of the script missing 
because of this) upon opening them because I forgot to press CTRL+HOME just 
after opening/choosing a spreadsheet.

I find it very illogical that Open Office requires the user press CTRL+HOME just 
to view a spreadsheet the same way each time a new one is chosen/opened. There 
is no way of having Open Office show a newly chosen or loaded spreadsheet in the 
left/topmost corner.

The problem is that

1) open office confusingly starts showing the section where the last user 
happened to have her cursor when she saved. This, mind you, more often than not 
is a completely random cell which therefore makes the program show only part of 
the spreadsheet confusing the user into thinking unless the user (like I try to) 
ALWAYS presses CTRL+HOME before saving

2) open office has NO clear way of showing that the sheet is infact BIGGER than 
what's showing on screen. The user looking at the cells - even top most cell row 
is not in ANY way being clearly told that the spreadsheet is bigger that the 
current view.

Please...

a) make it possible to turn on an option that makes calc ALWAYS open showing A1 
- like after you've clicked ctrl+home - and show first time chosen spreadsheets 
on A1 too

b) make it visually VERY VERY clear when a spreadsheet is BIGGER than what's on 
the screen (that's when data is on cells outside of view). E.g. with "..." in 
the left and rightmost part of the screen and something like that in the top/
bottom too - or make the cells fade out or something unless they're in the 
first/last row/column of data on the sheet.

I'm not sure how Excel does this but if it does this better or has an option to 
choose to _always_ start on A1, I'm seriously considering switching (I think 
Excel costs less than 1066 EUR). If Excel does not handle this problem better I 
would be very happy to see open office getting ahead of Excel in this regard!

Cheers
-- David

Comment 1 frank 2005-09-15 13:06:07 UTC

for requirements team

Comment 2 ace_dent 2008-05-16 01:41:03 UTC

OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 2+ years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html