Greetings all -
A quick question about a possibly obvious matter:
- The Excel Reader doesn’t import formulas, only the “results” - is this right?
I’ve some “COUNTIF” functions that need to run, after Knime, for column summaries that I can’t achieve in Knime. As such, I’m trying to import the pre-prepared columns of Excel formulas so that when the output xlsx file is viewed, they match the relevant columns that Knime has so perfectly created for me.
- Example of pre-prep’d (summarising) formula: =IF(COUNTIF(CP2:CT2,“Non-Compliant”), “Non-Compliant”, “Compliant”)
When however, I import the “source” spreadsheet bearing the 4 columns of source formulas, I only see the default value (“Compliant”), not the formula.
I want the formulas to pass through Knime untouched, so they can operate once the resulting xlsx file is viewed in Excel. Is what I’m seeing “just the way it is” or am I doing something obviously foolish? -or is there a solution?