Created attachment 37810 [details] sample code In detail, According to the suffix of Excel file, [apache tika] will automatically read the contents of the Excel file. callStacks: org\apache\tika\parser\microsoft\OfficeParser.#parse org\apache\tika\parser\microsoft\TikaHSSFListener#parse org\apache\tika\parser\microsoft\TikaHSSFListener#processFile poi-5.0.0.jar!\org\apache\poi\hssf\eventusermodel\HSSFEventFactory.class#processEvents poi-5.0.0.jar!\org\apache\poi\hssf\eventusermodel\HSSFEventFactory.class#genericProcessEvents poi-5.0.0.jar!\org\apache\poi\hssf\eventusermodel\HSSFRequest.class#processRecord poi-5.0.0.jar!\org\apache\poi\hssf\eventusermodel\FormatTrackingHSSFListener.classFormatTrackingHSSFListener#processRecord In Excel97-2003(xls), When [Format Cells > Number > Currency > Negative numbers] is set to [¥-1,234] or [(RED)¥-1,234], there will be a problem that [¥300] is read incorrectly as [$300]. The reason is that the Formatindex value of[¥- 1,234] and [(RED)¥-1,234] are [5] and [6], but the Formatindex values below 50 belong to [Custom] types. The Formatindex and FormatString of [Custom] are as follows: 5--> "\"$\"#,##0_);(\"$\"#,##0)", 6--> "\"$\"#,##0_);[Red](\"$\"#,##0)", Please refer to the attachment for sample code.
Can you try setting the user-local via LocalUtil.setUserLocale() to see if the local set locale affects this?
Created attachment 37838 [details] sample code2
Created attachment 37839 [details] test results
Thank you for your proposal. I tried the method you mentioned, but it still doesn't work. Please refer to the attachment [sample2] and [poi] for sample code.