[Libreoffice-bugs] [Bug 107638] New: Copy & Paste to Excel may not paste contents in clipboard if content' s length >= 256

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu May 4 18:05:35 UTC 2017


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

            Bug ID: 107638
           Summary: Copy & Paste to Excel may not paste contents in
                    clipboard if content's length >= 256
           Product: LibreOffice
           Version: 5.3.3.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: himajin100000 at gmail.com

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

-- 
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/20170504/d607556a/attachment.html>


More information about the Libreoffice-bugs mailing list