Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rational number set with value as fractions lead to datetime formatting through excel workbook #1274

Open
3 of 11 tasks
MartinFijneman opened this issue Aug 11, 2023 · 0 comments
Projects

Comments

@MartinFijneman
Copy link

MartinFijneman commented Aug 11, 2023

Prerequisites

  • I have written a descriptive issue title
  • I have verified that I am running the latest version of the COMET-IME
  • 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.

image

This incorrect value with datetime formatting then appears in the IME as well.

image

(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):
    • Microsoft Excel (32/64 bit):
    • Windows OS (32/64 bit):
    • Additional information:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
COMET-CE
  
Awaiting triage
Development

No branches or pull requests

1 participant