I am putting together a script to align numbers in a table by decimal/assumed decimals. (I think all of the parts I’ve found here on the forum – what a great resource!)
FrameMaker aligns like this:
We'd like it to align like this:
My script adds “.0” and changes the character style to white. (I got help with that part last week but the post got lost in the Adobe forum conversion.) That part works, but I can’t get it to do more than one cell. We can't run it on all tables in the document, or even a whole table. It will need to be by column. Right now, I'm thinking to put the cursor in the top cell of the column, then run the script. Here’s what I have.
#target framemaker
var doc, pgf, cell, regex;
//given the cell containing the insertion point
doc = app.ActiveDoc;
pgf = doc.TextSelection.beg.obj;
cell = pgf.InTextObj;
regex = /\./; // this finds a decimal
// ...navigate down the column.
while (cell.ObjectValid () === 1) { //I think this is where it breaks down
processDec (pgf, doc, regex);
cell = cell.CellBelowInCol;
}
// From here down it works great, on one cell.
function processDec (pgf, doc, regex) { //by FrameExpert
var end = Constants.FV_OBJ_END_OFFSET - 1, begin = 0, textRange;
var textList = pgf.GetText (Constants.FTI_CharPropsChange);
for (var i = textList.length - 1; i >= 0; i -= 1) {
begin = textList[i].offset;
if (begin !== end) {
textRange = new TextRange (new TextLoc (pgf, begin), new TextLoc (pgf, end));
if (regex.test (getText (textRange, doc)) === false) { // if there is a decimal, nothing happens
addDecimal ();
}
end = begin;
}
}
if (end > 0) {
textRange = new TextRange (new TextLoc (pgf,0), new TextLoc (pgf,end));
if (regex.test (getText (textRange, doc)) === false) { // if there is a decimal, nothing happens
addDecimal ();
}
}
}
function getText (textObj, doc) { //by FrameExpert
var text = "", textItems, i;
if (textObj.constructor.name !== "TextRange") {
textItems = textObj.GetText(Constants.FTI_String);
} else {
textItems = doc.GetTextForRange(textObj, Constants.FTI_String);
}
for (i = 0; i < textItems.len; i += 1) {
text += (textItems[i].sdata);
}
return text;
}
function addDecimal () {
var textRange = new TextRange;
textRange.beg.obj = textRange.end.obj = pgf;
textRange.beg.offset = 0;
textRange.end.offset = Constants.FV_OBJ_END_OFFSET - 1;
doc.TextSelection = textRange;
textRange = doc.TextSelection;
doc.AddText(textRange.end, ".0");
addWhite (); //calls function to apply the White character format to the .0
}
function addWhite () {
var textRange = new TextRange;
textRange.beg.obj = textRange.end.obj = pgf;
textRange.beg.offset = Constants.FV_OBJ_END_OFFSET - 3;
textRange.end.offset = Constants.FV_OBJ_END_OFFSET - 1;
applyCharFmt (textRange, "White", doc);
}
function applyCharFmt (textRange, name, doc) {
var charFmt = 0;
charFmt = doc.GetNamedCharFmt (name);
if (charFmt.ObjectValid()) {
doc.SetTextProps (textRange, charFmt.GetProps());
}
}
If it's possible, I'd like it if we could run it on multiple selected columns. Can anyone help me fix this?
Thank you.
2 Correct answers
Hi,
You have gone a long time without a reply. Maybe you figured it out already. I think the lack of response is related to the big changes with these forums. I'm sorry that you did not get any help yet.
I think your problem is very simple and exactly where you identified it. The problem is that you are iterating through multiple cells, but never resetting the paragraph for processing to the new cells. I think you just need to add one line as shown below:
// ...navigate down the column.
while (ce
16
Replies
Hi Russ,
Thank you for your reply. No, I hadn't received an answer yet. I figured the new format was why.
I used the line you added in my initial code and it does move down the column now. But something is still wrong. I put the cursor in the first cell of each column and ran it. It does this:
(I used "bold" instead of "white" so I could see what it was doing.) The code says to use the addDecimal function if there is no decimal, but on some of the cells it is ignoring that. Is there something wrong with my textRange?
Thanks,
Julie
Russ,
Here is my original post (it got lost in the forum transition):
I am looking for/trying to write a script to align decimals (and assumed decimals) in a table. FrameMaker does not align a column of numbers in a table to the decimal/assumed decimal. Instead, numbers without the decimal are shifted to the right a little.
To get around this, we have to add a decimal after the whole number and color it white, so that it looks like this:
I am trying to write a script to do this for us. The ultimate goal is for us to select the column or columns and then run the script on them. The script will read through the columns and when if finds a whole number, it will add “.0” and tag it “White,” then move on to the next whole number. I’ve been searching the forum for scripts others have shared, and I’m trying to build from the bottom up. So far, I can add the decimal in single cell.
I can also apply the character format; however, it only works if the cursor is before the decimal. If the cursor is after the decimal, it jumps to the next cell, but it doesn’t do anything. How do I make it apply the character format regardless of where the cursor is? [I got this part to work with help from people on the forum.]
I was trying to build from the bottom up, like FrameExpert always says to do. So I started with the most basic step -- adding the decimal. Did I make it more complicated that I needed to?
AdChoices