Apache OpenOffice (AOO) Bugzilla – Issue 123474
Fill handle does not increase cell values
Last modified: 2014-09-25 05:25:52 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.
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.
As given in description. AOO401m5(Build:9714) - Rev. 1524958 2013-09-20 11:54 - Linux x86_64 Debian
.
*** Issue 120622 has been marked as a duplicate of this issue. ***
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 sheet 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
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.