Issue 123474 - Fill handle does not increase cell values
Summary: Fill handle does not increase cell values
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: regression
: 120622 (view as issue list)
Depends on:
Reported: 2013-10-14 04:45 UTC by Rainer Bielefeld
Modified: 2014-09-25 05:25 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---

Sample Document (159.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-14 04:45 UTC, Rainer Bielefeld
no flags Details
Test kit with simple sample (64.78 KB, application/save-as)
2014-09-25 05:25 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2013-10-14 04:45:05 UTC
Created attachment 81760 [details]
Sample Document

Steps how to reproduce with server installation of  "AOO 3.4.0 – German UI / German locale [AOO340m1(Build:9590) - Rev.1327774]" on German WIN7 Home Premium (64bit)", own separate user profile:

1. open attached sample document
2. scroll so that cell F2159 becomes visible (you can search fro word "try")
3. Click F2159 in sheet ProjStat
   > Cell cursor with fill handle at it's bottom right corner appears
4. Drag and drop fill handle 5 cells down.
   Expected: Cells below F2159 show 1. Jul 13, 2. Jul 13, 3. Jul 13, ...
             (each following cell increased by 1)
   Actual: all cells still contain the same value                     :-(
5. Select cell range  2167:21:70
6. Menu 'Edit -> Fill -> Down'
   Expected: fills with increasing values
   Actual: as in Step 4 all cells with the same value                 :-(
7. Insert a new table behind sheet ProjStat (right click on sheet tab ...)
8. Click D5 in new sheet and insert value 1
   > "31. Dez 99" sown in D5
9. Click D5 and drag / drop fill handle 5 cells down
   As expected here fill handle works and increases numbers            :-)

Additional Info
(a) This is a regression compared to OOo 3.1.1
(b) removing conditional formatting will not solve the problem
(c) I do not know what the roots of the problem might be, in most of my 
    documents 'Fill' works as expected, but in some of my existing documents
    I observe the problem.
Comment 1 Rainer Bielefeld 2013-10-14 06:43:49 UTC
Still reproducible with  "AOO 4.1.0-Dev – English  UI / German locale - [AOO410m1(Build:9750)  -  Rev. 1530680 - 2013-10-11]" on German WIN7 Home
Premium (64bit)", own separate user profile.

Because of incomplete LCo selector (Bug 123063) no correct information can be left.
Comment 2 Edwin Sharp 2013-10-14 19:40:29 UTC
As given in description.

AOO401m5(Build:9714)  -  Rev. 1524958
2013-09-20 11:54 - Linux x86_64
Comment 3 Oliver Brinzing 2013-10-16 04:31:30 UTC
Comment 4 Rainer Bielefeld 2013-12-26 12:08:05 UTC
*** Issue 120622 has been marked as a duplicate of this issue. ***
Comment 5 Rainer Bielefeld 2013-12-26 12:41:03 UTC
Also Reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions - and a more simple sample document  Attachment 82149 [details] for Bug 90901:

11. open document from AOO Start center
12. Type "1" into D1, D20, D40
13. Click D1 and Drag / Drop fill handle to fill down until D4.
    Should show fill result 2, 3, 4, same for tests with  D20, D40
21. Close (without saving), reopen
22. Type "1" into D1, D20, D40
23. Autofilter Column A for "1"
    > Until Row 35 only rows with "1" in column A will be shown 
43. Click D1 and Drag / Drop fill handle to fill down until D4.
    Expected: shows fill result 2, 3, 4,
    Actual: sows 1, 1, 1 (Same for D40), Fill does not work anymore in this

Additional Info
(d) Currently I observe that problem with all simple sample documents I tested
    So I remove restrictions from Summary
(e) Compoarison with Competitors:
(e1) SoftMaker FreeOffice: does not suffer from this bug, but from Bug 89232
(e2) LibreOffice 4.1.3: Works perfect. Please see LibO#37623 - Auto Filter 
     disables incremental autofill function 
(e3) Gnumeric: Fill handle fundction seems different, no test possible
(e4) Lotus Symphony Release 3.0.1 Revision 20120110.2000
     Shows the same problem like AOO
(f) Still worked fine with OOo 3.3.0
Comment 6 Rainer Bielefeld 2014-09-25 05:25:35 UTC
Created attachment 83985 [details]
Test kit with simple sample

The problem is related to some strange area in content.xml:
"sample_101_ODF12 - Worksfine.ods" has been created by deleting contents 
<table:database-ranges>   ...   </table:database-range> from content.xml in "sample_101_ODF12 - notworking.ods". After that modification fill handle will work fine.

I can't tell how that content.xml code came into the documents, affected documents have a very long history.