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

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

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.