Just another Perl shrine | |
PerlMonks |
Re: string TRUE/FALSE getting converted to 1/0by sundialsvc4 (Abbot) |
on Jun 15, 2015 at 00:50 UTC ( [id://1130403]=note: print w/replies, xml ) | Need Help?? |
One question that pops into my mind right now is ... “how does Excel decide that the value should be displayed as True or False,” and, “exactly what underlying value is being interpreted in this way? Perhaps the actual value within the cell is a numeric 1/0, such that what the CSV is providing to you (namely, “the underlying cell-value, stripped of all formatting”) is, in fact, correct?
In Section
Seekers of Perl Wisdom
|
|