The reality is that the POI formula support is incomplete and noone is working on it. POI is a volunteer project and if you want to submit fixes, they will be reviewed.
If you want someone else to create a fix log an issue in https://bz.apache.org/bugzilla/ There are no guarantees that anyone will look into though. On Thu, 20 Feb 2025 at 14:16, Fabio Ebner <[email protected]> wrote: > > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
