6 Search and Replace GTK_WINDOW_TOPLEVEL GTK_WIN_POS_NONE False True False False True False 6 True GTK_BUTTONBOX_END True True True gtk-help True GTK_RELIEF_NORMAL 0 True True True gtk-cancel True GTK_RELIEF_NORMAL 0 True True True True gtk-ok True GTK_RELIEF_NORMAL 0 0 True False GTK_PACK_END 5 True True True True GTK_POS_TOP False False 12 True False 6 True 0 0.5 GTK_SHADOW_ETCHED_IN 5 True 5 4 False 4 4 True _Replace by True False GTK_JUSTIFY_CENTER False False 0 0.5 4 0 0 1 1 2 True _Search for True False GTK_JUSTIFY_CENTER False False 0 0.5 4 0 0 1 0 1 True 0 4 2 3 True When set, do not distinguish between upper and lower case letters True _Ignore case True GTK_RELIEF_NORMAL True False True 0 2 3 4 True Ask before each change True _Query True GTK_RELIEF_NORMAL False False True 0 2 4 5 True Do not consider matches in the middle of words True Ma_tch whole words only True GTK_RELIEF_NORMAL False False True 2 4 4 5 True Attempt to preserve case of text when replacing True _Preserve case True GTK_RELIEF_NORMAL False False True 2 4 3 4 True Search False False GTK_JUSTIFY_LEFT False False 0.5 0.5 0 0 label_item 0 True True True 0 0.5 GTK_SHADOW_ETCHED_IN 5 True 3 1 False 4 4 True Search and replace in all cells in the workbook True _Entire workbook True GTK_RELIEF_NORMAL True False True 0 1 0 1 True Search and replace in current sheet only True _Current sheet True GTK_RELIEF_NORMAL False False True scope_workbook 0 1 1 2 True Search and replace in specified range only True Ra_nge True GTK_RELIEF_NORMAL False False True scope_workbook 0 1 2 3 True Scope False False GTK_JUSTIFY_LEFT False False 0.5 0.5 0 0 label_item 0 False True False True True Normal False False GTK_JUSTIFY_CENTER False False 0.5 0.5 0 0 tab 12 True False 12 True 3 3 False 6 6 True Perform changes within non-string values True _Other values True GTK_RELIEF_NORMAL True False True 1 2 2 3 fill True Perform changes within cell comments True _Comments True GTK_RELIEF_NORMAL False False True 2 3 2 3 fill True Perform changes within expressions True _Expressions True GTK_RELIEF_NORMAL True False True 2 3 1 2 fill True Perform changes within string values True _Strings True GTK_RELIEF_NORMAL True False True 1 2 1 2 fill True <span weight="bold">Change Cells Containing</span> False True GTK_JUSTIFY_LEFT False False 0 0.5 0 0 0 3 0 1 fill True False False GTK_JUSTIFY_LEFT False False 0 0.5 0 0 0 1 1 3 0 False False True 2 3 False 6 6 True The search text is taken literally. True _Plain text True GTK_RELIEF_NORMAL True False True 1 2 1 2 fill True The search text is a regular expression True Re_gular expression True GTK_RELIEF_NORMAL False False True search_type_text 2 3 1 2 fill True <span weight="bold">Search Text Type</span> False True GTK_JUSTIFY_LEFT False False 0 0.5 0 0 0 3 0 1 fill True False False GTK_JUSTIFY_LEFT False False 0 0.5 0 0 0 1 1 2 0 False False True 2 3 False 6 6 True <span weight="bold">Miscellaneous</span> False True GTK_JUSTIFY_LEFT False False 0 0.5 0 0 0 3 0 1 fill True Search line by line _Row major True GTK_RELIEF_NORMAL True False True 1 2 1 2 fill True Search column by column _Column major True GTK_RELIEF_NORMAL False False True row_major 2 3 1 2 fill True False False GTK_JUSTIFY_LEFT False False 0 0.5 0 0 0 1 1 2 0 False False False True True Advanced False False GTK_JUSTIFY_CENTER False False 0.5 0.5 0 0 tab 4 True False 4 12 True 3 2 True 6 6 True Fail without any changes actually being done to any cell True _Fail True GTK_RELIEF_NORMAL True False True 0 1 0 1 True Skip cells that that would result in errors True _Don't change True GTK_RELIEF_NORMAL False False True error_fail 0 1 1 2 True Query for replacement True _Query True GTK_RELIEF_NORMAL False False True error_fail 0 1 2 3 True Create =ERROR("...") True _Make error expression True GTK_RELIEF_NORMAL False False True error_fail 1 2 0 1 True Turn unparsable entries into string values True Ma_ke string value True GTK_RELIEF_NORMAL False False True error_fail 1 2 1 2 0 True True False True True Error Behaviour False False GTK_JUSTIFY_CENTER False False 0.5 0.5 0 0 tab 0 True True Search and Replace Query GTK_WINDOW_TOPLEVEL GTK_WIN_POS_NONE False True False True True False 8 True GTK_BUTTONBOX_END 0 False True GTK_PACK_END True Search and Replace False False GTK_JUSTIFY_CENTER False False 0.5 0.5 0 0 0 False False True 3 2 False 4 4 True _Location True False GTK_JUSTIFY_CENTER False False 0 0.5 0 0 qd_location 0 1 0 1 fill True _Replacing True False GTK_JUSTIFY_CENTER False False 0 0.5 0 0 qd_old_text 0 1 1 2 fill True _By True False GTK_JUSTIFY_CENTER False False 0 0.5 0 0 qd_new_text 0 1 2 3 fill True True False True 0 True * False 1 2 1 2 True True False True 0 True * False 1 2 2 3 True True False True 0 True * False 1 2 0 1 0 True True True Ask before each change True _Query True GTK_RELIEF_NORMAL False False True 0 False False