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" <[email protected]> wrote: > On 12 September 2013 19:44, Paul <[email protected]> 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: [email protected] 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
