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

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: 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