Highlighted
Frequent Contributor

Excel Add-in v3.2 - Boolean values

Hi all,

 

I am having an issue that seems to be a result of the new v3.2 add-in update.

 

Previously, where boolean values were being pulled from the excel add-in, excel would automatically recognise them as general formatting and they would be activated and process the cell as a boolean.

 

Now it seems the values are being imported with a number formatting. Whilst I can change the formatting of the column of data to general and save the setting in the excel add-in, it will not activate and process the cell as a boolean until it is manually activated (i.e. I click into the cell and hit enter or run a text to columns)

 

Can we fix this/is there a way to quickly transform this to the way it was before?

3 REPLIES 3
Certified Master Anaplanner

Re: Excel Add-in v3.2 - Boolean values

Hi @CallumW 

 

I am using excel add-in 3.2 versions, recently downloaded.

If I understood your question correctly, you are telling that you are getting Number instead of Boolean value.

 

I tried your scenario, I am getting boolean value correctly.

001.png

 

Not sure where is the issue, please try uninstall and install it back. 

 

Regards,

Vignesh M

Frequent Contributor

Re: Excel Add-in v3.2 - Boolean values

Hi @VIGNESH.M 

 

I am getting a boolean value through correctly, but excel now formats the cells as a number rather than as general when it is pulled from Anaplan as it previously did in v.3.1

 

Best,

 

Callum

Certified Master Anaplanner

Re: Excel Add-in v3.2 - Boolean values

Hi callum,

Sorry, I misunderstood the question.

Yes , Am also getting it as Number instead General.
Please raise a ticket to Anaplan support, they will help you with more detail.

~Vignesh M