Bug 75907 - Column is showing the wrong width with merged cells
Summary: Column is showing the wrong width with merged cells
Status: RESOLVED DUPLICATE of bug 56105
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.6.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
 
Reported: 2014-03-08 08:35 UTC by sworddragon2
Modified: 2018-09-03 13:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example document (10.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-04-06 20:17 UTC, sworddragon2
Details
screencast showing how to produce the error (with audio) (2.32 MB, video/mp4)
2014-05-26 14:37 UTC, Yousuf Philips (jay) (retired)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description sworddragon2 2014-03-08 08:35:00 UTC
Steps to reproduce:

1. Create a new document.
2. Set the column width of A to 3cm and B to 5cm.
3. Select A1 and B1 and merge the cells.
4. Look at the column width of B.


It will now show you that the column width is 3cm but it should be 5cm.
Comment 1 A (Andy) 2014-03-08 09:26:12 UTC
not reproducible with LO 4.2.1.1 (Win 8.1)
Comment 2 sophie 2014-03-10 14:22:37 UTC
Could not reproduce with Version: 4.2.2.1
Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f Ubuntu 13.10 x64. Because we are 2 who couldn't reproduced, marked as works for me - Sophie
Comment 3 sworddragon2 2014-03-10 20:01:37 UTC
I have tested this now with the upstream version 4.2.1.1 (d7dbbd7842e6a58b0f521599204e827654e1fb8b) and can still reproduce the problem. I have even set LANG to C to go sure its not a localization-related problem. After setting A ro 3cm, B to 5cm, merging A1 and B1 I'm getting for A 1.18" and for B 1.18" too.
Comment 4 Thomas Hackert 2014-04-06 13:23:43 UTC
Hello Sworddragon2, *,
I cannot confirm this with LO Version: 4.2.3.3 Build ID: 6c3586f855673fa6a1576797f575b31ac6fa0ba3 (parallel installed, following the instructions from https://wiki.documentfoundation.org/Installing_in_parallel) nor with LO Version: 4.1.5.3 Build-ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24 (both with installed Germanophone lang- as well as helppack under Debian Testing i686) ... :( What I did:

1. Rightclick on the column header from column A and chose "Column Width..." and set it to "3,00cm"
2. Rightclick on the column header from column B and chose "Column Width..." and set it to "5,00cm"
3. Selected cell A1 and B1 with <Alt>+<ArrowLeft>, but you can mark both columns, as it would be no difference ... ;)
4. "Format – Merge Cells – Merge Cells"

I see the columns A and B merged into one cell/column with a width of the sum of both column width (8cm). And I see, that the column headers A and B are both as before (3cm and 5cm).

Did you do anything different? Or could you attach an ODS file to this bug, so that we can have a look at it, please?
Sorry for the inconvenience
Thomas.
Comment 5 sworddragon2 2014-04-06 20:17:47 UTC
Created attachment 97002 [details]
Example document

In the attachments is an example document created with LibreOffice Calc 4.2.3.2 on a new profile. A is 3cm and B 5cm but on looking at B it shows 3cm (or the related unit dependent on your system).
Comment 6 Jean-Baptiste Faure 2014-05-01 09:15:22 UTC
(In reply to comment #5)
> Created attachment 97002 [details]
> Example document
> 
> In the attachments is an example document created with LibreOffice Calc
> 4.2.3.2 on a new profile. A is 3cm and B 5cm but on looking at B it shows
> 3cm (or the related unit dependent on your system).

On my LO 4.2.5.0.0+ under Ubuntu 14.04 it shows 5 cm for the width of column B.

Best regards. JBF
Comment 7 sworddragon2 2014-05-01 09:48:16 UTC
So its just a reading issue. Does anybody know how to track this more?
Comment 8 Firas Hanife 2014-05-26 12:39:53 UTC
I can reproduce this issue on openSUSE 13.1 with LibreOffice
Version: 4.1.6.2
Build ID: 410m0(Build:2)
and
Version: 4.3.0.0.beta1
Build ID: 2e39c7e59c8fc8b16a54c3d981dceef27fb0c07f

As a consequence I'm changing affected LibreOffice version.
In the following comment I'll link a screencast of the issue.
Comment 9 Firas Hanife 2014-05-26 12:47:40 UTC
This is the screencast of LibreOffice 4.1.6.2
https://www.dropbox.com/s/y2c5vpz9sp5repj/WrongColumnWidth.mp4

(the video quality on Dropbox is bad, download and reproduce, its less than 1 mb, so that you can see correctly Line Width field)
Comment 10 Yousuf Philips (jay) (retired) 2014-05-26 14:37:08 UTC
Created attachment 99874 [details]
screencast showing how to produce the error (with audio)
Comment 11 Yousuf Philips (jay) (retired) 2014-05-26 14:39:24 UTC
check my screencast to reproduce the issue. the screencast is in Linux Mint, but i checked and was able to reproduce it on Win XP.
Comment 12 QA Administrators 2015-06-08 14:43:09 UTC Comment hidden (obsolete)
Comment 13 sworddragon2 2015-06-09 00:00:57 UTC
I'm still able to reproduce this issue with LibreOffice 4.4.3.2 on Linux 3.19.8.
Comment 14 QA Administrators 2016-09-20 10:02:08 UTC Comment hidden (obsolete)
Comment 15 Buovjaga 2018-09-03 13:15:44 UTC

*** This bug has been marked as a duplicate of bug 56105 ***