Issue 57432 - Autofill does not recognize merged cells as 1 cell
Summary: Autofill does not recognize merged cells as 1 cell
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 23 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2005-11-06 15:50 UTC by nutsywb
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Test Case: merged cells along the top to autofill (20.00 KB, application/
2005-11-06 15:52 UTC, nutsywb
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description nutsywb 2005-11-06 15:50:34 UTC
I think this is a defect. It's possible you guys did it on purpose. Here is my
situation. I am tracking something by day. In the top most line heading is the
date in question. Underneath are 4 columns corresponding to the information I
want to track. They are subheadings. I've merged the four columns in to one cell
for the date heading so that date applies to all four columns. This then repeats
across the sheet to represent the whole week. 

What I want to do is enter the date in the first column, and use the autofill to
fill in the other columns. When I try to do this, I get dates for every 4 days,
because OpenOffice still treats the merged cell as 4 cells. 

I don't think it's 4 cells anymore, that's the whole reason I merged them. This
is not the way that other spreadsheet programs that I've used function.
Comment 1 nutsywb 2005-11-06 15:52:17 UTC
Created attachment 31225 [details]
Test Case: merged cells along the top to autofill
Comment 2 nutsywb 2005-11-06 15:54:01 UTC
Platform: PC
OS: Windows 2000
Comment 3 atdsm 2005-11-21 21:34:23 UTC
Ok, I think I see what you are getting at. However, when I use autofill I find
that it just unmerges the destination cells. (This is a problem in and of
itself, but possibly not the same problem.)

Could you post step by step instructions that would allow us to duplicate the
bug from the file that you attached?


Comment 4 nutsywb 2005-12-09 02:46:00 UTC
Ok, I had to update my current document, because I added information and the
document changed. I'm going to start from where I am. The top cells were not
merged. So I merged cells A1 - D1, E1 - H1, and continued until I got to AB1.
They have dates in them. A1 - D1 has "11/12" in it. I clicked on the little box
at the bottom corner of the A1 - D1 cell and dragged it over the E1 - H1 cell.
While my mouse is hanging over cell E1 - H1, I notice the tool tip says says
"11/15" instead of of the expected "11/13".  At this point, I usually stopped
trying to put the date into the other cells.

I'm not sure if I ever bothered to drop the date in. I saw the tool tip and
assumed it would go in wrong. I may have done it and immediately pressed
"Ctrl-Z" to undo it. Either way I never noticed the rather strange phenomenon of
it splitting the next cell into which I dropped the date. 

To continue with my steps, if I let the date drop into the next cell, cell E1 -
H1, then it splits that cell back into the individual cells E1, F1, G1, and H1.
 That's not right either, though you can be the judge as to which is more wrong.

I would like to give my sincere appologies for dropping the ball on this. Things
have been rather busy with the holidays and all.

Thanks for looking into this for me! I love OpenOffice!
Comment 5 atdsm 2005-12-09 15:18:40 UTC
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.


Comment 6 nutsywb 2005-12-09 18:29:26 UTC
Though I hate to use Excel as a basis for functionality, I have to agree that
from a user perspective, this does seem to be the most intuitive way to proceed.
I found  the current functionality quite unexpected, even a little frustrating. 

I don't know if you were looking for additional input from me, but I thought I
should go ahead and put my vote in. Thanks!
Comment 7 frank 2005-12-13 17:13:48 UTC

this effect was mentioned first in Issue 49414 and should have resulted in an
enhancement request. For now I can not find something about it, so this Issue
goes to requirements to evaluate.

Comment 8 was82 2008-10-17 09:09:22 UTC
Just, i need it ;)