Difference between revisions of "Validator Extension"
(→Validator) |
|||
(One intermediate revision by the same user not shown) | |||
Line 13: | Line 13: | ||
3) The Validator - Task manager window will appear. From this window select the validator options: | 3) The Validator - Task manager window will appear. From this window select the validator options: | ||
− | * Empty cell references | + | * Empty cell references - show such formulas where the formula reference to empty cell |
− | * String cell references | + | * String cell references - show such formulas where the formula reference to string type cell |
− | * Value | + | * Value cells that not used in any formulas |
− | * Division by zero in formulas | + | * Division by zero in formulas - show such formulas where the formula try to divide by zero value |
− | Then click on OK button. The upcoming Validator window will show the status of validations. You can see the cell references, formulas and the possible error here. You can fix problems by editing the "Formula" filed then click on "Correct" button. After you solved all problems you can click on "Refresh" button to check the current status of validations. | + | Then click on OK button. The upcoming Validator window will show the status of validations. You can see the cell references, formulas and the possible error here. You can fix problems by editing the "Formula" filed then click on "Correct" button. After you solved all problems you can click on "Refresh" button to check the current status of validations. |
+ | |||
+ | === Donate === | ||
+ | |||
+ | If you like this extension you can donate our further development work [http://sourceforge.net/donate/index.php?group_id=170021 here]. | ||
+ | |||
+ | === Obiter dictum === | ||
+ | |||
+ | === Users' wishlist === | ||
[[Category:Calc]][[Category:Extensions]] | [[Category:Calc]][[Category:Extensions]] |
Latest revision as of 22:16, 26 September 2010
Validator
Validator is an OpenOffice.org Calc extension that validates cells based on selected rules.
http://extensions.services.openoffice.org/en/project/validator
1) Start OpenOffice.org Calc
2) Select Tools → Detective → Validator
3) The Validator - Task manager window will appear. From this window select the validator options:
- Empty cell references - show such formulas where the formula reference to empty cell
- String cell references - show such formulas where the formula reference to string type cell
- Value cells that not used in any formulas
- Division by zero in formulas - show such formulas where the formula try to divide by zero value
Then click on OK button. The upcoming Validator window will show the status of validations. You can see the cell references, formulas and the possible error here. You can fix problems by editing the "Formula" filed then click on "Correct" button. After you solved all problems you can click on "Refresh" button to check the current status of validations.
Donate
If you like this extension you can donate our further development work here.