JXL Cloud release notes

Feature change log of JXL for Jira Cloud.

2023

27 Jan 2023

More level visibility options

• Option to hide child and bottom level issues without parents
• Option to hide issues that are outside of levels

25 Jan 2023

Copy sheets between projects, more columns

• Copy sheets between projects
• Last viewed date column
• Smart column: Time since last viewed

19 Jan 2023

Enhanced conditional formatting

• Choose from 90 colours to format both foreground and background of cells and rows

12 Jan 2023

Smart column

• Smart column: All comments (when exported, all comments, their authors, times and dates are included)

2022

8 Dec 2022

More smart columns

• Smart column: Issue URL
• Smart column: Customer portal issue URL
• Smart column: Issue ID
• Smart column: Project key
• Smart column: Project ID
• Various smart columns related to comments

8 Nov 2022

More smart columns

• Smart column: Sprint status
• Smart column: Sprint closure

4 Nov 2022

Empty options in date and number column filtering

• Empty and not empty options in date and date time column filtering
• Empty and not empty options in number, time since, and time tracking column filtering

26 Oct 2022

More columns, time tracking format

• Category column
• Configurable display format in time tracking columns

18 Oct 2022

Views, sheet sharing

• Save frequently used states of features and preferences as views in sheets
• Share sheets with views enabled with other users

5 Sep 2022

More column sum-ups, more smart columns

• Sum-ups in "Time since..." columns with configurable sum-up style
• Various smart columns related to comments

31 Aug 2022

Merged columns

• Use merged columns to consolidate values from multiple individual fields from team-managed projects

16 Aug 2022

New issue structure preference

• Choose whether issues can be listed multiple times in the table across hierarchy levels in structures

11 Aug 2022

Insight custom field support

• Custom field type: Insight objects

9 Aug 2022

Images column

• Smart column: Images

4 Aug 2022

Conditional formatting

• Format background colour of cells and rows if field values meet specified conditions

14 Jul 2022

Column freezing

• Freeze columns on the left-hand side of the table

11 Jul 2022

Issue counts in groupings

• View issue counts in grouping rows

13 Jun 2022

Site migration

• Use the new migration feature to move your sheets between Jira sites

31 May 2022

Development information columns, smart columns

• Number of pull requests column
• Pull requests status column
• Number of builds column
• Builds status column
• Smart column: Number of labels
• Smart column: Number of components
• Smart column: Number of affected versions
• Smart column: Number of fix versions
• Smart column: Number of sub-tasks
• Smart column: Number of issue links
• Smart column: Number of issues linked
• Smart column: Number of attachments
• Smart column: Number of comments

23 May 2022

Sheet API, image file viewer, not empty in select column filtering, Deep Clone integration

• JXL Cloud API with create and delete sheet methods
• Insitu file viewer for image attachments
• NOT EMPTY option in select column filtering menus
• Deep Clone for Jira integration

11 May 2022

Issue Checklist for Jira columns, smart columns

• Issue Checklist for Jira Checklist column
• Issue Checklist for Jira Checklist completed column
• Issue Checklist for Jira Checklist progress column
• Issue Checklist for Jira Checklist progress % column
• Smart column: First commented by user
• Smart column: Last commented by user

4 May 2022

Issue security

• Security level column

2 May 2022

In-app help, column filtering improvements

• In-app help panel
• Select all action in column filtering menus
• Use EMPTY keyword with logical operators in text column filtering and table search

26 Apr 2022

Smart columns

• Project category column
• Smart column: Project type
• Smart column: Project configuration type

23 Mar 2022

Smart column

• Smart column: Time to due date

21 Mar 2022

Field sum-ups

• Sum up table contents
• Sum up groupings
• Add sum-up levels to custom issue structures

2 Mar 2022

Global permission, smart columns

• Manage who can make bulk changes to issues in sheets
• Smart column: Date of first comment
• Smart column: Date of last comment

23 Feb 2022

Smart columns

• Smart column: Time since status changed
• Smart column: Time between created and resolved
• Smart column: Last updated by user
• Smart column: Last update action
• Smart column: Number of sprints
• Smart column: Attachments size

21 Feb 2022

Issue grouping, Easy Agile Programs columns

• Group issues by field values
• In addition to hierarchy levels, use grouping levels in custom issue structures
• Easy Agile Program column
• Easy Agile Program increment column
• Level-specific column filtering preference now also applies to the table search

8 Feb 2022

Global permissions, read-only columns

• Manage who can view and create, edit, delete sheets via global permissions
• Optionally make columns read-only in your sheets

3 Feb 2022

Custom fields support

• Custom field type: Single-version select menu
• Custom field type: Multi-version select menu
• Custom field type: Readonly plain text

2021

28 Dec 2021

Expand/collapse levels

• Expand and collapse entire levels from the context menu when issue hierarchy is enabled

23 Dec 2021

Relative date column filtering

• Filter date and time columns relative to now (e.g. today, or from yesterday to X days from now, etc.)

16 Dec 2021

Hierarchy level filtering and level-specific column filtering

• Hide issues without children in hierarchies
• Control which hierarchy levels column filtering applies to

10 Dec 2021

Row numbers

• Optionally add row numbers for easier referencing of table positions in meetings

6 Dec 2021

Rename columns

• Change the heading of table columns in your sheets

29 Nov 2021

Advanced search syntax with logical operators

• Use logical operators (OR, AND, NOT), grouping (parentheses) and exact phrasing (quotation marks) in text column filtering and table search field

24 Nov 2021

Custom field support

• Custom field type: Projects

23 Nov 2021

Adaptable sheets

• Open sheets with an adapted scope and title using URL parameters

22 Nov 2021

Time tracking formats, expand/collapse all issues

• Time tracking columns now observe Jira display format and default unit settings
• Expand and collapse issues actions in context menu when issue hierarchy is enabled

17 Nov 2021

Custom issue hierarchy

• Create custom structures based on Advanced Roadmaps parent linkage, issue links, and more

4 Oct 2021

Sheet starring

• You can now pin your favourite sheets in the sheets directory and sheets menu by starring them

1 Oct 2021

Sheets browsing improvements

• Switch between recent and alphabetical sorting in sheets directory and sheets menu

28 Sep 2021

SLA columns

• Table columns for Jira Service Management SLA time fields

23 Sep 2021

Issue hierarchy

• Group issues by hierarchical relationships (Advanced Roadmaps issue levels also coming soon)

3 Sep 2021

Special Notes column

• Add issue notes that are visible in the context of the sheet you add them to (not a Jira field)

26 Aug 2021

Editable Epic link cells

• Cells in Epic link columns are now also editable

3 Aug 2021

Notifications switch and more granular sheet permissions

• Toggle email notifications of issue changes in sheets (needs administrator permission)
• You now need Edit Issues permission in a project to create, edit, delete sheets

27 Jul 2021

Faster column editing

• More lightweight Add column dialog for snappier sheet editing

20 Jul 2021

Inline create issues in sheets

• Hover over the row handles on the left of the table to create an issue
• Choose "Create issue below" in the cell context menu to create an issue
• Use keyboard shortcut Cmd+Shift+C (macOS) or Ctrl+Shift+C (Windows, Linux) to create an issue

8 Jul 2021

Epic link column improvements

• Epic Link cells now show the name and colour of the epic

29 Jun 2021

Row handles, time columns, custom field column header abbreviation

• Row handles
• Click row or column headers to select whole rows or columns
• Status category changed date column
• Resolved date column
• Smart column: Time since created
• Smart column: Time since updated
• Smart column: Time since status category changed
• Smart column: Time since resolved
• Column headers with long custom field names now get a smart abbreviation when needed

14 Jun 2021

Context menu, more JSM columns

• New context menu for cell selections
• Start Jira bulk editing for selected issues
• Request type column (Jira Service Management)
• Request language column (Jira Service Management)
• Satisfaction column (Jira Service Management)
• Satisfaction date column (Jira Service Management)

9 Jun 2021

Sheet directory page, more JSM columns, cascading select custom field support

• New sheet directory page accessible from the Jira header navigation
• Custom field type: Cascading select menu
• Request participants column (Jira Service Management)
• Approvers column (Jira Service Management)

31 May 2021

Save as new sheet, Votes, Watchers, Tempo columns, more custom fields support

• Ability to save sheet as a new sheet
• Ability to clear all sorting, filtering, sheet search from the status bar
• Overdue date values in the Due date column now appear red
• Votes column
• Watchers column
• Tempo team column
• Tempo account column
• Custom field type: Multi-user select menu
• Custom field type: Single and multi-user select menus (next-gen projects)
• Custom field type: Single-group select menu
• Custom field type: Multi-group select menu

17 May 2021

Sheet export

• Sheet export to XLSX, CSV, TSV files

10 May 2021

Comments and Status category columns

• Comments column
• Customer conversation column (Jira Service Management)
• Status category column

3 May 2021

Column filtering, Advanced Roadmaps columns

• Number-based column filtering
• Date-based column filtering
• Date and time-based column filtering
• Time tracking value-based column filtering
• Flagged option-based column filtering
• Paren link column (Advanced Roadmaps)
• Target start date column (Advanced Roadmaps)
• Target end date column (Advanced Roadmaps)
• Team column (Advanced Roadmaps)

28 Apr 2021

Column filtering

• Field value-based column filtering

21 Apr 2021

Attachments column, more custom fields support, more performance, issue dialog

• Attachments column
• Custom field type: Multi-line plain text
• Custom field type: Multi-choice select menu
• Custom field type: Date and time
• Custom field type: Checkboxes
• Custom field type: Radio buttons
• Custom field type: Single-user select menu (classic projects)
• Custom field type: Labels
• Issue dialog
• Performance improvements

13 Apr 2021

Column filtering, performance, more custom fields support

• String-based column filtering for text fields
• Performance improvements
• Custom field type: URL
• Custom field type: Date

8 Apr 2021

Custom fields support

• Custom field type: Single-line plain text
• Custom field type: Single-choice select menu
• Custom field type: Number

29 Mar 2021

Initial public release

• Multiple sheets per project
• Easy-to-use JQL composer for sheet scope editing
• Add, remove and re-arrange table columns
• Search in sheet
• Column sorting
• Column resizing
• Support for most standard fields, time tracking fields, and Jira Software fields
• Keyboard commands and navigation
• Select, copy and paste single or multiple cells
• Undo and redo cell changes
• Status bar for cell range calculations and more
• Next-gen project compatibility