Wiki Markup |
---|
{description} {excerpt}Sets or returns an array entered formula. An array entered formula is a formula that can have multiple output values. To set an array entered formula, surround the formula string with a '\{' and '\}'.{excerpt} {signature:C#} public System.String ArrayFormula{ get; set; } {signature}{signature:vb.net} Public Property ArrayFormula() As String {signature} {example}{code:csharp|title=C#} //--- Get ArrayFormula string formula = a.ArrayFormula; //--- Set ArrayFormula Area a = ws.CreateArea(10,0,10,1); a.ArrayFormula = "{=TREND(A1:A10,B1:B10)}"; {code} {code:vbnet|title=vb.net} '--- Get ArrayFormula Dim formula As String = a.ArrayFormula '--- Set ArrayFormula Dim a As Area = ws.CreateArea(10,0,10,1) a.ArrayFormula = "{=TREND(A1:A10,B1:B10)}" {code} {example} {scrollbar} |
Page History
Overview
Content Tools