[Libreoffice-bugs] [Bug 127675] Pasting only 65536 rows to Calc from Excel

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Sep 20 17:12:20 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=127675

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
            Version|6.4.0.0.alpha0+ Master      |Inherited From OOo
             Blocks|103411                      |
                 OS|All                         |Windows (All)
           Keywords|                            |difficultyBeginner,
                   |                            |easyHack, skillCpp

--- Comment #3 from Mike Kaganski <mikekaganski at hotmail.com> ---
Excel (tested with ver.2016) stores these formats to clipboard:

CF_TEXT
CF_BITMAP
CF_METAFILEPICT
CF_SYLK
CF_DIN
CF_UNICODETEXT
CF_ENHMETAFILE
Embed Source
Link Source
Object Descriptor
Link Source Descriptor
HTML Format
Rich Text Format
Hyperlink
Csv
Link
Biff8
Biff5
XML Spreadsheet
Biff12

The Biff8 is what is chosen by Calc when pasting (see
ScViewFunc::PasteFromSystem()). It is a format that is limited to 256 columns
and 65536 rows, hence it can't contain everything that Excel is capable to
store to clipboard (Biff5 has the same constraints). "XML Spreadsheet" format
seems to be the Excel 2003 XML format; and Biff12 is "Excel Binary Workbook"
(.xlsb), which is the format supported by LibreOffice (read-only) and doesn't
have the limitation of the older Biff formats.

The Biff8 clipboard format support was added in commit
https://git.libreoffice.org/core/+/f5412bb121481cf1e48af4d6dc10674bec6c095c.

Adding "easyhack" keyword.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103411
[Bug 103411] [META] Paste from MSO applications bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190920/9c34d210/attachment.html>


More information about the Libreoffice-bugs mailing list