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. > Thanks! > > > --Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html >
-- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
