Jarodtweiss

Hello All,

I'm generating an Office XML file to generate an Excel file. After I apply an XSL to downgrade the XML to generate a file compatible to Excel 2000 and Excel 97.

I have check in the "Office 2000 HTML Reference" to see how I should generate my header and footer and I have found for example the following constants:

- &L : for the left footer part

- &R : for the right footer part

- &N : for the total number of pages

When I use that, it's working good - I have done the test in Excel 2000 (EN) and Excel 2007(FR).

However I have also done the test in Excel 2003 (FR) and this is totally wrong. For this version, I should have used:

- &E : for the left footer part

- &D : for the right footer part (corresponding to Date for "Office 2000 HTML Reference")

- &T : for the total number of pages (corresponding to Time for "Office 2000 HTML Reference")

It seems that Excel 2003 has internationalized its storage format but this is very weird as Excel 2000 and Excel 2007 didn't.


Can you help me with that

Thanks !