Calculated cells
It would be interesting to make it possibile to calculate some values inserted into a table, like Excel does.
We can't create calculate fields in existing tables with data inserted into.
This would be very useful when we have some price list in a cloumn, the user puts a quantyty order in a row and then to have the final price (multiplication) in another row.
Francesco
shared this idea
-
Yuri Khristich
commented
Select two cells and run this script.
The script multiplies the two numbers and put the result in clipboard.var sel = app.selection;
app.copy();
var nums = sel[0].contents;
var frame = app.activeDocument.textFrames.add({geometricBounds : [0,0,300,40]});
frame.contents = (Number(nums[0]) * Number(nums[1])).toString();
frame.parentStory.texts[0].select();
app.cut();
frame.remove();
app.select(sel);