CALC formatting glitch

English
#1

Have been using CALC for a long time (LOVE it)
Today my CALC file - DATE column refused to update with <CTR>-; as 10 May 2024 as it has for quite a while.
Instead, it populated with ###
Tried to update the formatting in the whole column as well as the individual cells to 10 May 2024 -NOGO ?

Version: 7.6.6.3 (X86_64) / LibreOffice Community
Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Thanks, ⌡im [THE BookMan]

#2

What do you see in the Input Line?
Have you tried to widen the column size?
EDIT: What is the number cell formatting?

1 Like
#3

05/10/2024 is what shows up on the input line.

#4

Column width is the same as all the rest of the column, which shows the date as “10 May 2024”

#5

Cell and column are formatted as DATE - D. MMM. YYYY

#6

All cells below the current are displayed the same, even though the were all formattred at the same time and just a few minutes ago ?

#7

Error Codes

#8

No error codes, jus wrong formatting … ?

#9

9 Apr 2024
10 Apr 2024
9 May 2024
10 May 2024

Try widening the column, or reducing the font size. Or share a sample file to test.

1 Like
#10

Make that column wider.

#11

Widening the column does nothing to solve the problem

Exo_13:16 And it shall be for a token upon thine hand, and for frontlets between thine eyes: for by strength of hand YHWH brought us forth out of Egypt
Exo_13:19 Graves opened
Exo_14:10 I will have mercy 3. May. 2024
Exo_14:13 And Moses said unto the people Stand still and see the salvation of Yahweh
Exo_14:30 Days of wicked shortened 4. May. 2024
Exo_15:1 Then sang Moses and the children of Israel this SONG unto YHWH, and spake, saying, I will sing unto YHWH, for he hath triumphed gloriously: 5. May. 2024
Exo_15:2 Yahweh is my strength and song, He has become my salvation 7. May. 2024
Exo_15:13 Thou in thy mercy hast led forth the people which thou hast redeemed: thou hast guided them in thy strength unto thy holy habitation 8. May. 2024
Exo_15:26 And said, If thou wilt diligently hearken to the voice of YHWH thy Elohim, and wilt do that which is right in his sight, and wilt give ear to his commandments, and keep all his statutes, I will put none of these diseases upon thee, which I have brought upon the Egyptians: for I am YHWH that healeth thee 9. May. 2024
Exo_16:4 Gives us our daily bread, 10. May. 2024
Exo_16:14+ Gives manna
Exo_17:5 He is lamb
Exo_17:6 Quenches thirst
Exo_18:4 And the name of the other was Eliezer; for Elohim of my father, said he, was mine help, and delivered me from the sword of Pharaoh:
Exo_18:8 And Moses told his father in law all that YHWH had done unto Pharaoh and to the Egyptians for Israel’s sake, and all the travail that had come upon them by the way, and how YHWH delivered them
#12

image
image1920Ă—1080 277 KB

#13

Have you tried? If that don’t solve the problem, share a sample file to test.
You can see (in my previous comment) that 10 May 2024 occupies more space than 9 May 2024.
And in your screenshot I can see that there is no more horizontal space in the cell containing 9. May. 2024, so 10. May. 2024 will be seen as ###.

2 Likes

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.