Find volatile cells

The following example shows you how to list the volatile cells of a workbook. A cell is volatile when its value depends on NOW, TODAY, RAND, RANDBETWEEN or RANDARRAY, directly or through other cells. Volatile cells produce a different value on every calculation.

C# example

using System;
using Independentsoft.Calc;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            CalcSession session = new CalcSession();
            CalcResult result = session.Calculate(book);

            Console.WriteLine("Volatile cells: " + result.VolatileCells.Count);

            foreach (string reference in result.VolatileCells)
            {
                Console.WriteLine("    " + reference);
            }
        }
    }
}

VB example

Imports System
Imports Independentsoft.Calc
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook("c:\test\input.xlsx")

        Dim session As New CalcSession()
        Dim result As CalcResult = session.Calculate(book)

        Console.WriteLine("Volatile cells: " & result.VolatileCells.Count)

        For Each reference As String In result.VolatileCells
            Console.WriteLine("    " & reference)
        Next

    End Sub
End Module

Calc .NET > Tutorial > Find volatile cells

Need help? Ask our developers: