Public bug reported:
Copying and pasting of formulas in Gnumeric does not work properly. If
a cell with formula is copied, and an attempt is made to paste it down a
column, the formula is not copied, only the _value_ of the formula from
the original cell. This behavior is seen with C-c, C-p, and with mouse-
menu copy/paste. If the cell's lower-right corner 'marker' is pulled
with the mouse, the formula WILL copy correctly down the column.
If an area of data, including formulas, is copied, from INSIDE Gnumeric,
and an attempt is made to copy it elsewhere in the same spreadsheet, the
data may not copy, OR the Text Import Configuration dialog appears,
asking for choices about tab-delimited, columns, formatting as number or
text, and so on, before data will paste, and the formulas will NOT copy,
only the values of those formulas at the original locations. Cell
formatting does not appear to be preserved in the copy, even inside the
same spreadsheet. Data highlighted and copied from, for example, an
outside text file does not always paste into Gnumeric correctly.
The data, and formulas, along with their formatting, should just copy to
the new location, as is, and without extra dialog boxes, with formula
references changing to the new relative positions, as spreadsheets have
done for decades.
This bug seems to be substantially the same as that I filed for
OpenOffice, bug #433211 (also filed at OpenOffice itself as Issue
105211). I was unable to test copy-pasting in KSpread because of bug
#434976.
The bugs with the spreadsheets seem to me to be part of a larger Ubuntu and/or
Gnome clipboard function problem that seemed to first appear in some form in
Ubuntu 9.04, when highlighting and middle-mouse-button-pasting stopped working
reliably, and which may be what led to these bug reports:
klipper bug 433222
glipper bugs #216155 and #432906
and also to:
gnumeric on 9.04, bug #379051 (but bug happens for _any_ size data, not just
large)
Fresh install of Ubuntu 9.10 alpha 5, 64-bit, upgraded to packages of
alpha 6 a week or so later.
gnumeric:
Installed: 1.9.9-1ubuntu2
Candidate: 1.9.9-1ubuntu2
Version table:
*** 1.9.9-1ubuntu2 0
500 http://us.archive.ubuntu.com karmic/main Packages
100 /var/lib/dpkg/status
gnome:
Installed: (none)
Candidate: 1:2.22.2~4ubuntu7
Version table:
1:2.22.2~4ubuntu7 0
500 http://us.archive.ubuntu.com karmic/universe Packages
** Affects: gnumeric (Ubuntu)
Importance: Undecided
Status: New
--
Gnumeric copy-paste broken
https://bugs.launchpad.net/bugs/434990
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
