Re: [libreoffice-users] Calc calendar in xlsx file format - day numbers disappeared suddenly

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+unsubscribe@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