Options
Click "Options" tab in the dialog, you can set options in repair process:
•If "Open the fixed file when finished" option is selected, then DEXCELR will open the fixed xls or xlsx file after the reparation. Note you need application associating with the '.xls' or '.xlsx' extension to open the xls or xlsx files. In general, if you have installed Microsoft Excel on your computer, then Excel will associate with the '.xls' or '.xlsx' extension. This option is selected by default.
•If "Recover Array-Entered Formula(for XLS file only)" option is selected, then DEXCELR will recover array-entered formulas. This option is used for XLS file recovery only. For XLSX file, array-entered formulas are always recovered. This option is selected by default.
•If "Recover Shared Formula(for XLS file only)" option is selected, then DEXCELR will recover shared formulas. This option is used for XLS file recovery only. For XLSX file, shared formulas are always recovered. This option is selected by default.
•If "Convert and set the invalid formula as a string" option is selected, then whenever DEXCELR encounters an invalid formula, it will first convert the formula into a string with the format "Invalid formula: xxxx", where xxxx is the formula. Then set the corresponding cell to that string instead of the invalid formula. Thus you can check the formula and fix the problems in it. This option is selected by default.
Note:
•DEXCELR will remember the options the last time you set.
