111301 – Calc: Text in cell is truncated when file is reopened

Issue 111301 - Calc: Text in cell is truncated when file is reopened

Summary: Calc: Text in cell is truncated when file is reopened

Status:	CONFIRMED

Alias:	None

Product:	Calc
Classification:	Application
Component:	save-export (show other issues)
Version:	3.4.1
Hardware:	PC Linux, all

Importance:	P3 Normal with 1 vote (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:	zhaoshzh

URL:
Keywords:

Depends on:
Blocks:

Reported:	2010-05-01 04:18 UTC by richardm_oo
Modified:	2014-03-28 00:56 UTC (History)
CC List:	3 users (show)

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

Attachments
File that experiences the text cell truncation problem (6.50 KB, application/vnd.ms-excel) 2010-05-01 04:19 UTC, richardm_oo	no flags	Details
spreadsheet for example (9.59 KB, application/x-vnd.oasis.opendocument.spreadsheet) 2013-11-18 19:02 UTC, Edwin Sharp	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

Description richardm_oo 2010-05-01 04:18:15 UTC

In a spreadsheet, I enter text in a cell.  The cell has been formatted to "Wrap
text automatically".  I've probably entered about 300 characters.  I press enter
and see all of the text I typed in the cell: so far, it looks correct.  Do the
same in a few other cells.  Save.  Close the spreadsheet.  Now reopen it.  The
text in the cell has been truncated.  I counted the number of characters in one
of the truncated cells, and it looks like it was chopped off at 255 characters.

This problem sounds similar to Issue 14338 (closed as "WorksForMe").

I use the version of OpenOffice that came with my SuSE Linux installation, which
is (from the About box):
   OpenOffice.org 3.1.1
   OOO310m21 (Build:9319)
   ... "created by Novell"...
   Build 3.1.1.4
(note: this version was not a choice in the "Found in version" selector above)

As a check, I downloaded the latest OpenOffice and found I could reproduce the
problem there as well.  The About box for that version says:
   OpenOffice.org 3.2.0
   OOO320m12 (Build:9483)
   ... "created by Sun Microsystems"...

More gory details about machine specifics:
OS: Linux 2.6.31.12-0.2-desktop i686
    openSUSE 11.2 (i586)
KDE:  4.3.5 (KDE 4.3.5) "release 0"
CPU:  Intel(R) Core(TM)2 Duo CPU E7600 @ 3.06GHz

Comment 1 richardm_oo 2010-05-01 04:19:59 UTC

Created attachment 69215 [details]
File that experiences the text cell truncation problem

Comment 2 richardm_oo 2010-05-01 04:22:02 UTC

Other relevant information: I save the file as "Microsoft Excel 97/2000/XP (.xls)".

The attached spreadsheet experiences the problem.  To reproduce, edit one of the
long text cells to add a few words.  Save, close, and reopen to see that the
text has been truncated.

Comment 3 Edwin Sharp 2013-11-18 18:59:26 UTC

Confirmed with
AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian

Comment 4 Edwin Sharp 2013-11-18 19:02:23 UTC

Created attachment 81951 [details]
spreadsheet for example

look at cell C1 - it should have 300 characters.

Comment 5 zhaoshzh 2014-03-26 02:45:52 UTC

defect found before 4.1,so change the version