Re: string TRUE/FALSE getting converted to 1/0

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?

Replies are listed 'Best First'.
Re^2: string TRUE/FALSE getting converted to 1/0 by nayakr (Novice) on Jun 15, 2015 at 01:29 UTC
Thanks Sundialsvc4 for your response. The Spreadsheet module (or one of the other module that I am using) seems to be causing this since it is working fine when I pass in a xls file. Is there some way I can tell the interpreter not to convert these strings when a XLSX file is passed? I tried using `$str =~ s/TRUE/TRUE/i; $str =~ s/FALSE/FALSE/i;` [download] but that did not help. Thanks, Raj	[reply] [d/l]