Apache OpenOffice (AOO) Bugzilla – Issue 89747
String Truncated when copy - paste complete cell from Excel
Last modified: 2013-12-12 06:27:34 UTC
Hi, 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.
Created attachment 53822 [details] You can use the attached spreadsheet to experience the bug.
I cannot confirm it. I get all characters, when I copy the cell from Excel2007 to Calc, using OOo3.0Beta on WinXP.
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... :)
Hi maathieu, It's OK too when I copied the cells to Dev_DEV300_m21_winXP Chinese.
Cell A10 is truncated from 512 to 255 characters. Excel 2007, Calc Rev. 1525015 Win 7
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 :-( characters 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 Excel? (h) Does that work with excel? And if yes, why do (as it seems) all other spreadsheet programs fail?