Re: [libreoffice-users] Calc function COUNTA
From the help COUNTA(Number 1 [; Number 2 [; … [; Number 255]]]) where*Number 1*, *Number 2*, ..., *Number 255* are numbers, references to cells or to cell ranges of numbers. * The function counts numbers, dates, error values(Err:502), logical values (like TRUE ) or a text representation of numbers (like "7") passed either as arguments or a reference to the cells or as an array however, empty cells in the reference are not counted. In your case ISBLANK=0 is seen as Number 2 which is a logical value and so is counted as 1. Steve On 26/06/2022 10:45, Michael D. Setzer II wrote: With 3 no blank cells in range =COUNTBLANK($A$2:$A$1000) Returns 996 These all return 3 =COUNTA($A$2:$A$1000) =COUNTIF($A$2:$A$1000,">""") =COUNTIFS($A$2:$A$1000,">""") Believe =COUNTA(A$2:A$1, ISBLANK=0) is getting 0 from range, but the counts the isblank=0 as an item? On 25 Jun 2022 at 21:41, Harvey Nimmo wrote: Subject:[libreoffice-users] Calc function COUNTA From: Harvey Nimmo To: libreoffice-users Date sent: Sat, 25 Jun 2022 21:41:23 +0200 I wanted to count the number of non-blank items in a list of items using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an otherwise empty column. It returns the value 1! Is that supposed to mean something? Has anyone notice this? It's obviously not a big problem, because a workaround is obvious. But do I have to mistrust the results of the COUNTA function? Cheers Harvey -- To unsubscribe e-mail to:users+unsubscr...@global.libreoffice.org Problems?https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:https://wiki.documentfoundation.org/Netiquette List archive:https://listarchives.libreoffice.org/global/users/ Privacy Policy:https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calc function COUNTA
With 3 no blank cells in range =COUNTBLANK($A$2:$A$1000) Returns 996 These all return 3 =COUNTA($A$2:$A$1000) =COUNTIF($A$2:$A$1000,">""") =COUNTIFS($A$2:$A$1000,">""") Believe =COUNTA(A$2:A$1, ISBLANK=0) is getting 0 from range, but the counts the isblank=0 as an item? On 25 Jun 2022 at 21:41, Harvey Nimmo wrote: Subject:[libreoffice-users] Calc function COUNTA From: Harvey Nimmo To: libreoffice-users Date sent: Sat, 25 Jun 2022 21:41:23 +0200 > I wanted to count the number of non-blank items in a list of items > using COUNTA. > > Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an > otherwise empty column. It returns the value 1! > > Is that supposed to mean something? Has anyone notice this? > It's obviously not a big problem, because a workaround is obvious. > But do I have to mistrust the results of the COUNTA function? > > Cheers > Harvey > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Starting page numbering in a document on the second page
On 25/06/2022 21:28, Ian Bertram wrote: > > I have a long document (156 pages) plus a cover page. I want the cover page > to be unnumbered and the numbering to start with the second page of the > document. I’ve tried using page styles and got the second page to show as 1, > but the header also appeared on the cover page and also as Page 1. Removing > the cover page header removes it from the whole document. Is what I’m trying > to do possible? I feel as if I’m frustratingly close, but obviously missing > something. Check out: https://wiki.documentfoundation.org/Faq/Writer/002 or Chapter 5 "Formatting Pages: Basics" of the Writer Guide: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Starting page numbering in a document on the second page
I have a long document (156 pages) plus a cover page. I want the cover page to be unnumbered and the numbering to start with the second page of the document. I’ve tried using page styles and got the second page to show as 1, but the header also appeared on the cover page and also as Page 1. Removing the cover page header removes it from the whole document. Is what I’m trying to do possible? I feel as if I’m frustratingly close, but obviously missing something. Sent fromMailfor Windows -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Calc function COUNTA
I wanted to count the number of non-blank items in a list of items using COUNTA. Cell A1 has the formula =COUNTA(A$2:A$1, ISBLANK=0) above an otherwise empty column. It returns the value 1! Is that supposed to mean something? Has anyone notice this? It's obviously not a big problem, because a workaround is obvious. But do I have to mistrust the results of the COUNTA function? Cheers Harvey -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Fwd: LOWrite page numbers
On 25/06/2022 03:21, Chris J. wrote: Hi. Running Ubuntu 22.04 with LO 7.3.4.2 Ubuntu package 1:7.3.4. Before you ask, yes I RTFMed. Still can't get this working. I write stories where the chapters are individual files. First chapter has pages 1-15. Second chapter in a whole other file has to start with page 16. Is there a really straight forward example of this somewhere? I remember this being easier in Word. I can't get it to work in LO Writer. Thank you. I'm using LOWriter 6.4.7.2 in Ubuntu 20.04 and I have the same use case. The method described in the help page works for me. I have the offline help file for v6.4 and here is the paragraph concerned : To Start With a Defined Page Number Now you want some more control on page numbers. You are writing a text document that should start with page number 12. 1. Click into the first paragraph of your document. 2. Choose Format - Paragraph - Text flow. 3. In the Breaks area, enable Insert. Enable With Page Style just to be able to set the new Page number. Click OK. The new page number is an attribute of the first paragraph of the page. hth with your version. Philip -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy