Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi All,

I've just had the same thing. I was working on a file, and found that
the formulas I put in would only show up as formula values, instead of
results. I made sure that the option for Display > Formulas was
unchecked, as suggested below, but this did not change anything. I even
tried checking it, then unchecking it, but neither one did anything.

As I was using LO I tried upgrading first to, and then; they all exhibit the same behaviour. In when you enter
a formula you get a blank cell, but if you change the cell formatting
it shows up as the formula value, instead of the result, and this
persists even if you then change the cell format back to what it was,
or even use undo. The previous versions all showed up as the formula
value when you first put it in, not a blank cell (IIRC).

Then, just to be sure, I tried in a new, blank spreadsheet, and it was
fine. It's only when working in this one file that I have a problem.
The file is a csv file. But surely, *surely*, that can't be the
problem? I know any formulas can't be _saved_ with a csv file, but I
need to do some quick calculations on the values in the file, and have
no intention of saving them, and if I did, I would obviously have to
save as a different file type.

Anybody else know of this problem? Is it time to file a bug report? I
can't but see this as a bug. I can change cell backgrounds, font
colour, use bold, underlined or italic text (I checked), and this can't
be saved with csv files, so why can I do all that but not use formulas?
When saving I get warned about features that may not be saved with the
file, but when editing the file, the underlying type it is saved as
should make no difference to LO's ability to do calculations. At the
very least I should be warned as to why formulas are not working,
rather than have them just not show any results (or worse in,
just show a blank cell).



On Mon, 26 Aug 2013 14:32:32 -0500
David Stuckey <> wrote:

Thanks to all.  It is amazing how such a little action can cause so
much anxiety.

David Stuckey, MBA. MHSA.

On Fri, Aug 23, 2013 at 11:01 AM, Pedro <> wrote:

Open Calc, go to Tools > Options. In the Options dialog click on
the plus sign to the left of LibreOffice Calc (on the left hand
tree)  and then on View.
Uncheck the option on the top right Display > Formulas

Hope this helps.

View this message in context:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more: List archive: All messages sent
to this list will be publicly archived and cannot be deleted

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.