https://issues.apache.org/bugzilla/show_bug.cgi?id=55324
--- Comment #4 from [email protected] --- After few tests, * LEN(A1) works perfectly * MID(A1,4,2) works perfectly * IF (LEN(A1)>0, A1, A2) works perfectly * IF (1=1, MID(A1,4,2), A1) works bad * IF (1=1, A1, MID(A1,4,2)) works bad * IF (MID(A1,4,2)="ab", A1, "bad") works fine all formulas are re-evaluate before closing workbook. All works perfectly with XSSF but not with HSSF. are you sure there is no bug when combinating IF instruction and MID ? -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
