[Libreoffice-bugs] [Bug 140742] New: Copy/paste of row(s) to external programs omit initial empty columns (X11 clipboard)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140742
           Summary: Copy/paste of row(s) to external programs omit initial
                    empty columns (X11 clipboard)
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jim.avera at gmail.com

Description:
When copy/pasting row(s) from an LO spreadsheet into another spreadsheet
application, such as Google Docs or gnumeric, initial columns are omitted if
they are entirely empty.

This problem does not occur if a subset of columns is copied instead of entire
rows.

Comment: Most likely the bug relates to handling the X11 copy/paste/clipboard
protocol which I gather is a bit of a monster.   

Getting this right is important for interoperability with Google Docs.

Steps to Reproduce:
1. Start gnumeric (alternatively, create a Google Docs spreadsheet in a
browser).
2. (in another terminal) Open the attached test.ods in LibreOffice
3. Click in the Row border to select all of Row 1 in LO; Control-C to copy
4. Place cursor in any cell in gnumeric or the Google spreadsheet; control-V to
paste.

Actual Results:
The empty cell A1 in the LO spreadsheet is not copied; the data starting with
B1 are pasted into the other spreadsheet. 

Expected Results:
Empty cells should be preserved when copy-pasting rows.


Reproducible: Always


User Profile Reset: No



Additional Info:
Also try copy-pasting Rows 1 & 2 or all 3 rows together; when copying Rows 1 &
2 are copied column A is not copied (A1 and A2 are empty).  But if all three
rows are copied, then nothing is lost, apparently becuase A3 is not empty.

-- 
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/20210301/e1e34d24/attachment-0001.htm>