Copy And Paste From Excel Into Demantra Not Working When Custom Format Cells Used In Excel

(Doc ID 2358485.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5.1 version, Worksheet

ACTUAL BEHAVIOR
---------------
Customer is on 12.2.6.2

12.2.6 8 12260250
12.2.6 1 12260323
12.2.6 6 12260314
12.2.6 216 0

They have a requirement wherein in the Excel they format the cell to
Custom---> _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

After that if they input any number into the excel copy, then do a copy and
then try to paste that number into Demantra editable series ( either numeric
or string type ) a pop message comes up with the following

Some or all the cells in the paste area contain different cell types. You can
either choose to continue with the paste option by clicking YES option ( in
this case only cells with the same type will receive the pasted value)
YES NO

If they click Yes nothing happens

However if they go back to the excel and change the format of the cell to
Number then the paste works

But the customer has a business need to use the cell format as Custom as they
are using macros



EXPECTED BEHAVIOR
-----------------------
Able to copy and paste the data from Excel to Demantra

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. select series including drop down series
2. Copy from excel
3. Paste in worksheet

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot copy/paste data

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms