Hi,
I have a have a excel file in XML format. In the first cell I want to
have a exact formula not a reference formula, meaning instead of
formula="=RC[1]+R[1]C[2]" I want it to be formula="=A1+B1". Is there
anybody how can help me in this case?

Here is the file. You just need to save it as xml and open it with the
excel.
<?xml version="1.0"?
<?mso-application progid="Excel.Sheet"?
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40"
<Styles
<Style ss:ID="Default" ss:Name="Normal"
</Style
</Styles
<Worksheet ss:Name="Sheet1"
<Table
<Row
<Cell ss:Formula="=RC[1]+R[1]C[2]"
</Cell
</Row
</Table
</Worksheet
</Workbook


--
m_karbala
------------------------------------------------------------------------
m_karbala's Profile: http://www.excelforum.com/member.php...o&userid=27555
View this thread: http://www.excelforum.com/showthread...hreadid=507287