After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 504191 - Autofill does not merge cells
Autofill does not merge cells
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: Normal minor
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2007-12-18 07:10 UTC by Reggie Chan
Modified: 2008-02-21 19:53 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
Partial patch (3.71 KB, patch)
2007-12-22 00:17 UTC, Morten Welinder 		needs-work Details | Review
Updated patch (8.22 KB, patch)
2007-12-26 02:52 UTC, Morten Welinder 		none Details | Review

Description Reggie Chan 2007-12-18 07:10:43 UTC 
Steps to reproduce:
1. merge A1:A2, A3:A4
2. set A1 = 1, A3 = 2
3. select A1:A4 and autofill to A8

Expected behavior:
4. A5:A6 and A7:A8 become merged and A5 = 3, A7 = 4

Actual behavior:
4. A5 = 3 and A7 = 4, but A5:A6 and A7:A8 do NOT become merged.
Comment 1 Morten Welinder 2007-12-21 00:37:42 UTC 
There are a couple of different bugs there.

1. When selecting a1:a4 and drag the little square, you can drag to A8,
   but not to A6, for example.

2. Cells do not get merged.

3. In fact, if a5:a6 were merged, they will get unmerged.  Even worse, if
   a5:a7 are merged, the operation is still allowed.
Comment 2 Morten Welinder 2007-12-21 15:31:59 UTC 
and

4. It considers the blank hidden cells (a2, a4) when figuring out how
   to fill.

I have this pretty much under control.
Comment 3 Morten Welinder 2007-12-22 00:17:14 UTC 
Created attachment 101445 [details] [review]
Partial patch

This patch fixes a good deal of the problems.  However, ...

1. It does not fix the gui part.
2. When auto-filling left or up, it will consider the wrong parts of merged
   cells.
Comment 4 Morten Welinder 2007-12-26 02:52:43 UTC 
Created attachment 101607 [details] [review]
Updated patch

This patch handles some of the left/up fill problems.
Comment 5 Morten Welinder 2008-02-21 19:53:38 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.