Creaing PowerPoint presentation with OpenXml - Absolute position of - Microsoft Community


we're creating powerpoint presentations containing, among other things, line charts. in cases need draw arrow (or other shape) points specific point on chart, given point's (x,y) values in chart.

to this, need absolute position of chart point, relative slide's top-left corner.

currently we're using interop calculate dimensions of chart's plot area, can calculate absolute position of given chart point, shown below:

// chart point's x- , y values  double x = ... ;  double y = ... ;  powerpoint.shape shape = ... ;  powerpoint.chart chart = shape.chart;    double plotarealeft = shape.left + chart.chartarea.left + chart.plotarea.insideleft;  double plotareatop = shape.top + chart.chartarea.top + chart.plotarea.insidetop;    double plotareawidth = chart.plotarea.insidewidth;  double plotareaheight = chart.plotarea.insideheight;    // calculating range of x- , y values  double xmin = ... ;  double xrange = ... ;  double ymin = ... ;  double yrange = ... ;    // calculating exact position of point  double left = plotarealeft + (x - xmin) * plotareawidth / xrange;  double top = plotareatop + (y - ymin) * plotareaheight / yrange;

now works fine, we're in process of moving application server, , switching interop openxml creating presentations.

the problem dimensions of plotarea not fixed, dynamically calculated powerpoint, , calculation seems depending on lot of factors including labels, font, legend, , users manually changing position of plotarea. we're trying reverse-engineer calculation, far haven't been able come solution hits target every time.

we have tried commercial frameworks, such aspose.slides, seem have same problem (the functionality listed in their api, values never calculated - have value of nan).

my question thus: have or resources can use, or experiences solving problem?

thanks in advance.

hi alexander,

to better assistance concern, suggest post query on microsoft developer network forum. that, kindly click on link.

let know if have other concerns.



Office / PowerPoint / Microsoft Office Programming / Office 2010



Comments

Post a Comment

Popular posts from this blog

message deleted by transport agent, event: LED=550 4.3.2 - Microsoft Community

i waiting email verification code *** email address removed privacy *** after signing visual studios account. have run message trace see why email not being delivered , given following message: led=550 4.3.2 queue.transportagent; message deleted transport agent i have looked error , saying message being stuck in queue, resolve unfreeze queue. however, in order need exchange toolbox or exchange management, no longer exists office 365 since eac came about. yet haven't found queue viewers in eac can manage , unfreeze queue.   my spam filter set @ 'bypass spam filters'. have whitelisted domain, , have set connection filter allows ip address domain come through. however, after running message trace, email still being dropped. any insight on why happening?  thanks hi suean-work, according description, have try many settings on side. confirm again ‘bypass spam filters’ settings. did mean have c
Read more

Outlook conversion problem - Microsoft Community

i have orphaned ost file home computer connected office exchange server. home pc crashed , need access ost file using outlook 2010.  no longer have connection exchange server.  there data ost file pst file without expensive conversion tool? thanks there several methods convert ost file pst file. first, microsoft not provide official tool conversion. however, if can access contents of ost file in outlook, can perform conversion manually, follows: 1. start outlook. make sure can access contents in ost file converted. 2. create new pst file. 3. go ost file, select , copy contents converted mouse. 4. go new pst file, paste contents pst file that conversion. second, there many third-party ost pst conversion tools can try. can use online ost pst file conversion service. have used , work. how convert ost pst file can find here https://www.osttopst.online/ Office /
Read more

Outlook 2016 - Insert attachment to Meeting Invite You Do Not Own - Microsoft Community

Image
know if there way insert attachment (e.g., document) within meeting invite not own. example, vp creates meeting invite managers quick touch base.  the managers attach document invitees may view 'summary' while being discussed).  is possible invitee include attachment? hello janice, you can send attachment meetings got invited in outlook 2016. can insert attachment going event go insert tab select attach file . click send update send meeting updates, including attachment. let know if need further assistance. Office / Outlook / Windows 8 / Office 2016
Read more