TestProject Forum

When entering data in Google Sheets, can't I keep the existing formatting?

In the existing Excel file, I made a selection box format for Pass or Fail in Drop box.
However, if you use the [Update Value in Column and Row] add-on, text is entered without the formatting of the existing Excel file.
Is there a way to keep the format and only update the data?

Hi @jy_test thanks for reaching out.
The data is streamed as a normal text (string) at the moment it is not possible to override the file format from the addon.
it is possible to use robot actions to reformat the file after the test is finished as part of the automation flow.
If you have any other questions feel free to ask :slight_smile:

1 Like