19
Replies
Hi @Eugene Tyson , I think you would have to get and set the column widths—you are looking for something like this?
Before
After
// Check if a document is open
if (app.documents.length > 0) {
var doc = app.activeDocument;
// Check if a table is selected
if (app.selection.length > 0 && app.selection[0] instanceof Table) {
var table = app.selection[0];
var frame = table.parent;
// Get the selected text frame
var myTextFrame = frame;
// Get the number of columns and gutter width
var myColAmount = myTextFrame.textFramePreferences.textColumnCount;
var myGutterWidth = myTextFrame.textFramePreferences.textColumnGutter;
// Calculate the total width of the text frame and available width for columns
var myTextFrameBounds = myTextFrame.geometricBounds;
var myTotalWidth = myTextFrameBounds[3] - myTextFrameBounds[1];
var myAvailableWidth = myTotalWidth - (myGutterWidth * (myColAmount - 1));
// Calculate the width of each column
var myColumnWidth = myAvailableWidth / myColAmount;
//get the width of each column as a percentage of the table width
var ca = getColumnWidths(table)
// Set the table width to match the calculated column width
table.width = myColumnWidth;
//adjust the resized table’s column percentages
setColumnWidths(table, ca)
//alert("Table width set to match the column width of the text frame!");
} else {
alert("Please select a table before running the script.");
}
} else {
alert("Open a document before running the script.");
}
/**
* Gets an array of column widths as a percentage relative to the table width
* @ param the table
* @ return an array of column percentages
*
*/
function getColumnWidths(t){
var ca = []
var tw = t.width;
var tc = t.columns.everyItem().getElements()
for (var i = 0; i < tc.length; i++){
ca.push(tc[i].width/tw)
};
return ca
}
/**
* Sets a table’s column widths to the provided array of percentages
* @ param the table
* @ param an array of column percentages
* @ return void
*
*/
function setColumnWidths(t, a){
var tw = t.width;
var tc = t.columns.everyItem().getElements();
if (tc.length == a.length) {
for (var i = 0; i < tc.length; i++){
tc[i].width = tw*a[i]
};
}
}
I'll see if I can tweak it.
Would scaling the column insets along with the column widths work?
function setColumnWidths(t, a){
var tw = t.width;
var tc = t.columns.everyItem().getElements();
if (tc.length == a.length) {
for (var i = 0; i < tc.length; i++){
tc[i].width = tw*a[i];
tc[i].leftInset = tc[i].leftInset*a[i];
tc[i].rightInset = tc[i].rightInset*a[i];
};
}
}
Before and after
just not taking into account if the text frame has an inset
Scaling the insets for each column differently, probably doesn’t work. Might be better to get the first column’s scaled inset and use it for all?
By @rob day
I'm pretty sure, if you use my method - calculate the "scale" of the transformation - you can multiply insets by it - or any other aspect of the table - even the thickness of the edges - vertical ones of course.
For horizontal properties - scale of the difference in height should be calculated and used.
but isn't it the same for each column?
I think Eugene’s starting columns are different widths, and when he changes the width of the table they become the same—which he doesn’t want. If I run his OP code I get this:
He wants the resized table’s columns to keep their original proportions:
[...]
He wants this where the resized table’s columns are proportionally the same:
By @rob day
Yes, that's my point.
If you have a table with 4x columns:
20 | 30 | 40 | 50
Total width = 140
Let's assume - for simplicity - that the end width will be 70, then:
70 / 140 = 0.5
so:
20 * 0.5 = 10
30 * 0.5 = 15
40 * 0.5 = 20
50 * 0.5 = 25
and the total is 70...
One slight issue
It says NaN error when the text frame is not exactly square...
no part of the table can go past the gutter
The NaN is happening because you are skipping my getter function and writing your own loop, which is ok but you are getting the values after the table has been resized—if you don‘t want to use the getter function move your loop to before the table resize.
If the table/cell stroke value is known you could use it to adjust the final width, otherwise you would have to loop through the cells and get the max left and right stroke value, which could get tricky if there are different weights.
So in this example the left/right stroke is 5 points:
The stroke weight values are returned as points so I’ve set the measurement units to points at the top:
// Check if a document is open
if (app.documents.length > 0) {
var doc = app.activeDocument;
// Check if a table is selected
if (app.selection.length > 0 && app.selection[0] instanceof Table) {
//use points for measurements
app.scriptPreferences.measurementUnit = MeasurementUnits.POINTS;
var table = app.selection[0];
var frame = table.parent;
// Get the selected text frame
var myTextFrame = frame;
// Get the number of columns and gutter width
var myColAmount = myTextFrame.textFramePreferences.textColumnCount;
var myGutterWidth = myTextFrame.textFramePreferences.textColumnGutter;
// Calculate the total width of the text frame and available width for columns
var myTextFrameBounds = myTextFrame.geometricBounds;
var myTotalWidth = myTextFrameBounds[3] - myTextFrameBounds[1];
var myAvailableWidth = myTotalWidth - (myGutterWidth * (myColAmount - 1));
// Calculate the width of each column
var myColumnWidth = myAvailableWidth / myColAmount;
//get the width of each column as a percentage of the table width
//get the widths before the table is resized
var ca = getColumnWidths(table);
// Set the table width to match the calculated column width minus a stroke value
// if the stroke value is unknown add a function to get
table.width = myColumnWidth-5;
//adjust the table’s column percentages
setColumnWidths(table, ca)
app.scriptPreferences.measurementUnit = AutoEnum.AUTO_VALUE;
alert("Table width set to match the column width of the text frame!");
} else {
alert("Please select a table before running the script.");
}
} else {
alert("Open a document before running the script.");
}
/**
* Gets an array of column widths as a percentage relative to the table width
* @ param the table
* @ return an array of column percentages
*
*/
function getColumnWidths(t){
var ca = []
var tw = t.width;
var tc = t.columns.everyItem().getElements()
for (var i = 0; i < tc.length; i++){
ca.push((tc[i].width/tw).toFixed(2))
//$.writeln(tc[i].width)
};
return ca
}
/**
* Set a table’s column widths to the provided array aof percentages
* @ param the table
* @ param an array of column percentages
* @ return void
*
*/
function setColumnWidths(t, a){
var tw = t.width;
var tc = t.columns.everyItem().getElements();
if (tc.length == a.length) {
var ci = tc[0].leftInset * a[0]
for (var i = 0; i < tc.length; i++){
tc[i].width = tw*a[i];
tc[i].leftInset = ci;
tc[i].rightInset = ci;
};
}
}
AdChoices