Thank you, it helped me a lot.
Tomas Deák
@Tomas Deák
0
Reputation
2
Posts
210
Profile views
0
Followers
0
Following
Posts made by Tomas Deák
-
XLSX Chart position
Hello,
I am attempting to change the position of a chart in Excel, but I'm unsure how to proceed.
I discovered that the chart's position is located at the path xl/drawings/drawing1.xml, and the relevant element is xdr:twoCellAnchor. I tried modifying xdr:from and xdr:to using xlsxMerge or xlsxReplace, but unfortunately, I did not achieve any results.
for example:
{{#xlsxMerge "xl/drawings/drawing1.xml" (replace "xdr:wsDr.xdr:twoCellAnchor.xdr:from.xdr:row" "12" 20)}}
<c t="inlineStr"><is><t>20</t></is></c>
{{/xlsxMerge}}https://playground.jsreport.net/w/TomiDeak/~avzfgwq
![alt text]( image url)
Do you have any suggestions for this?