Hi Regina,I found your issue: the indent on your cells (like F3) is 223pt which places the text more or less 3 inches (7.9cm) to the right of the cell. This seems to be something that was done as formatting to the cells individually because the Default style calls for a zero indent. Looking at your setup, the long but easier option will be for you to select the day cells (using CTRL-drag to select more than one) and then Format > Cells... and go to the Alignment tab: there, set the Indent value to 0. This should bring your numbers back and they should be left justified. Excel is not as flexible as LO when it comes time to format the cells, so if you want to maintain the compatibility with Excel, do not use the padding that is available on Format > Cells... Borders if you want to move the numbers around: just use left, right, center justification. Some suggestions to make your life easier:You can replace the drop-down entry of cell J1 with this formula: =TEXT(DATE(L1,1,1),"dddd"), and the yes/no for leap year in J2 with =IF(DATE(L1+1,1,1)- DATE(L1,1,1)>365,"yes","no"). And those should work correctly in Excel as well.Don't hesitate if you have any other questions.Rémy. Le mardi 12 janvier 2021 à 17:20 -0700, Regina3000 a écrit : > Hi,It is a bit hard to guess what is going on without actually > seeingthe 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 > forcerecalculation)- Conditional formatting that overrides the cell > textcolor because an entry is invalid (year greater than 2020?). You > cantry 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 andif it's only a formatting issue.- A calculation or data > element iswrong 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 > controlwhich and find the source issueI hope this helps.Rémy. > Thanks. > I tried copy/paste special-numbers and the number showed up. > I tried Data/Calculate/Recalculate hard and that did nothing. > I tried Tools/Detective/Trace Precedents, and nothing obvious showed > up. > I think it's a formatting issue, but it's strange that it would show > up outof the blue, all of a sudden, when before, it was working just > fine. > I've attached a copy of the file with (I hope) sensitive > informationdeleted. I am seeing the same problems in this file as in > the original. Iwould be interested to see whether you find that the > numbers show up foryou. I have a suspicion that they will. > I'll be able to reboot my computer shortly, and I will report back as > towhether that fixed the issue. Of course, that won't tell me what > the issueis... > > > --Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html >
-- To unsubscribe e-mail to: [email protected] 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
