Skip to Content
0
Sep 01, 2020 at 11:36 AM

How to download an excel from Smart Table with multi input custom field

312 Views Last edit Sep 01, 2020 at 11:40 AM 2 rev

Hi Community,

My requirement it's to download an excel spreadsheet from an Smart Table that has a custom field that it's a multi input (can have more than one value).

I had put in the custom field "leadingProperty": "<navigation>/<Field>" and it looks like this:

<smartTable:SmartTable id="smartTable_ResponsiveTable" smartFilterId="smartFilterBar" tableType="ResponsiveTable" editable="false"
entitySet="et_trSet" useVariantManagement="true" header="Transport Request" showRowCount="true" useExportToExcel="true"
beforeExport="onBeforeExport" enableAutoBinding="false" demandPopin="true" persistencyKey="SmartTablePKey" useTablePersonalisation="true"
showTablePersonalisation="true" beforeRebindTable="onBeforeRebindTable"><Column id="Env" width="100px" hAlign="Begin">[...]


<customData>
<core:CustomData id="customEnv" key="p13nData"
value="\{"columnKey": "ntr_env/Env", "columnIndex":"9", "isCurrency": false, "leadingProperty": "ntr_env/Env", "sortProperty": "ntr_env/Env"}"/>
</customData>
<Text id="TextEnv" text="Environment"/>

[...]


</Column><cells>
<MultiInput id="idSmartMultiInput4" tokens="{ntr_env}" change="onEnvChange" tokenUpdate="onEnvUpdate" showValueHelp="false" maxLength="10">
<tokens>
<Token id="token" text="{Env}"/>
</tokens>
</MultiInput>
</cells>

and my Controller looks like:

		onBeforeExport: function (oEvt) {
			var mExcelSettings = oEvt.getParameter("exportSettings");


			// Disable Worker as Mockserver is used in Demokit sample
			mExcelSettings.worker = false;
		},

And even tho, I have, at least, one entry on the field, doesn't show in the excel.

I already tryied the functionality of Spliting cells with multiple values, and didn't work.

Am I doing something wrong?

Any advice on this?

thank you and regards