I just tried to write a macro, ACellF (ActiveCellFormula) for it. It didn't
work at all...
Function ACellF() As String
ACellF=ThisComponent.getCurrentSelection.getFormula()
End Function
I entered =ACELLF() in a cell and all that showed up was "=ACELLF()",
regardless which cell was selected. However, the function worked when called
in a macro, but obviously not as a cell function. If someone knows why it
doesn't work, I would be happy to know too...
I also XRayed it and it showed the formula of the currently selected cell.
Johnny Andersson
