Auto format values in a wiki table

[Matthew Patton]

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

[Mohamed Adel · Accepted solution]

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 

[Matthew Patton]

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