Locale Issues While Exporting To Excel (Doc ID 2124559.1)

Last updated on APRIL 14, 2016

Applies to:

Siebel CRM - Version 15.4 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.4 [IP2015] version, Siebel VB / eScript / COM

Using COM Integration, Sending values from Siebel To Excel and then getting values from Excel to Siebel , formats of the calculations returning incorrect. It seems to be Siebel Locale values are getting overwritten by OS values.

EX:
From Siebel 100.00 is sent to excel, the Excel is using the Spanish (Cost Rica) OS formatting for it and changing the value to 100,000 thus making the calculations incorrect in excel. The number then that displays in Siebel is also incorrect. Excel reads the OS and not from Siebel during the integration between the two. How can this be changed? This is also happening for dates in the Com Integration. (Siebel format MM/DD/YYYY, OS format DD/MM/YYYY. )

ERROR
-----------------------
 “Unhandled Exception: Unsupported data type” error is coming.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use below sample code to reproduce the behavior:
  if (MethodName == "MyMethod")
 {
  var Tdate = new Date();
var ExcelApp =
COMCreateObject("Excel.Application");
ExcelApp.Visible = true;
ExcelApp.WorkBooks.Add();
ExcelApp.ActiveSheet.Cells(1,1).Value = Tdate;
// ------- application failing
var fileName = "C:\\TestSuchi.xls";
ExcelApp.ActiveWorkbook.SaveAs (fileName);
ExcelApp.Application.Quit();
ExcelApp = null;
return (CancelOperation);
}



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get Date & Currency data in same format from Excel.

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