HOUR() and VALUE() function with Japanese full-width values

HOUR() and VALUE() function with Japanese full-width values

Posted by: yyoshimura on 2 April 2024, 4:23 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 2 April 2024, 4:23 pm EST

  Hi,

  We found that HOUR() and VALUE() function with Japanese full-width values cannot be calculated correctly using the library. Please see attachment for reproduction. Is this going to be supported? Thank you.

  Regards,
  
  Wenjin

  FullWidthValueSample.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 3 April 2024, 5:49 pm EST

  Hello Wenjin,

  We, too, can observe the issue at our end that you have mentioned and escalate this to the development team to look into this matter.

  We will update you as soon as we get any updates from their end.

  [Internal Tracking ID: DOCXLS:10115]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 30 April 2024, 6:54 pm EST

  Hello Wenjin,

  We are glad to inform you that the issue has been resolved in the latest 7.1.1 drop.
  
  Please upgrade to the latest version to fix this issue:
  
  https://www.nuget.org/packages/DS.Documents.Excel/7.1.1

  Regards,
  
  Prabhat Sharma.