PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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$"
See also
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment