You can try to open on another PC or remove customizations:
https://forum.openoffice.org/en/forum/viewtopic.php?p=168160
Otherwise remove the lock file or reinstall LibreOffice:
https://askubuntu.com/questions/491292/general-error-general-input-output-error-when-opening-documents-with-libreoff
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 21:37:
On 16/03/2023 23:12, Regina Henschel wrote:
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 01:13:
Hi, on the off chance I will be pleasantly surprised, can a function
act on a range.
i.e can I do something like
Thanks very much for the help. I will flag using the AVERAGE and ABS and
can adequately gain a feel for the data I need with the STDEVP function.
I had recently been using some R style vector arithmetic and wondered if
similar could be achieved using ranges in LO.
Steve
On 17/03/2023 11:29,
I was able to accomplish array math by clicking on the fx button on the row
above the letters naming columns, then click the array checkbox in the
lower left of the function wizard dialog box.
After that the function listing shows {} around the function, but you can't
type that in to get the
Hi Regina,
> But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.
Besides the typo, for that to work it would need to be all in the same
worksheet, which is contrary to the initial setup.
ISTM that using SUM() and COUNT() would be simpler, if the data is
already with the layout
On 16/03/2023 23:12, Regina Henschel wrote:
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 01:13:
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
Two separate issues.
A_ The curly brackets are not to be introduced manually. They are only
a sign that the formula is not "normal" (as introduced by pressing
[ENTER]) but instead is an array formula, introduced by simultaneously
pressing [CTRL]+[SHIFT]+[ENTER] (CSE). Search the wiki or the web
On 16 Mar 2023 at 18:22, ady wrote:
From:ady
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users
> Hi Regina,
>
> > But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.
>
> Besides the typo, for that to work it would
Hi Michael,
Michael D. Setzer II schrieb am 16.03.2023 um 22:45:
On 16 Mar 2023 at 18:22, ady wrote:
From:ady
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users
Hi Regina,
But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)}
On 16 Mar 2023 at 23:29, Regina Henschel wrote:
Subject:Re: [libreoffice-users] Function acting on
range
To: users@global.libreoffice.org
From: Regina Henschel
Date sent: Thu, 16 Mar 2023 23:29:10 +0100
> Hi Michael,
>
>
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 01:13:
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
In Writer, go to menu Tools > Options > Language Settings > Writing Aids.
Is the dictionary of the specific language listed and checked "on"?
In the same Language Settings dialog, are the relevant options checked "on"?
"How to install extra dictionaries?"
Why do I get a "general input/output error when trying to open a LO
document (Calc, in this case)? Seems to happen frequently but randomly.
Using Ubuntu 20.04 and LO Version: 6.4.7.2 Build ID:
1:6.4.7-0ubuntu0.20.04.6.
Thanks.
--
Eric Beversluis www.ericbeversluis.com Forthcoming: /For Love
13 matches
Mail list logo
