After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 121722 - pasting doesn't adjust column width or height when appropriate
pasting doesn't adjust column width or height when appropriate
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
1.1.x
Other Linux
: Normal enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 684198 777918 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2003-09-08 00:18 UTC by Don Armstrong
Modified: 2018-04-24 13:36 UTC
See Also:
GNOME target: ---
GNOME version: Unversioned Enhancement



Description Don Armstrong 2003-09-08 00:18:06 UTC
When you are pasting a full sheet, full column or full row into a new
sheet, empty column, or empty row, the column widths and or row heights are
not adjusted as appropriate.

That is, they should ideally be identical to the source of the paste.
Comment 1 Andreas J. Guelzow 2003-09-08 05:16:51 UTC
What do you mean with `empty column'? Is a column without content but
with formats empty?
Comment 2 Don Armstrong 2003-09-08 05:30:32 UTC
regarding whether or not this is an enancement, I assumed that the
pasting should have handled this formatting bug. But then again, I
didn't write the code, so I'm not totally sure about it.

Regarding emptyness, as far as the feature goes, it shouldn't matter
if the column was formatted, contained content, or was devoid of both.
Pasting a full column or row or sheet should (ideally) make the new
copy of the full column or row or sheet exactly identical. It now does
this, escept for column width or row heights.
Comment 3 Andreas J. Guelzow 2003-09-08 13:50:14 UTC
I guess you see pasting a complete column as different as pasting a
large number of cells. 

We are currently pasting all the cells in that column (or row or
sheet), so the formatting preserved is the format of all of those
cells. THe column width is a property of the column.

I am not sure we really want to see different behaviour based on
whetehr we are pasting 65535 cells or 65536 cells of the same column.
In the former cas e we are not justified to change the column width.

Comment 4 Andreas J. Guelzow 2012-09-17 13:30:00 UTC
*** Bug 684198 has been marked as a duplicate of this bug. ***
Comment 5 Technical Support 2016-12-06 06:39:34 UTC
Feature still appears to be missing. In LibreOffice Calc, OpenOffice Calc and Excel, option to include "Column widths" is in "Paste Special" dialog.

Best approximation in Gnumeric is to copy and paste selection, then choose "Auto Fit Width" and/or "Auto Fit Height." One drawback to this solution is that columns that start too narrow have to be adjusted repeatedly as longer entries are added.

The ability to copy column widths (and row heights) allows a set of columns (and rows) to be set up once, then copied across spreadsheet as needed.

A more versatile capability would be stylesheets - allowing formatting to be changed throughout a spreadsheet or several spreadsheets at once.

Gnumeric 1.12.32
Comment 6 Morten Welinder 2018-04-24 01:03:22 UTC
*** Bug 777918 has been marked as a duplicate of this bug. ***
Comment 7 Morten Welinder 2018-04-24 01:14:09 UTC
I think we have all the pieces to do this.  The internal clipboard
actually collects the information and it gets shipped inter-process
via xml.

Specifically, it would make sense to copy column width when the selection
covers the full columns and copy row height when selection the full rows.
Both for whole sheet.

Paste-special would need an option to do either.

Yes, it's mildly inconsistent between 65535 rows and a full column, but
it's more a difference between selecting a full column (by clicking on the
column header) and selecting a large range which may or may not be the
full column.  And we don't track that difference and probably never will.

In any case, paste-special is there for when the default isn't desired.
Comment 8 Morten Welinder 2018-04-24 13:36:51 UTC
A little more work than expected, but done.

This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.