Thank you for the screenshot as it was very informative to what I should do with the data. I tried it, rebooted the systems and no dice. The log that has the error is coming from another program called Archibus which uses aspose cells to generate files off SQL databases. I am guessing Archibus can’t handle the ‘Data Validation’ formula.
I never did anything that php folder and pom.xml though because I did not understand where it fits in my system.
version = 2.0
Result code = ruleFailed
Result message = Exception thrown by com.CBEspace.eventhandler.common.SpaceExcelExport.export().
Result details = null
java.lang.IllegalArgumentException: Unsupported formula : =IF($C$9="",0,IF($E$9<7,'Data Validation'!L4,IF($C$9=7,"", IF($E$9<10,'Data Validation'!L5,IF($C$9="K",'Data Validation'!L6,IF($C$9<9,'Data Validation'!L6,IF($C$9>8,'Data Validation'!L7,0))))))).
at com.aspose.cells.Cell.a(Unknown Source)
is there an alternative way I can rewrite the formula so it does not use the Data Validation function but does the same thing?