Yes it's a problem with zeros. But the question is...Why when I open the XML as DataTable the Zeros are shown normally??? Now if I open with the XSLT, Excel format that field as a number field when it is a Text Field :(
It's really I weird. Thanks any way for your suggestion Aji. --- In [email protected], Aji Sarosa <[EMAIL PROTECTED]> wrote: > > Hi, > > It seems like you are facing leading zeros problem. Please check the > following links for further suggestions: > > http://support.microsoft.com/kb/214233 > http://support.microsoft.com/kb/81518 > http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=146 > > I hope your file will look more beautiful :) > > Regards, > Aji Sarosa > > tavocol2002 wrote: > > > > Hi. > > > > A few weeks ago i started to use XML to generate massive data, because > > the > > use of COM Excel was too slow. Now i'm generating the same data result > > 10 > > times faster than COM Excel. > > > > The Question :D > > > > I'm generating an XML file trough AX, i have the XSD and XSLT to > > visualize > > the file in a beauty way :D > > > > I have one STRING field into the XML with a value of 000123432. > > When i open the file on Internet Explorer the file looks really good and > > use > > my custom XSLT file. > > > > The problem is that the client wants to see it through Excel 2007. > > > > When i open the XML on Excel the first thing that Excel does, is to ask > > me > > if i want to use my XSLT file. I choose YES and the data is shown on the > > grid > > but the field 000123432 now appears as 123432. > > > > If i open the XML file without the XSLT on Excel it shows me the XML as > > dataTable, with this option the field is shown as 000123432 but all the > > style > > is lost. > > > > Anybody knowns a good solution for this question. > > > > My head looks like a puzzle, i've seen every forum in spanish and some > > in > > english but i can not find an answer. > > > > Thank you very much from COLOMBIA :D > > COLOMBIA IS ME. > > NO MORE DEATH > > NO MORE KIDNAPPINGS > > NO MORE "FARC" > > > > Gustavo Adolfo Camargo Téllez > > Microsoft Dynamics AX Senior Developer > > MDO Consultores S.A.- www.mdo.com.co > > Bogota D.C. - Colombia (South America) > > > > [Non-text portions of this message have been removed] > > > > >
