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 360666 - Dependencies not taken into account when exporting via clippboard
Dependencies not taken into account when exporting via clippboard
Status: RESOLVED DUPLICATE of bug 360849
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2006-10-08 15:27 UTC by Jon Kåre Hellan
Modified: 2010-12-01 06:58 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Jon Kåre Hellan 2006-10-08 15:27:10 UTC
Enter the following:
A1: 1
A2: 2
A3: =A1+A2

Mark A2:A3 and select Edit/Copy.
The clipboard now contains the formula, but one of the dependencies is missing.
The application/x-gnumeric target is rendered as:

<gnm:ClipboardRange>
  ..
  <gnm:Cells>
    <gnm:Cell Col=\"0\" Row=\"2\" ExprID=\"1\">=A1+A2</gnm:Cell>
    <gnm:Cell Col=\"0\" Row=\"1\" ValueType=\"40\">2</gnm:Cell>
  </gnm:Cells>
</gnm:ClipboardRange>

In this situation, OpenCalc replaces formulas with unselected dependencies with constants. This is a sensible solution. The example above would become

A2: 2
A3: 3

The more complex 
source:

A1: 1
A2: 2
A3: =A1+A2
A4: 4
A5: =A3+A4

with A2:A5 copied to clipboard, would give

A2: 2
A3: 3           <-- converted to constant
A4: 4
A5: =A3+A4      <-- still a formula
Comment 1 Jon Kåre Hellan 2006-10-09 08:13:22 UTC
See also 360849
Comment 2 Jon Kåre Hellan 2006-10-10 08:07:03 UTC
Excel copies all cells as values. More about Excel 2003 clipboard behaviour in bug 360849, comment #1.
Comment 3 Andreas J. Guelzow 2010-12-01 06:58:37 UTC
This in fact talks about possibility (c) in bug 360849. It should really be considered in the context of bug 360849.

*** This bug has been marked as a duplicate of bug 360849 ***