[Enhancement suggestion]: add check that sampleSheet Sentrix_ID col is not in scientific notation

[ew367]

Contact Details

No response

Enhancement suggestion

the sentrix_ID col is often coerced into scientific notation by excel. This causes errors in the QC.rmd script.

possible solutions - extract sentrix_ID from basename
add a check before running calcQCmetrics script

[sof202]

If excel is converting IDs into scientific notation it might be truncating the value if the IDs are 16 digits or longer (I don't know if this is the case with these sentrix IDs).

If you have a way of accessing the ID column before it is converted to scientific notation, you could convert the values into strings. You'd do this by just adding a single ' quote at the start of each entry in the column. This forces Excel to accept it as the full ID as it interprets it as a text cell. Excel ignores the first ' character and should still just display the full number. The full number will also be written to any csv/tsv (etc.) files without the leading '.

Not sure if this is applicable or not, but it might help.

[ejh243]

this can be linked with #50

[sof202]

@ew367, solved by #220 right?