public void TestPopulateNew() { XSSFWorkbook wb = new XSSFWorkbook(); StylesTable st = wb.GetStylesSource(); Assert.IsNotNull(st.GetCTStylesheet()); Assert.AreEqual(1, st.GetXfsSize()); Assert.AreEqual(1, st.GetStyleXfsSize()); Assert.AreEqual(0, st.GetNumberFormatSize()); int nf1 = st.PutNumberFormat("yyyy-mm-dd"); int nf2 = st.PutNumberFormat("yyyy-mm-DD"); Assert.AreEqual(nf1, st.PutNumberFormat("yyyy-mm-dd")); st.PutStyle(new XSSFCellStyle(st)); // Save and re-load st = ((XSSFWorkbook)XSSFTestDataSamples.WriteOutAndReadBack(wb)).GetStylesSource(); Assert.IsNotNull(st.GetCTStylesheet()); Assert.AreEqual(2, st.GetXfsSize()); Assert.AreEqual(1, st.GetStyleXfsSize()); Assert.AreEqual(2, st.GetNumberFormatSize()); Assert.AreEqual("yyyy-mm-dd", st.GetNumberFormatAt(nf1)); Assert.AreEqual(nf1, st.PutNumberFormat("yyyy-mm-dd")); Assert.AreEqual(nf2, st.PutNumberFormat("yyyy-mm-DD")); }