Can someone please help!
I am a beginner using a simple 17 sheet spreadsheet. Occasionally I enter a value in a cell, the value is accepted and used in calculations, but the value itself disappears from the cell. I can solve this (so long as I noticed the error) by deleting all formatting, and re-entering required format options. I can then use the cell as normal without difficulty. What is going on here I wonder?
[Dropped] Random blank cell
[Dropped] Random blank cell
Last edited by MrProgrammer on Mon Oct 27, 2025 3:39 pm, edited 2 times in total.
Reason: Dropped: No attachment from cburge
Reason: Dropped: No attachment from cburge
Open Office 4.1.15 on Windows 7
Re: Random blank cell
I can guess at possible causes like conditional formatting that sets the cell font to match the background, but it would be better if you uploaded an example document. Make a copy of your current document and, if necessary, delete sheets from that so it is small enough to upload. The size limit for uploads is 128 KB. Ideally, you would explain which cells tend to have the problem.
To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response.
To upload a file, click Post Reply and look for the Attachments 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.