To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102579
                 Issue #|102579
                 Summary|Merged cells cause incorrect tabbing of cell selector 
                        |into protected cells.
               Component|Spreadsheet
                 Version|OOO310m11
                Platform|All
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|formatting
             Assigned to|spreadsheet
             Reported by|robelsman





------- Additional comments from [email protected] Sun Jun  7 16:58:49 
+0000 2009 -------
OOO310m11 (build 9399), Calc (English language)
Computer:  Intel Pentium IV 2.0GHz, 256MB RAM
Operating System:  Windows XP Home Edition, SP3
JAVA Runtime Environment:  Sun Microsystems, Version 6, update 13 (build 
1.6.0_13-b03)

Summary:  Merged cells cause incorrect tabbing of cell selector into protected 
cells.

Note:  Tools>Protect Document>Sheet must be turned ON.

1.  Tabbing forward from a merged, unprotected cell moves the cell selector to 
the next protected cell to the right instead of the next unprotected cell in 
the forward tabbing order if the underlying cells in the merged cell were 
unprotected before the merge operation.

In the test case that I have uploaded, after having selected merged, 
unprotected cell B3, use the TAB key to tab forward.  Instead of the cell 
selector moving from cell B3 to cell C5, as expected, the cell selector moves 
from cell B3 to cell F3, although cell F3 is a protected cell.  Note that cells 
C3, D3, and E3 were unprotected before the merge operation with cell B3; this 
problem does not occur if cells C3, D3 and E3 were protected before the merge 
operation with cell B3.

2. Tabbing backward from an unprotected cell moves the cell selector to the 
protected cell to the right of the next unprotected, merged cell in the 
backward tabbing order if the underlying cells in the merged cell were 
unprotected before the merge operation.

In the test case that I have uploaded, after having selected unprotected cell 
C5, use the SHIFT+TAB key combination to tab backward.  Instead of the cell 
selector moving from cell C5 to cell B3, as expected, the cell selector moves 
from cell C5 to cell F3, although cell F3 is a protected cell.  Note that cells 
C3, D3, and E3 were unprotected before the merge operation with cell B3; this 
problem does not occur if cells C3, D3 and E3 were protected before the merge 
operation with cell B3.

The rule should be that the cell selector does not tab forward or backward into 
a protected cell in a sheet when there is an unprotected cell somewhere in the 
same sheet.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to