I’m making a macro to set a formula in a cell with EDATE in the middle, one of the formulas that I need is:
but the result is making “EDATE” lowercase and breaking the cell data:
I have others cells in this sheet that use EDATE and all the others functions stay uppercase after running the macro, except EDATE that goes lowercase… Is there any way to force it keep uppercase?
This is the code that I’m using for the example above:
sDESPESAS=ThisComponent.Sheets.getByName("DESPESAS") firstRowD=10 sDESPESAS.getCellByPosition(7,firstRowD-1).setFormula("=IF($F"&(firstRowD)&">TODAY();"""";EDATE($G"&(firstRowD)&";$E"&(firstRowD)&"))")