Bug 130625 - EDITING: Find/Replace in array formula not working
Summary: EDITING: Find/Replace in array formula not working
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find-Search
  Show dependency treegraph
 
Reported: 2020-02-12 19:19 UTC by Steve Edmonds
Modified: 2021-01-29 20:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Calc sheet with array formulae for testing (1.13 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-12 19:22 UTC, Steve Edmonds
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Edmonds 2020-02-12 19:19:47 UTC
Description:
Using Edit>find & replace in formulae does not perform the replacement in array formulae.

Steps to Reproduce:
1.Create 2 named ranges, each a single cell. I.E _mu (=0.3) and _mu2 (=0.5). See attachment D44/D45
2.Create an array formula using _mu. See attachment D48:M49
3.Use find _mu, replace _mu2 formulae


Actual Results:
Search results show _mu is found in the array formulae
_mu is not replaced by _mu2 in the array formula

Expected Results:
_mu is replaced by _mu2 in the array formulae


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.4.2.0+
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 4.12; UI render: default; VCL: kde5; 
Locale: en-NZ (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Steve Edmonds 2020-02-12 19:22:02 UTC
Created attachment 157826 [details]
Calc sheet with array formulae for testing
Comment 2 m.a.riosv 2020-02-12 21:25:41 UTC
It is so, but I don't if it is a limitation or it is by purpose, because changes in arrays could imply e.g. change the range on where the array extends, and I don't know if it is possible or affordable on the fly while replacing.

Let's see if same dev can bring light on this.
Comment 3 Steve Edmonds 2020-02-13 00:53:33 UTC
This arose when importing an XLSX sheet and finding import of standard MS named ranges is not supported. (bug 130577)
Finding now that Edit>Find & Replace does not work for array formulae means simply renaming the violating named ranges is not a viable workaround for the bug 130577.
Comment 4 m.a.riosv 2020-02-13 10:04:46 UTC
I happens also with a simple array without name.
A1: =B1:B5 [Ctrl+Enter]
You are no able to change the range with search&replace.
Comment 5 BogdanB 2020-09-21 05:35:32 UTC
(In reply to m.a.riosv from comment #4)
> I happens also with a simple array without name.
> A1: =B1:B5 [Ctrl+Enter]
> You are no able to change the range with search&replace.

In A1 I have =B1:B5
Ctrl+H - Find & Replace

I search for 
--------------
=B1:B5
--------------

Replace with 
--------------
=B1:B6
--------------

Be sure to have "Search in Formula" in the bottom right window.

Result in A1:
--------------
=B1:B6
--------------

The formula is changed.


Tested in 
Version: 7.0.1.2
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 6 BogdanB 2021-01-29 20:35:39 UTC
It's working for me in all versions.

Also in
Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded


Please retest