예제 #1
0
        public void CreateCellStyle()
        {
            #region radspreadprocessing-features-styling-cell-styles_1
            Workbook workbook = new Workbook();
            workbook.Worksheets.Add();

            CellStyle cellStyle = workbook.Styles.Add("My style", CellStyleCategory.Custom);

            cellStyle.BeginUpdate();

            CellBorder border = new CellBorder(CellBorderStyle.DashDotDot, new ThemableColor(Colors.Red));
            cellStyle.LeftBorder   = border;
            cellStyle.TopBorder    = border;
            cellStyle.RightBorder  = border;
            cellStyle.BottomBorder = border;

            ThemableColor patternColor    = new ThemableColor(ThemeColorType.Accent1);
            ThemableColor backgroundColor = new ThemableColor(ThemeColorType.Accent5, ColorShadeType.Shade2);
            IFill         fill            = new PatternFill(PatternType.Gray75Percent, patternColor, backgroundColor);
            cellStyle.Fill = fill;

            cellStyle.HorizontalAlignment = RadHorizontalAlignment.Left;
            cellStyle.VerticalAlignment   = RadVerticalAlignment.Center;

            cellStyle.EndUpdate();

            workbook.ActiveWorksheet.Cells[0, 0].SetStyleName("My style");
            #endregion
        }
예제 #2
0
        public void ModifyCellStyle()
        {
            #region radspreadprocessing-features-styling-cell-styles_2
            Workbook workbook = new Workbook();
            workbook.Worksheets.Add();

            CellStyle style = workbook.Styles["Bad"];

            style.BeginUpdate();

            style.Fill      = new PatternFill(PatternType.DiagonalCrosshatch, Colors.Red, Colors.Transparent);
            style.FontSize  = UnitHelper.PointToDip(20);
            style.ForeColor = new ThemableColor(Colors.Black);

            style.EndUpdate();
            #endregion
        }