Problem description: If I create a merge of two or more cells horizontally or vertically and then fill down or across from or through these cells, the merge is removed and the fill happens to individual cells. If the merged areas are the same size, filling should work, not erase the 'merge' formatting. Steps to reproduce: 1. Create one or more merged regions 2. Enter some data above or in the merged region 3. Drag the corner of the data cell to drag down or across Current behavior: The merge formatting disappears when the data is filled into the merged cells Expected behavior: If the merged region(s) are a compatible size, the data should be entered and the merge left alone. If this is impossible or overly ambiguous, an error message should be generated. Platform (if different from the browser): Browser: Opera/9.80 (Windows NT 5.1; U; en) Presto/2.10.229 Version/11.61
[Reproducible] with attached Sample and "LibreOffice 3.5.3.2 (RC2) German UI/Locale [Build-ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80] on German WIN7 Home Premium (64bit) In sample in yellow Area the contents of A1:B3 is shown. Steps to reproduce: 1. Select B1:B2 2. Click "Merge Cells" Icon and merge without shifting contents of hidden cell > Double width cell visible with contents "11", no changes in yellow "show contents" area 3. Click B1 4. Fill down using fill handle until B3 Expected: B1,B2,B3 containing 1,2,3, merge remains Actual: As Expected, see H1:H3 5. Click A1 6. Fill down using fill handle until A3 Expected: A1,A2,A3 containing 1,2,3, merge remains Actual: Cell Contents as expected, but merge destroyed I never saw that working in a different way, already the same in OOo 1.1.4 (so "inherited"), but to me the current behavior seems inconsistent. I disagree with proposed solution in AOOo Bugzilla, in example but I simply want to see the same behavior in columns A and B and that merged cells keep merged. But may be there are ODF dependencies or similar?
What is interesting: msExcel 2007 in such situation issues warning: "For this needed that all cells should have equal size" and does nothing.
Reproducible with LO 4.3.2.2 (Win 8.1) Steps Done: 1. Open a new spreadsheet in CALC 2. Type in cell A1 "1" 3. Select cell A2 and A3 and merge them (e. g. via right mouse click -> MERGE CELLS) 4. Go to cell A1 5. Click on the small square in right bottom corner of this cell and move the mouse down over the merged cell A2 and A3 Result: Numbers are filled into the cells, but cell A2 and A3 are no longer merged.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.1 or preferably 5.0.2.2 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-10-14
Still repro. Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+ Build ID: 81fa5340191baf8687f9c82f1f414f5afc86b529 Threads 4; Ver: Windows 6.1; Render: default; TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-12-03_21:19:19 Locale: fi-FI (fi_FI)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
Repro 6.2+
*** Bug 49638 has been marked as a duplicate of this bug. ***
Created attachment 161628 [details] Excel2000,drag copy OK. I reproduced this bug. Excel2000,drag copy OK.
Created attachment 161629 [details] Calc,Drag Copy NG. I reproduced this bug. I can't drag and copy merged cells well in Calc. バージョン: 6.4.4.2 (x64) Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU threads: 4; OS:Windows 10.0 Build 18363; UI render: default; VCL: win; ロケール: ja-JP (ja_JP); UIの言語: ja-JP Calc: CL
just a guess https://opengrok.libreoffice.org/xref/core/sc/source/core/data/table4.cxx?r=175a2063#624
Retested. Repro in Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 5aa74aa1e6fac571f99146ebcb6adc9feb1459ad CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-28_19:35:14 Calc: threaded
Dear Mark C, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still reproduced in recent trunk build: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f95c3994f0b6a82a3bc2ddfb68822b74479ae185 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded For comparison, MS Office 365 gives the following error message when trying to fill down over merged cells: "To do this, all the merged cells need to be the same size"