After upgrade to 6.4, the cells that become with red background show incorrect value, should be a date, a number is shown instead. Senza nome 1.odt
Without showing us the format definition of style Accent
nobody can tell. The default style Accent
uses number format General
and hence it is expected what you get. Change the style Accent
to format category Date
and Format code DD/MM/YYYY
It’s Accent 1 - Date. If the condition is not met, the correct date appears.
Thanks solved. I was using style cf1, that was indeed general. Changing it to date, the issue is fixed. I can’t understand why this problem was not present in former Calc versions.
Then you presented a red herring in your screenshot - it clearly shows Accent
My bad, I showed the wrong info. It’s indeed cf1. Thanks for your help,
I followed the instructions of Opaque, and the problem was solved:
“The default style Accent uses number format General and hence it is expected what you get. Change the style Accent to format category Date and Format code DD/MM/YYYY”
Thanks a lot for your quick help!