My Oracle Support Banner

Columns are Ignored When Creating Websheet Data Grid as Copy-Paste from Xls (Doc ID 1439334.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Application Express (APEX) - Version 4.1.0 and later
Information in this document applies to any platform.

Symptoms

Columns are ignored when creating websheet data grid as copy-paste from xls if the columns are empty for the last rows and they are the last columns.

For example, for the xls provided at http://st-curriculum.oracle.com/obe/db/apex/r40/websheets/files/tasks_2010.xls 

  1.  If for the last column (BUDGET) the last value from the column is deleted.
  2. Then the datagrid is created by doing copy-paste from this XLS, the data grid is not creating the BUDGET column. 

This happens for all columns that have empty values in their last rows if they come in succession and there is no subsequent column with a value in the last row (for example, if the COST and BUDGET columns have empty values in the last row, the two columns will not be created). If the last column in the xls has a value for the last row, then all columns are created, even if there are empty values for the columns before. (In this case, if the BUDGET column has a non empty value for the last row, all the columns are created, even if some values from the previous columns are deleted). 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.