Issue 66028

Summary:

Merged cells do not drag-fill properly

Product:

Calc

Reporter:

jeongkyu.kim

Component:

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

cno, issues, kamataki, kyoshida, liujiaxiang, ooo.redflag, pagalmes.lists, rb.henschel, tora3, y-catch, yonggang.mao

Version:

OOo 2.0.3

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

Issue Blocks:

84483

Attachments:

Description	Flags
a screenshot to show correct behavior of drag-fill with not merged cell	none
a screenshot to show incorrect behavior of drag-fill with merged cell	none
a screenshot to show how excel handles drag-fill with merged cell	none
Update issue 66028's correct behavior.	none
Update the spec again.	none
changes and annotations to the spec	none
Update the specification again.	none

Description jeongkyu.kim 2006-06-02 08:10:25 UTC

When using drag-fill on a merged cell, two problems are encountered.

1. The fill data is inserted into regular cells, instead of expanding into new
merged cells isometric with the cell(s) providing the fill source.

2. Normal auto-fill-calculation, which works properly with regular cells, does
not work the same with merged cells.

Example:

1. Create a merged cell of any size.
2. Enter 3/1/04 into that cell.
3. Create another merged cell, adjacent to and of the same cell size as the
first cell. Enter 4/1/04 into the resulting merged cell.
4. Highlight both cells.
5. Use drag-fill (drag the selection area by the square in the bottom right
corner) and drag to the right.

Compare the result values with those from doing the same operation with
adjacent, non-merged cells. Also compare with other spreadsheet software.

Comment 1 jeongkyu.kim 2006-06-02 08:11:48 UTC

Created attachment 36870 [details]
a screenshot to show correct behavior of drag-fill with not merged cell

Comment 2 jeongkyu.kim 2006-06-02 08:12:23 UTC

Created attachment 36871 [details]
a screenshot to show incorrect behavior of drag-fill with merged cell

Comment 3 jeongkyu.kim 2006-06-02 08:13:55 UTC

Created attachment 36872 [details]
a screenshot to show how excel handles drag-fill with merged cell

Comment 4 frank 2006-06-02 10:32:33 UTC

requirements have to decide

btw simply copy and paste from Issue 49414 was not meant as I asked for new
Issue as enhancement.

Comment 5 jeongkyu.kim 2006-06-02 10:37:40 UTC

> btw simply copy and paste from Issue 49414 was not meant as I asked for new
Issue as enhancement.

There might be misunderstanding in 49414, but this description is exactly same
as my issue. If you think there is a difference, _please_ explain it in detail.

Even I dicussed this in QA list, there is a guy who agreed my issue is same as
49414.

Comment 6 jeongkyu.kim 2006-06-02 15:09:44 UTC

Hello Frank,

I am not sure this comment can get to you, but this is my best. I wrote e-mail
to you, but the message was refused by your mail server. Here is the content of
my e-mail. Please check this and reply if you have a chance.

Thank you.

-----
Hello Frank,

Sorry for interrupting you by personal e-mail. There seems to be some
misunderstanding regarding to the issues, and I want to explain it.

In my comments, I didn't mean that OO.o should do same as Excel. The reason of
my regarding the issue as defect is that _drag fill pattern in OO.o is
incorrect_. With non-merged cell, dates or integers are increased as use
expected. However, with merged cell, the pattern is out of expectation as you
see in the attached picture.

And, I believe the original description reflects this point well, so I
duplicated the description in the new issue. My apologies if it disturbs you.

I am looking forward to hear from you.

Regards,
Jeongkyu 
-----

Comment 7 redflagzhulihua 2007-12-25 08:45:43 UTC

Add myself to CC list.

Comment 8 yonggang.mao 2009-05-22 08:48:54 UTC

Created attachment 62429 [details]
Update issue 66028's correct behavior.

Comment 9 yonggang.mao 2009-06-01 10:09:52 UTC

Created attachment 62677 [details]
Update the spec again.

Comment 10 Regina Henschel 2009-06-01 23:35:45 UTC

Created attachment 62697 [details]
changes and annotations to the spec

Comment 11 yonggang.mao 2009-06-03 07:40:06 UTC

Created attachment 62738 [details]
Update the specification again.

Comment 12 niklas.nebel 2009-06-04 09:56:09 UTC

Work is in progress on the issue, so it should no longer be assigned to
"requirements".

Comment 13 paul_richards1976 2009-12-01 17:02:19 UTC

I'm so pleased that this is being worked on, I have use it in Excel to create my
Wife's invoices and it's the only thing that's stopping me from banishing
Microsoft all together in our house.

Please excuse my ignorance as I'm very new to this open source business but does
anyone know how long these things normally take to implement and how do we find
find out when it's been resolved?

Comment 14 Regina Henschel 2009-12-22 21:17:27 UTC

*** Issue 107844 has been marked as a duplicate of this issue. ***

Comment 15 Regina Henschel 2009-12-22 21:18:55 UTC

*** Issue 107844 has been marked as a duplicate of this issue. ***

Comment 16 Rob Weir 2013-07-30 02:44:22 UTC

Reset assignee on issues not touched by assignee in more than 1000 days.