Ask Your Question
0

How I can save a calc spreadhseet without formula

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

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 close merge delete

2 Answers

Sort by » oldest newest most voted
1

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

m.a.riosv gravatar image

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

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

Comments

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 +0200 )edit
0

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

pierre-yves samyn gravatar image

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

Hi

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

screenshot

  • 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.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 9,307 times

Last updated: Aug 01 '15