Hi Heidi
Am 06.01.2026 um 23:21 schrieb [email protected]:
Forwarding from sysadmin.
-----
Dear Developers,
when trying to use conditional formatting and style sheets in Open
Office Calc, I realized, that cells formatted as date (Format-Code
"NN, TT.MM.JJJJ") are converted to numbers. See example attached.
I can not recreate your issue on my dev version and on 4.1.16.
Maybe the format is changed into number somehow?
rightclick the cell, Format cell, then select date, and make sure the
format code is as you have printed.
Sadly the file has been removed by the mailing list.
I want to prepare a calendar for my working hours, which is valid for
every new year, when I just enter January 1st of the year in question
into cell "A3".
All weekends shall have "blue" as background colour, the target
working time (column "Soll") shall be set to 8 hours for weekdays
automatically and to 0 hours for saturdays, sundays and bank holidays.
Hope this bug will be fixed in one of the next updates.
Kind regards
Heidi
All the best
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
