Approve deviation: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 37: | Zeile 37: | ||
== See also == | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[The_validation_basic_functions| | [[Datei:Navigation_hoch.svg|link=]] [[The_validation_basic_functions|The validation basic functions]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Create_validations|Create validations]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[Create_validations|Create validations]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Create_multiple_validations|Create multiple validations]] <br> | [[Datei:Navigation_rechts.svg|link=]] [[Create_multiple_validations|Create multiple validations]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Auto-validations_in_firesys| | [[Datei:Navigation_rechts.svg|link=]] [[Auto-validations_in_firesys|Auto-validations in firesys]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Edit_validations|Edit | [[Datei:Navigation_rechts.svg|link=]] [[The_validation_worksheet|The validation worksheet]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Delete_validations|Delete | [[Datei:Navigation_rechts.svg|link=]] [[Edit_validations|Edit validations]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[Delete_validations|Delete validations]] <br> | |||
[[Datei:Navigation_rechts.svg|link=]] [[Update_validations|Update validations]] <br> | |||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie:English-Excel Dokument-Validierungen-Contentebene]] | [[Kategorie:English-Excel Dokument-Validierungen-Contentebene]] |
Version vom 6. August 2020, 08:05 Uhr
Use this function to approve non-relevant deviations of validations (e.g. in the area after the decimal point which is not displayed). Approved deviations are no longer listed as errors in the vali-dation sheet nor are they marked as errors in the Word tables.
Approve deviation
In order to approve deviations, please do the following:
- Change to the validation sheet and highlight the validation with a deviation you wish to approve.
- Select “Approve deviation” in the “Validation and consistency” group on the “*Validation” tab.
In the following dialogue, you can select the following two approval types:
Approve delta
Use this function if you would like to release a specific number range. The current deviation will then be directly recommended as delta. All values within this range automatically receive ap-proval.
Approve current values
Use this option to approve the current values as a deviation. The validation will be listed as a de-viation again, even if a value has only changed slightly. You can also add a comment and con-firm the dialogue with “OK”.
The deviation is approved and the respective information on the validation is shown as an Excel comment. This contains a date stamp, user information and the release value (Delta).
Good to know
| |
---|---|
Approved deviations are no longer listed as “Deviations” on the validation sheet under “Errors in validations”, they are listed as “Approved”. |
Practical example: Approve a deviation
Vorlage:Video-ValidierungAbweichungEN
See also
The validation basic functions
Create validations
Create multiple validations
Auto-validations in firesys
The validation worksheet
Edit validations
Delete validations
Update validations