https://bugs.documentfoundation.org/show_bug.cgi?id=118062

            Bug ID: 118062
           Summary: cannot find & replace a "("
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: rob...@iafrica.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to