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 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
Arbeitszeiten_Muster.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
