RunAllFormulas

GridDesktop.RunAllFormulas method

Exécute la formule de toutes les cellules.

public void RunAllFormulas()

Exemples

[C#]
gridDesktop1.Worksheets[0].Cells[0, 0].Value = "2";
gridDesktop1.Worksheets[0].Cells[1, 0].Value = "3";
gridDesktop1.Worksheets[0].Cells[2, 1].Value = "=a1*a2";
gridDesktop1.RunAllFormulas();
gridDesktop1.Invalidate();

[Visual Basic]
gridDesktop1.Worksheets(0).Cells(0, 0).Value = "2"
gridDesktop1.Worksheets(0).Cells(1, 0).Value = "3"
gridDesktop1.Worksheets(0).Cells(2, 1).Value = "=a1*a2"
gridDesktop1.RunAllFormulas()
gridDesktop1.Invalidate()

Voir également

class GridDesktop
espace de noms Aspose.Cells.GridDesktop
Assemblée Aspose.Cells.GridDesktop

RefreshControl SetAllScrollBarsVisible