[libreoffice-users] Write Protection Locked
Trying to edit a master (.odm) document. Write protection is locked on. Ctrl+Shift+M removes the 'Read Only' note at head of page, but edit access is still barred. Suggestions? Gordon. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc CountIf Alternative/Work Around
On 09/09/2017 05:18 PM, Brian Barker wrote: > Yup. Your syntax is almost right, but not quite. You need: > COUNTIF(Slant.B38:Slant.B1038;">"_Slant.B44) Thanks. That worked. > You can no doubt see that COUNTIF() expects an inequality to be > expressed as a text string. So ">1234" will work, but not ">A1", since > that "A1" will not be seen as a cell reference. If you need to > incorporate a cell reference, you need to concatenate the ">" sign with > the value in the cell, which will automatically be converted to text > because of the context of the reference. This looks like one of those basic things that I should have known, but somehow or other missed. :( Now wondering how many other things I've missed/skipped over, without realizing it. jonathon -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc CountIf Alternative/Work Around
At 16:42 09/09/2017 +, Jonathon Kantoor wrote:
In the spreadsheet I'm working on, I'm trying to find the number of
items that are more than 6 standard deviations from the norm.
Standard deviation formula is StDev(Slant.B38:Slant.Slant.B1038)).
That formula works. The obvious solution, as expressed in the
formula COUNTIF(Slant.B38:Slant.B1038,>IQ_Slant.B44) does not work.
Error # 510: Missing Variable. Using quotation marks for the
criteria to search by (">IQ_Slant.B44") does not work. Is there a
way to count the number of cells whose value is greater than the
variable, when the variable is the value found in a specific cell?
Yup. Your syntax is almost right, but not quite. You need:
COUNTIF(Slant.B38:Slant.B1038;">"_Slant.B44)
You can no doubt see that COUNTIF() expects an inequality to be
expressed as a text string. So ">1234" will work, but not ">A1",
since that "A1" will not be seen as a cell reference. If you need to
incorporate a cell reference, you need to concatenate the ">" sign
with the value in the cell, which will automatically be converted to
text because of the context of the reference.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc CountIf Alternative/Work Around
All:
In the spreadsheet I'm working on, I'm trying to find the number of
items that are more than 6 standard deviations from the norm.
Standard deviation formula is StDev(Slant.B38:Slant.Slant.B1038))
That formula works.
The obvious solution, as expressed in the formula
COUNTIF(Slant.B38:Slant.B1038,>IQ_Slant.B44) does not work.
Error # 510: Missing Variable.
Using quotation marks for the criteria to search by (">IQ_Slant.B44")
does not work.
Is there a way to count the number of cells whose value is greater than
the variable, when the variable is the value found in a specific cell?
jonathon
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Mysql Native Connector for LO 5.4
Le 08/09/2017 à 18:10, H. Stoellinger a écrit : Hi Heinrich, > environment together with LO 5.4.1. Is there a native connector (64-bit, > Linux-Mint 18.2)? The distro provided version of the native connector for Linux Mint 18.2 only works with 5.1.6.x I believe ? Of course, there is no native connector for any of the snap/PPA versions of LibreOffice nor I suppose for the 5.4.x version of LibreOffice from the TDF download site. The only place to find such a native connector would be the extensions website... Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
