Re: [libreoffice-users] Copying a Calc worksheet loses column widths

 Hello Dave
Good day
My experience has been as follows
Let's say we have 2 sheets. 
1. Original (this is the source). Let us say you have contents in this original sheet from cells A1 
to J6. 
2. Then we have a copy sheet - this is the target where you wish to paste
Option (a) : Probably what you want : If you hit Contrl ^ a (meaning select entire "original" sheet 
, including ALL cells, with or without contents, and copy to target sheet, then all column and row 
formatting is copied.
Option (b) : Probably what you got  : if you copy only the content cells, i.e. copy only cells A1 
to J6, and paste in target , then the column and row formatting is NOT copied
For me both options work well based on what I want. 

Note : Copying entire sheet as in Option (a) above does NOT create a bloated multi mega bite target 
sheet, it just copies content & Row + column and some other formatting
Note #2 : I am a windows user & My settings are as followsLibre office version :  25.2.1.2 (x86) / 
LibreOffice Community
Windows 11 X86_64 (10.0 build 22631); 

Best regardsHastham 

    On Monday, March 31, 2025 at 11:16:50 AM GMT+4, Dave Close <dave@compata.com> wrote:  
 
 Running libreoffice-calc-24.8.6.1-1.fc41.x86_64 on Fedora 41.

While using Calc, I want to duplicate (and then modify) a single
worksheet. In the past this worked flawlessly. Now all the data is
copied but the column widths are lost. All columns revert to their
default widths. I can fix this but it is tedious and should not be
necessary. Have I missed a new setting needed to make this work?

FWIW, my copy technique has been (1) create a new, blank worksheet,
(2) select the entire content of the to-be-duplicated worksheet
by selecting the box in the upper-left corner, (3) use ^C on that
worksheet, and (4) use ^V in cell A1 of the new worksheet.

I realize that Calc includes a "duplicate worksheet" function and that
that works correctly, except that it give the new worksheet a name
that does not conform to my expectation. I would prefer to continue
to use my established procedure so I wonder why it no longer works.
-- 
        Dave Close, Compata, Irvine CA      +1 714 434 7359
      dave@compata.com              dhclose@alumni.caltech.edu
  "We consider too much the good luck of the early bird and
  not enough the bad luck of the early worm." -- Franklin Roosevelt



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

  
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy