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

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?


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

On 12 September 2013 19:44, Paul <> 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:
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.