Description: In the appended test file some lines are concatenated in column B and identical in column A. Automatic filling of cells in Column A changes these cocatenation in Clumn Achanges previously made cell concatenations. Steps to Reproduce: 1.Mark the first three cells in column A 2.fill the remaining cells in column A by dragging the small square down the column Actual Results: The concatenation of the cells in column A has been altered Expected Results: Filled column with unchanged concatenations in column A Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 177931 [details] Small Testfile
I tried to reproduce the bug reported by the user in both Version: 7.2.5.2 (x86) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 5c138ac6a8334825ef171ac6291b66b277eb4288 Steps followed 1. Merged some cells in column A and similar cells in Column B as well. 2. Updated first few values in Column A 3. I dragged the auto fill in 2 ways. 3A. Dragged the auto fill from the last value in column A 3B Dragged the auto fill by selecting all the values in column A My inference By following the first approach (3A)the format of the selected cell was applied to all the cells values updated by auto fill. So some of the cells merged by user was un merged. Using 3B when I selected all the cells that had similar formatting as the cells below, when I did Autofill the value got updated as expected and formatting or merge was not affected. Can the team confirm whether it is a valid bug?
Created attachment 177949 [details] Auto fill from 1st value
Created attachment 177950 [details] Auto fill from last value
Earlier the merged state of the cells was not taken into account at all. This changed with https://git.libreoffice.org/core/commit/1ed04c2029218619aab2f3422130c890f67f309c tdf#40993 tdf#59585 sc fill: copy merged cell structure László: any thoughts on this? The reporter wants to preserve the "configuration" of merged target cells.
I'm unable to reproduce the same behavior in Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded or Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded