Error alert check in Data Validation is reset after saving

Error alert check in Data Validation is reset after saving

Posted by: yyoshimura on 14 September 2023, 10:22 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 September 2023, 10:22 pm EST

  Hi,

  We have a workbook with data validation defined as list and we want to allow value not in the list when input manually , so we uncheck the “Show error alert after invalid data is entered” in the Data Validation tab. After saving the workbook using the library the check is turned on and we cannot enter values tha are not in the list. Please see attachment for reproduction.

  Please help to look at this issue. Thank you.

  Regards

  ConsoleApp1.zip

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 September 2023, 2:34 am EST

  Hi,

  Thanks for reaching out to us.
  
  We have replicated this issue. This seems like a bug. So, we have escalated this issue to the development team. Will get back to you once we have any update from them.[Internal Tracking Id - DOCXLS-8923]

  Best Regards,
  
  Nitin

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 16 October 2023, 8:09 am EST

  Hi,

  This issue is fixed in the latest 6.2.3 version. Please test with the latest 6.2.3 version.

  Regards,
  
  Nitin

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 25 October 2023, 5:02 am EST

  Thank you. We confirmed that it is working as expected in V6.2.3.