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

Versions Compared

Old Version 29

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version 30

changes.mady.by.user Gabe Goodwin [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

Excerpt

Sets or returns whether formulas or their calculated values will be displayed in the worksheet. Calculated values are displayed by default.

Signature
C#
C#
<table class="diff-macro"><thead><tr><th class="diff-macro-title">unmigrated-wiki-markup</th></tr></thead><tbody><tr><td class="diff-macro-body"><pre>  public boolean ShowFormulas\{ get; set; \}
</pre></td></tr></tbody></table>
Signature
vb.net
vb.net

<p>Public Property ShowFormulas() As Boolean</p>

Example
Code Block
csharp
csharp
titleC#

...

//--- Get ShowFormulas
          bool displayFormulas = ws.ShowFormulas;

          //--- Set ShowFormulas
          ws.ShowFormulas = true;
Code Block
vb.net
vb.net
titlevb.net

...

'--- Get ShowFormulas
          Dim displayFormulas As Boolean = ws.ShowFormulas

          '--- Set ShowFormulas
          ws.ShowFormulas = True