to convert formula to results or values on an open office spread sheethttp://www.oooforum.org/forum/viewtopic.phtml?t=16595
use paste special and un-tick 'all values' and tick all others except "formula'
this does the same as paste special - Values on MicroMouse Excel
the latest result of the formula is fixed in the cell or cells thus pasted.
this is useful for keeping a record of values at a given time, date.
why is this not in the Help