ADF Desktop Integration (ADFdi)

How to evaluate excel formula in cell of ADF Desktop Integration table component?

Problem I was trying to evaluate excel formula in cell of ADFdi  table component. My try was unsuccessfull, got formula rendered as a literal string in the cell. Solution Apparently when ADFdi plugin evaluates value expression of particular column, it needs to know what kind of output you expect in the cell. Is it a literal value, o some instructions…

Continue Reading

ADF, ADF Desktop Integration (ADFdi), ADF Exceptions

ADF Desktop Integration Excel worksheet exception on upload operation: ArgumentException: invalid area string: N5:Q5,S5

Full exception stack: ArgumentException: invalid area string: N5:Q5,S5 Source: adfdi-excel-om-api Stack: at oracle.adf.client.windows.excel.om.api.ExcelRangeAreas.ParseRangeAddress() at oracle.adf.client.windows.excel.om.api.cache.ExcelRangeCache.get_RangeAreas() at oracle.adf.client.windows.excel.om.api.ExcelRangeReader..ctor(ExcelRange range, Int32 maxRows) at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.InitDataRangeIterator() at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.ProcessRows(Boolean abortOnFail) at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.Run(RTColumn rtColumnFlaggedOrChanged, Int32 cRowsFlaggedOrChanged, Boolean abortOnFail) at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.Upload(Boolean haveOptions, Boolean abortOnFail, Boolean downloadAfterUpload) at oracle.adf.client.windows.excel.runtime.uicomponent.RTDataEntryGrid.Invoke(RTComponentAction rtAction) at oracle.adf.client.windows.excel.runtime.uicomponent.RTActionCollection.DoInvoke(RTColumnCollection parent) This exception is thrown when data upload to server is requested. Range N5:Q5,S5 specifies cells…

Continue Reading

ADF Desktop Integration (ADFdi)

ADF dekstop integration (ADFdi) plugin with macro enabled file doesn’t work when opened from MS Internet Explorer. File is opened but nothing is loaded. Why?

Actually this is not an issue or bug, it is not even directly related to ADFdi. Everything work as supposed to 🙂 ADFdi plugin can’t function properly, because Excel opens file in a protected view. This happens because AES (Attachment Execution Services) marks file as downloaded from internet (only MS IE and Outlook can do this). Before showing file contents…

Continue Reading

ADF, ADF Desktop Integration (ADFdi), ADF Exceptions

ADFDI-00502: The client was unable to establish an unauthenticated session with the web application. What can be the reason?

I have experienced such error. The reason was, that web application didn’t know, that servlet “adfdiRemoteServlet”, responsible for Excel workbook connectivity, should be secured. Problem happens only when ADF security is set to “ADF Authentication and Authorization”. This means, that ADF takes care not just for login, but for access to various resources (in our case it is adfdiRemoteServlet) as…

Continue Reading