CALC - Cell formatting fails after x number of uses

I set the cell formatting for date and the style I prefer, then after several uses, it stops working, even when I reiterate at the individual cell or the entire column. Sometimes it works again after a while.

Also there is a typo at the login
you don’t have to rememeber or create another one

Thanks for the hint for the typo!

As for your problem, there is more information needed:

  • How did you set the date format?
  • Which other styles did you customized and how?
  • Which LibO version and which OS are you using?

The more details you provide the faster a solution can be found.

Initially I highlighted the column and set it to date and the style I like = 06/19/2013
When it failed I reiterated - both the column and the cell
It indicated that it was still set to date and style
Libre Office 3.5.7.2
Build ID: 350m1 (Build:2)

Xubuntu 4.8

That is the only column in this spreadsheet that I customized.

FYI…I have a rather large (well, not really, maybe 100kb) writer sheet that crashes pretty regularly, usually recovers but this time almost all the text disappeared and there was no indication and no recovery attempt. I did get an error when I opened it telling me stuff was gone. I reopened it but almost all (6 1/2 pages out of 7) was gone.