Bug 88782 - EDITING spreadsheet: autofill using fill handle inserts incorrect data when used with merged cells
Summary: EDITING spreadsheet: autofill using fill handle inserts incorrect data when u...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split AutoFill
  Show dependency treegraph
 
Reported: 2015-01-24 21:27 UTC by Jens
Modified: 2019-07-06 20:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test document to reproduce the bug (25.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-24 21:27 UTC, Jens
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jens 2015-01-24 21:27:39 UTC
Created attachment 112783 [details]
test document to reproduce the bug

This was observed on Libreoffice 4.2.5 Linux (Ubuntu 14.04 stock installation), 4.3.5-rc2 Linux (libreoffice PPA) and 4.2.4.2 OS X (install from libreoffice website).

See attached spreadsheet.

Instructions:
Select 2015 and 2016, and try to use the fill handle to autofill to the right until 2020.

Result:
Instead of copying the formatting - two cells joined for each year – and increasing the years, 2016 is repeated and then each year is inserted twice into every other cell.

This happens with other combinations of merged/joined cells as well.
Comment 1 m.a.riosv 2015-01-24 21:40:33 UTC
Hi @Jens, thanks for reporting.

Reproducible:
Win7x64
Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7

Maybe the same problem than reported https://bugs.documentfoundation.org/show_bug.cgi?id=86143
Comment 2 Jens 2015-01-24 21:47:30 UTC
Similar, but not identical. There are actually two bugs:

1. (#86143) complains about autofill results of merged cells not being merged too (even with workaround)

2. I also :) complain about the autofill results. If I select two cells I would expect the increment between these cells to be used for autofill increments, but Calc seems to do something different.
Comment 3 Jens 2015-01-25 11:36:08 UTC
PS: If there's anything else I can do to help, please tell me!

(And don't take "complain" in the previous comment too seriously.. I'm a heavy LO user and very much interested in getting as many bugs fixed as possible.)
Comment 4 Cor Nouws 2015-02-03 09:54:29 UTC
(In reply to Jens from comment #3)

> (And don't take "complain" in the previous comment too seriously.. I'm a
> heavy LO user and very much interested in getting as many bugs fixed as
> possible.)

;)

Do you know if this worked correctly before, Jens?
Comment 5 QA Administrators 2016-02-21 08:34:49 UTC Comment hidden (obsolete)
Comment 6 Jens 2016-02-21 18:47:23 UTC
Hello,
retested with LibreOffice 5.1.1.1, Build-ID: c43cb650e9c145b181321ea547d38296db70f36e
CPU Threads: 8; OS Version: Mac OS X 10.11.3; UI Render: GL; 
Locale: de-DE (de.UTF-8)

Result: Same bug behaviour as before. Not resolved. Sorry .. :)
Comment 7 Jens 2016-02-21 19:03:38 UTC
Bug is also present on LibreOffice 3.3.0.4 (Mac).
Comment 8 QA Administrators 2017-03-06 15:01:01 UTC Comment hidden (obsolete)
Comment 9 m.a.riosv 2017-03-06 23:27:07 UTC
Still with
Version: 5.3.1.1 (x64)
Build ID: 72fee18f394a980128dc111963f2eefb05998eeb
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Comment 10 QA Administrators 2018-10-29 03:57:41 UTC Comment hidden (obsolete)
Comment 11 Jens 2019-07-06 20:42:33 UTC
Still present in this version:

Version: 6.2.4.2
Build-ID: 1:6.2.4-0ubuntu0.18.04.1~lo1
CPU-Threads: 4; BS: Linux 4.15; UI-Render: Standard; VCL: kde5; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded