ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Warning
From version 28, Spreadsheet.DeleteLine is kept for backward compatibility. This function has been replaced with <Spreadsheet>.DeleteRow.
Deletes a row from a Spreadsheet control.
Example
// Supprime les lignes 2 et 3
TBLR_MonTableur.SupprimeLigne(2)
TBLR_MonTableur.SupprimeLigne(3)
Syntax
<Spreadsheet control>.DeleteRow(<Row> [, <Worksheet>])
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Row>: Integer
Number of the line to be deleted, 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.
Component: wd300obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/20/2024

Send a report | Local help