ReadRangeX : ReadFormatting - Null does not inherit parent settings

Feedback Activities
, ,
1

Hi team,

This is a bug report.
It seems that ReadFormatting property of ReadRangeX does not work correctly if it’s set to null.
In the official documentation, it says "Null means that the formatting options are the same as for the parent card. ".

image
image1000×142 6.53 KB

However, if null is set in ReadFormatting of ReadRangeX and is set RawValue in UseExcelFile, it doesn’t return raw value (returns string). If RawValue is set in ReadFormatting of ReadRangeX explicitly, it returns raw value.
The following is reproducing sample for it.

The image shows a UiPath workflow snippet that reads data from an Excel file using two different read formatting options and displays the data types of the read values in a message box. (Captioned by AI)
The image shows a UiPath workflow snippet that reads data from an Excel file using two different read formatting options and displays the data types of the read values in a message box. (Captioned by AI)1354×912 58.9 KB

Environment : Studio 23.10.7 + Excel activities (2.23.4 or 2.22.4)

Sample
Sample20240731-4.zip (9.8 KB)

Hopefully there will be a fix for this problem soon.

Regards,