On Raspberry PI Debian trixie moving from 7.2 to 25.8 calc format “M/D” not working.
In a macro building the weeks average the top cell which is the date for daily entries and I’ve been filling that top cell for weekly averages with this code:
Blockquote
’ date for weekly average
monStr = cDate(cellRC(DateRow, wkAvgCol - daysInWeek).Value) ’ typical 5 day week
monStr = format( monStr, “M/D” ) ’ 7/10 (/2017)
friStr = cDate(cellRC(DateRow, wkAvgCol - 1).Value)
friStr = format( friStr, “M/D/YY” )
cellRC(DateRow, wkAvgCol).Formula = monStr + " " + friStr
This has put this “12/22 12/26/25” in the top cell of the weeks averages.
Since the upgrade to 25.8 I now get “12/22/2025 12/26/2025”
Though I don’t see how it could make a difference in the spreadsheet Monday’s and Friday’s dates are displayed as “M/D”
Pointers appreciated and Happy Holidays,
Mike