Re: [libreoffice-users] Function acting on range

2023-03-15 Thread Michael D. Setzer II
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,

[libreoffice-users] Function acting on range

2023-03-15 Thread Steve Edmonds
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

[libreoffice-users] LibreOffice 7.3.7.2

2023-03-15 Thread Stephanos
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 >

Re: [libreoffice-users] Office doesn't handle its own graphics?

2023-03-15 Thread V Stuart Foote
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

[libreoffice-users] PDF Creation

2023-03-15 Thread Hylton Conacher (ZR1HPC)
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,

Re: [libreoffice-users] Office doesn't handle its own graphics?

2023-03-15 Thread Robert Großkopf
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