| Summary: | search "Find" not working in CALC - I'm thinking it stuck on a formula default | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Larry <lonewolfeg> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | critical | ||
| Priority: | medium | ||
| Version: | 4.1.4.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
calc doc showing sheet 2 Search/Find bug
Try a cntl-f find on sheet 2 to see bug two sheets. 2nd sheet has text by ref to first sheet which cntl-f does not find ref text on sheet 2 not found by cntl f |
||
Created attachment 91748 [details]
Try a cntl-f find on sheet 2 to see bug
Comment on attachment 91748 [details]
Try a cntl-f find on sheet 2 to see bug
will add another attachment. I believe the bug is one of finding computed text i.e. where text on second sheet is reference from the first sheet.
Created attachment 96722 [details]
two sheets. 2nd sheet has text by ref to first sheet which cntl-f does not find
cleaner spreadsheet where sheet 2 has ref text from sheet 1. cntl-f does not find the ref text on sheet 2.
Comment on attachment 96722 [details]
two sheets. 2nd sheet has text by ref to first sheet which cntl-f does not find
one more try
Created attachment 96723 [details]
ref text on sheet 2 not found by cntl f
Closing this bug out. The cntl-f find will find value text but not computed text which is probably by design. I am not sure if I get the versions right, but 4.1 probably used Ctrl+H search dialog settings. So by then you could Ctrl+H, change settings, search for something and then Ctrl+F search would do the same thing. Right now since Ctrl+H does not affect the settings for Ctrl+F anymore, it is almost a duplicate of this: #102506 |
Created attachment 91746 [details] calc doc showing sheet 2 Search/Find bug Find does not not work on the attached CALC document in sheet #2. Find/Replace will however work but dialog defaults to formula and must be changed to Value for it to work. I suspect Find is somehow defaulting to a "Formula" search and there is no way in the Find dialog to reset this to "Value".