ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / XLS file functions
  • Overview
  • Masks that can be used in the MaskWD property
  • Integer masks
  • Real masks
  • Date masks
  • Time masks
  • Date-Time masks
  • Duration masks
  • Currency masks
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
XLSCell type: MaskWD property
Overview
The MaskWD property of the xlsDocument type is used to define the display mask in WINDEV or WEBDEV format that will be used in the Excel cell ("DD/MM/YYYY" for example).
The specified mask is automatically converted into Excel format. The hundredths of a second found in the masks are not supported.
This help page presents the different masks that can be used.
Masks that can be used in the MaskWD property

Integer masks

Examples of masks available for the cells that display integers:
  • "9"
  • "999"
  • "999999"
  • "999 999"
  • "999 999 999"

Real masks

Examples of masks available for the cells that display reals:
  • "999 999, 999 999"
  • "999 999, 999999"
  • "999, 999"
  • "999999,9"

Date masks

Examples of masks available for the cells that display dates:
  • "MM/DD/YYYY"
  • "MM/DD/YYY"
  • "DD/MM/YY"
  • "DD-MM-YYYY"
  • "DD-MM-YY"
  • "DD MM YYYY"
  • "DD MM YY"
  • "Day:DD Month:MM Year:YYYY"

Time masks

Examples of masks available for the cells that display times:
  • "HH:MM:SS"
  • "HH:MM"
  • "HH"
  • "HH h MM"
  • "HH hr MM min"
  • "HH Hours MM Minutes SS Seconds"

Date-Time masks

Examples of masks available for the cells that display dates and times:
  • "MM/DD/YYYY HH:MM:SS"
  • "DD/MM/YY HH:MM"
  • "MM/DD/YY HH:MM:SS"

Duration masks

Examples of masks available for the cells that display durations:
  • "HH:MM:SS"
  • "D HH:MM:SS"
  • "D Days HH Hours MM Minutes"

Currency masks

Examples of masks available for the cells that display currencies:
  • "+999 999,99 $"
  • "999999,99$"
  • "+999 999,999999 $"
  • "999999,999 999$"
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help