Free Support Forum - aspose.com

Currency Format BUG

Hello,


When i set the format of a cell to ‘$ English (United States)’ In 7.0.1 4090 was coming back pre-pended to my currency value. I switched over to release 7.0.2 and now the 4090 is gone but there is no currency value at all. I have attached a very simple test doc to test this.

Example:

Value in model $500.00
7.0.1 value in c# = 4090500.00
7.0.2 value in c# = 500.00

The value expected in c# should be $500.00

Hi,

Please use Cell.StringValue instead of Cell.Value, because values like numbers, dates, currency etc are all stored as integers.

Please see the code below and its output. I have used the latest:
Aspose.Cells for .NET v7.0.2.2

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Test.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


Cell cell = worksheet.Cells[“A1”];


Debug.WriteLine(cell.StringValue);
Output:
$500.00

This happens also when i do this:

results = CurrentWorkBook.Worksheets.GetRangeByName(mappingField).ExportDataTableAsString();
 Is there a work around for this scenario?  Also was this a change to they way values are pulled in the latest release 7.0 + as rolling back to my production release the values work just fine in comparison to the first post.

Hi,

Please provide us your sample code to replicate this issue.