Description: Pasting only 65536 rows to Calc from Excel possible a problem with selecting of right format for pasting from clipboard in LibreOffice Calc Steps to Reproduce: 1. Open XLSX file from attach 2. Copy cell range A1:A100000 3. Try paste it into Calc => will be paste only 65536 rows instead of all 100000 Actual Results: Pasting only 65536 rows to Calc from Excel Expected Results: Pasting all data from Excel to Calc Reproducible: Always User Profile Reset: No Additional Info: Version: 6.4.0.0.alpha0+ (x64) Build ID: 06925c1230cd6269fa5189ac3f4d608c9edf68e9 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-09-17_00:45:28 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
Created attachment 154330 [details] Example XLSX with 100000 rows with data
Open file from attach in Excel of course =(
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.
So the idea is to add the Biff12 Clipboard format support, which would take precedence over the other two Biff formats on import.
Re-evaluating the EasyHack in 2023 This issue is still relevant. I've tested this with MS Office 2019 and both LO 7.5 and the latest LO 7.6 dev master, and the problem is still there: Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 32; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_DE); UI: en-US Calc: threaded Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 23bd3bd10e74b0c23c2654d02d7d830e7693adac CPU threads: 32; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_DE); UI: en-US Calc: threaded
*** Bug 87843 has been marked as a duplicate of this bug. ***
I don't have Excel on my machine, but I can open the file using Excel in the browser (Edge on Win10). Copying and pasting this way goes through a different path than Biff8; specifically, it goes through the HTML_SIMPLE path and somehow this also manages to fail and the text that is pasted into the cell is "The selection you're trying to copy and paste is too large. Select a smaller set of data and try again.". So, is this different path a different bug, or should that also be fixed with this bug?
(In reply to Matt K from comment #7) This is different, and needs an own report and fix. Thanks for looking!
(In reply to Mike Kaganski from comment #8) > (In reply to Matt K from comment #7) > > This is different, and needs an own report and fix. Thanks for looking! Filed Bug 156214 for that