TExcelFile.ConvertExternalNamesToRefErrors Method
Overloads
TExcelFile.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
Unit: FlexCel.Core
procedure TExcelFile.ConvertExternalNamesToRefErrors; overload;
See also
TExcelFile.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
Unit: FlexCel.Core
procedure TExcelFile.ConvertExternalNamesToRefErrors(const recalcBeforeConverting: Boolean); overload; virtual; abstract;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | 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) |