OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 7

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

A boolean value indicating whether or not to copy cell formulas.

Signature
C#
C#
 public boolean CopyFormulas{ get; set; }
Signature
vb.net
vb.net
Public Property CopyFormulas() As Boolean
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.

Example
Code Block
csharp
csharp
titleC#

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

          //--- Set the property object to copy formulas.
          copyPasteProperties.CopyFormulas = true;
Code Block
vb.net
vb.net
titlevb.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