I create an project that create one xlsx file. In this file I have some formulas and in some formulas when I open in Excel an @ are added inside.
For sample: The formula that I insert IF(I2="","",CONCAT(I2,LEFT(T2,1))) The formula that show when I open in a Excel =@IF(I2="","",CONCAT(I2,LEFT(T2,1))) And the Excel dont show the value. I need to remove mannualy the @ to works this is my code: String formulaOriginal = coluna.getXlsxColumnFormula(); Cell cell = dataRow.createCell(coluna.getXlsxColumnOrder()); cell.setCellFormula(formula); cell.setCellStyle(style); I have anothers formulas in my code for sample: IF(Q2="Engineering",CLEAN(K2),IF(CLEAN(O2)<>"",O2,IF(P2=M2,"",IF(ISNA(VLOOKUP(P2,''Not Order Writer''!A:A,1,FALSE)),IF(ISNA(VLOOKUP(P2,''Not Order Writer''!B:B,1,FALSE)),CLEAN(P2),"Reduce Commission"),"")))) and in this formula the excel DONT put the @ can anyone help me? tks
