We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cell with currency format as BMD

Aspose.Cells Product Family
#1

Hi,

Cell.getType() returns 1 (DATE_TIME) for cells with Currency format as BMD (Bermudan dollar) instead of NUMERIC.
#2

Hi Bee,


Thank you for contacting Aspose support.

Please share the problematic sample along with the Aspose.Cells for Java version information and environment details for through investigation.
#3

Hi,

Sorry for the late reply. I have attached the spreadsheet.
Aspose Cells Java 8.4.0
#4

Hi Bee,


Thank you for sharing the sample spreadsheet.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for Java 8.7.0.2, and we are able to notice the said problem, that is; the cells E5, E6 & E7 are being detected as of DateTime type. We have logged this incident as CELLSJAVA-41735 in our bug tracking system. Please spare us little time to properly analyze the problem cause and get back to you with updates in this regard.
#5

Hi,

Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSJAVA-41735 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

#6

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix:
Aspose.Cells for Java v8.7.1.2 and let us know your feedback.

#7

The issues you have found earlier (filed as CELLSJAVA-41735) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.