PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
SpreadsheetInsertColumn (Function)
In French: TableurInsèreColonne
Inserts an empty column into a Spreadsheet control found in a window.
Example
// Inserts several columns
FOR I = 2 to 5
SpreadsheetInsertColumn(PSHEET_Spreadsheet, I)
END
Syntax
SpreadsheetInsertColumn(<Spreadsheet Control> [, <Column>])
<Spreadsheet Control>: Control name
Name of Spreadsheet control to use.
<Column>: Optional integer
Number of the column before which the new column will be inserted. For example, if this parameter is set to 2, the new column will be inserted at position 2. The existing columns will be moved to the right and the formulas will be updated.
If this parameter is not specified and if a column is selected in the control, the insertion will be performed before the selected column. Otherwise (no selected column), the function has no effect.
Remarks
  • The insertion operation is added into the list of operations to cancel: the user can cancel this operation via the popup menu or by pressing [CTRL] + Z.
  • This function can only be used on a Spreadsheet control found in a window.
Related Examples:
The Spreadsheet control Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control.
This example explains how to:
- load an xlsx file in a spreadsheet control,
- save the spreadsheet in a file,
- fill the control with data coming from the database,
- insert rows, columns,
- access the cells and handle them (modify their value, their style, ...),
- enter formulas,
- ...
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment