SpreadsheetML reports and Named cells

Topics: Developer Forum, User Forum
Sep 9, 2008 at 9:03 AM
Edited Sep 9, 2008 at 9:13 AM
I use Smarty and MS Office 2003 XML format to generate reports.

There are 2 tables in report:

It is simple to create totals for each table:
<Cell ss:StyleID="footer_center_USD" ss:Formula="=SUM(R[-{$table1_length}]C:R[-1]C)">
<NamedCell ss:Name="Total1"/>

<Cell ss:StyleID="footer_center_USD" ss:Formula="=SUM(R[-{$table2_length}]C:R[-1]C)">
<NamedCell ss:Name="Total2"/>
$rec_length - length of table.

Now I need to create in report footer calculated cell Sum of total in Table 1 and  Table 2

But here I have problem:

I need to define
  <NamedRange ss:Name="Total1" ss:RefersTo="=Table1!R2C1"/>
  <NamedRange ss:Name="Total2" ss:RefersTo="=Table1!R3C1"/>
with absolute addresses!

How do I solve this problem?