Redmine

This Redmine plugin allows you to view and edit issues in an Excel-like spreadsheet format. You can efficiently update multiple issues at once and use custom queries for flexible filtering and display.

japanese:
Redmineのチケットを、Excelのようなスプレッドシート形式で表示・編集できるプラグインです。複数のチケットを一度に効率的に更新でき、カスタムクエリとの連携により柔軟なフィルタリングと表示が可能です

Key Features¶

1. Excel-like Grid Interface¶

• Sleek grid display with narrow borders.
• Blue outline on focused cells.
• Row hover effects.
• Visual feedback for modified rows (yellow background).

2. Bulk Update Functionality¶

• Direct editing of multiple issues on the grid.
• Save all changes at once with the "Save Changes" button.
• Change detection and status display.
• Automatic Email Suppression: No email notifications are sent during bulk updates.

3. Custom Query Integration¶

• Query list displayed in the sidebar (same as Redmine's standard issue list).
• Automatic application of query filters and column settings.
• Highlighted active query.

4. Issue History Panel¶

• Check issue change history without navigating away from the page.
• Expand the panel by clicking the clock icon (⌛) in the ID column or double-clicking a row.
• View change details (Status, Custom Fields, etc.) and comments.
• Side panel layout keeps the main list visible while checking details.

5. Dynamic Display Settings¶

• Integrated filtering and column selection.
• Dual-list UI for column selection.
• "Apply" button updates both filters and columns simultaneously.
• Collapsible control panel.

6. Keyboard Navigation & Paste¶

• Arrow Keys (↑↓←→): Move between cells.
• Enter Key: Move to the cell below.
• Line breaks in textareas: Possible with the Enter key.
• Clipboard Paste: Directly paste multi-cell data copied from Excel or Google Sheets using `Ctrl+V`.

7. Advanced File Import (CSV/Excel)¶

• Upload CSV or Excel files and load them into the spreadsheet.
• Update Existing Issues: If an `ID` column exists, the plugin automatically identifies and updates the corresponding issues.
• Add New Issues: Rows without an ID are added as "New Issues" at the end of the spreadsheet.
• Flexible Column Mapping: Automatically maps column headers like "Subject", "subject", or localized names.
• Finetune data on-screen before committing changes with bulk save.
• Notifications show the number of updated and added issues.

8. Pagination¶

• View issues page by page (synchronized with Redmine's standard "Per page" settings).
• Displays item counts (e.g., "(1-25/100)") and supports per-page switching.
• Standard pagination links at the bottom.

9. Advanced Export¶

• CSV: UTF-8 with BOM into prevent encoding issues in Excel.
• XLSX: Native Excel (.xlsx) support.
  - Preserved Line Breaks: Multi-line text (like Descriptions) is correctly exported with line breaks.
  - Applied Styling: Bold headers, borders, and auto-adjusted column widths.

1. Navigate to the plugins directory:

   cd /path/to/redmine/plugins

2. Clone or copy the plugin:
   git clone https://github.com/yken-tsuru/redmine_spreadsheet_editor redmine_spreadsheet_editor
3. Install dependencies:
   bundle install
4. Restart Redmine: # For Passenger
   touch /path/to/redmine/tmp/restart.txt
5. Enable the module in project settings:
   • Go to Project Settings -> Modules tab.
   • Check "Spreadsheet Editor".