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