ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Warning
From version 28, SpreadsheetDeleteLine is kept for backward compatibility. This function is replaced by SpreadsheetDeleteRow.
Deletes a row from a Spreadsheet control.
Example
// Deletes the rows 2 and 3
SpreadsheetDeleteRow(PSHEET_MySpreadsheet, 2)
SpreadsheetDeleteRow(PSHEET_MySpreadsheet, 3)
Syntax
SpreadsheetDeleteRow(<Spreadsheet control> , <Row> [, <Worksheet>])
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Row>: Integer
Number of the row to delete, for example: 1.
The row numbers start from 1.
The function has no effect if this parameter is not valid.
<Worksheet>: Optional integer
Number of the worksheet to use. If this parameter is not specified, the current worksheet is used.
The function has no effect if this parameter is not valid.
Remarks
After the function execution:
  • the rows found below the deleted row are shifted to the top.
  • the content of expressions is renamed.
Business / UI classification: UI Code
Component: wd290obj.dll
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/15/2022

Send a report | Local help