https://bugs.documentfoundation.org/show_bug.cgi?id=104933
Bug ID: 104933
Summary: EDITING: Find and replace does not apply formulas when
replacing blank cells
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I use Find & Replace to replace the contents of a cell with a formula, the
matching cells are replaced with the results of that formula, as expected.
However when I use Find & Replace to replace some empty cells, instead of the
result of the formula the blank cells are replaced with the formula as if it
were text.
Steps to Reproduce:
1. Write some text in some cells, leave some empty
2. Select a range of cells that include some empty cells
3. From the Edit menu, open the Find & Replace tool.
4. Leave the "Search For" field empty and put a simple formula in the "Replace
With" field (for example =SUM(1,2))
5. Try the same thing but this time copy the value of a non-empty cell and
paste that in the "Search For" field.
Actual Results:
The empty cells were replaced with cells containing the literal text =SUM(1,2)
Expected Results:
The empty cells should contain the result of =SUM(1,2), that is, the number 3.
Reproducible: Always
User Profile Reset: No
Additional Info:
As a workaround, manually entering the formulas instead of using find & replace
works. However it is tedious and impractical on large spreadsheets.
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
