Ask Your Question

How I can save a calc spreadhseet without formula [closed]

asked 2013-08-15 12:53:13 +0100

saji gravatar image

Hi All, . My Spreadsheet contains a lot of sheets and formulas linked each other. It is confusing to normal reader. How I can hide or save it (in calc format) without formulas, showing only the results (values/texts).

Thanks for your help -saji

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-23 11:12:27.108034

2 Answers

Sort by » oldest newest most voted

answered 2013-08-16 01:43:27 +0100

m.a.riosv gravatar image

updated 2015-08-01 04:29:55 +0100

I do not know any option to save only values.

But it is possible in a few steps convert all formulas to values and then save the file.

  • Go to A1 in the first sheet.
  • Select all sheets. (Click the first tab, click the last tab while Shift is pressed)
  • Select all cells: Crtl+A (Menu/Edit/Select all)
  • Paste special only the text: Ctrl+Shift+V (Menu/Edit/Paste special)
    • Deselect Past all
    • Select Numbers.
    • Deselect Formulas.
    • Ok.

Only numbers and text must be there.

Save the file with other name to avoid destroy the source file.

edited 2015-08-01

Since 4.4 there is an option to convert selected cells in their values.

Menu/Tools/Cells content/Formula to values.

edit flag offensive delete link more


Amendment: Between "selecting all cells" and "paste special" it is necessary to copy all the selection into clipboard, e.g. by Ctrl+C.

It helped me, thanks.

GoodMirek gravatar imageGoodMirek ( 2015-07-30 10:40:47 +0100 )edit

Just to say in 6.0 it is Menu/Data/Calculate/Formula to value.

Andrew B 512 gravatar imageAndrew B 512 ( 2020-02-17 22:26:58 +0100 )edit

answered 2015-08-01 08:31:15 +0100

pierre-yves samyn gravatar image

updated 2015-08-01 08:33:10 +0100


It is not necessary to save the spreadsheet without formula. Just ask Calc hide formulas:

  • Display the styles window (sidebar)
  • Right click on Default then Modifiy
  • Cell Protection tab check Hide formula


  • To (dis)enable the protection (on every concerned sheet): Tools Protect Document Sheet.

We can even set a password. Please note this protection is limited and less secure than password-protection document. No password in HideFormula.ods attached.


edit flag offensive delete link more

Question Tools



Asked: 2013-08-15 12:53:13 +0100

Seen: 13,963 times

Last updated: Aug 01 '15