Some formula one @ are added

[fabioebner]

I trying to genereate one xlsx file. with a fomrula in a cell a basic formula

=IF(I2="";"";CONCAT(I2;LEFT(T2;1)))

but when I open the excel the formula was changed to

=@if(I2="";"";CONCAT(I2;LEFT(T2;1)))

and the cell dont show anything until I manually remove the @

this is my code:

ws.formula(dataRowIndex,coluna.getXlsxColumnOrder(),xmlEscape(formula));

and the xmlEscape method

    public static String xmlEscape(String input) {
        if (input == null) {
            return null;
        }

        // A ordem de substituição é importante para evitar substituições duplas
        // Primeiro substituímos '&', para não "bagunçar" as substituições dos outros caracteres.
        String escaped = input.replace("&", "&");

        // Agora substituímos os demais.
        escaped = escaped.replace("<", "&lt;");
        escaped = escaped.replace(">", "&gt;");
        escaped = escaped.replace("\"", "&quot;");
        escaped = escaped.replace("'", "&apos;");

        return escaped;
    }

[rzymek]

Could you provide a complete code sample that reproduces the problem?
I've tried this and I worked fine (at least in google sheets, I don't have a windows machine at hand now)

    @Test
    void testForIssue512() throws Exception {
        writeWorkbook(wb -> {
            Worksheet worksheet1 = wb.newWorksheet("Sheet1");
            worksheet1.value(0,0,"a1");
            worksheet1.value(1,0,"a2");
            worksheet1.formula(1,1,"IF(A1=\"\",\"\",CONCAT(A1,LEFT(A2,1)))");
        },"512.xlsx");
    }