To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57432
User atdsm changed the following:
What |Old value |New value
================================================================================
CC|'atdsm' |''
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |oooqa
--------------------------------------------------------------------------------
Summary|Autofill does not treats |Autofill does not
|merged cells as 1 cell |recognize merged cells as
| |1 cell
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Dec 9 07:18:40 -0800
2005 -------
Confirmed - OOo 2.0, Windows XP SP2.
There's an easier way to replicate too...
1) Open a new spreadsheet
2) Merge cells A1-D1
3) Merge cells E1-H1
4) Enter a "1" in merged cell A1-D1
5) Drag to autofill from merged cell A1-D1 to merged cell E1-H1
After this, you will notice two things: (1) Cell E1-H1 has unmerged, splitting
back into four cells (E1, F1, G1, H1). (2) Cell E1 contains "5", not "2" as we
would expect.
So, Autofill does not recognize cells A1-D1 to be a single (merged cell), but
rather to be four cells. Same for merged cell E1-H1. Thus, when you try to drag
from merged cell A1-D1, it first starts at "4" (which would be the logical
contents of cell D1 if dragging a 1 from cell A1), then increments once for each
cell in the next merged cell, ending at 8 and splitting merged cell E1-H1.
Same thing happens vertically (using merged cells A1-A4, A5-A8)
Proper behaviour:
-OOo autofill should recognized a merged cell as a single cell.
-Perhaps autofill should only work with blocks of cells the same size as the
originating cell IE, it you couldn't drag a merged cell of size 3 into a merged
cell of size 4 or size 2. (This is how Excel does it, for example - attempting
to do otherwise generates the error message "This operation requires the merged
cells to be identically sized.")
-When dragging a merged cell onto unmerged cells, the unmerged cells should be
converted to merged cells of the appropriate size.
Confirming.
Steve
---------------------------------------------------------------------
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]
