Hi beaton, On Thu, Jan 26, 2006 at 10:56:20 -0800, beaton wrote:
> Good: Regular expressions, such as ([0-9])([A-Z]), are supported in the > "Search for" field. > Bad: Calc doesn't support regex in the "Replace with" field. Correct, back references in substitutions aren't supported. Only the entire match can be used in the replacement, using the ampersand '&' character. Which is also documented in the online help. This isn't restricted to Calc though, the entire suite uses the same engine. > Find and Replace, Range Problem > ------------------------------- > The "Current selection only" checkbox is like a booby trap waiting to > destroy data. > Suppose I select a range of cells, then I turn on "Current selection only", > then I click on a single cell -- Calc turns off "Current selection only", Because then you don't have a selection. > and leaves it turned off, even when I select a new range of cells. At least the checkbox then is enabled again. I agree though that the handling could be enhanced to automatically operate on a range if a range is selected. If that's what also other users expect. > If I don't notice this malicious behavior, my whole spreadsheet is > changed. If I click [Find All], Calc doesn't confine the find > operation to the range I selected, it does the whole spreadsheet. This > is also true for the replace command. This is bad -- suppose I want to > make changes to all matching cells in column D, and leave all other > columns unchanged -- I can't do it. You can by checking the checkbox. > Suggestion: Get rid of the "Current selection only" checkbox. Follow the > Excel standard: <nitpick> There is no Excel standard </nitpick> There may be some different behavior in Excel that maybe is better. > Search the whole spreadsheet if one cell is selected; if a > range is selected, then confine the search to the range. This may be a good behavior. Did you lookup whether a request for enhancement was already filed? http://qa.openoffice.org/issue_handling/pre_submission.html If there isn't, you may do so. > Find and Replace, Wildcard Problem > ---------------------------------- > Calc Find doesn't support wildcards. Known, RFE in queue: http://qa.openoffice.org/issues/show_bug.cgi?id=32344 > User Interface Inconsistency > ---------------------------- > The Find dialog box has a "More Options" button. When you click it, it > changes to "Less Options" > "Data menu > Filter > Standard Filter" has a "More" button. When you click > it, it doesn't change to "Less". > Suggestion: Make button names consistent. Is there anything wrong with > using Excel's [Options >>] and [<< Options]? Don't know. Maybe there were reasons. What are left and right shifted options? > Checkboxes vs. Radio Buttons > ---------------------------- > Radio buttons are normally used for mutually exclusive choices, and > checkboxes are used for choices that are not mutually exclusive . > The Find dialog box violates these standards. > "Regular expression", "Similarity search" and "Search for Styles" are > mutually exclusive options and should be represented by radio buttons, not > check boxes. Seconded. Again, you may lookup whether an issue was already filed, or submit one if it wasn't. > A fourth radio button, "Wildcard search" should be added. > A minor nitpick: If Calc's dialog boxes standardize on "sentence case", > then "Search for Styles" should be "Search for styles". Seconded. Again, change requests should be filed as issues, so they can be tracked and assigned to the developer responsible. > If you can, you should draw a faint line around the set of radio buttons, > to give the user a visual cue to the set of alternatives. The usual style used in OOo dialogs doesn't draw boxes around items, which somehow would capture them, but visually they are separated by horizontal and/or vertical lines. > Data Filters > ------------ > Data filters don't do anything. ?? I doubt that. They do. Eike P.S.: As you're not subscribed to the mailing list you were posting to, you will miss replies that are directed to the list only. When answering, please reply only to the list (Reply-To header is set), not to my personal account. Thanks. -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
