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
<[email protected]> 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
[email protected] [email protected]
"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: [email protected]
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: [email protected]
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
