My Average formula has quit working =C27/C28.
This just worked on Wednesday 3/4/2026, as of 3/6/2026 it is no longer calulating the avg of 2 cells indicated. This is being used in a score sheet of games played/won. Any ideas what happened?
Using Windows 11, Open Office version 4.1.16 that I did just download AFTER discovering the issue of formula not working. HELP PLEASE
[Dropped] Average formula stopped working
[Dropped] Average formula stopped working
Last edited by MrProgrammer on Fri Mar 13, 2026 3:43 pm, edited 1 time in total.
Reason: Dropped: No attachment provided
Reason: Dropped: No attachment provided
openoffice 4.1.2 on Windows 10
-
Hagar Delest
- Moderator
- Posts: 33629
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Average Formula stopped working
Can you upload a sample file showing the problem?
See: How to attach a document here.
See: How to attach a document here.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
Re: Average Formula stopped working
Do you get the error #VALUE? If so, the "values" are in fact text. Use View | Value Highlighting to see; text cells are formatted in black, formulae in green, and number cells in blue.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.