In ‘PM Administration’ – Tools\Repair Excel Template function - project and mode Excel names are added to Template so they are visible for Template designers with changed default value from “” to appopriate default value and data type.
PM_ID = -1
PM_NUMBER = ""
PM_CREATIONDATE = 1/1/1900
PM_PROJECT_CREATIONDATE ='1/1/1900
PM_LASTCHGDATE = 1/1/1900
PM_LASTQDVPATH = ""
PM_PROJECTVER = -1
PM_PROJECTVER_LETTER = ""
PM_ISACTIVE = FALSE
PMNewProject = FALSE
PMNewCopyProject = FALSE
PMEditProject = FALSE
PMDisplayProject = FALSE
Warning: Possible break in your Template – initially e.g. dates were stored in these Excel names as text e.g. 1.1.1900 – they were displayed properly in user’s locale but not as Excel dates (double numbers) so usual Excel date functions couldn’t be applied. Also in case a formula tested these names for default value “”, this formula is now incorrect as default values changed. However it is assumed that these date (and other) names were simply displayed or properly converted so the expected impact in current situation is no impact or only in rare cases.
The filter textbox in list windows now selects all text after selection of this control so user can immediately replace its value.