ExcelFile.ConvertExternalNamesToRefErrors Method
Overloads
ExcelFile.ConvertExternalNamesToRefErrors
Use it to convert the external names in a sheet to #REF! . It can be useful when you need to remove all external links in a file. NOTE: You will probably want to use ConvertFormulasToValues(Boolean) too.
Syntax
Namespace: FlexCel.Core
public void ConvertExternalNamesToRefErrors()
See also
ExcelFile.ConvertExternalNamesToRefErrors(Boolean)
Use it to convert the external names in a sheet to #REF! . It can be useful when you need to remove all external links in a file. NOTE: You will probably want to use ConvertFormulasToValues(Boolean) too.
Syntax
Namespace: FlexCel.Core
public abstract void ConvertExternalNamesToRefErrors(Boolean recalcBeforeConverting)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
recalcBeforeConverting | Boolean | If true (the default), FlexCel will try to recalculate the file before converting the formulas. Use false when for any reason FlexCel can't recalculate the values (for example if you have links to other files that don't exist anymore) |