ONLINE HELP WINDEV, WEBDEV AND WINDEV MOBILE
Version: 151617181920212223242526
Name of cell found ("A1" for example). If several cells are found, <Result> contains the name of first cell found. "" (empty string) if no cell is found.
Name of Spreadsheet control to use.
Value to find in the cells of Spreadsheet control. This value can correspond to a number or to a character string.
Name of the from which the search will be performed. This cell is excluded from the search. Remark: this parameter is used to browse all cells containing a value. If this parameter is not specified, the search is performed from the "A1" cell.
Versions 23 and laterSearch options: psheetSearchWithCaseSearch while taking the case into account. psheetSearchContain"Contains" search. psheetSearchInFormulaSearch in the formulas only. psheetSearchExact"Exact" search. psheetSearchCurrentWorksheetSearch in the current worksheet. psheetSearchNoCaseSearch while ignoring the case. psheetSearchAnyWorksheetSearch in all worksheets of workbook. By default, the search is performed according to the following combination of constants: psheetSearchWithCase + psheetSearchCurrentWorksheet + psheetSearchExactNew in version 23Search options: psheetSearchWithCaseSearch while taking the case into account. psheetSearchContain"Contains" search. psheetSearchInFormulaSearch in the formulas only. psheetSearchExact"Exact" search. psheetSearchCurrentWorksheetSearch in the current worksheet. psheetSearchNoCaseSearch while ignoring the case. psheetSearchAnyWorksheetSearch in all worksheets of workbook. By default, the search is performed according to the following combination of constants: psheetSearchWithCase + psheetSearchCurrentWorksheet + psheetSearchExactSearch options: psheetSearchWithCaseSearch while taking the case into account. psheetSearchContain"Contains" search. psheetSearchInFormulaSearch in the formulas only. psheetSearchExact"Exact" search. psheetSearchCurrentWorksheetSearch in the current worksheet. psheetSearchNoCaseSearch while ignoring the case. psheetSearchAnyWorksheetSearch in all worksheets of workbook. By default, the search is performed according to the following combination of constants: psheetSearchWithCase + psheetSearchCurrentWorksheet + psheetSearchExact
Last update: 09/22/2020
Send a report | Local help
Searching...
I accept the terms of the license agreement
All you have to do is configure your product as follows: