Description: See STEPS TO REPRODUCE Steps to Reproduce: 1. Open LibreOffice Calc 2. in Cell A1, type as follows = REPT("a",255) 3. in Cell A2, type as follows = REPT("a",256) 4. Select A1:A2 in Calc 5. Open Excel(I used Excel 2016) 6. Select A1:A2 cell in Excel 7. DO any of the following to reproduce the problem. 7-a. Ctrl + V 7-b. Click the toolbar button with "Paste" as its title 7-c. select context menu item "Paste Special", choose "SYLK" format DONT DO the following. 7-d. Select Paste options like "Keep source formatting" nor "Match destination formatting" in context menu. Actual Results: In Excel A1 will show 255 'a' letters A2 will show nothing Expected Results: In Excel A1 will show 255 'a' letters A2 will show 256 'a' letters Reproducible: Always User Profile Reset: No Additional Info: I guess that SYLK only supports 255 characters as its cell content and that Excel tries to parse data with this type in a strict way. Then, Excel tries not to paste invalid data. User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:55.0) Gecko/20100101 Firefox/55.0
Just a guess: Excel doesn't handle more than 255 characters when importing SYLK format. Calc exports that fine, just save your test to a filename.slk and inspect or try to open with Excel. There's probably nothing we can do.
In Excel 2013, default paste results in nothing appearing in both A1 and A2, but believe this may be a problem with Excel more than its a problem from LibreOffice's side. Excel is choosing the wrong paste option, as many of the other paste special options (DIF, HTML, Unicode Text, Text) all work fine and its 'keep source formatting' and 'match destination formatting' paste options do work fine as well.
I see. Honestly speaking, I was thinking LibreOffice's dropping support for SYLK format in order to avoid confusion on users' side could be an option.