PC Review


Reply
Thread Tools Rate Thread

copy paste is changing the cell value format.

 
 
Aruna Akella
Guest
Posts: n/a
 
      21st Dec 2007
I have endlish OS machine but changed my decimal seperator to "," in regional
settings.

My app is an addin to Excel - and a src cell has "1.5" as cell value - but
when I copy and paste it after initializing my app, then the destination cell
value is changed to "1,5" (but before initializing my app, native Excel
copy/paste shows correct format of destination cell value).

Below is the code that I do during copy/paste operation with in Excel from
my app.

string srcCellValue = "1.5"

// during my debug mode - I see correct format of excel destination cell
value
// at this point, but after I call set_Value() method, the destination cell
// value changes to "1,5".
destRange.set_Value(Excel1.XlRangeValueDataType.xlRangeValueDefault,
srcCellValue);

Any help is really appreciated. I did also try changing the numberdecimal
seperator to "." before calling set_value method - but this didn't help! (

Thread.CurrentThread.CurrentCulture.NumberFormat.NumberDecimalSeparator = ".")

Thanks!

--
Aruna
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel format changing when using copy and paste bmsmith General Software 0 1st Aug 2011 06:02 AM
Changing date format in copy paste Wullie Microsoft Excel Misc 2 8th Dec 2008 01:06 PM
How do you copy and paste and word doc. w/o changing the format? =?Utf-8?B?VHJhY3k=?= Microsoft Word Document Management 1 1st Nov 2006 08:23 PM
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Microsoft Excel Worksheet Functions 1 11th Mar 2006 04:44 AM
Copy and Paste macro needs to paste to a changing cell reference =?Utf-8?B?bG91bG91?= Microsoft Excel Programming 0 24th Feb 2005 10:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:35 AM.