In our application we are generating excel sheet using stylesheet.

When I open the application generated excel using textpad, the styles and cell's data can be seen. There are 22 cells.

But, when I open and save the excel without doing any changes using Excel 2003, the format gets changed somehow.

If I open the saved excel using textpad now, there are lesser cells than 22.

After analysis, the reason was identified as "When two consecutive cells are blank in excel, they are colspanned when saved using excel 2003".

Is this a bug in MS excel 2003 or should this be handled in stylesheet used in our application? Is there any way to avoid this?

Can this be avoided using any specific style attribute in stylesheet? I tried searching but could not find a proper solution.

Kindly help me in this regard if you have any idea on this issue.

How is this related to XSLT? I suggest you ask on an Excel forum.

/- Sam Judson : Wrox Technical Editor -/

yes this is related to xslt.

excel is generated using xslt.
So may be some more style attributes need 2 be added..

thats why i placed the post here.

If you know the XML you are trying to generate with your XSLT then tell us what you are trying to generate and how you've tried it so far and whats not working.

If you are asking us to verify details of what XML format Excel accepts then that is outside the realms of this forum.

/- Sam Judson : Wrox Technical Editor -/

ok thanks !!

probably you are talking about
ss:Index="X" attribute,
which can be used in <Row> or <Cell> elements.
Where "X" means for 'Row' number of row, and for 'Cell' - number of column the value to be put.