JavaScript Table API – The Basics

[dreimer]

Oh interesting didn't know they were reversed. Good to know.

And my main problem was Top and Bottom go in 10ths and Left and Right go in 100ths

Thanks.

[DSweet]

It's been too long for this thread to not have something in it so...I have the following simple code which just loops through a set amount of iterations to create a generic table. Everything worked fine until I wanted to add the colors to the rows to make it look like GreenBar paper. Yea I know I'm really dating my age here, but oh well. I took the coding Dan placed earlier

myTable.ShadingColor1 = "Blue";
myTable.ShadingPct1 = 20;
myTable.ShadingRepeat1 = 1;
myTable.ShadingColor2 = "Red";
myTable.ShadingPct2 = 40;
myTable.ShadingRepeat2 = 1;
myTable.ShadingType = "ByRows";

and I placed it in my table rule

var tableRows = 10;

var colHead1 = 'Record';
var colHead2 = 'First Name in Stack';
var colHead3 = 'Record';
var colHead4 = 'Last Name in Stack';
var colHead5 = 'Print File Name';

var myTable = new FPTable;
myTable.ShadingColor1 = "Blue";
myTable.ShadingPct1 = 20;
myTable.ShadingRepeat1 = 1;
myTable.ShadingColor2 = "Red";
myTable.ShadingPct2 = 40;
myTable.ShadingRepeat2 = 1;
myTable.ShadingType = "ByRows";
myTable.AddColumns(10800, 10800, 10800, 10800, 10800);
myTable.AddRow();

myTable.Rows[0].Cells[0].Margins = new FPTableMargins;
myTable.Rows[0].Cells[0].Margins.Top = 23;
myTable.Rows[0].Cells[0].Margins.Bottom = 23;
myTable.Rows[0].Cells[0].Margins.Right = 10;
myTable.Rows[0].Cells[0].Margins.Left = 10;
myTable.Rows[0].Cells[0].Font="PNCSans";
myTable.Rows[0].Cells[0].PointSize=9.5;
myTable.Rows[0].Cells[0].VAlign = "Middle"
myTable.Rows[0].CopyCells(0, 1, 2, 3, 4);
myTable.Rows[0].SetContents(colHead1, colHead2, colHead3, colHead4, colHead5);
myTable.Rows[0].Type = "Header";


for ( var a = 1; a <= tableRows; a++)  {
    myTable.AddRow();
    myTable.Rows[a].Cells[0].Margins = new FPTableMargins;
    myTable.Rows[a].Cells[0].Margins.Top = 23;
    myTable.Rows[a].Cells[0].Margins.Bottom = 23;
    myTable.Rows[a].Cells[0].Margins.Right = 100;
    myTable.Rows[a].Cells[0].Margins.Left = 10;
    myTable.Rows[a].Cells[0].Font="PNCSans";
    myTable.Rows[a].Cells[0].PointSize=8.4;
    myTable.Rows[a].Cells[0].VAlign = "Middle"
    myTable.Rows[a].CopyCells(0, 1, 2, 3, 4);
    myTable.Rows[a].Cells[0].Content = "Record 1-"+a;
    myTable.Rows[a].Cells[1].Content = "First Name 1-"+a;
    myTable.Rows[a].Cells[2].Content = "Record 2-"+a;
    myTable.Rows[a].Cells[3].Content = "First Name 2-"+a;
    myTable.Rows[a].Cells[4].Content = "Print File_"+a;
}

return myTable.MakeTags();

However no matter where I place the code section for the color (I've tried at the front as shown above, I've tried placing it in front of and after the "myTable.AddRow();" statements, I've tried placing it at the end before the "MakeTags()" statement) each time I get a blank table. The contents of each cell are correct, but no color. Am I missing something? Where does the color coding come in to the programming scheme?

[step]

Originally Posted by DSweet

var tableRows = 10;

var colHead1 = 'Record';
var colHead2 = 'First Name in Stack';
var colHead3 = 'Record';
var colHead4 = 'Last Name in Stack';
var colHead5 = 'Print File Name';

var myTable = new FPTable;
myTable.ShadingColor1 = "Blue";
myTable.ShadingPct1 = 20;
myTable.ShadingRepeat1 = 1;
myTable.ShadingColor2 = "Red";
myTable.ShadingPct2 = 40;
myTable.ShadingRepeat2 = 1;
myTable.ShadingType = "ByRow";
myTable.AddColumns(10800, 10800, 10800, 10800, 10800);
myTable.AddRow();

myTable.Rows[0].Cells[0].Margins = new FPTableMargins;
myTable.Rows[0].Cells[0].Margins.Top = 23;
myTable.Rows[0].Cells[0].Margins.Bottom = 23;
myTable.Rows[0].Cells[0].Margins.Right = 10;
myTable.Rows[0].Cells[0].Margins.Left = 10;
myTable.Rows[0].Cells[0].Font="PNCSans";
myTable.Rows[0].Cells[0].PointSize=9.5;
myTable.Rows[0].Cells[0].VAlign = "Middle"
myTable.Rows[0].CopyCells(0, 1, 2, 3, 4);
myTable.Rows[0].SetContents(colHead1, colHead2, colHead3, colHead4, colHead5);
myTable.Rows[0].Type = "Header";


for ( var a = 1; a <= tableRows; a++)  {
    myTable.AddRow();
    myTable.Rows[a].Cells[0].Margins = new FPTableMargins;
    myTable.Rows[a].Cells[0].Margins.Top = 23;
    myTable.Rows[a].Cells[0].Margins.Bottom = 23;
    myTable.Rows[a].Cells[0].Margins.Right = 100;
    myTable.Rows[a].Cells[0].Margins.Left = 10;
    myTable.Rows[a].Cells[0].Font="PNCSans";
    myTable.Rows[a].Cells[0].PointSize=8.4;
    myTable.Rows[a].Cells[0].VAlign = "Middle"
    myTable.Rows[a].CopyCells(0, 1, 2, 3, 4);
    myTable.Rows[a].Cells[0].Content = "Record 1-"+a;
    myTable.Rows[a].Cells[1].Content = "First Name 1-"+a;
    myTable.Rows[a].Cells[2].Content = "Record 2-"+a;
    myTable.Rows[a].Cells[3].Content = "First Name 2-"+a;
    myTable.Rows[a].Cells[4].Content = "Print File_"+a;
}

return myTable.MakeTags();

You just need to change it to "ByRow" instead of "ByRows".

[DSweet]

Thanks Step. I really thought I had "copy and pasted" it. Not quite sure as to why it came out differently. Guess my mind is slipping.

Thanks again.
.

[step]

Originally Posted by MikeA

Hello all,

I'm hoping someone can point me in the right direction. Like the previous poster, I'm having an issue with the VAlign property of FPTable. I have a rule in which I create a table and set it to align cell content to center, both horizontally and vertically. This works if I call the rule as the first item in a text box. But if there is anything at all, even just a carriage return, above the rule, the content of the cells floats to the top. Everything else looks to be following the rule.

Here is the rule:

new FPTable;
var myTable = new FPTable;
myTable.AddColumns(16000, 6000, 6000, 6000, 6000, 6000);

// Add the top row
var topRow = myTable.AddRow();
    topRow.Cells[0].HAlign = "Center";
    topRow.Cells[0].VAlign = "Middle";
    topRow.Cells[0].SetBorders("Thin", "Black", "Top", "Bottom", "Right", "Left");
    topRow.Cells[0].Font="Times New Roman";
    topRow.Cells[0].PointSize=11;    
    topRow.Cells[0].Bold="On";
    topRow.CopyCells(0,1,2,3,4,5);
    topRow.SetContents("Your Monthly Amount", "$100", "$250", "$500", "$1,000", "$5,000");

// Add the bottom row
var bottomRow = myTable.AddRow();
    bottomRow.Cells[0].SetBorders("Thin", "Black", "Top", "Bottom", "Right", "Left");
    bottomRow.Cells[0].ShadeColor="Black";
    bottomRow.Cells[0].ShadePct=15;
    bottomRow.Cells[0].Font="Times New Roman";
    bottomRow.Cells[0].PointSize=11;
    bottomRow.Cells[0].Bold="On";    
    bottomRow.CopyCells(0,1,2,3,4,5);
    bottomRow.SetContents("Our Offer To You", "100", "250", "500", "1000", "5000");

// Center the table in the text box
return myTable.MakeTags().replace(/^\<table/, "<table alignment=center");

Using FP VDP Creator 8.2.7. I've attached a sample job for perusal. I cannot seem to figure this one out.

Thanks!

I understand this is a relatively old post, but I've been battling this bug all week and thought I'd share another workaround. I've noticed in the past that toggling "use legacy line leading" will sometimes remedy the issue (as previously noted in this thread) but I'm still unclear as to why that is. Furthermore, I think FusionPro has begun to rework the way it handles leading – so relying on "legacy" leading as a workaround did not sit well with me.

While thumbing through the section on tables in the TagsRefGuide, I noticed a "space" attribute and found that if you define space above (or below) the table, all of the cells magically become centered again:

var myTable = new FPTable;
myTable.AddColumns(16000, 6000, 6000, 6000, 6000, 6000);

// Add the top row
var topRow = myTable.AddRow();
    topRow.Cells[0].HAlign = "Center";
    topRow.Cells[0].VAlign = "Middle";
    topRow.Cells[0].SetBorders("Thin", "Black", "Top", "Bottom", "Right", "Left");
    topRow.Cells[0].Font="Times New Roman";
    topRow.Cells[0].PointSize=11;    
    topRow.Cells[0].Bold="On";
    topRow.CopyCells(0,1,2,3,4,5);
    topRow.SetContents("Your Monthly Amount", "$100", "$250", "$500", "$1,000", "$5,000");

// Add the bottom row
var bottomRow = myTable.AddRow();
    bottomRow.Cells[0].SetBorders("Thin", "Black", "Top", "Bottom", "Right", "Left");
    bottomRow.Cells[0].ShadeColor="Black";
    bottomRow.Cells[0].ShadePct=15;
    bottomRow.Cells[0].Font="Times New Roman";
    bottomRow.Cells[0].PointSize=11;
    bottomRow.Cells[0].Bold="On";    
    bottomRow.CopyCells(0,1,2,3,4,5);
    bottomRow.SetContents("Our Offer To You", "100", "250", "500", "1000", "5000");
// Center the table in the text box
return myTable.MakeTags().replace(/^\<table/, '<table space="above:1" alignment=center');

If you actually want to add space above/below the table, then it's worth mentioning that the value should be in 10ths of a point but any value greater than 0 fixes the alignment issue. More info can be found on page 56 of the TagsRefGuide.pdf

[Dan Korn]

Originally Posted by step

Furthermore, I think FusionPro has begun to rework the way it handles leading

Yes, in FusionPro 9.3.36 and later, you can specify the leading mode as 9.3 on the Global Paragraph Settings dialog, which improves several issues like this regarding text layout in tables.

[sdavenport]

What is the proper tag for assigning a Title to a table?

[Dan Korn]

Originally Posted by sdavenport

What is the proper tag for assigning a Title to a table?

It's the <title> tag, as documented in the FusionPro Tags Reference. But there's no corresponding property in the JavaScript table API, because, quite frankly, it's just as easy to put the title in the text frame before the rule that builds the table.