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 305405 - Pasting from excel doesn't work
Pasting from excel doesn't work
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
1.5.x
Other Windows
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-05-25 08:28 UTC by j.gnome
Modified: 2005-05-28 04:15 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
test file (2.68 KB, application/octet-stream)
2005-05-25 08:31 UTC, j.gnome
Details
sample dump (44.40 KB, application/octet-stream)
2005-05-27 18:54 UTC, Ivan Wong
Details
sample dump 2 (35.75 KB, application/octet-stream)
2005-05-27 18:55 UTC, Ivan Wong
Details

Description j.gnome 2005-05-25 08:28:53 UTC
Pasting from Excel (or OpenOffice.org) used to somewhat work in 1.4.x: it lost
all formatting and pasted as tab delimited text.

I kind of like the fact that 1.5.x doesn't ignore the formatting, but it only
seems to paste a bitmap and not the actual cell contents.

I used the ClipBook viewer (C:\WINDOWS\system32\clipbrd.exe on Windows XP) to
examine the clipboard contents, and it looks like Gnumeric is getting the
"Bitmap" or "DIB Bitmap" stuff.

The console says this while pasting:
load_inc
load_inc
load_inc
load_inc
Comment 1 j.gnome 2005-05-25 08:31:33 UTC
Created attachment 46864 [details]
test file

This is what I see after pasting.
Comment 2 Morten Welinder 2005-05-25 15:06:27 UTC
No idea about this one, nor do I see any code that can output "load_inc".
(That might be a debug statement in Ivan's tree, though.)

Ivan?  Jon Kaare?
Comment 3 Ivan Wong 2005-05-27 17:54:02 UTC
Reasons:

- our bmp writing and image copy/paste patches have been committed recently.
- gnumeric supports image copy/paste recently
- the priority of image is higher than that of text when requesting selection 
targets
- Excel registers these formats when it copies:

UTF8_STRING
DataObject
Biff8
Biff5
Biff4
Biff3
Biff
Wk1
XML Spreadsheet
HTML Format
Csv
Hyperlink
Rich Text Format
Embed Source
Native
OwnerLink
Object Descriptor
Link Source
Link Source Descriptor
Link
ObjectLink
Ole Private Data
image/bmp (by gtk+/win32, when CF_DIB is there)
Comment 4 Ivan Wong 2005-05-27 18:54:20 UTC
Created attachment 46963 [details]
sample dump

From Microsoft Office\Office10\Samples\SAMPLES.XLS, sheet "Chart Labeling"
Comment 5 Ivan Wong 2005-05-27 18:55:20 UTC
Created attachment 46964 [details]
sample dump 2

From Microsoft Office\Office10\Samples\SOLVSAMP.XLS, sheet "Engineering Design"
Comment 6 Jody Goldberg 2005-05-28 04:15:53 UTC
fixed.
1.5.2 will now accept rich content from MS Excel, including charts.