Description: Description: Dear folks ! For example in a small table there are TWO ways of inserting columns: First : One can select a column (on top side the column letters) and then one can INSERT a (or more) Column "right clicking the mouse" selecting "Insert Column to the left". Second : With (by) the mouse a part of the table can be market and selectet and then this selection can be moved / dragged (for example) one coulumn to the right with the the same effect of having a coulumn 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 row 1,2,3,4,5, "sum" of these 5 to the rigt beside 2. below create row 6,7,8,9,10, "sum" of these 5 to the right beside 3. Select column letter of 2 and 7 insert column to the left by mouse right click "insert to the left" See "sum - formula" 4: UNDO inserting coloumn (str z / crtl z) 5: mark with mouse "cell 2 to cell "sum (6-10)" as selection DRAG selection one coloumn to the right -> See "sum - formula" Actual Results: different behaivior Expected Results: identical behavior ? Reproducible: Always User Profile Reset: No Additional Info: 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
Created attachment 158493 [details] small file to test / check
Hi, i did some further testing on this ! hope my english is sufficient. The resulöts i figured out happens in BUG 131186 "inserting ROWs" as well in the same manner in this BUG 13120 "Inserting Coloums" The developers should examine these stepps: create row 1,2,3,4,5, SUM (of these 5) beside between each insert a couloum BY "select Couloumn Letter on top" // insert coloumn on left side with mouse rigth click should be now:: 1, empty , 2, empty, 3, empty, ......, sum(1-6) NOW ::!! Select sum formula with mouse AND Shift Key to have sum - formula selected and draggable Drag sum formula to the left into the empty cell Select both (Number 5 AND AlSO sum formula), THEN drag both to the left empty cell ERROR 522 occurs The same happens if you do an a coloumn 1,2,3,4,5, sum(of these) Insert "rows" between by selecting row numbers right click insert row above When done undo this by "the same dragging methode" kind regards
*** This bug has been marked as a duplicate of bug 131186 ***