Invalid NumberFormat in XML

Jeff Woehler

unread,

Nov 22, 2002, 8:52:57 AM11/22/02

to

I've discovered a discrepancy betweeen Microsoft Excel
2002 and the Office Web Component for Excel.

Summary:
| Excel 2002 | OWC
------------|--------------------|-------------------
Does Write | with " | like original
------------|--------------------|-------------------
Can Read | both | without "
------------|--------------------|-------------------

Detail:

The problem deals with the Currency or Accounting
NumberFormat. If an Excel 2002 Workbook containing the
Accounting Style is saved in XML format, it saves the
Style as such:
---------------------------------------
<ss:NumberFormat
ss:Format="_("$"* #,##0.00_);_
("$"* $#,##0.00$;_("$"* "-
"??_);_(@_)"/>
---------------------------------------

When this same section of XML is read into the OWC, an
error message is displayed: "The document is not a well-
formed XML file." And then promptly displays a blank
Excel workbook.

However, when the " escapes are removed from the
Style so that the NumberFormat looks like:
---------------------------------------
<ss:NumberFormat
ss:Format="_($* #,##0.00_);_($* $#,##0.00$;_($* -??
_);_(@_)"/>
---------------------------------------
then the OWC is able to read the Excel XML file without
any problems. (Excel 2002 is also able to read this
modified XML file.)

Finally, by copying and pasting into the OWC from Excel
2002, the WB displays correctly. However when you save
the output of the XMLData property from the OWC and
attempt to redisplay the data in the OWC, it produces the
error above.

Please respond with the current status of this problem.
Is there an update I am not aware of? Something that will
allow us to use Excel 2002 and the OWC without having to
manually "fix" the XML file.

Thanks for the help,
Jeff Woehler
jew...@kimball.com

J.E. McGimpsey

unread,

Nov 22, 2002, 10:02:20 AM11/22/02

to

You should post this to either
micorosoft.public.office.developer.web.components,
microsoft.public.excel.misc or to microsoft.public.xml (probably the
former). Since this is a Macintosh-oriented newsgroup, there's likely to be
more expertise with web components there.

On 11/22/2002 06:52, in article
1079201c2922e$769ff2e0$8af82ecf@TK2MSFTNGXA03, "Jeff Woehler"

Jeff Woehler

unread,

Nov 22, 2002, 10:08:44 AM11/22/02

to

I appologize. I missed the "mac" at the beginning.
Jeff

>-----Original Message-----
>You should post this to either
>micorosoft.public.office.developer.web.components,
>microsoft.public.excel.misc or to microsoft.public.xml
(probably the
>former). Since this is a Macintosh-oriented newsgroup,
there's likely to be
>more expertise with web components there.
>
>
>
>
>
>On 11/22/2002 06:52, in article
>1079201c2922e$769ff2e0$8af82ecf@TK2MSFTNGXA03, "Jeff
Woehler"
><jew...@kimball.com> wrote:
>
>> I've discovered a discrepancy betweeen Microsoft Excel
>> 2002 and the Office Web Component for Excel.
>>
>> Summary:
>> | Excel 2002 | OWC
>> ------------|--------------------|-------------------

>> Does Write | with " | like original

>> ------------|--------------------|-------------------
>> Can Read | both | without "

>> ------------|--------------------|-------------------
>>
>> Detail:
>>
>> The problem deals with the Currency or Accounting
>> NumberFormat. If an Excel 2002 Workbook containing the
>> Accounting Style is saved in XML format, it saves the
>> Style as such:
>> ---------------------------------------
>> <ss:NumberFormat

>> ss:Format="_("$"* #,##0.00_);_
>> ("$"* $#,##0.00$;_("$"* "-
>> "??_);_(@_)"/>
>> ---------------------------------------
>>

>> When this same section of XML is read into the OWC, an
>> error message is displayed: "The document is not a
well-
>> formed XML file." And then promptly displays a blank
>> Excel workbook.
>>

>> However, when the " escapes are removed from the

>> Style so that the NumberFormat looks like:
>> ---------------------------------------
>> <ss:NumberFormat
>> ss:Format="_($* #,##0.00_);_($* $#,##0.00$;_($* -??
>> _);_(@_)"/>
>> ---------------------------------------
>> then the OWC is able to read the Excel XML file without
>> any problems. (Excel 2002 is also able to read this
>> modified XML file.)
>>
>> Finally, by copying and pasting into the OWC from Excel
>> 2002, the WB displays correctly. However when you save
>> the output of the XMLData property from the OWC and
>> attempt to redisplay the data in the OWC, it produces
the
>> error above.
>>
>> Please respond with the current status of this problem.
>> Is there an update I am not aware of? Something that
will
>> allow us to use Excel 2002 and the OWC without having to
>> manually "fix" the XML file.
>>
>> Thanks for the help,
>> Jeff Woehler
>> jew...@kimball.com
>>
>>
>

>.
>

J.E. McGimpsey

unread,

Nov 22, 2002, 10:21:07 AM11/22/02

to

Happens!

On 11/22/2002 08:08, in article
109ed01c29239$0c843fa0$8af82ecf@TK2MSFTNGXA03, "Jeff Woehler"