Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

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 4.0.3.3 I tried upgrading first to 4.0.5.2, and then
4.1.1.2; they all exhibit the same behaviour. In 4.1.1.2 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 4.1.1.2,
just show a blank cell).

Thoughts?

Paul



On Mon, 26 Aug 2013 14:32:32 -0500
David Stuckey <dgstuckey25@gmail.com> 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 <pedlino@gmail.com> 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:
> > http://nabble.documentfoundation.org/Formulas-in-text-instead-of-result-LO-Calc-tp4071257p4071306.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more:
> > http://wiki.documentfoundation.org/Netiquette List archive:
> > http://listarchives.libreoffice.org/global/users/ All messages sent
> > to this list will be publicly archived and cannot be deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted