Cell value is different than Excel

Cell value is different than Excel

Posted by: yyoshimura on 14 November 2025, 1:56 am EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 14 November 2025, 1:56 am EST

  Hi,

  We have a workbook created using the library at server side. We notice that the cell value of a workbook is different than Excel. Please see attachement for reproduction. The cell [D22] in [Error] sheet is 0 in Excel, but when we get the same cell using the library the value is 3.

  Please help to investigate this issue. Thank you.

  Regards

  GcExcelTest.zip

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 14 November 2025, 3:44 am EST

  Hi Yukinori,

  Thank you for sharing the sample workbook.

  We reviewed the formulas and evaluated the workbook using both Excel and DsExcel. In both environments, the calculated value of D22 is 3, which is the correct outcome based on the formula chain.

  Here is the breakdown for clarity:

  Formula in D22: =IF(I26<>“”, I26, IF(I27<>“”, I27, I28))
  
  I26: empty
  
  I27: empty
  
  Formula in I28: =IF(C4<>“OK”, $C$28, $C$25)

  C4 contains “NG”

  Since “NG” is not equal to “OK”, the formula correctly picks C28, which contains 3

  So the calculated value of D22 is expected to be 3 in both Excel and DsExcel.

  If your scenario expects the cell to return 0, or if the behavior differs in a specific version/environment, please let us know and we’ll investigate further.

  Kind regards,
  
  Chirag

  https://gccontent.blob.core.windows.net/discourse-forum-uploads/file-f997352e-e55b-4d1e-97eb-e9894b97a35b.gif(image larger than 4 MB)

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 16 November 2025, 9:42 pm EST - Updated 16 November 2025, 9:48 pm EST

  Hi,

  Thank you for the explanation. At our end the result is different in Excel with GcExcel library. Please see attachment for details. The C4 cell contains “OK” and result in D22 is 0.

  Our Excel version is in Japanese and details is as following.
  
  

  

  910×127 6.12 KB

  

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 16 November 2025, 11:47 pm EST

  Hi Yukinori,

  Thanks for sharing the required details.

  We can replicate the behavior you mentioned in the Japanese culture. We are discussing the matter with the concerned team and will get back to you as soon as we have any further information.

  Internal Tracking ID: DOCXLS-13279

  Kind Regards,
  
  Chirag