[Issue 119504] [From Symphony] Calc offers SYLK clipboard format even when a cell's text is >255 chars long -> can't copy from AOO, paste to excel

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=119504

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|---                         |4.1.13
    Confirmation in|                            |
            Summary|[From Symphony]If word's    |[From Symphony] Calc offers
                   |length in a cell is         |SYLK clipboard format even
                   |>255,can not copy/paste     |when a cell's text is >255
                   |from AOO to excel           |chars long -> can't copy
                   |                            |from AOO, paste to excel
                 CC|                            |damjan@apache.org

--- Comment #1 from damjan@apache.org ---
Also present in 4.1.13, probably all other versions.

If you press F2, and Ctrl+A to select the cell's text, and then Ctrl+C to copy,
it pastes fine in Excel. Only if you Ctrl+C the cell itself, is there a 255
character limit when pasting.

The cause can be determined by Excel's "Paste special", and trying each
different format:

"Text" pastes all 256 characters correctly.
"Unicode Text" pastes all 256 characters correctly.
"HTML" pastes all 256 characters correctly.
"DIF" pastes all 256 characters correctly.
"SYLK" BREAKS, pasting nothing if there are > 255 characters!!!

According to Wikipedia's page:
https://en.wikipedia.org/wiki/Symbolic_Link_(SYLK)

"Each line of a SYLK input file must be no longer than 260 characters.
Otherwise, Microsoft Excel will issue an error message and skip loading the
overlong line."

and

".slk file exports opened with Excel have a limit of 255 characters in a cell."


So the problem is that Calc is offering the SYLK clipboard format to Excel even
for data which cannot be safely transferred using that format.

I wonder why it works when you select the text directly (F2 and Ctrl+A),
possibly it goes through a different code path that is smarter and doesn't
offer SYLK.



Workaround: use Excel's "Paste Special" and paste in a format other than SYLK.

-- 
You are receiving this mail because:
You are the assignee for the issue.