XlsFile.ConvertExternalNamesToRefErrors Method
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 ExcelFile.ConvertFormulasToValues(Boolean) too.
Syntax
Namespace: FlexCel.XlsAdapter
public override 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) |