To avoid errors when using multiple cell formats for numerical data where monetary values could be stored in the cells, only format the cells in which the data is entered. For example, you can format both the lo-tax and hi-tax versions of the cell so that the entry automatically conforms to the active number format. If you use either the m- or d-numeric format, the system will try to determine the appropriate format for the data. For example, if you enter 3.00 in a m-numeric cell, the system will detect that you are trying to put a numeric value into that cell and auto-format the value to d-numeric. The problem is that the user may not notice that the data has been changed to the wrong format and then try to filter by date or change the data type in the report.
This issue led to several reports of "select by date" reports not working when the date expressed in the column always matched the value of the original date text. We have now added logic that looks at the date format in each table. If it uses a date format that matches the format of the original date, we will leave the formatting in place and continue down the table. Otherwise, we will leave the date format as it is because it was provided by the user.
The rules for autoformatting are based on the AssignedDateFormat property. There are two settings, AssignedDateFormat and AssignedDateFormatMask. Both settings can be loaded into the system using AUTOLOAD. Using the AssignedDateFormat property is the best approach if the format of the table always matches the format of the original data. In that case, no formatting is done and the data type used by the browser is left intact.
If the AssignedDateFormat is not used for the table, then the user could modify the date format on the cells. If the AssignedDateFormat was set to "dd/mm/yyyy", the user changes it to "dd/mm/yyyy". When the table is sorted, the AssignedDateFormat could change and then the system would try to switch to debug back to the original date format, which would return the values to the correct date format. d2c66b5586