ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
  • Spreadsheet control
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
The Content property is used to read or write the whole content of a control:
  • List Box populated programmatically,
  • Combo Box populated programmatically,
  • WINDEV Spreadsheet.
This allows you to read or write all the rows in the control in a single line of code.
Remark: On a List Box or Combo Box control based on a data file, you can only read the list of elements.
Example
// Adds elements to the current content of the List Box control
LIST_List1.Content = LIST_List1.Content + CR + "Tommy" + CR + "Emma"
WINDEVUser code (UMC)
n is int
// Add the row into the Table control (the Combo Box column being the 2nd one)
n = TableAddLine(TABLE_Table1, "1", "c2")
// Modify the content of the Combo Box column for the added row
// Note: Return values are used via gStoredValue,
// therefore, this option must be enabled in the description of the column
TABLE_Table1.COL_ComboBox[n].Content = "computer 1" + gStoredValue("c1") + CR + ...
"computer 2" + gStoredValue("c2")
Syntax

Getting the content of a Spreadsheet control, or a List Box or Combo Box populated programmatically Hide the details

<Control content> = <Control used>.Content
<Control content>: Character string
List of elements for the content of the control. Elements are separated by CR characters.
WINDEV For Spreadsheet controls, this content is in binary format. This content can be saved with fSaveBuffer.
<Control used>: Control name
Name of the control to be used. This control must be:
  • a List Box control populated programmatically,
  • a Combo Box control populated programmatically,
  • a table column of type "List of values",
  • WINDEV a Spreadsheet control.

Changing the content of a Spreadsheet control, or a List Box or Combo Box populated programmatically Hide the details

<Control used>.Content = <Control content>
<Control used>: Control name
Name of the control to be used. This control must be:
  • a List Box control populated programmatically,
  • a Combo Box control populated programmatically,
  • a table column of type "List of values",
  • WINDEV a Spreadsheet control.
<Control content>: Character string
List of elements displayed in the control. Elements are separated by CR characters.
WINDEV For Spreadsheet controls, the content displayed is in binary format. You can use the fLoadBuffer function.
Remarks
WINDEV

Spreadsheet control

The Content property is used to get and modify the binary content of the Spreadsheet control. For example:
PSHEET_Show.Content = fLoadBuffer(fExeDir()+"\Fashion Showxls")
This property is equivalent to the Value property.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/16/2024

Send a report | Local help