Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread WA.TWORSX via AOL
Not a problem, Alan. On 1/27/2020 5:43 PM, Alan B wrote: See David Robeley's response. I was jumping back and forth between virtual machines and inadvertently used the one with LibreOffice without remembering you're using OpenOffice. My bad. Sorry about that. On Mon, Jan 27, 2020 at 4:20 P

Re: confirm unsubscribe from users@openoffice.apache.org

2020-01-27 Thread Larry Gusaas
On 2020-01-27 7:29 p.m., users-h...@openoffice.apache.org wrote: Hi! This is the ezmlm program. I'm managing the users@openoffice.apache.org mailing list. I'm working for my owner, who can be reached at users-ow...@openoffice.apache.org. To confirm that you would like larry.gus...@gmail.co

Re: Cannot Open OpenOffice Doc on new Mac

2020-01-27 Thread Larry Gusaas
On 2020-01-27 1:35 p.m., Stephen Kozowyk wrote: Hi, I’ve relocated my files to my new Mac and did not keep the OpenOffice app this time around. I want to open the files on the Mac programs of Numbers or Pages. How do I do this without OpenOffice? Do I need to download the latest version of Ap

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread Alan B
See David Robeley's response. I was jumping back and forth between virtual machines and inadvertently used the one with LibreOffice without remembering you're using OpenOffice. My bad. Sorry about that. On Mon, Jan 27, 2020 at 4:20 PM WA.TWORSX via AOL wrote: > Alan: > > I tried in cell H44: =

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread WA.TWORSX via AOL
TNX David; I have just been visiting the LibreOffice help https://help.libreoffice.org/6.2/he/text/scalc/01/func_minifs.html?DbPAR=CALC and came to that same conclusion. On 1/27/2020 4:46 PM, David Robley wrote: Those functions are not available in AOO - but exist in LibreOffice since ar

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread David Robley
Those functions are not available in AOO - but exist in LibreOffice since around version 5.2 On 28/1/20 7:50 am, WA.TWORSX via AOL wrote: Alan: I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working for me. Error508: Error in bracketing is shown. I also tried with use of se

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread WA.TWORSX via AOL
Alan: I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working for me. Error508: Error in bracketing is shown. I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") rather than commas; #NAME? error is returned. No joy here. I could not find anything  as =MINFS(  )

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread Alan B
Hello Vince, Thank you for your kind words. In your sheet notes you describe needing to "segment a formula" into several ranges. Unnecessary work, I think. Try the following formulas instead... In H43, =MAXIFS(G6:G41,G6:G41,">0") In H44, =MINIFS(G6:G41,G6:G41,">0") They appear to me to work as

Cannot Open OpenOffice Doc on new Mac

2020-01-27 Thread Stephen Kozowyk
Hi, I’ve relocated my files to my new Mac and did not keep the OpenOffice app this time around. I want to open the files on the Mac programs of Numbers or Pages. How do I do this without OpenOffice? Do I need to download the latest version of Apache to do this? The files were not converted and

Re: Is there a FAXing Facility in AOO?

2020-01-27 Thread Steven Ahlers
Vince, I use an App that transmits PDFs to fax machines. The app was free from the App Store, there is a charge for each transmittal. I don’t remember if it’s a per transmittal or a per page. Sent from my iPhone > On Jan 27, 2020, at 8:14 AM, WA.TWORSX via AOL > wrote: > >  > I have a PDF

Re: Is there a FAXing Facility in AOO?

2020-01-27 Thread Fernando Cassia
On Mon, Jan 27, 2020, 11:14 WA.TWORSX via AOL wrote: > > I have a PDF file that contains info that I want to transmit to a FAX > recipient. If I convert that PDF file, via OCR, would AOO-Writer be > useful to FAX the document? > > Regards, VinceB. > What you need to fax us a rasterized (bitmap)

Re: Downloading Open Office With Windows 10

2020-01-27 Thread Steven Ahlers
Tony, As a courtesy to you I am sending a copy of this message to you, if you’re not subscribed to the users list you may miss some replies. Please respond only to: users@openoffice.apache.org so that all users can assist you. Are you downloading from the official website: https://www.openoffi

Re: Downloading Open Office With Windows 10

2020-01-27 Thread JD
On Mon, Jan 27, 2020 at 6:47 AM Tony wrote: > I have tried to do this with no success, will it download while I am using > Windows 10, am I missing something obvious. I have just moved from Windows > 7 to 10 and I had Open Office on my old system. I will be gratefull for any > advice you can give

Is there a FAXing Facility in AOO?

2020-01-27 Thread WA.TWORSX via AOL
I have a PDF file that contains info that I want to transmit to a FAX recipient. If I convert that PDF file, via OCR, would AOO-Writer be useful to FAX the document? Regards, VinceB. - To unsubscribe, e-mail: users-unsubsc

Downloading Open Office With Windows 10

2020-01-27 Thread Tony
I have tried to do this with no success, will it download while I am using Windows 10, am I missing something obvious. I have just moved from Windows 7 to 10 and I had Open Office on my old system. I will be gratefull for any advice you can give. Thank you G. A. Rich Sent from Mail for Windows