Description: If two vertically adjacent cells contain a formula in the lower cell and those two cells are "merged" it turns the formula into hard data in the merged cells. It doesn't become apparent until the merged cells are drag filled to the right to replicate the formulae. Then it just becomes an incremental increase of "edited" data Steps to Reproduce: With the attached sample sheet observe the formula in the merged cells C9:C10 Observe that the formula has been replicated by drag-filling to the adjacent cells. Unmerge C9:C10 and observe that the formula is written into the upper cell C9 Observe the formula in C13 Select C12:C13 and merge Looks OK but now drag-fill the merged cell structure to L12:L13 Observe that the formulae have become edited data in C12:C13 which was simply incremented by 1 as it was dragged 2. 3. Actual Results: Formula in the merged structure is transmuted to data as if it were a paste special operation Expected Results: Retained the Intact formula in the merged structure Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
Created attachment 185087 [details] Simple Example .ods
(In reply to Colin from comment #0) > > Looks OK but now drag-fill the merged cell structure to L12:L13 > Observe that the formulae have become edited data in C12:C13 which was > simply incremented by 1 as it was dragged The transmutation is not the result of drag-filling but simply the merging of the two cells
Reproducible, the problem occurs by merging the cells vertically, not horizontally. Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: c21113d003cd3efa8c53188764377a8272d9d6de CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
*** This bug has been marked as a duplicate of bug 93202 ***
(In reply to m.a.riosv from comment #3) > Reproducible, the problem occurs by merging the cells vertically, not > horizontally. Whether horizontally or vertically, the behavior is the same. When merging, the cell address that is closer to "Home" (A1) is predominant.