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.hensc...@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+h...@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+h...@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
