-
-
Save olivier7121/d4804f52131c6963aa159a197fca069e to your computer and use it in GitHub Desktop.
Excel 2007 XML file for issue with dataValidation (type = "list")_from Excel 2007
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8" standalone="yes"?> | |
| <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension ref="A1:F1"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"/></sheetViews><sheetFormatPr baseColWidth="10" defaultRowHeight="15"/><cols><col min="2" max="2" width="24.42578125" bestFit="1" customWidth="1"/></cols><sheetData><row r="1" spans="1:6"><c r="A1"><v>2017</v></c><c r="B1" s="1" t="str"><f ca="1" xml:space="preserve"> HYPERLINK("#Tab_1!"& CELL("address", INDEX(C1:F1, MATCH(A1, C1:F1, 0))), "Go to the selected column")</f><v>Go to the selected column</v></c><c r="C1"><v>2016</v></c><c r="D1"><v>2017</v></c><c r="E1"><v>2018</v></c><c r="F1"><v>2019</v></c></row></sheetData><dataValidations count="1"><dataValidation type="list" allowBlank="1" showInputMessage="1" showErrorMessage="1" sqref="A1"><formula1>"2016, 2017, 2018, 2019"</formula1></dataValidation></dataValidations><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/><pageSetup paperSize="0" orientation="portrait" horizontalDpi="0" verticalDpi="0" copies="0"/></worksheet> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment