Bug 107638 - Copy & Paste to Excel in SYLK format may not paste contents in clipboard if content's length >= 256
Summary: Copy & Paste to Excel in SYLK format may not paste contents in clipboard if c...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2017-05-04 18:05 UTC by himajin100000
Modified: 2019-09-19 17:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description himajin100000 2017-05-04 18:05:35 UTC

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
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
Comment 1 Eike Rathke 2017-05-04 20:21:13 UTC
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.
Comment 2 Yousuf Philips (jay) (retired) 2017-05-04 20:25:01 UTC
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.
Comment 3 himajin100000 2017-05-04 23:32:54 UTC
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.