#1102: TimesheetExport.kt
projectforge-business/src/main/kotlin/org/projectforge/business/timesheet/TimesheetExport.kt Service / Excel Export, projectforge-business/src/main/kotlin/org/projectforge/business/timesheet/TimesheetExport.kt 159 lines · 120 code · 30 comments · 9 blank
Spring @Service that exports filtered timesheet lists as Excel (.xlsx) workbooks via the Merlin Excel library. export() creates a workbook with columns: user fullname, customer, project, kost2 display name, week/day-of-week labels, start/stop time (in user timezone, HH:mm format), duration (Excel fraction-of-day, [h]:mm format), hours (decimal, #,##0.00), optional AI time savings columns (hours + percentage), location, reference, task title, task reference, short description (wrap-text), description (wrap-text), task path, id, created, lastUpdate. Sets auto-filter and freeze pane. Uses bold header row. References taskTree and userGroupCache for resolving task paths and user names.
Git History
868d6abb7 2025 -> 2026
3c439391c Timesheet: recent entries (display of kost2, project and customer) fixed. Timesheet: ai unit is preset by recent entry. Timesheet-Excel-Export: AI-savings added.
78a38ca8f ExcelUtils.createFont and used by all font creating excel routines.
63081666f Source file headers: 2024-> 2025.
53b501ab6 Example scripts fixed. TimesheetDO.getDuration() -> TimesheetDO.duration.
e66d5f5f7 Migration stuff in progress... TaskTree -> Kotlin and runs now in isolated entity manager
a0ae2827f ExcelExport of timesheets: Timezone of time stamps fixed.
b6092df09 Copyright 2023 -> 2024
316996504 Timesheet export as XSLX (using Merlin)