All the tables in the active document! …
Indesign active tables plugin how to#
I can apply a cell style or a paragraph style to the content in that cell, but I don't know how to both search for a cell or paragraph style and then still search for the range of numbers to apply the various colors. Active Tables lets you display numbers in several ways, and you can assign paragraph styles to formulas. You can also sort and move columns and rows, even change rows to columns or columns to rows. On this particular table, because it is a data merge and I don't want to repeat the headers over and over on the page, I have eliminated the Table Header, and now I no longer have a way to differentiate that column. For example, Active Tables brings Excel-like formulas to InDesign, so you can add a column of numbers. a larger range of colors to be applied to numbers. But there is a final column that has different conditional formatting. Using the decimal search allowed me to differentiate those numbers from the ones with the various color backgrounds. I have several columns of numbers that need to remain with just a gray background. I thought I was all set but I have one last riddle to solve. Var m圜ells = .cells.everyItem().getElements(),įor ( c = 0 c = 0 & Number(m圜ntents) = 50 & Number(m圜ntents) = 70 & Number(m圜ntents) = 0 & Number(m圜ntents) = 25 & Number(m圜ntents) = 45 & Number(m圜ntents) = 60 & Number(m圜ntents) = 80 & Number(m圜ntents) <= 100 ) m圜ells.appliedCellStyle = "Grade Blue" Place the cursor in the cell of a table Var overrides = myFound.clearOverrides() //this is the new line added in this content Is there a way to search by column title and apply the formula, so I don't have to go through and manually select each text frame to apply the second forumula? Does that make sense?Īlert ("Please select a table or a frame containing a table.") Īpp.findGrepPreferences = app.changeGrepPreferences = null Īpp.findGrepPreferences.findWhat = "^\\d+(\\.\\d+)?" The following script does what I want for the first situation, but it then I can't run the second script because it will change the colors I already changed using the first script. But then I have four columns that are "grades," and they have more variety in the colors (red, orange, yellow, green, blue e.g. So for example I have four columns that are "ranks," and those would just have red, yellow, or green backgrounds applied (which I change with a cell style)(e.g. I have a script that will find a number and change the cell style based on the number, but I need to use a second formula for finding the cell to apply the cell style to, based on the Column Title. Since I'm really new to scripting I can't get this to work as I want to. I'm trying to get a script for applying cell styles based on content.
0 kommentar(er)
