Hi!
F9 seems to be assigned to ReCalculate as default, but it seems like it
doesn't work in all situations.
If I enter a formula, such
as =RAND()*18, the result of the cell in which I entered it changes
everytime I hit F9, but some formulas does not just change!
=RAND.BETWEEN(0;100)
I am not sure about its name since I translated it from Swedish, but it
shows the same value every time I hit F9. It only changes when I reenter the
whole formula.
I also made a function of my own, which I mentioned in another thread:
Function ACellF() As String
ACellF=ThisComponent.getCurrentSelection.getFormula()
End Function
This one is supposed to show the formula of the currently selected cell. I
can only make it do that in one way:
1. Add the ACellF macro to MyMacros/Standard.
2. Enter the following in B1:
=ACELLF()
3. Enter the following in A1:
=RAND()*18
4. Click on A1.
5. Click Tools->Options->OpenOffice.org Calc/Calculate->Iterations->OK.
6. B1 now shows =RAND()*18.
It doesn't matter if the Iterations checkbox was ticked or not, just
changing it from one to the other makes my function to work. Then, if I
select another cell than A1, I expect B1 to change to the formula of the now
selected cell, but that doesn't happen until I do step 5 again.
So what do you guys here say? Bug or should it be like this? Is there a way
to write a cell formula like mine that actually works? Other comments?
Please don't mention the war or superbowl.
Johnny Andersson
