I have a data file, linked to an Excel worksheet, which has been used for some time without issues.
Following the Katalon Studio 7 update (we upgraded from 6.3.3 to 7.0.3 and since to 7.0.5), a timestamp value in my data sheet shows as ‘#VALUE!’, presumably an error in displaying the value from Excel.
Within my Excel data sheet, I have a ‘Timestamp2’ column (N) that uses the following formula, which joins a date value from one cell, with a ‘T’ value and a timestamp from another cell:
TEXT(K2,“yyyy-mm-dd”)&“T”&TEXT(L2,“hh:mm:ss”)
Additionally, I have a ‘Timestamp’ column (G) which looks to the value from column N, e.g. ‘=N2’.
Other formulas continue to work fine, but presumably changes within Katalon have affected the ability to utilise the ‘TEXT’ formula. I have attached an image for reference, but can this please be investigated?
We only updated the POI library recently. Can you share the Excel file ? If you create a new project and a new Test Data with that Excel file then does the problem still persist ?
Thanks for the feedback. Can I share the Excel file via email rather than through the forum?
I have tried to create a new project via Katalon (File > New > Project) although there is no response when doing this. I am not sure if this is a known issue?
@ThanhTo, The cell ‘A’ which shows as #VALUE! is not used in my test cases but the other cell ‘B’ which refers cell ‘A’ for its value is empty in data file with excel import.
Cell ‘A’ marked in red & cell ‘B’ is marked in blue in below screen shot.
