none
Bad XLSX file RRS feed

Answers

  • Dave, 

    If you look at the sheet1.xml, you'll see that it has a column specified that has a max less than the min. Comment that out and it should open in Excel just fine. Here's the piece in question with the commented bad <col>: 

      <dimension ref="A16"/>
      <cols>
        <col min="1" max="1" width="27.22265625"/>
        <!-- <col min="2" max="1" width="12.7109375" customWidth="1"/> -->
        <col min="2" max="2" width="27.22265625"/>
        <col min="3" max="3" width="27.22265625"/>
    


    When opening in Excel the first time, you should get this error: 

    

    This points you to the columns issue. 

    Hope this helps you. 

    Tom

    • Marked as answer by DavidThi808 Thursday, November 14, 2019 12:42 PM
    Thursday, November 14, 2019 7:57 AM
    Moderator

All replies

  • Hi Dave,

    Thank you for your inquiry about Microsoft open specifications. We have created an incident for investigating this issue. One of the Open specifications team member will contact you shortly.

    Regards,
    Sreekanth Nadendla
    Microsoft Windows Open Specifications

    Wednesday, November 13, 2019 2:04 AM
    Moderator
  • Hi Dave, 

    I'll take a look, is there anything in particular that this document exercises in the file format? Anything to focus on? 

    Best regards,
    Tom Jebo
    Sr Escalation Engineer
    Microsoft Open Specifications


    Thursday, November 14, 2019 7:27 AM
    Moderator
  • Dave, 

    If you look at the sheet1.xml, you'll see that it has a column specified that has a max less than the min. Comment that out and it should open in Excel just fine. Here's the piece in question with the commented bad <col>: 

      <dimension ref="A16"/>
      <cols>
        <col min="1" max="1" width="27.22265625"/>
        <!-- <col min="2" max="1" width="12.7109375" customWidth="1"/> -->
        <col min="2" max="2" width="27.22265625"/>
        <col min="3" max="3" width="27.22265625"/>
    


    When opening in Excel the first time, you should get this error: 

    

    This points you to the columns issue. 

    Hope this helps you. 

    Tom

    • Marked as answer by DavidThi808 Thursday, November 14, 2019 12:42 PM
    Thursday, November 14, 2019 7:57 AM
    Moderator
  • Thursday, November 14, 2019 12:42 PM