Description: Dear folks ! For example in a small table there are TWO ways of inserting rows: First : One can select a row (on left side the row numbers) and then one can INSERT a (or more) Row by "right clicking the mouse" selecting "Insert Row above". Second : With (by) the mouse a part of the table can be market and selectet and then this selection can be moved (for example) one row down with the same effect to have a row inserted in the partition of the whole sheet I have figured out, that both modificaton do NOT have the same Results especially if some cells have a formula inside. A simple example is attached with descripion in the file to produce. kind regard Steps to Reproduce: 1. create coloumn 1,2,3,4,5, sum of this 5 numbers below 2. create coloumn 6,7,8,9,10, sum of this 5 numbers below 3. select 2 to "sum" by mouse, move selection 1 row down 4. repeat 3 to "sum" Actual Results: formula is wrong Expected Results: formula is correct Reproducible: Always User Profile Reset: No Additional Info: dont know
Created attachment 158453 [details] small table with steps to see faulty behavior
Repro Version: 6.4.2.1 (x64) Build ID: c92dba0b4728c0ec26c4b83e2c0fbf3284425375 CPU threads: 4; OS: Windows 10.0 Build 19569; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL Second drag of cells shows the misbehavior. Repro with Aoo 4.1.1
confirming, root cause seems to be: forumla in C9 =SUM(C3:C8) is not adjusted after drag operation, e.g. after first drag to: =SUM(C3:C9), after secand drag to: =SUMME(C3:C10),... btw: it works with excel 2016
Hi, behavior as well on Version: 6.4.1.2 (x64) Build-ID: 4d224e95b98b138af42a64d84056446d09082932 CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: GL; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: CL regards jürgen
HI, please read my comment number 2 on BUG 131220 There are some more effects to be seen. Happening both on ROWS ant COLUMNS too. regards jürgen
*** Bug 131220 has been marked as a duplicate of this bug. ***
Hi m.a.riosV I dont know much about this "bugzilla" !? The information on the other "dupilcate bug" to which i refer here in comment No. 5 -which referrs to bug 131220 comment No 2 should NOT go lost anyway. May be one of my descriptions of the two bugs shall be copied to another ? Especially the "re (respective) back - dragging" after inserting rows / columns, because it "simply" is the other dragging direction and incorporates some faults ?! You or anyone familiar with THIS bugzilla should do what is needed, i am not. best regards jürgen
Hi, as well in Version: 6.4.2.2 (x64) Build-ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3 CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: GL; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: CL regards jürgen