Re: [libreoffice-users] CALC: Show All Formulas only shows formulas in bottom line cells

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 users+help@libreoffice.org
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