[CONFIGURATION] Bug in Libre Office Calc that might be a Kubuntu or Ubuntu display thing.

[steve7233]

Here is what I observed I formated the cell to date. 3/1 to 3/3 and 3/5 displays as expected however 3/4 always displays as a fraction no matter what cell or the fact that the cells formatting code is set to date. When I went to the Bugzilla Libre Office section it said that many bugs are OpenGL or OpenCL problems. I don't know how to check that so I thought I'd post here to start. Does anyone have any idea why this is happening?

[Snowhog]

Confirmed here too. In fact, the fractions 1/4 and 1/2 are also displayed as fractions in Calc in a Column specifically specified for the Cells to be 'Date'.

[jglen490]

That is weird!

Entering the full date (i.e., 3/4/21), results in a properly formatted date. Also, entering 3/04 results correctly.

Still, weird!

[Snowhog]

For the 'reason' and 'fix', see https://ask.libreoffice.org/en/quest...e-75-or-30414/

[Snowhog]

That is weird!

Entering the full date (i.e., 3/4/21), results in a properly formatted date. Also, entering 3/04 results correctly.

Still, weird!

And that, to me, is an even better way to deal with this; to enter mm/dd instead of mm/d. That avoids the Libre Office Calc Auto-correct feature from kicking in, but keeps the rules for those fractions in place.

[Fred47]

and if you want to show only the month/day then select that format in the Date category.

[marco07]

I am using Libre Office version 7.1 on Neon 20.04 User's edition. I trired 1/2, 1/4, 3/4 , 3/04. All was shown and correctly according to column formatted as mm/dd/year.

[chimak111]

WFM on libreoffice-calc/focal,now 1:7.0.4~rc2-0ubuntu0.20.04.2 amd64 [installed]