Issue 92479 - Unable to point to cell on another sheet in two columns to the right of frozen column
Summary: Unable to point to cell on another sheet in two columns to the right of froze...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0 Beta 2
Hardware: All Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 93038 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-08-05 15:29 UTC by vuxma
Modified: 2013-01-29 21:44 UTC (History)
1 user (show)

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

Attachments
A simple test spreadsheet with frozen column to demonstrate the issue - it is not possible to point to sheet 2 values from columns c & d without manually typing the sheetname and cell address (7.54 KB, text/plain)
2008-08-05 15:34 UTC, vuxma 		no flags Details
attachment to demonstrate the issue - it is not possible for the cells in B & C columns below the split line to point to the other sheets' values without manually typing the sheetname and cell address. (12.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-08-15 04:42 UTC, chl207 		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 vuxma 2008-08-05 15:29:45 UTC 
There is a problem in Calc, that I allready noticed in on of the latest stable 
releases of OpenOffice, but as I am cuurently using 3.0 b2 I report it here.

If i freeze a column in calc it is not possible to point to another cells on 
other sheets in the next two columns to the right of the frozen column. If I 
enter '=' sign to enter a formula and try to point to a cell on another sheet, 
nothing happenes. If I unfreeze the column everything starts to work OK.
Comment 1 vuxma 2008-08-05 15:34:11 UTC 
Created attachment 55571 [details]
A simple test spreadsheet with frozen column to demonstrate the issue - it is not possible to point to sheet 2 values from columns c & d without manually typing the sheetname and cell address
Comment 2 chl207 2008-08-15 04:28:52 UTC 
On WinXP, DEV300_m28,the bug exists.
BTW,the cells in all columns above the split line work well.
Comment 3 chl207 2008-08-15 04:42:37 UTC 
Created attachment 55795 [details]
attachment to demonstrate the issue - it is not possible  for the cells in  B & C columns  below the split line to point to the other sheets' values without manually typing the sheetname and cell address.
Comment 4 redflagzhulihua 2008-08-18 07:07:39 UTC 
Confirmed
Comment 5 frank 2008-08-27 11:06:38 UTC 
*** Issue 93038 has been marked as a duplicate of this issue. ***
Comment 6 Joe Smith 2008-09-30 17:54:29 UTC 
I see this problem in OOo 2.4.1 and 3rc3 under Fedora Linux 9.

The problem only happens if I type the '=' key to start the formula; it does not
happen if I start the formula by clicking the '=' button on the formula bar.
Comment 7 ajbwork 2008-09-30 17:57:27 UTC 
I can confirm this in RC2.