- 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
XLSCell type: MaskWD property
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$"
This page is also available for…
|
|
|
|