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 <[email protected]> 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 <[email protected]> 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: [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 > > > > > -- 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
