[DATA LOSS] Write Cell can cause data loss (it writes over the entire worksheet in random cells if a comment is present in the xlsx file)

I found out about this issue when I wanted to comment on one specific input record via comment in Excel file. I cannot share the file, but when I opened it after the bot threw the exception I was glad I keep lots of backups… (it wasn’t even close to being recoverable).

Scenario: User wants to save a single cell to the specified Excel file that might contain some comments in the cells

Steps to reproduce: Write Cell to an Excel file that has a comment in one of the cells

Current Behavior: Studio throws an exception as below. Output Excel file now contains scrambled data (effective loss of data occurs)

image

Expected Behavior: Write Cell only writes what it is supposed to to the single cell

Studio/Robot/Orchestrator Version: Studio 2018.2.3

Last stable behavior:
Last stable version:
OS Version: Win 10 Enterprise 1703 64bit
Others if Relevant: (workflow, logs, .net version, service pack, etc): Run the example and open both files afterwards to see the bug in action: Write Cell bug.zip (14.4 KB)

My version of UiPath.Excel.Activities package:

2 Likes