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

Hi T. R.,

Thanks, but as I stated in my original email, changing the cell
formatting doesn't do anything. I've tried a number of different
formats, including percent, currency, number and text, as well as
clearing direct formatting.

That said, I did redo my experiment (for about the 10th time), but this
time I put the formula in a new column to the right of the existing
data, and it worked fine. However, when I do as previously, and make a
new column B, and put the formula in there, it still doesn't work.
Actually, now that I experiment, it seems to work in any column I put
the formula, existing or new, provided it isn't between the
original first two columns.

I created a minimal sample file (I would attach, but I think it will be
stripped out of the email?), and tried again. When I put the formula in
a column to the right of the existing data, it works, but when I create
a new column B and put the formula there, I get the formula value
instead of the result. When I save it and then open it in a plain text
editor, I see that in the column that worked, the result is saved, but
in column B the formula value is saved. However, when I then open the
file in LO again, now both columns show the result, although the
originally working one is of course just a number. And I can still not
get the result when putting a formula into a newly created second
column. I note that it works fine if I put it in column B *without*
creating a new column, but any newly created column between the
original columns A and B will not show a formula result.

This is very strange. It's as if creating a new column B somehow marks
it as not for formulas.

And I tested it in a normal ods file, and it doesn't exhibit this
behavior, only in csv files.

Any ideas anybody?

Paul



On Thu, 12 Sep 2013 19:53:30 -0500
"T. R. Valentine" <trvalentine@gmail.com> wrote:

> On 12 September 2013 19:44, Paul <paulsteyn1@afrihost.co.za> wrote:
>
> > 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.
>
> Make sure the cell is not formatted as text.
> Format -> Cells, Numbers tab, under 'Category'


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