We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

NamedRanges

Is it possible to set the text value of a cell using the namedrange. Thx

1 Reply

AD Administrator Syncfusion Team January 9, 2005 05:20 PM

No. The style.FormattedText may change, but the style.Text value always has to be the formaula. The only way that a named range can affect a cell is if the cell is a formula cell (style.CellType = "FormulaCell") and if the style.Text value for that cell holds a formula (string starting with an =). So, for such a cell, the style.Text value will have to be a formula, and this does not change. What is displayed in teh cell, style.FormattedText, will change as teh result of NamedRange, but the style.Text will not change.

Loader.
Live Chat Icon For mobile
Up arrow icon