Issue 51689 - Extra characters inserted in cells during export to xhtml
Summary: Extra characters inserted in cells during export to xhtml
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 680m122
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-07-07 18:02 UTC by mlf2
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
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 mlf2 2005-07-07 18:02:46 UTC 
Two extra characters (\xC2\xA0) are inserted into each cell's value during
export to xhtml.

Start with a new spreadsheet.  Enter "Test1" in cell A1.  Export to xhtml.  Now
look at the .xhtml file in a hex editor.  Note the two characters starting at
550 below. (your address may vary)

00000540: 6566 6175 6c74 223e 3c70 3e54 6573 7431  efault"><p>Test1
00000550: c2a0 3c2f 703e 3c2f 7464 3e3c 2f74 723e  ..</p></td></tr>
Comment 1 mlf2 2005-07-07 18:13:55 UTC 
openoffice.org1.9.113 
Running on Fedora Core 2
Comment 2 frank 2005-07-18 14:48:21 UTC 
Hi Swante,

seems to be yours.

Frank
Comment 3 frank 2005-07-18 14:48:45 UTC 
Hi Swante,

seems to be yours.

Frank
Comment 4 mlf2 2005-07-26 19:09:42 UTC 
Also present in 1.9.118.
Comment 5 svante.schubert 2005-08-08 17:38:40 UTC 
BACKGROUND:

Empty paragraph do not provoke a carridge return. To enforce this behavior a
non-breakable space (i.e &nbsp; or &#160;) have been added (i.e.
<xsl:text>&#160;</xsl:text>) to an 'empty' paragraph.

FIX:
Unfortunately the condition to check for empty paragraph in xhtml/body.xsl was
erroneous 
<xsl:when test="*">
test only for all paragraphs without child elements it have to be exchanged (2
times) to
<xsl:when test="* or text()">

Many thanks for pointing this out!