none
about customWorkbookView RRS feed

  • Question

  • Hi dear all,

    Look at the following is my workbook definition

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
     <fileVersion appName="chrome" lastEdited="5" lowestEdited="5" rupBuild="9302"/>
     <workbookPr date1904="true" defaultThemeVersion="124226"/>
     <bookViews>
      <workbookView xWindow="120" yWindow="45" windowWidth="19155" windowHeight="4935"/>
     </bookViews>
     <sheets>
      <sheet name="WorkSheet1" sheetId="1" r:id="rId1"/>
     </sheets>
     <calcPr calcId="144525"/>
     <customWorkbookViews>
      <customWorkbookView name="test" guid="{7C124235-B2D3-437C-85AB-98A2392A388F}" activeSheetId="1" showFormulaBar="false"/>
     </customWorkbookViews>
    </workbook>

    My question is the customWorkbookView element will be reported error in Office 2010 , but I can verify it correctly in XML SDK productivity tools . How did this happen ? Many thanks!


    nice done!

    Sunday, October 7, 2012 3:52 AM

Answers

  • Hi yushang,

    I found the problem with your ooxml_msdn.xlsx file.  Your customWorkbookView element was missing two required attributes: windowHeight and windowWidth.  When I added those, Excel was able to open it without error.  Here's the updated workbook.xml:

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
        <sheets>
            <sheet name="Demo" sheetId="1" r:id="rId1"/>
        </sheets>
        <customWorkbookViews>
            <customWorkbookView name="test" guid="{7C124235-B2D3-437C-85AB-98A2392A388F}" activeSheetId="1" showFormulaBar="false" windowWidth="100" windowHeight="200"/>
        </customWorkbookViews>
    </workbook>

    The entries for these attributes in 18.2.3  "customWorkbookView (Custom Workbook View)" doesn't explicitly say they are required, however, the schema in A.2  "SpreadsheetML" accurately specifies them as required.

    Thanks,

    Tom

    Wednesday, October 17, 2012 4:58 AM
    Moderator

All replies

  • Hi yushang,

    Thanks for your question.

    Someone from our team will get in touch with you shortly.

    Thanks and regards,

    Sebastian


    SEBASTIAN CANEVARI - MSFT Escalation Engineer Protocol Documentation Team

    Sunday, October 7, 2012 2:55 PM
  • Hi yushang,

    I'll look into this and get back to you.  Two questions:

    1) can you please send the xlsx file to dochelp at Microsoft dot com and reference the URL for this thread and my name?

    2) what did you use to create this file?

    Best regards,
    Tom Jebo
    Escalation Engineer
    Microsoft Open Specifications

    Tuesday, October 9, 2012 6:19 PM
    Moderator
  • Hi,

    I've sent you the file ooxml_msdn.xlsx , the subject is to Tom Jebo . I created this file with notepad. Many thanks!


    nice done!


    • Edited by yushang Wednesday, October 10, 2012 2:36 PM
    Wednesday, October 10, 2012 2:35 PM
  • Hi yushang,

    I found the problem with your ooxml_msdn.xlsx file.  Your customWorkbookView element was missing two required attributes: windowHeight and windowWidth.  When I added those, Excel was able to open it without error.  Here's the updated workbook.xml:

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
        <sheets>
            <sheet name="Demo" sheetId="1" r:id="rId1"/>
        </sheets>
        <customWorkbookViews>
            <customWorkbookView name="test" guid="{7C124235-B2D3-437C-85AB-98A2392A388F}" activeSheetId="1" showFormulaBar="false" windowWidth="100" windowHeight="200"/>
        </customWorkbookViews>
    </workbook>

    The entries for these attributes in 18.2.3  "customWorkbookView (Custom Workbook View)" doesn't explicitly say they are required, however, the schema in A.2  "SpreadsheetML" accurately specifies them as required.

    Thanks,

    Tom

    Wednesday, October 17, 2012 4:58 AM
    Moderator
  • Yes . It is! Many thanks!

    nice done!

    Wednesday, October 17, 2012 6:54 AM