Referencing Calc spreadsheet cells in Draw text boxes
Posted: Tue Feb 12, 2019 12:28 am
I'm looking for advice on a little project.
I have an OO Draw .odg file. In the drawing is a square box with eight text boxes. The text boxes are player positions in a game. I want to reference those player position names out of a spreadsheet. That way anyone can simply update the positions in the spreadsheet cells and I only have to open and print the drawing without making hard changes in the drawing. The final rendition of this will have much more data and player positions, but this gets the point across.
I'm assuming this can be done through scripting or OO BASIC but I'm a wee bit rusty in my programming these days.....
I've included the two files.
Thanks,
D. Speirs
I have an OO Draw .odg file. In the drawing is a square box with eight text boxes. The text boxes are player positions in a game. I want to reference those player position names out of a spreadsheet. That way anyone can simply update the positions in the spreadsheet cells and I only have to open and print the drawing without making hard changes in the drawing. The final rendition of this will have much more data and player positions, but this gets the point across.
I'm assuming this can be done through scripting or OO BASIC but I'm a wee bit rusty in my programming these days.....
I've included the two files.
Thanks,
D. Speirs