Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

Hi,It is a bit hard to guess what is going on without actually seeing
the file. Can you e-mail it to me?Two things come to mind:-
Calculations are in manual mode and the cells are not re-calculated.
You can see the status in Data > Calculate (or try F9 to force
recalculation)- Conditional formatting that overrides the cell text
color because an entry is invalid (year greater than 2020?). You can
try to copy a blank cell and paste the value in the cell elsewhere
(using Paste Special). You can then see if the calculation is done and
if it's only a formatting issue.- A calculation or data element is
wrong and the cell formula prevents wrong outputs to be shown
(something like =IFERROR(something,"")). You can use the Detective
(Tools > Detective > Trace Precendents) to find which cells control
which and find the source issueI hope this helps.Rémy.
Le mardi 12 janvier 2021 à 15:27 -0700, Regina3000 a écrit :
I have a calendar file in XLSX format that I've been using and
tweaking foryears, now. For the past two days, I've been updating it
for 2021. Today, Ithought I had it correct, but of course you always
miss one thing oranother.
I copy the base file and update it from year to year.
I reopened it and all of the day numbers were gone. I opened the base
file,and the day numbers were gone from it, as well.
By "gone," I mean that they don't show. If I select a day number
cell, I cansee the formula that generates the number, and if I go to
edit the cellformat, and turn the font color from "Automatic" to
"black," it STILLdoesn't show up.
I'm guessing there is an issue with LibreOffice, but I don't
haveLibreOffice running. I can't find it in Task Manager (running
Windows 10Pro) to kill it.
Has anyone seen anything like this, and if so, what did you do to fix
it? Ican't reboot, right now, because I'm in the middle of a bunch of
otherstuff, too, but I suspect that if I rebooted, it would be fixed.

--Sent from:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.