Truncated y data with separated columns imported from excel

Found a bug? Tell us about it here

Moderator: DPlotAdmin

Post Reply
Ashi
Posts: 28
Joined: Sun Dec 30, 2007 11:49 pm

Truncated y data with separated columns imported from excel

Post by Ashi »

If the number of y data points is uneven when importing two separated columns from excel (as in, you need to hold ctrl to select them), the longer data gets truncated.

This only happens if the columns are separated, you use ctrl to select them, and if the last column is the shorter one.

Examples:
Sorry, it's dropping the formatting in my post but if you click edit as admin or click "quote" you should see the formatting.

This gets truncated:
X Y1 Y2
0.28 128109.6023 136513.3172
0.3 123353.2152 131468.3675
0.32 116310.8059 124168.3574
0.34 111313.4909 118948.3447
0.36 107922.1955 115369.882
0.38 105756.033
0.4 103903.3047
0.42 101940.2787

This does not get truncated:


X Y2 Y1
0.28 136513.3172 128109.6023
0.3 131468.3675 123353.2152
0.32 124168.3574 116310.8059
0.34 118948.3447 111313.4909
0.36 115369.882 107922.1955
0.38 105756.033
0.4 103903.3047
0.42 101940.2787

This does not get truncated:

X Y2 Y1
0.28 136513.3172 128109.6023
0.3 131468.3675 123353.2152
0.32 124168.3574 116310.8059
0.34 118948.3447 111313.4909
0.36 115369.882 107922.1955
0.38 105756.033
0.4 103903.3047
0.42 101940.2787
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

Thanks for pointing out the problem. I'll fix that before the next release.
Visualize Your Data
support@dplot.com
Post Reply