Steps to reproduce: 1) open spreadsheet which several columns of data (mine has a header row but I don't think that impacts this bug). 2) open the find&replace window 3) in the sheet, add a new column (e.g. C) in between columns with CTRL+ 4) select column to the left (B), copy and paste into column on the right 5) select column B and in the find&replace window, select some date to replace Outcome: Calc will find and replace data in column B AND C even though only column B is selected for find&replace. This behaviour seems not to occur if the find&replace window is not open during the copypaste.
Do you have checked "Other options - Current selection only" on Find&replace dialog? Probably when Find&replace dialog is starting then dialog check if more than one cell is selected. If yes, dialog tick the option "Current selection" only. I can reproduce with Version: 4.5.0.0.alpha0+ Build ID: 2116f1cfb31e5fcf829c2f101cd878a32b56c365 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-19_05:59:03 I think it's not a bug, you can tick the option "Current selection" by yourself.
Ah... thank you. I think I will keep this open as a bug though because this is pretty idiotic I must say, as a 'feature'. If the user has (and that's the behaviour most users will exhibit) selected a particular data range, than this should automatically active the 'current selection only' feature. In my case, this may have cost me 2 days work because I did NOT realise that the adjacent column aside, this may have affected data across the large spreadsheet I was working in. Now I have to backtrack to make sure LO did not mess up my data.
Ah and I discovered something else. When the Find&Replace window is not open and I select a data range, then I open it, then the Selected Range Only is selected. So the problem is 'ticking that box' when the window is already open. So I think it actually is a bug.
(In reply to Michael Bauer from comment #3) > Ah and I discovered something else. When the Find&Replace window is not open > and I select a data range, then I open it, then the Selected Range Only is > selected. So the problem is 'ticking that box' when the window is already > open. So I think it actually is a bug. Yes, looks like dialog check selected cells during starting. How LO should solve this situation? - user select more cells - open Find&Replace window - untick "Current selection" for some reason - run Find&Replace --> (more cells are selected) You propose find&replace "If the user has (and that's the behaviour most users will exhibit) selected a particular data range, than this should automatically active the 'current selection only' feature.", but user untick "Current selection".
I'm not sure I understood what you meant but what I'm saying is this: When the user manually selects a data range, this should be the default range for searching or search & replace, irrespective of what window was open before or during the selection of the data range. The search and search&replace should only cover the entire document if the user manually deselects 'Selected range' in the options. It is simply illogical to assume that a user manually selects a data range and then wants, be default, to ignore that selection and search/search/replace the entire sheet. Why would a user bother to select a data range for that?
(In reply to Michael Bauer from comment #5) > It is simply illogical to assume that a user manually selects a data range > and then wants, be default, to ignore that selection and > search/search/replace the entire sheet. Why would a user bother to select a > data range for that? Changed severity to enhancement, but this needs to be debated. Some users might get annoyed, if this sniffing of selection was implemented.
(In reply to Beluga from comment #6) > Changed severity to enhancement, but this needs to be debated. Some users > might get annoyed, if this sniffing of selection was implemented. Sounds like one for the UX to contemplate... (In reply to raal from comment #4) > You propose find&replace "If the user has (and that's the behaviour most > users will exhibit) selected a particular data range, than this should > automatically active the 'current selection only' feature.", but user untick > "Current selection". Is that what's being proposed here? Let's get our ducks in a row first, and then this can go over to the UX Team for clarification. Status -> NEEDINFO (Michael: Once you've added a clear proposal for what to change re: Find & Replace, then change status back to UNCONFIRMED, please. Thanks!)
It's hardly UNCONFIRMED any longer, no? See comment #1? Anyway, I thought I was pretty clear in comment #5 but I'll try and be clearer. Current behaviour: If "Find & Replace" window is open and the user selects a data range and then runs find & replace, the selected data range is ignored because the "Current selection" box remains unticked. This is illogical (and referring to comment #6 in fact is annoying users as it is). I have yet to hear someone suggest a situation in which a user is doing Find & Replace, selects a data range manually but still wants to run Find & Replace on the whole data range. Proposed behaviour: When the user manually selects a data range, this should be the default range for "Search" or "Search & Replace", irrespective of what window was open before or during the selection of the data range. "Search" and "search & Replace" should only cover the entire document if the user manually deselects "Selected range" in the options. This is, by the way, also the default behaviour in Excel.
(In reply to Michael Bauer from comment #8) > This is, by the way, also the default behaviour in Excel. Excel 2013 doesn't have a tickbox to alternate between current selection. Always defaults to selection, if present. Changing this to ux-advise. Comment from Matthew Francis: "I would e.g. select something to copy and paste *into the dialog*, then get confused/annoyed by the lack of result" This is not a far-fetched scenario, as the Current selection tickbox is hidden by default.
(In reply to Beluga from comment #9) > (In reply to Michael Bauer from comment #8) > > This is, by the way, also the default behaviour in Excel. > > Excel 2013 doesn't have a tickbox to alternate between current selection. > Always defaults to selection, if present. > > Changing this to ux-advise. Fair enough: Status -> NEW
A lack of results is a more preferable 'error' in my view because no data is lost or affected until the correct settings are chosen. When I discovered this 'behaviour' by accident, I had already lost 2 days work because the default behaviour 'silently' affects the whole sheet. This of course includes the selected range but unless you *happen* to have to rows or columns side by side, only one of which should be affected, then you potentially, as I did, mess up a whole swathe of data without ever noticing it until it's way too late. True, Excel has no such tickbox but it is the default behaviour. Thank you for clarifying.
The issue comes from the fact that the Find & Replace dialog is not modal. Is there any reason for?
We're replacing our use of the 'ux-advise' component with a keyword: Component -> LibreOffice Add Keyword: needsUXEval [NinjaEdit]
Solution 1: Make the dialog modal (not the best option). Solution 2: Check 'current selection only' by default regardless anything has been selected before (you wont be able to change all occurrences unless you expand other options and untick the checkbox) Solution 3: Keep the current behavior (modifications to the selection while the dialog is open are not taken into account; that's also true when you start with a selection but unselect later) Solution 4: Drop the option and apply the function to the selection; if nothing is selected use the whole sheet (that's the Excel way; feels quite natural and would be my recommendation. => Remove the option 'Current selection only' in Find and Replace and use always the selection or the full sheet if nothing is selected Summary was "Wrong replace behaviour with Find & Replace window open"
(In reply to Heiko Tietze from comment #14) > Solution 2: Check 'current selection only' by default regardless anything > has been selected before (you wont be able to change all occurrences unless > you expand other options and untick the checkbox) > Solution 3: Keep the current behavior (modifications to the selection while > the dialog is open are not taken into account; that's also true when you > start with a selection but unselect later) I vote for: improve the current behavior. Now if you select a cell range and open the F&R dialog, the 'current selection only' option is activated automatically. If you deselect the cell range, then the option will be deactivated automatically. The problem is that the other way round (nothing selected, F&R opened, then cell range selected) doesn't work automatically. Also a subsequent selection of a cell range doesn't activate the 'current selection only' option again. This must be enhanced. > Solution 4: Drop the option and apply the function to the selection; if > nothing is selected use the whole sheet (that's the Excel way; feels quite > natural and would be my recommendation. > > => Remove the option 'Current selection only' in Find and Replace and use > always the selection or the full sheet if nothing is selected I'm against removing the option because it doesn't harm in the use case what was the reason for this bug report. LibreOffice boasts of its flexibility and configurability. Removing this option would counteract that principles.
(In reply to Thomas Lendo from comment #15) > LibreOffice boasts of its flexibility and configurability. Does it? We agreed on the following LibreOffice focuses on: * Simplicity by default with Full Functionality on demand Every processing has two ways of access: a very simple way with the core features only and an advanced way with all features * Consistency over Efficiency Users should feel familiar with all tools rather than having specialized apps. * Usability over Graphical Design Form follows function, Libreoffice respects the OS theming. https://wiki.documentfoundation.org/Design/HIG_foundations#UX_Manifesto (Totally off-topic here and just fyi)
(In reply to Michael Bauer from comment #0) Michael, please edit the misleading title. This feature is essential, and is here to stay. Don't remove it. instead, suggest to fix a (certain) bug, and describe the bug. thanks (you nearly gave me a heart attack).
(In reply to Thomas Lendo from comment #15) > I vote for: improve the current behavior. Now if you select a cell range and > open the F&R dialog, the 'current selection only' option is activated > automatically. If you deselect the cell range, then the option will be > deactivated automatically. The problem is that the other way round (nothing > selected, F&R opened, then cell range selected) doesn't work automatically. > Also a subsequent selection of a cell range doesn't activate the 'current > selection only' option again. This must be enhanced. I would be fine with this improvement approach. (In reply to yallabalagan from comment #17) > Michael, please edit the misleading title. You can't edit bug titles. >This feature is essential, and is here to stay. >Don't remove it. As it is, it's hardly a "feature", more like a pain in the backside. >instead, suggest to fix a (certain) bug, and describe the bug. Sometimes in LO you come across an issue that looks like it's X but it turns out to be Y after discussion. That's just how it is, so please don't be patronising by suggesting I should be able to magically diagnose the issue at the start. If I could do that, I would be filing bugs, I'd be filing patches.
(In reply to Michael Bauer from comment #18) > > Michael, please edit the misleading title. > You can't edit bug titles. You can, though. I did it.