Why can’t I do this?
(The problem is that “=A1” isn’t being substituted with the value of the cell it’s referring to)
It is not possible. You can add the request for enhancement in Bugzilla