{description}
{excerpt}A boolean value indicating whether or not to copy cell formatting.  Cell formatting includes font, color, number formatting, fill color, fill pattern and borders.{excerpt}
{signature:C#}
 public boolean CopyFormatting{ get; set; }
{signature}{signature:vb.net}
Public Property CopyFormatting() As Boolean
{signature}
{example}{code:csharp|title=C#}

          //--- Is the property object set to copy cell formatting?
          boolean willCopyFormatting = copyPasteProperties.CopyFormatting;

          //--- Set the property object to copy cell formatting.
          copyPasteProperties.CopyFormatting = true;
        {code}
{code:vb.net|title=vb.net}

          '--- Is the property object set to copy cell formatting?
          Dim willCopyFormatting As Boolean = copyPasteProperties.CopyFormatting

          '--- Set the property object to copy cell formatting.
          copyPasteProperties.CopyFormatting = True
        {code}

{example}