Issue 26727 - Its possible to enter values to cells do not exists because they are "overlapped" by a connected cell
Summary: Its possible to enter values to cells do not exists because they are "overlap...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1RC
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 27045 28067 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-03-19 11:35 UTC by norbert2
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

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

Attachments
connected_cells.sxc (5.44 KB, application/vnd.sun.xml.calc)
2004-03-19 11:35 UTC, norbert2 		no flags Details
merged2.sxc (5.43 KB, application/vnd.sun.xml.calc)
2004-04-27 06:41 UTC, norbert2 		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 norbert2 2004-03-19 11:35:31 UTC 
Please have a look at the attached spreadsheet, and do the following steps:

- select the blue cell

- push the cursor up: the green (connected) cell is selected

- push the cursor up again: now the cell B1 is selected. But this cell does not 
really exist, because it is overlapped by the A1. Now You can enter values to 
B1. In the attached spreadsheet I already have entered the value "TEST" to B1. 
The red cell references to B1, in order to show the problem.

Excel does not have this problem.
Please fix it.
Comment 1 norbert2 2004-03-19 11:35:51 UTC 
Created attachment 13936 [details]
connected_cells.sxc
Comment 2 frank 2004-03-19 12:33:59 UTC 
Hi Niklas,

reproducible only if you use merged cells in the first row.

Frank
Comment 3 frank 2004-03-29 09:24:59 UTC 
*** Issue 27045 has been marked as a duplicate of this issue. ***
Comment 4 norbert2 2004-04-20 15:48:50 UTC 
Please also have a look at issue 28067.
Comment 5 frank 2004-04-21 10:12:35 UTC 
*** Issue 28067 has been marked as a duplicate of this issue. ***
Comment 6 frank 2004-04-21 10:13:44 UTC 
Hi Niklas,

it also applies for d&d operations.

Frank
Comment 7 norbert2 2004-04-27 06:40:52 UTC 
The problem also happens for the left border. Just have a look at the doument 
attached below.
(Please also check the right and bottom border for the problem. I have not 
tested this.)
Comment 8 norbert2 2004-04-27 06:41:34 UTC 
Created attachment 14794 [details]
merged2.sxc
Comment 9 frank 2004-05-05 12:03:37 UTC 
Due to time problems this is re-targeted to OOo later
Comment 10 Regina Henschel 2009-07-13 19:32:54 UTC 
It is a feature of OOo, to use that cell, which is hidden by a connection. This
feature is used to store additional information, which will be evaluated in
other cells, but not shown. Excel does not has this feature.
(There is a nice calendar on
http://de.openoffice.info/viewtopic.php?f=2&t=14977&p=81619 which uses this
feature.)

The real issue is that you neither can access the cell by navigator nor by using
the name field. But you have to disconnect the cells before you can edit the
value and connect it again afterwards.
Comment 11 Marcus 2017-05-20 11:13:41 UTC 
Reset assigne to the default "issues@openoffice.apache.org".