Error occurs when recalculating formulas
Hello!
When I try to recalculate Excel formulas using the ExcelRadar node on Windows 11 KNIME Ver5.3.0
and import them, I get an error like the one in the image and can’t get the data properly.
The formula and cell contents are as follows. Please refer to the attached Excel for details.
Cell A2: 2024/03 Column B(DAY): =IF(NOW()>DATE(YEAR(INDIRECT(“$A$2”)&“/1”),MONTH( INDIRECT(“$A$2”)&“/1”),DAY( INDIRECT(“$A$2”)&“/1”))+TIME(14,0,0),$A$2&“/1”,“”) Column C(Value): =IF($B3=“”,“”,ROUND(Sheet1!E3,))
※There is a formula error in the Value column, but it is displayed without any problems in Excel. If you recalculate and collect it in KNIME, an error will occur.
Does anyone know the cause and solution?
Thank you!