Booleans in Google Sheets Importer

[Thomas Castleman]

Currently, if you import a Google sheet which has boolean values (indicated by “TRUE” and “FALSE”), they are not recognized as booleans by CODAP:

In this example, the lefthand column was brought in by importing a Google sheet, and the righthand column is computed by the formula isBoolean(Booleans).

It would be great if the importer could recognize this upper-cased TRUE/FALSE format (which is a common pattern in sheets) and convert them to CODAP booleans so they can be computed on accordingly.

Thanks!

[Bill Finzer]

Hello Thomas,

You’re right. And the same thing happens if you type the values in all upper-case.

We’ll fix this!

Thanks,

Bill

[Author]

Posts