Ejemplo n.º 1
0
        private void SetParagraphFormat(Paragraph para)
        {
            if (para != null)
            {
                switch (_style.HAlign)
                {
                case HAlignment.Center:
                    para.Alignment = Alignment.center;
                    break;

                case HAlignment.FullWidth:
                    para.Alignment = Alignment.both;
                    break;

                case HAlignment.Left:
                    para.Alignment = Alignment.left;
                    break;

                case HAlignment.Right:
                    para.Alignment = Alignment.right;
                    break;
                }
                if (_style.HasFontStyle() && _style.FontStyle.HasFlag(FontStyle.Bold))
                {
                    para.Bold();
                }
                if (_style.HasFontStyle() && _style.FontStyle.HasFlag(FontStyle.Italic))
                {
                    para.Italic();
                }

                para.FontSize(12 + (_style.HasFontDSize() ? _style.FontDSize : 0));
                if (_style.HasFontName())
                {
                    para.Font(new FontFamily(_style.FontName));
                }
                if (_style.HasFontColor())
                {
                    var p       = new HSSFPalette(new PaletteRecord());
                    var c       = p.GetColor(_style.FontColor);
                    var triplet = c.GetTriplet();
                    para.Color(Color.FromArgb(triplet[0], triplet[1], triplet[2]));
                }
            }
        }
Ejemplo n.º 2
0
        private Formatting GetFormatting()
        {
            var result = (from f in _formattings where f.Key.CompareTo(_style) == 0 select f.Value).FirstOrDefault();

            if (result == null)
            {
                result = new Formatting
                {
                    Bold   = _style.HasFontStyle() && _style.FontStyle.HasFlag(FontStyle.Bold),
                    Italic = _style.HasFontStyle() && _style.FontStyle.HasFlag(FontStyle.Italic),

                    Size = 12 + (_style.HasFontDSize() ? _style.FontDSize : 0)
                };

                /*if (_style.HasFontColor())
                 *  result.FontColor = (Color) _style.FontColor;*/
                _formattings.Add(new ContentStyle(_style), result);
            }
            return(result);
        }
Ejemplo n.º 3
0
        private void AssignStyle(CellStyle cellStyle, ContentStyle style)
        {
            if (style.HasFontName() || style.HasFontStyle() || style.HasFontDSize() || style.HasFontColor())
            {
                var font = GetFont(style); //Workbook.CreateFont();  // cellStyle.GetFont(Workbook);

                if (style.HasFontName())
                {
                    font.FontName = style.FontName;
                }
                if (style.HasFontDSize())
                {
                    font.FontHeightInPoints += style.FontDSize;
                }
                if (style.HasFontStyle())
                {
                    if (style.FontStyle.HasFlag(FontStyle.Bold))
                    {
                        font.Boldweight = (short)FontBoldWeight.BOLD;
                    }
                    else
                    {
                        font.Boldweight = (short)FontBoldWeight.NORMAL;
                    }
                    font.IsItalic  = style.FontStyle.HasFlag(FontStyle.Italic);
                    font.Underline = style.FontStyle.HasFlag(FontStyle.Underline)
                                         ? (byte)FontUnderlineType.SINGLE
                                         : (byte)FontUnderlineType.NONE;
                }
                if (style.HasFontColor())
                {
                    font.Color = style.FontColor;
                }

                cellStyle.SetFont(font);
            }
            if (style.HasBgColor())
            {
                cellStyle.FillForegroundColor = style.BgColor;
                cellStyle.FillPattern         = FillPatternType.SOLID_FOREGROUND;
            }
            switch (style.HAlign)
            {
            case HAlignment.Left:
                cellStyle.Alignment = HorizontalAlignment.LEFT;
                break;

            case HAlignment.Right:
                cellStyle.Alignment = HorizontalAlignment.RIGHT;
                break;

            case HAlignment.Center:
                cellStyle.Alignment = HorizontalAlignment.CENTER;
                break;
            }
            switch (style.VAlign)
            {
            case VAlignment.Top:
                cellStyle.VerticalAlignment = VerticalAlignment.TOP;
                break;

            case VAlignment.Bottom:
                cellStyle.VerticalAlignment = VerticalAlignment.BOTTOM;
                break;

            case VAlignment.Middle:
                cellStyle.VerticalAlignment = VerticalAlignment.CENTER;
                break;
            }

            if (style.Borders.HasFlag(TableCellBorder.Top) /* ?? false*/)
            {
                cellStyle.BorderTop      = CellBorderType.THIN;
                cellStyle.TopBorderColor = style.BorderColor; //HSSFColor.BLACK.index;
            }
            else
            {
                cellStyle.BorderTop = CellBorderType.NONE;
            }

            if (style.Borders.HasFlag(TableCellBorder.Left))
            {
                cellStyle.BorderLeft      = CellBorderType.THIN;
                cellStyle.LeftBorderColor = style.BorderColor; //HSSFColor.BLACK.index;
            }
            else
            {
                cellStyle.BorderLeft = CellBorderType.NONE;
            }

            if (style.Borders.HasFlag(TableCellBorder.Right))
            {
                cellStyle.BorderRight      = CellBorderType.THIN;
                cellStyle.RightBorderColor = style.BorderColor; //HSSFColor.BLACK.index;
            }
            else
            {
                cellStyle.BorderRight = CellBorderType.NONE;
            }

            if (style.Borders.HasFlag(TableCellBorder.Bottom))
            {
                cellStyle.BorderBottom      = CellBorderType.THIN;
                cellStyle.BottomBorderColor = style.BorderColor; //HSSFColor.BLACK.index;
            }
            else
            {
                cellStyle.BorderBottom = CellBorderType.NONE;
            }

            if (style.WrapText ?? false)
            {
                cellStyle.WrapText = (bool)style.WrapText;
            }
        }
Ejemplo n.º 4
0
        private Font GetFont(ContentStyle style)
        {
            var curFont = Workbook.GetFontAt(0);

            for (short i = 1; i < Workbook.NumberOfFonts; i++)
            {
                var font = Workbook.GetFontAt(i);

                if (style.HasFontName())
                {
                    if (!String.Equals(font.FontName, style.FontName, StringComparison.OrdinalIgnoreCase))
                    {
                        continue;
                    }
                }
                else
                if (!String.Equals(font.FontName, curFont.FontName, StringComparison.OrdinalIgnoreCase))
                {
                    continue;
                }

                if (style.HasFontStyle())
                {
                    if (style.FontStyle.HasFlag(FontStyle.Italic) && !font.IsItalic)
                    {
                        continue;
                    }
                    if (style.FontStyle.HasFlag(FontStyle.Bold) && font.Boldweight != (short)FontBoldWeight.BOLD)
                    {
                        continue;
                    }
                    if (style.FontStyle.HasFlag(FontStyle.Underline) && font.Underline != (byte)FontUnderlineType.SINGLE)
                    {
                        continue;
                    }
                    if (style.FontStyle == FontStyle.Regular &&
                        (font.IsItalic || font.Boldweight != (short)FontBoldWeight.NORMAL || font.Underline != (byte)FontUnderlineType.NONE))
                    {
                        continue;
                    }
                }
                if (style.FontDSize == 0 && curFont.FontHeightInPoints != font.FontHeightInPoints)
                {
                    continue;
                }
                if (style.FontDSize != 0)
                {
                    var fs = curFont.FontHeightInPoints + style.FontDSize;
                    if (font.FontHeightInPoints != fs)
                    {
                        continue;
                    }
                }
                if (style.HasFontColor() && style.FontColor != font.Color)
                {
                    continue;
                }

                return(font);
            }
            return(Workbook.CreateFont());
        }