Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
TKendrick20
Partner - Specialist
Partner - Specialist

Extension that adds objects at predefined locations?

Is it possible to create an extension where I could click a button and the extension would run and insert a text box at a certain location with a certain color and certain size?

Let me elaborate: If I have 7 sheets and want three text boxes in the same exact position and size on each page, but don't want to go through and manually do this on each sheet, could an extension be programmed so that it knows where to drop these text boxes on each page?

6 Replies
Anonymous
Not applicable

I think it easier to copy/paste rather than create a special extension or macro for this.

Create your three objects on one sheet, select all three, copy (Ctrl+C), go to another sheet, right-click, paste as Link, repeat on the other sheets.

Doesn't it work for you?

TKendrick20
Partner - Specialist
Partner - Specialist
Author

I can only seem to copy one item at a time, and it always goes to the same place on the next page. I need it to be formatted based on what's already on that page.

Alexander_Thor
Employee
Employee

Extensions can't add objects into the core document.

You could add HTML elements into the browser at run time but they will be lost whenever you refresh the page.

As Michael suggests linked objects are the way to go in terms of maintainability.

If you want to automate creation of documents maybe macros could help you out, loop all the sheets and add the objects.

TKendrick20
Partner - Specialist
Partner - Specialist
Author

and how does one link objects?

Alexander_Thor
Employee
Employee

Copy a object, right click > 'Paste object as Link' or simply enter the same object id in the objects you want to link.


Then the objects will be linked, change it one place and it will propagate to all of the linked objects.

Anonymous
Not applicable

The advantage of the linked objects that are in fact "the same" object which exists in multiple places.  If you change a property like text color or font size, it changes in all linked objects.  But location on sheets can be different.

Object ID is the same for all linked objects.

(I don't know why you cant copy/paste multiple objects at a time.  Make sure that you select multiple.)