To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=71322
User raner changed the following:
What |Old value |New value
================================================================================
Summary|Cells containing zero-leng|Cells containing zero-leng
|th strings are saved a bla|th strings are removed (XL
|nk cells (XLS export) |S export)
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Nov 7 17:08:15 -0800
2006 -------
The problem is actually a little bit different between OpenOffice 1.1.4 and
2.0.4.
When called with the "create" option, the attached Java class will create a test
file, Issue71322.xls. When this file is verified, using the "verify" option of
the class, the output is:
1 | "A1" | "B1"
2 | "" | ""
3 | "" | "B3"
This is the expected output; cells A2, B2, and A3 contain zero-length strings.
When the file is loaded with OpenOffice 1.1.4 and saved again, the result is:
1 | "A1" | "B1"
2 | BLANK | BLANK
3 | BLANK | "B3"
This is pretty much the problem that was reported as issue 50737.
When a new Issue71322.xls file is created again and then loaded and saved with
OpenOffice 2.0.4 the result is:
1 | "A1" | "B1"
2
3 | null | "B3"
Cell A3, which contained the zero-length string, has been removed (it has not
even been replaced with a blank cell; there simply is no cell A3 in that sheet
anymore). Likewise, row 2 has been completely removed.
I changed the wording of the summary line to reflect this new discovery. I
initially assumed that I was dealing with issue 50737 that was still present in
OpenOffice 2.0.4, but apparently the behavior is different.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
