{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Read Me","DStar"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Read Me","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"flags":["formulas_cached_only"]}
["This spreadsheet contains various test cases for the functions: DMIN, DMAX, DSUM"]
["Name of the main junit test class which uses this spreadsheet:"]
["org.apache.poi.ss.formula.functions.TestDStarFunctionsFromSpreadsheet"]
["(The content of cell 'Read Me'!A3 is confirmed by the test)"]
[]
["Every sheet besides this first one contains formula evaluation test cases in a standardised format."]
["On row 4 of each sheet, in columns B,C,D there are the column headings \"Formula\", \"Expected Result\" and \"Comment\""]
["The test iterates down from row 5 onward  until a the text \"<end>\" is found in column A.   Rows with \"<skip>\" in column A are ignored (useful for currently unsupported behaviour).  Otherwise column A can be used for commenting the group of rows below. "]
["If the evaluated result of column B does not match the expected result in column C, the junit test will report a failure.  Test failures get annotated with the section and row comments, if any."]
["Besides the first 4 columns, row 5 onwards, the junit test does not inspect any other cells in the sheet.  The other cells can be used freely to set up test data."]
["Care should be taken to not only make the values in column C match those in column B, but also to make sure column C contains only simple literal values.  This can be achieved easily by 'pasting special' from column B to C, selecting the 'as values' option."]

{"sheet":"DStar","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"flags":["formulas_cached_only"]}
[null,"Sheet Comment:","D* tests",null,null,"database"]
[{"$nulls":5},"name","age","size"]
[null,"Formula","Expected Result","Comment",null,"Huey",8,45]
[{"$nulls":5},"Dewey",7,"fourty-six"]
["DMIN",{"$nulls":4},"Louie",6,47]
[null,6,6,"integerresults",null,"Donald",32,70]
[null,0,0,"no match",null,"Scrooge",62,65]
[null,0,0,"non integer column",null,"Donald",32,70]
[null,45,45,"mixed column"]
[null,47,47,"min without 45"]
[]
["DMAX"]
[null,8,8,"integerresults"]
[null,0,0,"no match"]
[null,0,0,"non integer column"]
[null,47,47,"mixed column"]
[null,65,65,"max without 70"]
["DSUM"]
[null,21,21,"integerresults"]
[null,0,0,"no match"]
[null,0,0,"non integer column"]
[null,92,92,"mixed column"]
[null,64,64,"string equal"]
[null,83,83,"string other than"]
[]
["<end>",{"$nulls":4},"age","age","size","size","size","size"]
[{"$nulls":5},"<10",">100","<50","<50","<>45","<>70"]
[]
[{"$nulls":5},"name","name"]
[{"$nulls":5},"=donald","<>donald"]