https://bugs.documentfoundation.org/show_bug.cgi?id=158185
--- Comment #2 from Vladimir Sokolinskiy <[email protected]> --- Hello Eike! Thank you very much for your answer! For myself, I distinguish between the worlds of “VBA” and “Excel”. Your first link is to the Like operator of the "VBA" world. I don't know of Excel worksheet functions or Excel object methods that support the Like operator wildcard character set. By the way, the Excel Range.Find method, in addition to laconic documentation, has a number of, let’s say, not generally known features. For example, macro (Excel VBA) Sub test() Dim r As Range Set r = Cells.Find(What:="#", LookIn:=xlValues, lookat:=xlPart, SearchFormat:=False) MsgBox r.Address End Sub will find, among other things, cells with numeric content in which “###” characters are displayed due to insufficient column width. It is unlikely that this behavior should be taken into account when emulating the Range.Find method in Calc. :) -- You are receiving this mail because: You are the assignee for the bug.
