Apache OpenOffice (AOO) Bugzilla – Issue 78917
Extended Calc-related Find and Replace options gone after executing macro
Last modified: 2017-05-20 11:11:15 UTC
Executing a recorded macro causes Calc to lose its extended Find and Replace options such as search in Formula, search in rows or columns, etc. 1. Restart OpenOffice 2. Open an empty spreadsheet 3. Open the Find&Replace dialog 4. Click the advanced options button 5. The Calc related options are there 6. Execute the macro below 7. Repeat steps 3. and 4. 8. The advanced options of Writer are shown instead of those of Calc This is pretty annying, since it does not even require to reopen the document, it needs a complete restart of the OpenOffice/StarOffice process, to get rid of this behaviour--and this everytime after you executed such a macro. BTW, the macro has been recorded with the macro recorder. sub testSearch rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ---------------------------------------------------------------------- dim args2(17) as new com.sun.star.beans.PropertyValue args2(0).Name = "SearchItem.StyleFamily" args2(0).Value = 2 args2(1).Name = "SearchItem.CellType" args2(1).Value = 0 args2(2).Name = "SearchItem.RowDirection" args2(2).Value = false args2(3).Name = "SearchItem.AllTables" args2(3).Value = false args2(4).Name = "SearchItem.Backward" args2(4).Value = false args2(5).Name = "SearchItem.Pattern" args2(5).Value = false args2(6).Name = "SearchItem.Content" args2(6).Value = false args2(7).Name = "SearchItem.AsianOptions" args2(7).Value = false args2(8).Name = "SearchItem.AlgorithmType" args2(8).Value = 1 args2(9).Name = "SearchItem.SearchFlags" args2(9).Value = 71680 args2(10).Name = "SearchItem.SearchString" args2(10).Value = "_" args2(11).Name = "SearchItem.ReplaceString" args2(11).Value = " " args2(12).Name = "SearchItem.Locale" args2(12).Value = 255 args2(13).Name = "SearchItem.ChangedChars" args2(13).Value = 2 args2(14).Name = "SearchItem.DeletedChars" args2(14).Value = 2 args2(15).Name = "SearchItem.InsertedChars" args2(15).Value = 2 args2(16).Name = "SearchItem.TransliterateFlags" args2(16).Value = 1024 args2(17).Name = "SearchItem.Command" args2(17).Value = 3 dispatcher.executeDispatch(document, ".uno:ExecuteSearch", "", 0, args2()) end sub
I checked with "2.2.1 Multilingual German version WIN XP: [680m18(Build9161)]" and can confirm the reported effect - without any knowledge what might have caused it.
Hi Niklas, please have a look at this one. Frank
Could you set a target milestone for a fix for this issue, please?
It has already a target: Later
Reset assigne to the default "issues@openoffice.apache.org".