Re: [libreoffice-users] Calc Question

Aha! It WAS the separator. Regina's answer to Chris Gummo is helpful
to me also. Thank you.

> > > SHOW FORMULAS ONLY SHOWS FORMULAS IN BOTTOM ROW<<<
I have another problem in LibreOffice Calc on Ubuntu 10.10. One can
display all formulas in a worksheet:  Calc > Tools > Options >
LibreOffice Calc > View > Display > (select) Formulas. The quick
keyboard toggle for this feature is Ctrl+~ (Control key + tilde
character on the left of the 1 key.)

However in my worksheets, the show formula option only seems to
display the formulas in the last (bottom) line of the worksheet. I
have not been able to find anywhere that this has been reported. If
this is a bug, I would appreciate it if it would be fixed, as this is
a most useful feature for troubleshooting worksheets.

Note: I am not very familiar with participating in mailing lists, and
not sure of how participants keep track of multiple discussions. If
I'm doing this wrong, please feel free to give me a clue. Well, more
than a clue... Thanks!

Roger

On Sun, Apr 10, 2011 at 4:40 PM, Regina Henschel
<rb.henschel@t-online.de> wrote:
> Hi Chris,
>
> Chris Gummo schrieb:
> > The formula that we use is below. We use it in the Data Vailidation
> > section
> > and not in every cell. I have not been able to get it to work.
> >
> > =COUNTIF(F4;K380,F4)=1
>
> Please have a look at the separators. I guess it should be
> =COUNTIF(F4:K380;F4)=1
>
> If you want to copy&paste the format, then I expect
> =COUNTIF($F$4:$K$380;F4)=1
>
> Kind regards
> Regina
>
> --
> 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

-- 
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