after entering a correct spreadsheet into OOo with simple cross-sheet
references (actually, ANY cell references), OOo outputs as Excel 2003 XML the
following incorrect A1 format:



<Row ss:Height="12.8376">
<Cell ss:StyleID="Normal" ss:Formula="of:=['this sheet name has
spaces'.A1]"><Data ss:Type="Number">1</Data></Cell>
<Cell ss:StyleID="Normal" ss:Formula="of:=[Sheet1.A1]"><Data
ss:Type="Number">1</Data></Cell>
</Row>
<Row ss:Height="12.8376"><Cell ss:Index="2" ss:StyleID="Normal"/></Row>

MS Excel outputs the following for the same spreadsheet:

   <Row>
    <Cell ss:Formula="='this sheet name has spaces'!RC"><Data
ss:Type="Number">1</Data></Cell>
    <Cell ss:Formula="=Sheet1!RC[-1]"><Data ss:Type="Number">1</Data></Cell>
   </Row>


The RC format Excel uses allows the format 
'Sheet name'!R1C1 for sheet names with spaces if you are doing cross-sheet
references and want an absolute cell reference, 
or, 
SheetName!R1C1 if you are doing a sheet name without spaces and want an absolute
cell reference,
or,
R1C1 if you are referencing the same sheet and want an absolute cell reference.

The R1C1 absolute format is really handy for those who are doing the coding,
because everything is indexed with numbers.  and Excel 2003 Accepts it just
fine, I tested the format.  usually what you see coming OUT of Excel is pretty
weird for RC addressing.  I don't know if that format is documented anywhere or
not as a standard.

example: R12305C121