False Search and Replace Query dialog True False vertical 8 True False end gtk-cancel False True True True False Perform no more replacements False True False False 0 gtk-no False True True True False Do not perform this replacement False True False False 1 gtk-yes False True True True True True False Perform this replacement False True False False 2 False True end 0 True False 6 6 12 True False 0 Search and Replace center 0 0 2 1 True False 0 Location True center qd_location 0 1 1 1 True False 0 Replacing True center qd_old_text 0 2 1 1 True False 0 By True center qd_new_text 0 3 1 1 _Query False True True False True Ask before each change Ask before each change False True 0 True 0 4 2 1 True True False ● 1 1 1 1 True True False ● 1 2 1 1 True True False ● 1 3 1 1 False True 1 qd_cancel qd_no qd_yes False 6 Search & Replace dialog True False vertical 6 True False end gtk-help False True True True False False True False False 0 gtk-cancel False True True True False False True False False 1 gtk-apply False True True True False True False False 2 gtk-ok False True True True True False False True False False 3 False False end 0 True True True 5 True False 12 6 12 True False 0 Search 0 0 2 1 True False 18 0 4 _Search for True center 0 1 1 1 True False 18 0 4 _Replace by True center 0 2 1 1 True False 18 True 0 3 3 1 _Ignore case False True True False True When set, do not distinguish between upper and lower case letters When set, do not distinguish between upper and lower case letters 18 False True 0 True True 0 4 1 1 _Preserve case False True True False True Attempt to preserve case of text when replacing Attempt to preserve case of text when replacing False True 0 True 1 4 1 1 _Query False True True False True Ask before each change Ask before each change 18 False True 0 True 0 5 1 1 Ma_tch whole words only False True True False True Do not consider matches in the middle of words Do not consider matches in the middle of words False True 0 True 1 5 1 1 True False 0 Scope 0 6 3 1 _Entire workbook False True True False True Search and replace in all cells in the workbook Search and replace in all cells in the workbook 18 False True 0 True True 0 7 2 1 _Current sheet False True True False True Search and replace in current sheet only Search and replace in current sheet only 18 False True 0 True True scope_workbook 0 8 2 1 Ra_nge False True True False True Search and replace in specified range only Search and replace in specified range only 18 False True 0 True True scope_workbook 0 9 1 1 True False True 2 0 1 1 True False Normal center False True False 12 6 12 True False 0 <span weight="bold">Change Cells Containing</span> True 0 0 1 1 _Strings False True True False True Perform changes within string values Perform changes within string values 18 False True 0 True True 0 1 1 1 _Other values False True True False True Perform changes within non-string values Perform changes within non-string values 18 False True 0 True True 0 2 1 1 _Expressions False True True False True Perform changes within expressions Perform changes within expressions False True 0 True True 1 1 1 1 _Comments False True True False True Perform changes within cell comments Perform changes within cell comments False True 0 True 1 2 1 1 True False 0 <span weight="bold">Search Text Type</span> True 0 3 1 1 _Plain text False True True False True The search text is taken literally. The search text is taken literally. 18 False True 0 True True 0 4 1 1 Re_gular expression False True True False True The search text is a regular expression The search text is a regular expression False True 0 True search_type_text 1 4 1 1 True False 0 <span weight="bold">Miscellaneous</span> True 0 5 1 1 _Row major False True True False True Search line by line Search line by line 18 False True 0 True True 0 6 1 1 _Column major False True True False True Search column by column Search column by column False True 0 True row_major 1 6 1 1 _Keep strings as strings False True True False True When set, string values will remain as such after replacement, even if they look like numbers or expressions When set, string values will remain as such after replacement, even if they look like numbers or expressions 18 False True 0 True True 0 7 1 1 Save the current settings as default settings False True True False True When set, the current settings will be saved as the default settings for future invocations of this and the Search dialog. When set, the current settings will be saved as the default settings for future invocations of this and the Search dialog. False 0 True 1 7 1 1 True False True 2 0 1 1 1 True False Advanced center 1 False True False start 12 6 12 _Fail False True True False True Fail without any changes actually being done to any cell Fail without any changes actually being done to any cell False True 0 True True 0 0 1 1 _Don't change False True True False True Skip cells that would result in errors Skip cells that would result in errors False True 0 True error_fail 0 1 1 1 _Query False True True False True Query for replacement Query for replacement False True 0 True error_fail 0 2 1 1 Make _error expression False True True False True Create =ERROR(&quot;...&quot;) Create =ERROR("...") False True 0 True error_fail 1 0 1 1 Make _string value False True True False True Turn unparsable entries into string values Turn unparsable entries into string values False True 0 True error_fail 1 1 1 1 2 True False Error Behaviour center 2 False False True 1 help_button cancel_button apply_button ok_button