Issue 89747 - String Truncated when copy - paste complete cell from Excel
Summary: String Truncated when copy - paste complete cell from Excel
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp, oooqa
Depends on:
Reported: 2008-05-21 16:18 UTC by maathieu
Modified: 2013-12-12 06:27 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

You can use the attached spreadsheet to experience the bug. (76.00 KB, application/
2008-05-21 16:19 UTC, maathieu
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description maathieu 2008-05-21 16:18:46 UTC

I found a nasty bug while pasting simple cells from Excel 2007, to Calc.

It appears that if the Excel cell contains more than 255 characters, the excess
characters are stripped off when the Excel cell is pasted into Calc.

Conversely, when a Calc cell is pasted into Excel 2007, if it is more than 255
characters long it will paste a blank cell.

It's quite easy to reproduce :
- Create an excel spreadhseet with a single cell that contains a sentence longer
than 255 characters,
- open it with Excel 2007,
- copy the cell, 
- paste it into Calc
- see how it gets trimmed off.
Comment 1 maathieu 2008-05-21 16:19:56 UTC
Created attachment 53822 [details]
You can use the attached spreadsheet to experience the bug.
Comment 2 Regina Henschel 2008-05-21 17:23:11 UTC
I cannot confirm it. I get all characters, when I copy the cell from Excel2007
to Calc, using OOo3.0Beta on WinXP.
Comment 3 maathieu 2008-05-21 22:40:26 UTC
I'm using the 2.4.0 release. I didn't test with 3.0.

Well, if it's corrected in the new version, I'm all happy... :)
Comment 4 jm38706415 2008-07-08 08:02:34 UTC
Hi maathieu,

It's OK too when I copied the cells to Dev_DEV300_m21_winXP Chinese.
Comment 5 Edwin Sharp 2013-09-23 12:58:53 UTC
Cell A10 is truncated from 512 to 255 characters.

Excel 2007, Calc Rev. 1525015 Win 7
Comment 6 Rainer Bielefeld 2013-12-12 06:27:34 UTC
 Reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions:

0. From AOO Start center open blank new Spreadsheet
1. Open Sample Document with MS Excel Viewer
2. Click A9
   > Celll cursor arouncd A9
3. <control+c> for copy
4. Click into Blank new Calc spreadsheet A1
5. <Control+v> for Paste
   Bug: Last character "V" is missing                                 :-(
6. Click A10
   > Celll cursor arouncd A10
7. <control+c> for copy
8. Click into Blank new Calc spreadsheet A2
9. <Control+v> for Paste
   Bug: Identical contents as in step 5 (instead of twice as much     :-(

Additional Info:
(a) Copy / Paste to EditPad Lite document without truncation
(b) Copy / Paste to Writer Lite document without truncation
(c) In Step 5 or 9 no data loss with menu 'Edit -> Paste Special -> Unformatted 
    Text', also no data loss when paste as RTF
(d) I see the same truncation when I copy / paste to 
(d1) SoftMaker FreeOffice
(d2) Gnumeric
(d3) LibO 4.1.3
(e) Not reproducible with
(e1) Calligra (Always unformatted text?) 
(f) Works fine when I paste in cell edit mode (after <f2>)
(g) currently I am not sure whether this is an OO bug. Might be 
    something very special with Excel cell contents clipboard formatting in
(h) Does that work with excel? And if yes, why do (as it seems) all other
    spreadsheet programs fail?