Hi Heidi, all Possibly the bug is already fixed in current development branch 4.2
Can you please try a very recent Test build compiled by Matthias Seidel (assuming you are using the MS Windows OS)? https://drive.google.com/drive/folders/19vbNmIHzTkDEMbzvMMlOA_soZF0199Yx Please find attached a corrected version of your ODS file (I hope it passes the filter) Best, Pedro > On 01/06/2026 10:32 PM WET [email protected] wrote: > > > 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]
Arbeitszeiten_Muster_v2.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
