Analysis

  • Status Unconfirmed
  • Percent Complete
    0%
  • Task Type Bug Report
  • Category Other
  • Assigned To No-one
  • Operating System Windows
  • Severity Low
  • Priority Very Low
  • Reported Version 2.1.1
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Analysis
Opened by Jamie Hockin - 12.06.2009
Last edited by Torsten Bonde Christiansen - 22.09.2010

FS#8 - Import from Excel Clipboard

Analysis v 2.2 (build 169 and earlier)

read /cb failed with import of a single column or if there were any missing values in the last numeric column imported
Workaround: create a new column in Excel that had no missing values or include . for missing values

Reads OK:
test note n2
0.025974026 1 a
0.019933555 1 b
0.013333333 1 c
0.049382716 1 d
0.034059946 1

reads OK:
test note n2
0.025974026 1 a
0.019933555 1 b
0.013333333 1 c
0.049382716 1 d
0.034059946 e

does not read:
test note n2
0.025974026 1 a
0.019933555 1 b
0.013333333 1 c
0.049382716 1 d
0.034059946

error message:
Separators: (tab: 10)(semicolon: 0)(comma: 0)(space: 0) Lines: 6
Cannot define number of variables

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing