Add a way to replace formulas with their current values, to "bake them in".
It seems done in 4.4 https://wiki.documentfoundation.org/ReleaseNotes/4.4#Direct_conversion_of_formulas_into_static_values Small issue with this: after insert value doesn't updated Input line until click on cell for update.
This has already been implemented as Maxim said above.