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]
