Issue 28223 - Excel XML export transformation - Calculation
Summary: Excel XML export transformation - Calculation
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 680
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: svante.schubert
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, rfe_eval_ok
Depends on:
Blocks: 28207
  Show dependency tree
 
Reported: 2004-04-22 10:15 UTC by niklas.nebel
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description niklas.nebel 2004-04-22 10:15:29 UTC
*** autogenerated child task for Issue 28207 ***
Comment 1 niklas.nebel 2004-04-22 10:29:13 UTC
Calculation settings that are saved with the document
Comment 2 svante.schubert 2004-04-27 14:07:19 UTC
Detailed information can be found under "OpenOffice.org XML File Format 1.0, 
Chapter 4.3 Calculation Settings, Page 240 
http://xml.openoffice.org/xml_specification.pdf

The import filter does support (only) the following, therefore due to time
constraints only that will be supported for the export:

<xsl:element name="table:calculation-settings">
	<xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:PrecisionAsDisplayed">
		<xsl:attribute name="table:precision-as-shown">true</xsl:attribute>
	</xsl:if>
	<xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:Date1904">
		<table:null-date table:date-value="1904-01-01"/>
	</xsl:if>
	<xsl:element name="table:iteration">
		<xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:Iteration">
			<xsl:attribute name="table:status">enable</xsl:attribute>
		</xsl:if>
		<xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:MaxIterations">
			<xsl:attribute name="table:steps"><xsl:value-of
select="/ss:Workbook/x:ExcelWorkbook/x:MaxIterations"/></xsl:attribute>
		</xsl:if>
		<xsl:if test="/ss:Workbook/x:ExcelWorkbook/x:MaxChange">
			<xsl:attribute name="table:maximum-difference"><xsl:value-of
select="/ss:Workbook/x:ExcelWorkbook/x:MaxChange"/></xsl:attribute>
		</xsl:if>
	</xsl:element>
</xsl:element>


Comment 3 svante.schubert 2004-05-13 17:47:58 UTC
Removed this from the first CWS, due to lower priority.
Comment 4 svante.schubert 2004-07-29 12:39:54 UTC
Set to OOoLater until target have been reconsidered for all Excel features.
Comment 5 erwin.tenhumberg 2004-10-26 16:09:02 UTC
set keywords according to RFE process
Comment 6 svante.schubert 2005-11-14 16:01:38 UTC
Due to the upcoming new XML Office 12 Microsoft format, the earlier Microsoft
spreadsheetml format is deprecated. Due to heavy workload no further time will
be spend on developing the filter of this deprecated format.
Comment 7 svante.schubert 2005-11-14 17:27:18 UTC
closed