Bug 118062 - cannot find & replace a "("
Summary: cannot find & replace a "("
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-06-08 06:43 UTC by Elmar
Modified: 2018-06-10 11:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
find replace ( problem (29.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-06-08 06:45 UTC, Elmar 		Details
Screenshot with find&replace options that works (79.07 KB, image/png)
2018-06-09 08:23 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Elmar 2018-06-08 06:43:39 UTC 
Description:
I need to change a column of formulas but find& replace cannot do it
formula is =if(f5.... to w5, w6, w7, etc
If I find "f", it becomes =iw(w5...


Steps to Reproduce:
1. create incorrect formula =IF(F5=0,0,Y5/F5)
2. copy to multiple cells
3. am using wrong reference, wish to change col F to col W
4. can find /F but not (F
5. gives search string  not found error 

Actual Results:  
as described

Expected Results:
need a way to be able to include ( in a search string


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Version: 6.2.0.0.alpha0+
Build ID: 288878045e54651ffe96e5faa879ab3bbabf9510
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-06-05_01:47:11
Locale: en-GB (en_ZA.UTF-8); Calc: group threaded


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0
Comment 1 Elmar 2018-06-08 06:45:26 UTC 
Created attachment 142608 [details]
find replace ( problem

Note: the example doc has the situation where the f in col X has already been replaced by w in the division expression
Comment 2 Xavier Van Wijmeersch 2018-06-08 12:12:39 UTC 
I never use find and replace on formulae.

1 select exp. X21 to X31
2 go to cell X21 make your change; F to W
3 press alt+enter

and all the selected cell will change the wrong formula in to the right formula

regards
Comment 3 m_a_riosv 2018-06-09 08:23:23 UTC 
Created attachment 142622 [details]
Screenshot with find&replace options that works

Maybe I'm wrong, but seems you have regular expressions enable in the options.
Attached screenshoot shows the options to have it working.
Comment 4 m_a_riosv 2018-06-09 21:31:26 UTC 
'(' it's part of regular expressions, if you need to search/replace it, there is needed escape the character using instead '\('.
Comment 5 Elmar 2018-06-10 03:23:48 UTC 
So, to conclude the matter:

In Find & Replace my error was that I did not untick "regular expressions".

An alternative is to select an area, type the formula (in this case, correct the formula), then ALT+ENTER.

Tried both, and they worked!

That is great. I did not know that, nor did I find it in the Help.

How does one improve the help?

Maybe there should be a section that highlights these two techniques?