Enum StyleModifyFlag

StyleModifyFlag enumeration

The style modified flags.

public enum StyleModifyFlag

Values

Name	Value	Description
LeftBorder	256	Indicates whether left border has been modified for the style.
RightBorder	512	Indicates whether right border has been modified for the style.
TopBorder	1024	Indicates whether top border has been modified for the style.
BottomBorder	2048	Indicates whether bottom border has been modified for the style.
DiagonalDownBorder	4096	Indicates whether diagonal-down border has been modified for the style.
DiagonalUpBorder	8192	Indicates whether diagonal-up border has been modified for the style.
Diagonal	12288	Indicates whether one or more diagonal borders(DiagonalDownBorder, DiagonalUpBorder) have been modified for the style.
HorizontalBorder	32	Indicates whether horizontal border has been modified for the style. Only for dynamic style, such as conditional formatting.
VerticalBorder	64	Indicates whether vertical border has been modified for the style. Only for dynamic style, such as conditional formatting.
Borders	16224	Indicates whether one or more borders(LeftBorder, RightBorder, TopBorder, BottomBorder, Diagonal, HorizontalBorder, VerticalBorder) have been modified for the style.
NumberFormat	16384	Indicates whether numberformat has been modified.
HorizontalAlignment	32768	Indicates whether horizontal alignment has been modified.
VerticalAlignment	65536	Indicates whether vertical alignment has been modified.
Indent	131072	Indicates whether indent property has been modified.
Rotation	262144	Indicates whether rotation property has been modified.
WrapText	524288	Indicates whether wrap text property has been modified.
ShrinkToFit	1048576	Indicates whether shrink to fit property has been modified.
TextDirection	2097152	Indicates whether text direction property has been modified.
RelativeIndent	128	Indicates whether relative indent property has been modified for the style. Only for dynamic style, such as conditional formatting.
AlignmentSettings	4161664	Indicates whether one or more alignment-related properties(HorizontalAlignment, VerticalAlignment, Rotation, WrapText, WrapText, Indent, ShrinkToFit, TextDirection, RelativeIndent) have been modified.
Pattern	4194304	Indicates whether pattern of the shading has been modified.
ForegroundColor	8388608	Indicates whether foreground color has been modified.
BackgroundColor	16777216	Indicates whether background color has been modified.
CellShading	29360128	Indicates whether one or more shading-related properties(Pattern, ForegroundColor, BackgroundColor) have been modified.
Locked	67108864	Indicates whether locked property has been modified.
HideFormula	134217728	Indicates whether hide formula has been modified.
ProtectionSettings	201326592	Indicates whether one or more protection-related properties(Locked, HideFormula) have been modified.
FontSize	1	Indicates whether font size has been modified.
FontName	2	Indicates whether font name has been modified.
FontColor	3	Indicates whether font color has been modified.
FontWeight	4	Indicates whether font weight has been modified.
FontItalic	5	Indicates whether italic property of font has been modified.
FontUnderline	6	Indicates whether underline property of font has been modified.
FontStrike	7	Indicates whether strike property font has been modified.
FontScript	8	Indicates whether subscript or superscript property of font has been modified.
FontFamily	9	Indicates whether font family has been modified.
FontCharset	10	Indicates whether charset of the font has been modified.
FontScheme	11	unused.
FontDirty	12	unused.
FontSpellingError	13	unused.
FontUFillTx	14	unused.
FontSpacing	15	unused.
FontKerning	16	unused.
FontEqualize	17	unused.
FontCap	18	unused.
FontVerticalText	19
Font	31	Indicates whether one or more properties have been modified for the font of the style.
All	234881023	Indicates whether one or more properties have been modified for the style.

Examples

[C#]

namespace Demos
{
    using Aspose.Cells;
    using System;

    public class StyleModifyFlagDemo
    {
        public static void StyleModifyFlagExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();

            // Add a new worksheet to the workbook
            Worksheet worksheet = workbook.Worksheets[0];

            // Set some values in the worksheet
            worksheet.Cells["A1"].PutValue("Sample Text");
            worksheet.Cells["A2"].PutValue(123.45);

            // Create a new style
            Style style = workbook.CreateStyle();
            style.Font.Name = "Arial";
            style.Font.Size = 12;
            style.Font.Color = System.Drawing.Color.Blue;
            style.HorizontalAlignment = TextAlignmentType.Center;
            style.VerticalAlignment = TextAlignmentType.Center;

            // Apply the style to a cell
            worksheet.Cells["A1"].SetStyle(style);

            // Check which style properties have been modified
            bool isFontModified = style.IsModified(StyleModifyFlag.Font);
            bool isFontSizeModified = style.IsModified(StyleModifyFlag.FontSize);
            bool isFontColorModified = style.IsModified(StyleModifyFlag.FontColor);
            bool isHorizontalAlignmentModified = style.IsModified(StyleModifyFlag.HorizontalAlignment);

            // Output the results
            Console.WriteLine("Font Modified: " + isFontModified);
            Console.WriteLine("Font Size Modified: " + isFontSizeModified);
            Console.WriteLine("Font Color Modified: " + isFontColorModified);
            Console.WriteLine("Horizontal Alignment Modified: " + isHorizontalAlignmentModified);

            // Save the workbook
            workbook.Save("StyleModifyFlagExample.xlsx");
        }
    }
}

See Also

• namespace Aspose.Cells
• assembly Aspose.Cells