In Calc, Tools > Options > LibreOffice Calc > View is the option to display formulas in the cells (as opposed to the cell entry dialog window at the top of the screen.) This option can be quick-toggled by Ctrl-~ (e.g. holding the Control key down while tapping the ~ tilde key on the left of the 1 key.)
However in my XLS worksheets which I use in LibreOffice Calc, this option reveals only the formulas in the bottom row of cells, although many cells above contain formulas as well. I have not seen this behavior reported anywhere. If this is indeed a bug, fixing it should be important, as it is a key feature that greatly facilitates troubleshooting problems in worksheets. Actually, I mentioned this in another mailing list post, then discovered that the mailinglist entries were being posted on a web-based archive -- so I decided I should post my original report here so it could be found. -- View this message in context: http://nabble.documentfoundation.org/CALC-Show-All-Formulas-only-shows-formulas-in-bottom-line-cells-tp2804590p2804590.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
