none
Theree is no such floating-point number as zero RRS feed

  • Question

  • While generating XLSX reports i stumbled upon very weird bug in Excel 2010

    How do you think, is 0.000E+0 correct number or not ? OpenXML SDK 2.0 validator thinks it is. What about Excel... it has doubts. If this number is parsed as part of 2002 ExcelXML format, then it is okay. But if it is met in XLSX or ODS files - then it is a no-go. Even if you open that number as string - later you jsut cannot change cell format to numeric.

    Really cryptic bug...

    I wonder while OpenXML SDK 2.0 did not listed this as errata or as comment in validator tool.

    Below are files with the only cell with zero value in it - as string, as integer and aas float. See for yourselves.

    http://www.datafilehost.com/download-7ac958b0.html

    http://www.datafilehost.com/download-cee4661a.html

    http://www.datafilehost.com/download-735b09af.html

    Mirror:

    http://www.bigupload.com/en/file/77092/test-dbl.xlsx.html

    http://www.bigupload.com/en/file/77093/test-int.xlsx.html

    http://www.bigupload.com/en/file/77094/test-str.xlsx.html

    Mirror:

    http://rusfolder.com/34691210

    http://rusfolder.com/34691211

    http://rusfolder.com/34691212

    Friday, January 25, 2013 2:56 PM

All replies

  • can anyone confirm this and perhaps register bug-report in SDK and Office development teams ?

    Maybe Excel 2013 has this fixed ?

    Saturday, January 26, 2013 1:48 PM
  • Hi Arioch,

    Thank you for posting in the MSDN  Forum.

    Could you please provide the code that generates the workbook? It might be helpful for troubleshooting.

    I look forward to your reply.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, January 28, 2013 10:51 AM
    Moderator
  • I really don't think that would help you much, but if you wish...

    https://github.com/the-Arioch/avemey.com/tree/master/zexmlss

    However, i believe that is not the matter of code, that is the matter of whether cell value is encoded right or wrong in the given sample file. No matter who and how generated that.

    And then either SDK Validator and specifications are wrong allowing "exponential zero" format, or Excel parser for XLSX/ODS is wrong crashing on it.

    What about workaround - surely i already implemented it.


    • Edited by Arioch, the Monday, January 28, 2013 3:22 PM
    Monday, January 28, 2013 3:21 PM
  • Hello, guys! can anyone submit bug to Excel teams and add errate to OpenXML SDK docs ?
    Tuesday, February 5, 2013 9:17 AM
  • Hi Arioch,

    Sorry for the late in reply.

    I've download test_str.xlsx file and cannot reproduce

    Even if you open that number as string - later you jsut cannot change cell format to numeric.

    Open that workbook, I can see the below

    After I click Convert to Number, the text will be transform to number format.

    Besides, I've checked the code link in your last reply but I'm not sure which one is the code you've used to generate the workbook with the number inside. Could you please pack the code and upload it to SkyDrive and then share it to me?

    Much appreciate for your time and effort.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, February 21, 2013 8:30 AM
    Moderator