Issue 73226

Summary: Column letters render incorrectly in large spreadsheet
Product: Calc Reporter: ian_waring <ian.waring>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin
Version: OOo 2.0.4Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Calc when first opened, cell cursor at cell A2
none
Hit uparrow to get to Cell A1
none
Then hit rightarrow twice to go to cell C1
none
One example file that shows this issue none

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