Ok, so increasingly strange. I looked back at the PDFs for previous years,
and it looks like the numbers have been marching across the cell towards the
right for 3 years, after having started off on the left.
I've reset the base spreadsheet and this year's to zero indent, and made a
note. We'll se
Interestingly, the base spreadsheet that I copy and edit, has an indent of
193 pt, 30 pt less than this one. The one for 2020 has an indent of 53 pt,
and rather than being to the right, where I wanted the numbers to be,
they're somewhere to right of center. I don't have 2019 any longer, or I'd
chec
Oh, wow! Good catch! I don't know how that happened, since I didn't
deliberately do that.
I'll also try out your formula suggestion. Thanks!
Any idea how that indent could have slipped in there? I know for sure I
didn't put it there.
--
Sent from:
http://document-foundation-mail-archive.96907
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 formatti
I have a calendar file in XLSX format that I've been using and tweaking for
years, now. For the past two days, I've been updating it for 2021. Today, I
thought I had it correct, but of course you always miss one thing or
another.
I copy the base file and update it from year to year.
I reopened it
