Excel Add-in v3.2 - Boolean values

CallumW
CallumW
in Integrations and extensibility

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?

Tagged:

Answers

  • VIGNESH.M
    VIGNESH.M

    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

  • CallumW
    CallumW

    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

  • VIGNESH.M
    VIGNESH.M
    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

Categories