DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Import from Exel Clipboard with time format

 
Post new topic   Reply to topic    DPlot Forum Index -> Bug Reports
View previous topic :: View next topic  
Author Message
joma



Joined: 02 Sep 2004
Posts: 7
Location: Germany, near Frankfurt

PostPosted: Thu Sep 02, 2004 4:05 am    Post subject: Import from Exel Clipboard with time format Reply with quote

Suggest, you have the following columns in excel:
2:10 1
2:20 2
2:30 3
2:40 2
This is time and number

Drawing a diagram from these data via the excel plugin works fine, but putting these both columns into the clipboard and inserting them into an open Dplot via paste results in an error message: "Error reading numbers from Clipboard."

Sad JO
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Thu Sep 02, 2004 9:53 am    Post subject: Reply with quote

The short answer is "use the Add-In"

The longer answer is - Copy/Paste doesn't work well for anything but numbers and has limitations with numbers, too. Most applications (and especially Excel) place data in a variety of formats on the clipboard when you 'Copy' it. Currently DPlot only grabs text from the clipboard, which consists of your Excel data exactly as it appears on the spreadsheet. I could spend a lot of time writing code to parse clipboard text, but it would still be unsatisfactory because it would only be working with the data as it is formatted. For example if your time values included seconds but were formatted as "hh:mm" then the seconds would be lost. A better solution, and one that will be added eventually, is to add support for Excel's BIFF clipboard format. BIFF passes all numbers as they are stored internally in Excel. This change was on the front burner for a while but became less important when the Add-In was created.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Bug Reports All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group