OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

NumberFormat values for Date data types

Signature
C#
C#
 public sealed class DateFormat
Signature
vb.net
vb.net
Public NotInheritable Class DateFormat
Values

Name

Description

Anchor
DayMonthYear
DayMonthYear
DayMonthYear

d-mmm-yyyy;@ For example, 2-Feb-08.)

Anchor
DayOfWeekMonthDayYear
DayOfWeekMonthDayYear
DayOfWeekMonthDayYear

dddd, mmmm dd, yyyy (For example, Saturday, February 2, 2008.)

Anchor
FullTextMonthDayYear
FullTextMonthDayYear
FullTextMonthDayYear

mmmm d, yyyy;@ (For example, February 2, 2008.)

Anchor
FullTextMonthYear
FullTextMonthYear
FullTextMonthYear

mmmm-yy;@ (For example, February-08.)

Anchor
MonthDay
MonthDay
MonthDay

m/d;@
(For example 2/2 for February 2nd.)

Anchor
MonthDayYear
MonthDayYear
MonthDayYear

m/d/yy;@
(For example, 2/2/08.)

Anchor
MonthDayYearHourMinute12
MonthDayYearHourMinute12
MonthDayYearHourMinute12

m/d/yy h:mm AM/PM;@ (For example, 2/2/08 12:00 AM)

Anchor
MonthDayYearHourMinute24
MonthDayYearHourMinute24
MonthDayYearHourMinute24

m/d/yy h:mm;@ (For example, 2/2/08 0:00)

Anchor
MonthDayYearPreserveLeadingZero
MonthDayYearPreserveLeadingZero
MonthDayYearPreserveLeadingZero

mm/dd/yy;@
(For example, 02/02/08.)

Anchor
MonthSingleLetter
MonthSingleLetter
MonthSingleLetter

mmmmm;@ (For example, D for December or S for Septmeber.)

Anchor
MonthSingleLetterYear
MonthSingleLetterYear
MonthSingleLetterYear

mmmmm-yy;@ (For example, F-08 for February 2008.)

Anchor
TextDayMonth
TextDayMonth
TextDayMonth

d-mmm;@
(For example, 2-Feb.)

Anchor
TextDayMonthYear
TextDayMonthYear
TextDayMonthYear

d-mmm-yy;@
(For example, 2-Feb-08.)

Anchor
TextDayMonthYearPreserveLeadingZero
TextDayMonthYearPreserveLeadingZero
TextDayMonthYearPreserveLeadingZero

dd-mmm-yy;@
(For example, 02-Feb-08.)

Anchor
TextMonthYear
TextMonthYear
TextMonthYear

mmm-yy;@ (For example, Feb-08.)