Issue 28223

Summary: Excel XML export transformation - Calculation
Product: Calc Reporter: niklas.nebel
Component: save-exportAssignee: svante.schubert
Status: CLOSED WONT_FIX QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: 680Keywords: ms_interoperability, rfe_eval_ok
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 28207    

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