Issue 73226 - Column letters render incorrectly in large spreadsheet
Summary: Column letters render incorrectly in large spreadsheet
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-01-07 14:35 UTC by ian_waring
Modified: 2013-08-07 15:13 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Calc when first opened, cell cursor at cell A2 (257.56 KB, image/png)
2007-01-07 14:36 UTC, ian_waring 		no flags Details
Hit uparrow to get to Cell A1 (255.33 KB, image/png)
2007-01-07 14:37 UTC, ian_waring 		no flags Details
Then hit rightarrow twice to go to cell C1 (255.68 KB, image/png)
2007-01-07 14:38 UTC, ian_waring 		no flags Details
One example file that shows this issue (1.85 MB, application/vnd.ms-excel)
2007-01-07 15:34 UTC, ian_waring 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ian_waring 2007-01-07 14:35:21 UTC 
I have several spreadsheets of circa 37,000 rows. If saved in Excel 2003 with
the cursor left on cell A2, then opened in OpenOffice Calc 2.0.4, row 1 is
invisible. If I hit an up-arrow, I can get all of row 1 showing above the
A...B...C...D.... column headers. If I then hit the right arrow twice, I end up
with a mix of row 1 with column headers above and below. The end result is
unusable for doing any useful work on the spreadsheet.

I have screen shots of all three screens:

http://ian.waring.googlepages.com/OpenOfficeFirstOpen.png
http://ian.waring.googlepages.com/OpenOfficeUpArrowtoA1.png
http://ian.waring.googlepages.com/OpenOfficeArrow2RighttoC1.png

Any ideas if there is a fix in place? I'm running OpenOffice 2.0.4 Calc on
Fedora Core 6 - the version that comes with the distribution and with all
updates to date applied.

Ian W.
Comment 1 ian_waring 2007-01-07 14:36:46 UTC 
Created attachment 41967 [details]
Calc when first opened, cell cursor at cell A2
Comment 2 ian_waring 2007-01-07 14:37:44 UTC 
Created attachment 41968 [details]
Hit uparrow to get to Cell A1
Comment 3 ian_waring 2007-01-07 14:38:40 UTC 
Created attachment 41969 [details]
Then hit rightarrow twice to go to cell C1
Comment 4 kpalagin 2007-01-07 14:52:53 UTC 
ian_waring,
can you try with OO 2.1 or at least provide the file, attaching it to your 
issue?
Comment 5 ian_waring 2007-01-07 15:34:57 UTC 
Created attachment 41974 [details]
One example file that shows this issue
Comment 6 ian_waring 2007-01-07 15:37:41 UTC 
File added as requested.
Comment 7 kpalagin 2007-01-07 21:08:39 UTC 
Confirming with OO 2.1 on Suse 10.2 (running in Virtual PC session) - I get 
the same results. 
OO 2.1 on WinXP (on real hardware) has some problems with attached .xls too.
Comment 8 frank 2007-01-23 10:34:02 UTC 
Hi,

problem is that the file is an Excel5 file and the import filter for that format
interprets the freeze position and type in a false way.

Re-assign to DR.

Frank
Comment 9 Martin Hollmichel 2007-11-09 16:51:45 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x