Page History

{description}
{excerpt}A boolean value indicating whether or not to copy cell formulas.  {excerpt}
{signature:C#}
 public boolean CopyFormulas{ get; set; }

{signature}{signature:vb.net

}
Public Property CopyFormulas() As Boolean

{signature}
{remarks}
If this property is set to true, then the formula will be copied.  If this value is set to false and the CopyValues property is set to true, then only the final result of the formula, and not the formula itself, will be copied.
{remarks}
{example}{code:csharp|title=C#}

          //--- Is the property object set to copy formulas?
          boolean willCopyFormulas = copyPasteProperties.CopyFormulas;

          //--- Set the property object to copy formulas.
          copyPasteProperties.CopyFormulas = true;
        

{code}
{code:vb.net

|title=vb.net

}

          '--- Is the property object set to copy formulas?
          Dim willCopyFormulas As Boolean = copyPasteProperties.CopyFormulas

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

{example}