Re: [libreoffice-users] Function acting on range
On 16 Mar 2023 at 13:13, Steve Edmonds wrote: Date sent: Thu, 16 Mar 2023 13:13:03 +1300 To: Users From: Steve Edmonds Subject:[libreoffice-users] Function acting on range > Hi, on the off chance I will be pleasantly surprised, can a function act > on a range. > > i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28)) to > average the absolute value of the numbers in the range. > The above seems to return only the last value of the range. I can > achieve this with an intermediate column on every sheet. > Steve Believe ABS returns absolute value of just a number or cell, got errors when I tried a range. Did a test that seems to work. Put number in B2 to G2 1 2 3 -1 -2 -3 =(SUMIF(B2:G2,">=0")-SUMIF(B2:G2,"<0"))/COUNT(B2:G2) It sums up all the positive number and zeros, and then subtracts the sum of all the negative number) that is then divided by count. In this case sums were 6 and -6 resulting in 12, and then dividing by 6 result was 2. Think it would work using range across sheets? Don't know if any cells might contain blanks, so might just want to hard code number to divide? > > -- > 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
[libreoffice-users] Function acting on range
Hi, on the off chance I will be pleasantly surprised, can a function act on a range. i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28)) to average the absolute value of the numbers in the range. The above seems to return only the last value of the range. I can achieve this with an intermediate column on every sheet. Steve -- 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] LibreOffice 7.3.7.2
Dear All I use Kubuntu 22.04.2 LTS. The version of Libre Office that auto installed with Kubuntu 22.04.2 LTS and LibreOffice 7.3.7.2 that I installed manually, have the same problem: No spell checking takes place. I looked around at some setting and can report as follows: Tool > Spelling > Text Language shows no entry and the drop down at the end says 'None'. Tools > Options > Languages shows: 'User Interface [Default - English USA]' 'Locale settings [English (UK)]' 'Default language for documents Western [Default - English UK]' I am at a loss to know what to do Any help appreciated Best wishes Stephen London UK -- 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] Office doesn't handle its own graphics?
Further to Robert's response. You can also OLE object insert an ODF drawing document .ODG (main menu Insert -> OLE Object -> OLE Object...). But will need to select the 'Create from file' radio button on the dialog. Will have to adjust the resulting OLE frame to your needs. You can also choose to link to the OLE object (allowing changes to the original to update the insertion on its next edit session). It is functional, but it is usually much more efficient to export from Draw in a raster or vector format, and then insert that image cleanly. -- V Stuart Foote -- 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] PDF Creation
Hi, Running LO 7.4.5.1 and am endeavouring to create a fillable PDF form using Writer. The file will be viewed using the free Adobe Reader software. What I am battling with is the document saving the remote text that is entered so that when it is sent back to me via email as an attachment, whether the email sending be in Text or HTML, that the written text is not deleted. Each time I open the PDF form on my side to view it and then close it, Adobe Reader always asks if I want to save changes, despite no changes being made. I am endeavouring to find out from my remote users filling out the form but I wondered if there was a form control or other that needed to be set to save the inserted text on the form onto the form so that it and the saved text can be emailed. What am I missing? Regards Hylton -- 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] Office doesn't handle its own graphics?
Hi Gavin, I'm creating a document in Writer, and wanted to include some graphics from Draw. But you can't insert a Draw file. Draw files are filtered out of the file dialog by default; and if you enable "all files" and select one, you get an error message. A draw document could contain many pages. On every page will be shapes/images. So a *.odg-document couldn't be imported as image to a *.odt-document. Mark the shape/image you want to import. Drag and drop it to Writer. Or: Export the marked content as *.wmf. So you could import this image by the import dialog of Writer. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- 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