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.
(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)
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)
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!
I think Clipboardic is fine for the task: http://www.nirsoft.net/utils/clipboardic.html
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.
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.