Esempio n. 1
0
        /**
         * Get a <b>copy</b> of the currently used CT_Fill, if none is used, return a new instance.
         */

        public CT_Fill GetCTFill()
        {
            CT_Fill ct;

            // bug 56295: handle missing applyFill attribute as "true" because Excel does as well
            if (!_cellXf.IsSetApplyFill() || _cellXf.applyFill)
            {
                int          FillIndex = (int)_cellXf.fillId;
                XSSFCellFill cf        = _stylesSource.GetFillAt(FillIndex);

                ct = (CT_Fill)cf.GetCTFill().Copy();
            }
            else
            {
                ct = new CT_Fill();
            }
            return(ct);
        }
Esempio n. 2
0
        public void SetUp()
        {
            stylesTable = new StylesTable();

            ctStylesheet = stylesTable.GetCTStylesheet();

            ctBorderA = new CT_Border();
            XSSFCellBorder borderA  = new XSSFCellBorder(ctBorderA);
            long           borderId = stylesTable.PutBorder(borderA);

            Assert.AreEqual(1, borderId);

            XSSFCellBorder borderB = new XSSFCellBorder();

            Assert.AreEqual(1, stylesTable.PutBorder(borderB));

            ctFill = new CT_Fill();
            XSSFCellFill fill   = new XSSFCellFill(ctFill);
            long         fillId = stylesTable.PutFill(fill);

            Assert.AreEqual(2, fillId);

            ctFont = new CT_Font();
            XSSFFont font   = new XSSFFont(ctFont);
            long     fontId = stylesTable.PutFont(font);

            Assert.AreEqual(1, fontId);

            cellStyleXf          = ctStylesheet.AddNewCellStyleXfs().AddNewXf();
            cellStyleXf.borderId = 1;
            cellStyleXf.fillId   = 1;
            cellStyleXf.fontId   = 1;

            cellXfs         = ctStylesheet.AddNewCellXfs();
            cellXf          = cellXfs.AddNewXf();
            cellXf.xfId     = (1);
            cellXf.borderId = (1);
            cellXf.fillId   = (1);
            cellXf.fontId   = (1);
            stylesTable.PutCellStyleXf(cellStyleXf);
            stylesTable.PutCellXf(cellXf);
            cellStyle = new XSSFCellStyle(1, 1, stylesTable, null);
        }