Bug 41610 - Calc FORMATTING: Add functionality "Paste column width"
Summary: Calc FORMATTING: Add functionality "Paste column width"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
: 129016 (view as bug list)
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2011-10-09 05:18 UTC by Jeroen
Modified: 2019-11-25 22:03 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Paste menu in Excel 2010 with "Keep source column width" option (24.64 KB, image/png)
2014-12-01 19:26 UTC, Timur

Note You need to log in before you can comment on or make changes to this bug.
Description Jeroen 2011-10-09 05:18:34 UTC
Problem description: 
Not able to paste the column width

Steps to reproduce:
1. Select e.g. 5 columns on sheet 1
2. Goto sheet 2, select 5 columns and do Paste Special
3. There is no 'Paste column width'. Uncheck 'paste all' and select 'Formatting'. Indeed the column width is adjusted but the formatting of this sheet too; there is no way to just paste the column width as in MS Excel.

Current behavior:
See 'steps to reproduce'.

Expected behavior:
See 'steps to reproduce'.

Platform (if different than the browser): 
Windows, Linux (Ubuntu)         
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.187 Safari/535.1
Comment 1 sasha.libreoffice 2012-04-12 03:02:53 UTC
Thanks for new idea
In 3.5.2 such functionality not implemented yet. Changing status to New
Comment 2 Timur 2014-12-01 19:26:50 UTC
Created attachment 110317 [details]
Paste menu in Excel 2010 with "Keep source column width" option
Comment 3 Timur 2015-04-15 08:48:52 UTC
In addition to an explanation in Comment 0 (cannot paste the column width without formatting), there's another practical problem with this: 
- if we want to copy just some cells (part of the sheet), not entire columns, then we can't paste them with their width at all, and they retain the width of a new sheet.
That may be another issue, but the solution seems the same: to have "Keep source column width" option.
The issue is inherited from OO.
Comment 4 raal 2019-11-25 22:03:16 UTC
*** Bug 129016 has been marked as a duplicate of this bug. ***