Bug 41610

Summary: Calc FORMATTING: Add functionality "Paste column width"
Product: LibreOffice Reporter: Jeroen <08gr10>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: brucehohl, director84, sasha.libreoffice, timur
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard: BSA
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 102593    
Attachments: Paste menu in Excel 2010 with "Keep source column width" option

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. ***