[sc-issues] [Issue 72827] Line-breaks are not export ed to Excel2003 XML

[sus]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72827


User sus changed the following:

                What    |Old value                 |New value
================================================================================
                Keywords|                          |needhelp
--------------------------------------------------------------------------------




------- Additional comments from [EMAIL PROTECTED] Wed Jan 17 12:21:09 -0800 
2007 -------
Hi Jogurt!

I take a look into it and I can give at some additional information on this bug,
if somebody is able to fix it, following beyond. But unfortunately I have got
many many other tasks with higher priorities I won't spend further time on it.
Sorry, but you have to find yourself someone else who is able to fix this and
upcoming spreadsheetml issues, unless they are very severe.

Therefore I added the keyword 'needhelp'


Here the information I found out: 

In ODF we have this:
<table:table-cell office:value-type="string">
   <text:p>A</text:p>
   <text:p>b</text:p>
</table:table-cell>

In the spreadsheetml we have following:
<Cell ss:StyleID="s21"><Data ss:Type="String">A&#10;b</Data></Cell>

We might add a string '&#10;' everytime the element ahead is a text:p, but this
will be changed to a real caridge return in the output.

In the XSLT this would be:

        <!-- ******************** -->
        <!-- *** Common Rules *** -->
        <!-- ******************** -->

<xsl:template match="*">
 <xsl:param name="cellStyleName" />

<!-- LineBreak in Cell -->
 <xsl:if 
test="preceding-sibling::text:p[1]"><xsl:text>&#10;</xsl:text></xsl:if> 
 <xsl:call-template name="style-and-contents">
   <xsl:with-param name="cellStyleName" select="$cellStyleName" />
  </xsl:call-template>
</xsl:template>


Best regards,
Svante

---------------------------------------------------------------------
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]