Problem with Excel

[a_gomathi]

Hi all,

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.

Gomathi

[Eranga]

Hi,

Are you talking about a Java application. I'm not sure.

[a_gomathi]

yes in a java appln excel geenrated using xsl stylesheet

[Eranga]

Ok, I don't know about style sheet. But there is no such a bug in Excel, I'm sure that because I've done such a similar application with consecutive cells.

[Zosden]

Did you just say there are no bugs in a microsoft program? That is laughable.

[Eranga]

I don't say that. I just say there is no such a bug in Excel. That's all. If you want you can laugh. But I'm sure that.

[Eku]

welcome to java-forums matery.
^_^ Do we have a thread for Bugs?

[Eranga]

No, we don't have. ;) I think bugs also some exceptions in the way of Java.