UWP Excel DataValidations in a sheet is dissapear after workbook saved

UWP Excel DataValidations in a sheet is dissapear after workbook saved

Posted by: munemoto on 19 June 2021, 6:24 am EST

• 

  munemoto

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 June 2021, 6:24 am EST

  Hi,

  I want to know how to resolve.

  CompornetOne Excel for UWP ver.10.0.20211.739
  
  VisualStudio 2019 16.10.2

  1. Load from xlsx file exists. This xlsx workbook has DataValidations(List) in a sheet.
  2. I known the validations exist in sheet just before saving workbook using QuickWatch in VisualStudio.
  3. My program call workbook.SaveAsync and this method is done without exceptions.

  But, when I open this saved ExcelWorkbook, there is no validations in sheet.

  I want to resolve this problem.

• 

  kartik.sagar

  

  • Post Options:
  • Link
    Copy

  Posted 21 June 2021, 6:00 am EST

  Hi Tugu,

  Thank you for sharing the replication steps.

  We are able to reproduce this behavior and It seems like a bug. So, we have escalated it to the devs and will revert back to you when there is any update. [Internal Tracking Id - C1XAML-27690]

  Best Regards,
  
  Kartik

• 

  munemoto

  • Post Options:
  • Link
    Copy

  Posted 21 June 2021, 8:02 pm EST

  Thanks Kartik.

  I’ll wait your update.

• 

  kartik.sagar

  

  • Post Options:
  • Link
    Copy

  Posted 6 August 2021, 12:16 am EST

  Hi Tugu,

  We are happy to inform you that this issue has been fixed in the latest build 2021v2. So, I would request you to upgrade to the latest build.

  Best Regards,
  
  Kartik