OT: OOo Calc Formula

[Robert Bell <robert@xxxxxxxxxxxxxxxxx>]

I have an Excel sheet I need to use in OOo but I am having trouble with 
one formula. In excel this will return the Sheet Name:

=RIGHT(CELL("filename",A1),SUM(LEN(CELL("filename",A1))-SEARCH("]",CELL("filename",A1),1)))

Now I know the delimiter in OOo is #$ not ] but I cant seem to get this 
to work.. If anyone has a suggestion I would appreciate it.