Learn, share, discuss

Ask and answer questions about CODAP. Share how you’re using CODAP in and out of the classroom or in your research.

Booleans in Google Sheets Importer

Tags: booleans sheets

This topic has 1 reply, 2 voices, and was last updated 2 years, 7 months ago by Bill Finzer.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
April 1, 2022 at 12:38 pm #6942 Score: 0

Thomas Castleman
Participant

Karma: 3 pts

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!

April 1, 2022 at 2:42 pm #6943

Bill Finzer
Keymaster

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.