Formula linked with radio button disappeared after saving

Formula linked with radio button disappeared after saving

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 February 2023, 6:26 pm EST

  Hi,

  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.

  Regards
  
  sample.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  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.

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 27 February 2023, 5:20 pm EST

  Hi,

  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.

  Regards

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 28 February 2023, 6:28 pm EST

  Hello,

  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]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 13 December 2023, 6:52 pm EST

  Hello,

  We are glad to inform you that the issue has been fixed in the latest 7.0.0 version of the API.
  
  Please upgrade to the latest version to fix this issue.
  
  https://www.nuget.org/packages/GrapeCity.Documents.Excel/

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 5 March 2024, 8:15 pm EST

  Thank you for the fix. It is working as expected.