JavaScript Table API – The Basics

[Dan Korn]

Originally Posted by NPN

Can this be used to solve the problem in this thread?

http://forums.pti.com/showthread.php...border+graphic

Meaning, can you make a dynamic table cell that fits to an uploaded graphic then make a border around it?

Yes. I'll answer in that other thread to keep this one on a narrower topic.

[Doug Pershing]

I don't see a way to span rows or columns. Am I missing something?

[Dan Korn]

Originally Posted by Doug Pershing

I don't see a way to span rows or columns. Am I missing something?

This is called "straddle" in FusionPro. From the original post:

Originally Posted by Dan Korn

To combine or merge cells together, HStraddle and VStraddle can be used to straddle cells both Horizontally and Vertically:

myTable.Rows[3].Cells[0].HStraddle = 2;
myTable.Rows[3].Cells[2].VStraddle = 2;

These properties correspond to the HStraddle and VStraddle attributes of the <cell> tag, as documented in the Tags Reference Guide.

[Doug Pershing]

Thanks Dan. I found it just before you replied.

[Doug Pershing]

Using the VStraddle causes the cell contents to duplicate down a cell.

[DSweet]

Going back to your original post...your command to set the borders of the table includes the "thickness", "color" and "locations". MUST all these be equal? If I wanted to have a top and bottom border different from the left and right border how would I code this?

I tried something like

    text.Rows[0].Cells[0].SetBorders.Top("Thin", "Red");
    text.Rows[0].Cells[0].SetBorders.Bottom("Thin", "Green");
    text.Rows[0].Cells[0].SetBorders.Right("Medium", "Blue");
    text.Rows[0].Cells[0].SetBorders.Left("Medium", "Black");

but that caused an error stating that

text.Rows[0].Cells[0].SetBorders.Top is not a function

I would like to know how to set each one in a tag.
Thanks.
.

[Doug Pershing]

Top is not a function it is a parameter. Try this:

text.Rows[0].Cells[0].SetBorders("Thin", "Red", "Top");
text.Rows[0].Cells[0].SetBorders("Thin", "Green", "Bottom");
text.Rows[0].Cells[0].SetBorders("Medium", "Blue", "Right");
text.Rows[0].Cells[0].SetBorders("Medium", "Black", "Left");

[Dan Korn]

Originally Posted by Doug Pershing

Top is not a function it is a parameter. Try this:

text.Rows[0].Cells[0].SetBorders("Thin", "Red", "Top");
text.Rows[0].Cells[0].SetBorders("Thin", "Green", "Bottom");
text.Rows[0].Cells[0].SetBorders("Medium", "Blue", "Right");
text.Rows[0].Cells[0].SetBorders("Medium", "Black", "Left");

Yes, that's correct. You could also do this:

text.Rows[0].Cells[0].Rulings.Top.Color = "Red";
text.Rows[0].Cells[0].Rulings.Top.Thickness = "Thin";
text.Rows[0].Cells[0].Rulings.Bottom.Color = "Green";
text.Rows[0].Cells[0].Rulings.Bottom.Thickness = "Thin";
text.Rows[0].Cells[0].Rulings.Right.Color = "Blue";
text.Rows[0].Cells[0].Rulings.Right.Thickness = "Medium";
text.Rows[0].Cells[0].Rulings.Left.Color = "Black";
text.Rows[0].Cells[0].Rulings.Left.Thickness = "Medium";

By the way, this entire table API is defined in the Builtins.js file, so feel free to look at the code and see how it generates the table tags. Please do not edit the Builtins.js file, however.

Please feel free to suggest improvements to the API as well, since it's still open for enhancements. For instance, in the latest 7.2P1k release, there's a new FPTable.NewRow() function which returns the newly-added FPTableRow object, so that you don't have to remember the row index.

[Doug Pershing]

Thanks Dan that helps. I have had trouble with the VStraddle command. Whenever I use it the contents of the cell always duplicates into the straddled cell below it. HStraddle works fine. Do you have any idea why the VStraddle would duplicate the contents? I removed all CopyCells commands to make sure it wasn't something I was doing.

[Dan Korn]

Originally Posted by Doug Pershing

Thanks Dan that helps. I have had trouble with the VStraddle command. Whenever I use it the contents of the cell always duplicates into the straddled cell below it. HStraddle works fine. Do you have any idea why the VStraddle would duplicate the contents? I removed all CopyCells commands to make sure it wasn't something I was doing.

Please create a new thread with your specific question. If you can post an example, that would be great.