TXlsFile.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 TExcelFile.ConvertFormulasToValues(Boolean) too.
Syntax
Unit: FlexCel.XlsAdapter
procedure TXlsFile.ConvertExternalNamesToRefErrors(const recalcBeforeConverting: Boolean); overload; override;
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) |
See also