Bug 89173 - CLIPBOARD: add support of Excel 2003 XML (aka XMLSS) format
Summary: CLIPBOARD: add support of Excel 2003 XML (aka XMLSS) format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste MSO-XML2003
  Show dependency treegraph
 
Reported: 2015-02-06 14:26 UTC by dg
Modified: 2023-10-05 07:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Excel cell XML data from clipboard (755 bytes, text/plain)
2016-04-29 14:31 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description dg 2015-02-06 14:26:51 UTC
Calc supports XMLSS for file open/save. Please add support of XMLSS for clipboard copy/paste operations as well.

Background: XMLSS is quite a useful format for applications that need data exchange with Excel. Implementing the requested feature would allow to use these applications with Calc with minimum of adaptation.
Comment 1 Robinson Tryon (qubit) 2015-02-08 12:52:13 UTC
(In reply to dg from comment #0)
> Calc supports XMLSS for file open/save. Please add support of XMLSS for
> clipboard copy/paste operations as well.
> 
> Background: XMLSS is quite a useful format for applications that need data
> exchange with Excel. Implementing the requested feature would allow to use
> these applications with Calc with minimum of adaptation.

Hi dg,
Sounds like an interesting idea for enhancement. I assume that this is a Windows-only feature?

Please provide a set of reproduction steps that can be used to test whether XMLSS support exists (and is working correctly) in LibreOffice.

Status -> NEEDINFO

(please change the status back to UNCONFIRMED after you provide the repro steps)
Comment 2 dg 2015-02-08 13:15:38 UTC
hi
(In reply to Robinson Tryon (qubit) from comment #1)
> I assume that this is a Windows-only feature?
I suppose yes, but not sure, because I'm not familiar with LibreOffice export/import and clipboard support on other platforms.

> Please provide a set of reproduction steps that can be used to test whether
> XMLSS support exists (and is working correctly) in LibreOffice.
Reproducing is easy:
1) select some cells in Calc, then Copy them to the clipboard => the clipboatd should contain 'XML Spreadsheet' format data among other formats (this can be seen by clipboard viewers or e.g. in Excel's Paste Special dialog);
2) select some cells in Excel, then Copy to the clipboard => Calc's Paste Special dialog should have 'XML Spreadsheet' format among other items and the program should be able to paste the data.

(BTW, the same could be done for other formats and for other apps in the Office, but this is out of this particular case task)
Comment 3 Joel Madero 2015-10-17 16:57:55 UTC
Hi Dg-

First thanks so much for your patience as to us moving this forward.

Now, I've taken a bit of time to try to confirm that this is the case and I'm just not seeing it. I followed your steps (copied calc cells, went to Excel 2010, paste special) but I don't see anything pertaining to XML Spreadsheet, what I see (I literally copied 4 cells with 1,2,3,4 in them respectively):

Picture (PNG);
Picture (Enhanced metafile);
Bitmap
SYLK
DIF
HTML
Unicode Text
Text

That's it. I see different options when I reverse the order (copy from excel, paste to calc):

GDI Metafile
Biff8;
Biff5;
DIF
HTML format
Unformatted Text
RTF
Microsoft Excel Worksheet
DDE Link

Can you tell me if there's something there that I'm looking for? Or is there a clipboard viewer that you know of that is free, without spyware, that I can download to see what you see?

Marking as NEEDINFO (I know sorry!), once you clarify a bit please mark as UNCONFIRMED. Thanks!
Comment 4 mahfiaz 2016-04-19 07:36:14 UTC
I think Clipboardic is fine for the task:
http://www.nirsoft.net/utils/clipboardic.html
Comment 5 Buovjaga 2016-04-29 14:31:01 UTC
Created attachment 124729 [details]
Excel cell XML data from clipboard

I couldn't get Clipboardic to give me the data, but InsideClipboard by Nirsoft worked (remember to click refresh).

From MSO 2013.
Comment 6 Mike Kaganski 2023-10-05 07:29:12 UTC
This does not describe a *specific* scenario that could be used to *see* the problem. Comment 2 told that "Calc's Paste Special dialog should have 'XML Spreadsheet' format among other items" when pasting from Excel, but didn't address later comments 3,5 - so there's no info if Excel really exports that format, so we could already have reproducible paste scenario. Then we need a reproducible scenario in a different direction - such that some specific external application allows to test the imagined clipboard content from Calc.

And we also need a justification for this: what is *impossible* today, which would be enabled by supporting such a niche clipboard format.