Apache OpenOffice (AOO) Bugzilla – Issue 66028
Merged cells do not drag-fill properly
Last modified: 2013-08-07 15:13:10 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.
Created attachment 36870 [details] a screenshot to show correct behavior of drag-fill with not merged cell
Created attachment 36871 [details] a screenshot to show incorrect behavior of drag-fill with merged cell
Created attachment 36872 [details] a screenshot to show how excel handles drag-fill with merged cell
requirements have to decide btw simply copy and paste from Issue 49414 was not meant as I asked for new Issue as enhancement.
> 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.
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 -----
Add myself to CC list.
Created attachment 62429 [details] Update issue 66028's correct behavior.
Created attachment 62677 [details] Update the spec again.
Created attachment 62697 [details] changes and annotations to the spec
Created attachment 62738 [details] Update the specification again.
Work is in progress on the issue, so it should no longer be assigned to "requirements".
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?
*** Issue 107844 has been marked as a duplicate of this issue. ***
Reset assignee on issues not touched by assignee in more than 1000 days.