If I get it right, HSSF and XSSF reflect the two standards of Excel workbook: "Excel 97" (till Office XP/2003) and "Excel 2007" (Office 2007+). They have different internal layout, number of sheets/columns (SpredsheetVersion contents) etc.
If I want to test POI behavior against Excel, does the file format (.xls/.xlsx) completely define the standard? I.e. is it possible that an .xls file with formulas (let's say the functions are supported in Excel 2003) behaves differently in Excel 2003 and Excel 2007+? In other words, is it safe to test behavior of HSSF/.xls in Office 2007+? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
