rtimai wrote:
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.
Can you post a sample file that shows this and post a link back here?
Sounds strange but remember that by not using ODF formats for your
working files can cause problems. What happens if you save as .ods then
reopen?
Andy
--
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
