Results 1 to 8 of 8
  1. #1
    a_gomathi is offline Member
    Join Date
    May 2008
    Posts
    2
    Rep Power
    0

    Default Problem with Excel

    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

  2. #2
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

  3. #3
    a_gomathi is offline Member
    Join Date
    May 2008
    Posts
    2
    Rep Power
    0

    Default

    yes in a java appln excel geenrated using xsl stylesheet

  4. #4
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

    Default

    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.

  5. #5
    Zosden's Avatar
    Zosden is offline Senior Member
    Join Date
    Apr 2008
    Posts
    384
    Rep Power
    7

    Default

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

  6. #6
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

    Default

    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.

  7. #7
    Eku
    Eku is offline Senior Member
    Join Date
    May 2008
    Location
    Makati, Philippines
    Posts
    234
    Rep Power
    7

    Default

    welcome to java-forums matery.
    ^_^ Do we have a thread for Bugs?
    Mind only knows what lies near the heart, it alone sees the depth of the soul.

  8. #8
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

Similar Threads

  1. JSP To EXCEL
    By sureshsri1981 in forum JavaServer Pages (JSP) and JSTL
    Replies: 3
    Last Post: 09-24-2009, 10:12 PM
  2. Excel Column
    By Gajesh Tripathi in forum New To Java
    Replies: 2
    Last Post: 04-13-2008, 02:26 PM
  3. jsp excel
    By lak in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 03-29-2008, 10:53 AM
  4. export to excel
    By diana glz in forum New To Java
    Replies: 0
    Last Post: 03-13-2008, 09:26 PM
  5. ms excel
    By cool_gal in forum New To Java
    Replies: 9
    Last Post: 07-20-2007, 03:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •