Problem with Formula Added an @ when open in Excel
Fabio Ebner <[email protected]> Thu, 20 Feb 2025 10:15:18 -0300
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <CABuOS-wn2MaST6c0GkTVTY_CtBMcAQ2zEjHPWi89xKASyNJB=A@mail.gmail.com> |
--000000000000eb8b38062e92ab88 Content-Type: text/plain; charset="UTF-8" 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 --000000000000eb8b38062e92ab88--