Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 28 May 2014 22:39:22 +0200Always show formula in input/formula bar, even after closing Calchttps://ask.libreoffice.org/en/question/34712/always-show-formula-in-inputformula-bar-even-after-closing-calc/In Calc, is there a way to keep a formula visible when you click on a cell, even after saving a closing/re-opening a Calc document? Currently after the formula is used, upon re-opening the spreadsheet it only displays the formulas **results** in the input line. I would like to have the formula's visibility retained in the input/formula line at all times. Only in the cell do I wish to have the formulas output displayed. Wed, 28 May 2014 16:39:12 +0200https://ask.libreoffice.org/en/question/34712/always-show-formula-in-inputformula-bar-even-after-closing-calc/Comment by Lupp for <p>In Calc, is there a way to keep a formula visible when you click on a cell, even after saving a closing/re-opening a Calc document? Currently after the formula is used, upon re-opening the spreadsheet it only displays the formulas <strong>results</strong> in the input line. I would like to have the formula's visibility retained in the input/formula line at all times. Only in the cell do I wish to have the formulas output displayed. </p>
https://ask.libreoffice.org/en/question/34712/always-show-formula-in-inputformula-bar-even-after-closing-calc/?comment=34715#post-id-34715What you want is default and I never observed a behaviour as you described it. The only way I know to exclude formulae from showing in the edit control is using the protection tool. Can you describe in detail what you did before closing and reopening your Calc file?Wed, 28 May 2014 16:56:20 +0200https://ask.libreoffice.org/en/question/34712/always-show-formula-in-inputformula-bar-even-after-closing-calc/?comment=34715#post-id-34715Comment by m.a.riosv for <p>In Calc, is there a way to keep a formula visible when you click on a cell, even after saving a closing/re-opening a Calc document? Currently after the formula is used, upon re-opening the spreadsheet it only displays the formulas <strong>results</strong> in the input line. I would like to have the formula's visibility retained in the input/formula line at all times. Only in the cell do I wish to have the formulas output displayed. </p>
https://ask.libreoffice.org/en/question/34712/always-show-formula-in-inputformula-bar-even-after-closing-calc/?comment=34721#post-id-34721Please, what file format do you use to save?Wed, 28 May 2014 22:39:22 +0200https://ask.libreoffice.org/en/question/34712/always-show-formula-in-inputformula-bar-even-after-closing-calc/?comment=34721#post-id-34721