I have a scenario where i want to reuse an image within my Excel spreadsheet. In the sheet I have an image (red/yellow/green circle for status). Rather than use xlsxAddImage which will create a copy of the image X number of times, I have created an Excel Template that has the image in there once and then I am using the twoCellAnchor concept and referencing the same image by rID#. This works fine when working with OpenXML and verifying everything in the Office productivity tool. However, since this is in a different namespace than the original x: used in Row, it seems that the xlsxAdd has a big issue here. Not sure why, but it's not working. here's what I am seeing.
First, I would normally thing i would reference it by doing {{#xlsxAdd "xl/drawings/drawing1.xml" "wsDr.twoCellAnchor"}}, but instead I have to do {{#xlsxAdd "xl/drawings/drawing1.xml" "xdr:wsDr.twoCellAnchor"}} otherwise it creates another XML node without the namespace. This is not an issue, but is slightly odd.
Second (and the real issue) is that my content should be something like
<xdr:twoCellAnchor editAs="oneCell" xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing">
...
</xdr:twoCellAnchor>
However, the result in the file generated strips out the xdr: from the node. This is causing Excel to not render anything (as well as the productivity tool not knowing what type of node it is). I have also tried
<xdr:twoCellAnchor editAs="oneCell">
and that didn't help anything.
Any help I can get on handling the namespace appropriately would be appreciated.