ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Type XLSCell: 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: 03/27/2025

Send a report | Local help