[x] I have verified that I am running the latest version of the COMET-IME
[x] I have searched open and closed issues to ensure it has not already been reported
Description
Rational number set with value as fraction corresponding to a valid date incorrectly turned to datetime formatting through excel workbook
For scale with rational number set, the idea is that a value can be provided as ratio, e.g. 3/45. If the provided rational number is applicable to it, at one point during testing this was turned into a datetime format: provided value of 3/21 was turned into date time for 21st of March.
This occurs when a workbook is used: upon rebuilding, in the workbook the rational number is changed into a date: 3/21 is turned into 21/3/2023. This is then a change, that is taken over in any subsequent submit action.
The value can be submitted to the server.
This incorrect value with datetime formatting then appears in the IME as well.
(Note that in the test, I accidentally switched the intended values to be provided in the element definitions, leaving the descriptive names (inside/ outside date range) misleading and incorrect, so please consider these ED names obsolete; the issue should be clear however)
Steps to Reproduce
Logs
[ ] There are no logs regarding the issue
{ ] I have attached a log file or included the relevant section in this issue
System Configuration
COMET version:
[ ] COMET-IME:
[ ] Other:
Web Services:
[ ] CDP4/COMET Web Services version:
[ ] OCDT WSP version:
Environment (Operating system, version and so on):
Prerequisites
Description
Rational number set with value as fraction corresponding to a valid date incorrectly turned to datetime formatting through excel workbook
For scale with rational number set, the idea is that a value can be provided as ratio, e.g. 3/45. If the provided rational number is applicable to it, at one point during testing this was turned into a datetime format: provided value of 3/21 was turned into date time for 21st of March. This occurs when a workbook is used: upon rebuilding, in the workbook the rational number is changed into a date: 3/21 is turned into 21/3/2023. This is then a change, that is taken over in any subsequent submit action. The value can be submitted to the server.
This incorrect value with datetime formatting then appears in the IME as well.
(Note that in the test, I accidentally switched the intended values to be provided in the element definitions, leaving the descriptive names (inside/ outside date range) misleading and incorrect, so please consider these ED names obsolete; the issue should be clear however)
Steps to Reproduce
Logs
System Configuration