nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Auto format values in a wiki table

Matthew Patton_bcgj8y

I'm looking to highlight colors based on values put in a table on a Jira field. I can't copy from excel, because formating doesn't carry over. I'm wondering if there are any solutions with automation or Structures for Jira addon for server. The table is updated once and that's it, just looking to see if we can automate the highlights or get them to carry over if we setup conditional formating in excel.

The table is standard for all issues and looks similar to below. Area a would be green for anything between 0 - .05, everything else is red. Area 2 can be between 73.05 and 73.15 is green, everything else is red...and so on.

Areas	value1	Value2
A	2	0.05
B	73.05	73.15
C
D
E

Accepted answers

Mohamed Adel

Hi @Matthew Patton

I recommend for your this reading article How to embed Excel tables in Jira issues , it will require some macros & Visual Basic in Excel . but I guess it will help in copy pasting the table with the right format

Regards,

Mohamed Adel

All comments

Mohamed Adel

Hi @Matthew Patton

Regards,

Mohamed Adel

Matthew Patton_bcgj8y

Hi Mohamed,

The article was good and easy to follow. Does great formating a table into a wiki format, however it doesn't copy over conditional formating.

Does anyone know if this could be done in groovy/@ScriptRunner ? where I could split the table string by the wiki cell's "|" and parse through the data? Don't need to get into technical details, just wondering plausable.

Mohamed Adel

in nutshell, Yes you can format the field data in your desired format with ScriptRunner , you can use an update listener to format the field value accordingly.

Regards,

Mohamed Adel

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

structure

automation