Email Validation Fails for Copy-Pasted Entries from Excel in OpenCTI User Creation

[chance-capinia]

Description

When creating users in OpenCTI using information copied from an Excel spreadsheet, the email addresses are marked as invalid. However, manually typing the same email addresses results in them being recognized as valid. The email format appears correct in both cases.

Environment

1. OS: Windows 10
2. OpenCTI version: 6.4.6
3. OpenCTI client: Frontend
4. Browsers Tested: Microsoft Edge, Brave

Reproducible Steps

Steps to create the smallest reproducible scenario:

1. Navigate to Settings > Security > Users > Create User in OpenCTI.
2. Copy user details, including the email address, from an Excel spreadsheet.
3. Paste the email address into the Email Address field.
4. Observe that the email address is marked as invalid.
5. Manually type the same email address into the field.
6. Observe that the email address is recognized as valid.

Expected Output

Copying and pasting email addresses from an Excel spreadsheet should result in valid entries, identical to manually typing the email addresses.

Actual Output

Email addresses copied and pasted from an Excel spreadsheet are marked as invalid, even when the format is correct.

Additional information

• The issue occurs consistently with both Microsoft Edge and Brave browsers.
• The email format in the Excel sheet matches the required format.
• No extra spaces or formatting were apparent in the email addresses.

Screenshots (optional)

[nino-filigran]

I could not reproduce this bug ! Could you maybe share the excel (with dummy data perhaps) that you used so that I can try it again?