Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
brusckowski
80
How to clear the existing cell range
posted

Hi,

I received an error - "The array formula is already applied to a cell range. Clear the existing cell range first."   The Infragistics excel engine does not have clear method which clear the existing cell range. Do you have any ways to clear this cell range?

Parents
No Data
Reply
  • 54937
    Offline posted

    You can get the ArrayFormula (e.g. using the WorksheetRow's GetCellFormula method and casting to ArrayFormula) and then use the ArrayFormula's ClearCellRange method.

Children