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.