NPOI 2.0.6

New features

1. Support Scatter chart in XSSF (xlsx) (other chart types are not supported yet)
2. Extract pictures from Excel (xlsx)
3. XWPF becomes stabler than before
4. Able to support xml:space="preserve" attribute
5. Add mono assembly in the release package
6. file generated by NPOI will contain NPOI tags in custom properties to identify the generator
7. Adjust some XWPF interfaces
8. implement XSSFCell.IsMergedCell
9. IWorkbook implements IList

Sample changes

1. add new samples like BigGridTest, WritePerformanceTest to test performance
2. add ScatterChart to show how to create Scatter chart
3. add LinkedDropDownList for both XSSF and HSSF
4. add MonthlySalaryReport to show how to use formula in XSSF
5. add CreateCustomProperties to show how to use custom props in XSSF and XWPF

Bug fixes

1. fix shift row issue in XSSFSheet
2. fix performance issue due to XmlSerializer. NPOI is getting rid of XmlSerializer.
3. reading/writing CT_Drawing
4. fix ddd pattern issue in CellDateFormatter
5. Change some common interfaces in NPOI.SS
6. fix OutOfMemory issue in MemoryPackagePart
7. Able to read AbsoluteAnchor, OneCellAnchor, TwoCellAnchor in drawing.xml
8. Formula will be calculated automatically after generation
9. improve performance for XSSF while creating new rows For detail, please read https://npoi.codeplex.com/discussions/443655
10. fix name encoding issue of custom properties in HSSF For detail, please read https://npoi.codeplex.com/workitem/12296
11. fix exception in HSSFRows.RemoveAllCells
12. fix CellStyle Hashtable comparison issue in class HSSFCellUtil. This can help prevent over 4000 styles issue from code.
13. Fix globalization issue in ExpandedDouble
14. fix a lot of xml serialization issue for OOXML
15. implement XSSFCell.IsMergedCell
16. IWorkbook implements IList