I am using a spreadsheet. In the column I am presently using there are two cells that wont include the figure in their cells in the final total. I hope you can understand my explanation. Can anyone help me? Many Thanks.
Norman
[Dropped] Cell not working
[Dropped] Cell not working
WINDOWS 10
oPEN OFFICE 4.1.5
oPEN OFFICE 4.1.5
Re: cell not working
It may be that the content of those two cells is text. Try selecting the menu item View -> Value Highlighting. Numbers will then be blue, text will be black and the result of formulas will be green. Are the cells that are not included in the total black? If they are green, what is the formula?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: cell not working
If those cells are sums generated by the Auto-Sum function (looks like a sideways M) and the cell for the final total is also generated using the Auto-Sum, then it is a problem, but one that (looking at the code) seems to be intentional....ie: An auto-sum in a column will not, automatically, include an auto-sum already in the column.
This can be over-ridden on a cell by cell basis by editing the formula entered by the Auto-Sum button.
Aside from that, I second FJCC's suggestion that the cells contain text or formulas that generate text, rather than numbers or formulas that generate a numeric response.
This can be over-ridden on a cell by cell basis by editing the formula entered by the Auto-Sum button.
Aside from that, I second FJCC's suggestion that the cells contain text or formulas that generate text, rather than numbers or formulas that generate a numeric response.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: cell not working
The cells in question are all blue, no black, green for the total sum
Something went wrong since I/ve been using this spread sheet for a number of years with no problems.
Could it be the formula somehow went awry? All the other cells in the column are working.Norman
Something went wrong since I/ve been using this spread sheet for a number of years with no problems.
Could it be the formula somehow went awry? All the other cells in the column are working.Norman
WINDOWS 10
oPEN OFFICE 4.1.5
oPEN OFFICE 4.1.5
Re: cell not working
Without seeing your file it is hard to say what is happening. Can you upload the file and explain which cells are causing a problem? To do that, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.