The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Copy from Excel full precision

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AnaJesus Posted - 01/27/2024 : 11:45:17 AM
Hi,

According with video tutorials pasting data from excel is by default done with full precision. It is not happening in my case and is causing me problems due to the type of data I work with. I have MAC so I use parallels in consolidate mode and origin works perfectly and quickly. I tried opening my excel files in windows and paste from there to Origin but still it doesn't work and only visible digits are being copied instead of the full precision. Can someone help please?

I have been looking online, on tutorials and in the forum but can't solve my issue, apologies if I missed it posted elsewhere and thanks in advance.

AnaJ

Origin Ver. and Service Release Origin 2024 (64-bit)
10.1.0.170) | Operating System:IOS

Origin Ver. and Service Release Origin 2024 (64-bit)
10.1.0.170):
Operating System:IOS
3   L A T E S T    R E P L I E S    (Newest First)
snowli Posted - 01/29/2024 : 08:39:12 AM
Hi AnaJesus,

Do you mind sharing your data so I can see how to reproduce it.
Also, is it really a full precision data or just large ID kind of number.

Thanks, Snow
AnaJesus Posted - 01/29/2024 : 05:15:42 AM
I Snow

Thanks for your feedback. Unfortunately this is not the issue, the problem is really the import. If I change the significant digits I get only zeros because the data was not imported with full precision so the information is not there to be displayed.

As for now, I am importing excel sheets in the bulk and then once they are in originlab I can copy the data under full precision. THis is really time consuming and not practical at all so if someone has a way to directly copy and paste data from excel spreadsheets with full precision I appreciate the feeback.

Thnak you once more
AnaJ



Origin Ver. and Service Release Origin 2024 (64-bit)
10.1.0.170):
Operating System:IOS
snowli Posted - 01/27/2024 : 4:30:46 PM
It may be a display issue only. See "A Note about Displayed vs. Actual Values" on https://www.originlab.com/doc/en/Origin-Help/Wks-Col

E.g. if you double click the column header to open Column Properties dialog.
Then set Display digits to significant digits 15.
You should see full digits.



Thanks, Snow

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000