asp.net mvc 3 - Exporting a hyperlink in Pivot Grid -
i have pivot grid exports both gridview , pivotgrid. gridview export correctly creates hyperlinks users. however, pivotgrid export not. question is, there way export hyperlink still hyperlink?
below code have in controller export.
public actionresult exportpivotgrid() { //a fresh copy of data session["ipdreportsdata"] = ipdreport.getreportdata(session["adhocdatasource"].tostring(), sccview.classes.helper.officeid); var pivotgridsettings = new pivotgridsettings(); pivotgridsettings.name = "exportpivotgrid"; pivotgridsettings.beforeperformdataselect = (s, e) => { mvcxpivotgrid pivotgrid = s mvcxpivotgrid; //get current layout of pivot grid string layout = (string)(session["ipdcurrentpivgridlayout"]); pivotgrid.loadlayoutfromstring(layout, devexpress.web.aspxpivotgrid.pivotgridweboptionslayout.defaultlayout); }; xlsxexportoptionsex xopt = new xlsxexportoptionsex(); xopt.allowhyperlinks = defaultboolean.true; xopt.exporthyperlinks = true; xopt.textexportmode = textexportmode.text; xopt.exporttype = devexpress.export.exporttype.wysiwyg; return pivotgridextension.exporttoxlsx(pivotgridsettings, session["ipdreportsdata"], true, xopt); }
i have working within pivot grid page displayed, using fieldvaluedisplaytext method in settings of pivot grid. however, when tried apply export, export never loaded.
any appreciated.
Comments
Post a Comment