https://bugs.documentfoundation.org/show_bug.cgi?id=151971
--- Comment #5 from [email protected] --- Created attachment 183513 --> https://bugs.documentfoundation.org/attachment.cgi?id=183513&action=edit Figures In my last comment, "Similarity Search" was suggested the cause of Calc aborted. The further tests were performed and I found issue, a. Whether the program aborts depends on Options settings for "Similarity Search" The followings are the test procedures and results. 1. Test File Only two cells are set as followings. A1: test1 B1: test2 2. Option Dialog of "Similarity Search" Refer attached pdf file: Report for Similarity Search - Only Figure .pdf I have one of options as checked one by one, set “Find string” as test1 and press “Find” button in Find&Search dialog. ("Similarity Search" was always enabled.) When three items, surrounded in Blue square in Figure1, were checked, Calc works properly. But, when one of items, surrounded in Red square, is checked, Calc was aborted. The combination of Checked items have not been tested because 2^19 trials were necessary. After aborted, started Calc and showed Option dialog box. The ALL items in Option dialog box were checked. The settings of options might be store as Calc itself properties, not stored in .ods file since the settings of Option dialog always shows that at which last Calc was closed, not depends on loaded .ods file. I propose that no item checked or only Case-sensitive checked is as default at aborted because Calc will be always aborted at performing search in FInd&Search dialog if without changing "Similarity Search" Options or disable "Similarity Search". 3. “Find” function in ToolStrip Automatic (Calc software) setting for Options settings for "Similarity Search" lets this issue complex. In “Find” function in ToolStrip, which located at the bottom of Calc. (see Figure3). When press “Up” or “Down” icon and search string successfully, Options settings for "Similarity Search" automatically changed to Only Case sensitive Check box is enabled and others are disabled. (see Figure 2) After is successful search, "Similarity Search" seems to be working properly until watching Option Dialog for "Similarity Search". 4. “Find” function message It may be a small issue. But I notice that a strange message is shown during above tests. Note that Shown messages in the following procedures are my translations to English from Japaneses, so there may be different in English version. I’m not sure that same issue occurs in your OS and software conditions. Only two cells are set as followings. A1: test1 B1: test2 Procedure 1 a. Set “test1” as the string for “Find” in “Find” function ToolStrip. b. Place cursor in any cell except A1. c. Press “Up” or “Down” icon one time. d. Selected cell move to A1. e. Press “Down” icon and shows “no string was found.” with changing the background color to Red. => should be shown as “reached to the end of the sheet”. f. Press “Up” icon and shows “reached to the end of the sheet”. Procedure 2 a. Set “test2” as the string for “Find” in “Find” function ToolStrip. b. Place cursor in any cell. c. Press “Up” or “Down” icon one time. d. Selected cell move to A2. e. Press “Down” icon and shows “reached to the end of the sheet”. f. Press “Up” icon and shows “reached to the end of the sheet”. 5. Version information of my Calc Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
