Formula linked with radio button disappeared after saving

Posted by: yyoshimura on 26 February 2023, 6:26 pm EST

  • Posted 26 February 2023, 6:26 pm EST


    We have some radio buttons linked with a cell A and the cell is referencing another cell B using a formula. After saving the file using the library we found that the formula of cell A disappeared. Please refer attachment for reproduction. The cell E5 is referencing B2 but the formula disappeared after saving.

    Please help to investigate this issue. Thank you.


  • Posted 27 February 2023, 4:18 pm EST

    Hello Yoshimura,

    Apologies for the inconvenience caused to you.

    The excel file Text.xlsx that you have shared does not contain any formula in cell A. If you have any other understanding then please let us know and share the screenshot of the same.

    Also, cell E5 which contains the formula B2 disappears when selecting the radio button in your given excel. When saving the file with GcExcel API, the radio button gets selected automatically which is causing the issue. Please confirm if you have the same understanding so that we can discuss it further with the development team accordingly.


    Prabhat Sharma.

  • Posted 27 February 2023, 5:20 pm EST


    Thank you for your explanation. We understand that the behavior of formula disappearance of radio button is correct.

    The problem is that the state of radio button selection is correctly set by the value of cell E5(value: 2) but the display value of E5(value: 0) is not the same as the state of radio button. We think that the correct radio button selection is meaning that E5 value is correct but actually it is not. Hope that it makes the description of the problem clearer.


  • Posted 28 February 2023, 6:28 pm EST


    Thank you for your additional information.

    We have reported this to the development team for investigation and will let you know as soon as we get an update from the developers.

    [Internal Tracking ID: DOCXLS-7688]


    Prabhat Sharma.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels