ONLINE HELP WINDEV, WEBDEV AND WINDEV MOBILE
Version: 15161718192021222324252627
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 the Spreadsheet control to be used.
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 research. Remark: this parameter is used to browse all cells containing a value. If this parameter is not specified or is an empty string (""), the search starts at cell "A1".
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 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 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 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: 05/26/2022
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: