| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <html> |
| |
| <head> |
| <title>Spreadsheet Project - Filter Test Documents</title> |
| <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> |
| <meta name="author" content="Daniel Rentz"> |
| <style type="text/css"> |
| th.le, td.le { padding-top:1px; padding-bottom:1px; padding-left:10px; padding-right:10px; text-align:left; } |
| td.ce { padding-top:1px; padding-bottom:1px; padding-left:10px; padding-right:10px; text-align:center; } |
| </style> |
| </head> |
| |
| <body> |
| <h1>Spreadsheet Project - Filter Test Documents</h1> |
| |
| <h2>Spreadsheet File Formats Overview</h2> |
| <table> |
| <tr><th class="le">File Format</th><th class="le">Extensions</th><th class="le">Note</th><th class="le">Created with</th></tr> |
| <tr><td class="le">BIFF2</td><td class="le">.xls</td><td class="le">Binary format used by MS Excel 2.x</td><td class="le">MS Excel 3.0a German</td></tr> |
| <tr><td class="le">BIFF3</td><td class="le">.xls</td><td class="le">Binary format used by MS Excel 3.0</td><td class="le">MS Excel 3.0a German</td></tr> |
| <tr><td class="le">BIFF4</td><td class="le">.xls</td><td class="le">Binary format for worksheets used by MS Excel 4.0</td><td class="le">MS Excel 4.0 German</td></tr> |
| <tr><td class="le">BIFF4W</td><td class="le">.xlw</td><td class="le">Binary format for workbooks used by MS Excel 4.0</td><td class="le">MS Excel 4.0 German</td></tr> |
| <tr><td class="le">BIFF5</td><td class="le">.xls</td><td class="le">Binary format used by MS Excel 5.0 and 95</td><td class="le">MS Excel 95 (MS Excel 7.0)</td></tr> |
| <tr><td class="le">BIFF8<sub>(11)</sub></td><td class="le">.xls</td><td class="le">Binary format used by MS Excel 97, 2000, XP, and 2003</td><td class="le">MS Excel 2003 (MS Excel 11.0)</td></tr> |
| <tr><td class="le">BIFF12<sub>(11)</sub></td><td class="le">.xlsb</td><td class="le">Binary format written by the XML plugin of MS Excel 2003</td><td class="le">MS Excel 2003 (MS Excel 11.0)</td></tr> |
| <tr><td class="le">XML<sub>(11)</sub></td><td class="le">.xlsx, .xlsm</td><td class="le">XML format written by the XML plugin of MS Excel 2003</td><td class="le">MS Excel 2003 (MS Excel 11.0)</td></tr> |
| <tr><td class="le">BIFF8<sub>(12)</sub></td><td class="le">.xls</td><td class="le">BIFF8 binary format written by MS Excel 2007</td><td class="le">MS Excel 2007 (MS Excel 12.0)</td></tr> |
| <tr><td class="le">BIFF12<sub>(12)</sub></td><td class="le">.xlsb</td><td class="le">Binary format used by MS Excel 2007</td><td class="le">MS Excel 2007 (MS Excel 12.0)</td></tr> |
| <tr><td class="le">XML<sub>(12)</sub></td><td class="le">.xlsx, .xlsm</td><td class="le">XML format used by MS Excel 2007</td><td class="le">MS Excel 2007 (MS Excel 12.0)</td></tr> |
| </table> |
| |
| <h2>Spreadsheet Test Documents</h2> |
| <table> |
| <tr><th class="le" colspan="12">Cell Contents</th></tr> |
| <tr><td class="le" colspan="12">These documents contain basic cell contents (numbers, texts, error codes, formulas).</td></tr> |
| <tr> |
| <td class="ce"><a href="cells_import_biff2.xls">BIFF2</a></td> |
| <td class="ce"><a href="cells_import_biff3.xls">BIFF3</a></td> |
| <td class="ce"><a href="cells_import_biff4.xls">BIFF4</a></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="cells_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="cells_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="cells_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="cells_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="cells_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="cells_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="cells_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain cells with data validation settings.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="datavalidation_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="datavalidation_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="datavalidation_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="datavalidation_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="datavalidation_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="datavalidation_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Cell Formatting</th></tr> |
| <tr><td class="le" colspan="12">These documents contain formatted cells and cell styles.</td></tr> |
| <tr> |
| <td class="ce"><a href="cellformat_import_biff2.xls">BIFF2</a></td> |
| <td class="ce"><a href="cellformat_import_biff3.xls">BIFF3</a></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="cellformat_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="cellformat_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="cellformat_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="cellformat_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="cellformat_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="cellformat_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="cellformat_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="cellformat_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain all available built-in number formats.</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="numberformat_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain cells with conditional formatting.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="condformat_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="condformat_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="condformat_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="condformat_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="condformat_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="condformat_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Formulas, Functions, Defined Names</th></tr> |
| <tr><td class="le" colspan="12">These documents contain formulas (cell formulas, array formulas, shared formulas, table operations, functions).</td></tr> |
| <tr> |
| <td class="ce"><a href="formula_import_biff2.xls">BIFF2</a></td> |
| <td class="ce"><a href="formula_import_biff3.xls">BIFF3</a></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="formula_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="formula_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="formula_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="formula_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="formula_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="formula_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formula_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formula_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formula_export_specials.ods">ODS</a></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain defined names (local and global names, built-in names).</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce">n/a</td> |
| <td class="ce"></td> |
| <td class="ce"><a href="definedname_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="definedname_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="definedname_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="definedname_import_xml_11.xlsm">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="definedname_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="definedname_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="definedname_import_xml_12.xlsm">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain tests for specific sheet functions.</td></tr> |
| <tr> |
| <td class="le" colspan="4">- CONVERT_ADD</td> |
| <td class="ce"></td> |
| <td class="ce"><a href="addin_convert_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">External Links, Hyperlinks</th></tr> |
| <tr><td class="le" colspan="12">The target documents for external links and hyperlinks: <a href="external/targets.zip">targets.zip</a> (contains a _README.TXT file)</td></tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain formula links to external documents.</td></tr> |
| <tr> |
| <td class="ce"><a href="external/externallink_import_biff2.xls">BIFF2</a></td> |
| <td class="ce"><a href="external/externallink_import_biff3.xls">BIFF3</a></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="external/externallink_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="external/externallink_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="external/externallink_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="external/externallink_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="external/externallink_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="external/externallink_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="external/externallink_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="external/externallink_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain hyperlinks.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="external/hyperlink_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="external/hyperlink_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="external/hyperlink_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="external/hyperlink_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="external/hyperlink_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="external/hyperlink_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Document Settings</th></tr> |
| <tr><td class="le" colspan="12">These documents are write-protected with the password "Password".</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="writeprotection_import_biff3.xls">BIFF3</a></td> |
| <td class="ce"><a href="writeprotection_import_biff4.xls">BIFF4</a></td> |
| <td class="ce"><a href="writeprotection_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="writeprotection_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="writeprotection_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="writeprotection_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="writeprotection_import_xml_11.xlsm">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="writeprotection_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="writeprotection_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="writeprotection_import_xml_12.xlsm">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Sheet Types and Settings</th></tr> |
| <tr><td class="le" colspan="12">These documents contain different types of sheets (worksheets, chart sheets, macro sheets, ...).</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="sheettypes_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="sheettypes_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="sheettypes_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="sheettypes_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="sheettypes_import_xml_11.xlsm">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="sheettypes_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="sheettypes_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="sheettypes_import_xml_12.xlsm">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><td class="le" colspan="12">These documents contain page and print settings on different sheets.</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce">n/a</td> |
| <td class="ce"></td> |
| <td class="ce"><a href="pagesettings_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="pagesettings_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pagesettings_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pagesettings_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pagesettings_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pagesettings_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pagesettings_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain view settings on different sheets.</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce">n/a</td> |
| <td class="ce"></td> |
| <td class="ce"><a href="viewsettings_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="viewsettings_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="viewsettings_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="viewsettings_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="viewsettings_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="viewsettings_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="viewsettings_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain protection settings on different sheets.</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="sheetprotection_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="sheetprotection_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="sheetprotection_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="sheetprotection_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="sheetprotection_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="sheetprotection_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="sheetprotection_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Filters, scenarios</th></tr> |
| <tr><td class="le" colspan="12">These documents contain autofilters and advanced filters.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="autofilter_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="autofilter_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="autofilter_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain scenarios (what-if analysis).</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="scenarios_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="scenarios_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="scenarios_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="scenarios_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="scenarios_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="scenarios_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Pivot Tables</th></tr> |
| <tr><td class="le" colspan="12">The target documents for pivot tables with external data source: <a href="pivot/pivottargets.zip">pivottargets.zip</a></td></tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain pivot tables based on various source data.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_datasource_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain pivot tables with different layouts.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_layout_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12"></th></tr> |
| <tr><td class="le" colspan="12">These documents contain pivot tables with field grouping settings.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="pivot/pivottable_grouping_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Drawing Layer</th></tr> |
| <tr><td class="le" colspan="12">These documents contain various drawing objects.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="drawing_import_biff3.xls">BIFF3</a></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="drawing_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="drawing_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="drawing_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce"><a href="drawing_import_biff12_11.xlsb">BIFF12</a><sub>(11)</sub></td> |
| <td class="ce"><a href="drawing_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="drawing_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="drawing_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="drawing_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><td class="le" colspan="12">These documents contain cell notes (comments).</td></tr> |
| <tr> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="cellnotes_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="cellnotes_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="cellnotes_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><td class="le" colspan="12">These documents contain picture links and externally linked objects (OLE objects).</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="external/oleobject_import_biff3.xls">BIFF3</a></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="external/oleobject_import_biff4.xlw">BIFF4W</a></td> |
| <td class="ce"><a href="external/oleobject_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="external/oleobject_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="external/oleobject_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="external/oleobject_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><td class="le" colspan="12">These documents contain form controls embedded in sheets.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="formcontrols_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="formcontrols_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formcontrols_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formcontrols_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><td class="le" colspan="12">These documents contain form controls with embedded bitmaps and mouse pointer settings.</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="formcontrols_bitmaps_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formcontrols_bitmaps_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formcontrols_bitmaps_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><td class="le" colspan="12">These documents contain legacy form controls (BIFF3/BIFF4 buttons are contained in drawing layer test documents).</td></tr> |
| <tr> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce">n/a</td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"></td> |
| <td class="ce"><a href="formcontrols_legacy_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formcontrols_legacy_import_biff12_12.xlsb">BIFF12</a><sub>(12)</sub></td> |
| <td class="ce"><a href="formcontrols_legacy_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Chart Types</th></tr> |
| <tr><td class="le" colspan="12">These documents contain samples of different chart types.</td></tr> |
| <tr> |
| <td class="le" colspan="4">- Bar/column charts</td> |
| <td class="ce"><a href="chart/chart_charttype_bar_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_bar_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_bar_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_bar_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_bar_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Area charts</td> |
| <td class="ce"><a href="chart/chart_charttype_area_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_area_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_area_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_area_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_area_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Line/stock charts</td> |
| <td class="ce"><a href="chart/chart_charttype_line_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_line_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_line_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_line_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_line_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Scatter/bubble charts</td> |
| <td class="ce"><a href="chart/chart_charttype_scatter_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_scatter_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_scatter_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_scatter_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_scatter_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Radar charts</td> |
| <td class="ce"><a href="chart/chart_charttype_radar_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_radar_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_radar_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_radar_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_radar_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Pie/doughnut charts</td> |
| <td class="ce"><a href="chart/chart_charttype_pie_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_pie_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_pie_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_pie_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_pie_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Surface charts</td> |
| <td class="ce"><a href="chart/chart_charttype_surface_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_charttype_surface_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_surface_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_charttype_surface_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_charttype_surface_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr><th class="le" colspan="12">Chart Settings and Formatting</th></tr> |
| <tr><td class="le" colspan="12">These documents contain charts with various changed chart elements.</td></tr> |
| <tr> |
| <td class="le" colspan="4">- Data series, labels</td> |
| <td class="ce"><a href="chart/chart_series_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_series_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_series_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_series_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_series_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Axis formatting, gridlines</td> |
| <td class="ce"><a href="chart/chart_axis_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_axis_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_axis_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_axis_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_axis_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Axis scaling settings</td> |
| <td class="ce"><a href="chart/chart_axis_scaling_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_axis_scaling_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_axis_scaling_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_axis_scaling_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_axis_scaling_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Title, axis titles, legend</td> |
| <td class="ce"><a href="chart/chart_title_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_title_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_title_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_title_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_title_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Missing and hidden points</td> |
| <td class="ce"><a href="chart/chart_sourcedata_missing_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_sourcedata_missing_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_sourcedata_missing_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_sourcedata_missing_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_sourcedata_missing_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- 3D view settings</td> |
| <td class="ce"><a href="chart/chart_3dsettings_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_3dsettings_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_3dsettings_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_3dsettings_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_3dsettings_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Styles and formatting</td> |
| <td class="ce"><a href="chart/chart_formatting_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_formatting_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_formatting_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_formatting_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_formatting_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Bitmap fill formatting</td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_bitmaps_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_bitmaps_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_bitmaps_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_bitmaps_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Object positioning</td> |
| <td class="ce"></td> |
| <td class="ce"><a href="chart/chart_positioning_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_positioning_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_positioning_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_positioning_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| <tr> |
| <td class="le" colspan="4">- Embedded drawing shapes</td> |
| <td class="ce"><a href="chart/chart_embeddedshapes_import_biff5.xls">BIFF5</a></td> |
| <td class="ce"><a href="chart/chart_embeddedshapes_import_biff8_11.xls">BIFF8</a><sub>(11)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_embeddedshapes_import_xml_11.xlsx">XML</a><sub>(11)</sub></td> |
| <td class="ce"><a href="chart/chart_embeddedshapes_import_biff8_12.xls">BIFF8</a><sub>(12)</sub></td> |
| <td class="ce">n/a</td> |
| <td class="ce"><a href="chart/chart_embeddedshapes_import_xml_12.xlsx">XML</a><sub>(12)</sub></td> |
| <td class="ce"></td> |
| </tr> |
| </table> |
| </body> |
| |
| </html> |
| |
