Anyone has any idea about XF: Extended Format (E0h) record ?

Hey John,

Thanks for the response. Yes, that's what I thought it should be.
but it seems not correct in my situation.

I have two simple excel files.
the first cell of the the first row of both excel files are using
the same number format Number/(1,234.00) no color.

for the first file. the Cell->XFIndex is :24
XF[24]->FormatIndex is: 187
for the second file. the Cell->XFIndex is :23
XF[23]->FormatIndex is: 184

I noticed that 187/184 is greater than 163, does that means the format
is user defined ? but as you see above, I am using a standard format.

any idea about what's happening there ?

Thanks so much,

Tim



"John McNamara" <jmcnamara RemoveThis @cpan.org> wrote in message
news:mkr4b0hsal775nf3qqbfuegpq0vhm3i157@4ax.com...
 > On Sun, 23 May 2004 20:58:30 -0700, "KongHu" wrote:
 >
  > >Every cell keep a XF index point to the XF table, you can get the format
  > >ID from the XF table, but I am trying this method against several excel
  > >file, I found the same format(for example 12,345.00) map to different
  > >format ID, in my case it's 176/179, anyone has any idea about how to
  > >get the format information of the cell ?
 >
 >
 > An XF (0xE0) record contains formatting information which, in relation
 > to Excel's "Format Cells" dialog, corresponds to the Alignment,
 > Border, Patterns and Protection tabs.
 >
 > It also contains references to two other BIFF records: FONT (0x31) and
 > FORMAT (0x1E). These correspond to the Font and Number tabs in the
 > "Format Cells" dialog.
 >
 > Thus two cells with the same number format but different border styles
 > will have different XF ids but should have the same XF->FORMAT ids.
 >
<font color=purple> > See also: <a style='text-decoration: underline;' href="http://sc.openoffice.org/excelfileformat.pdf</font" target="_blank">http://sc.openoffice.org/excelfileformat.pdf</font</a>>
 >
 > John.
 > --
 ><!-- ~MESSAGE_AFTER~ -->

On Mon, 24 May 2004 22:34:32 -0700, "KongHu" wrote:

 >I have two simple excel files.
 >the first cell of the the first row of both excel files are using
 >the same number format Number/(1,234.00) no color.
 >
 >for the first file. the Cell->XFIndex is :24
 > XF[24]->FormatIndex is: 187
 >for the second file. the Cell->XFIndex is :23
 > XF[23]->FormatIndex is: 184

If you start with two new files and add the same number format to each
one then you will get the same index numbers.

However, if exactly the same formatting hasn't been applied to each
workbook in the same sequence then the index numbers will be
different. It isn't the case that "1,234.00" will always map to the
same index (unless it is one of the special default internal formats
that isn't stored as a string).

 >I noticed that 187/184 is greater than 163, does that means the format
 >is user defined ? but as you see above, I am using a standard format.

That is correct. User defined number formats start from 0xA4 (164).

You may also find some useful information here:

<a style='text-decoration: underline;' href="http://chicago.sourceforge.net/devel/docs/excel/" target="_blank">http://chicago.sourceforge.net/devel/docs/excel/</a>

<a style='text-decoration: underline;' href="http://search.cpan.org/dist/Spreadsheet-ParseExcel/" target="_blank">http://search.cpan.org/dist/Spreadsheet-ParseExcel/</a>

John.
--<!-- ~MESSAGE_AFTER~ -->