DisplayStringValue value incorrect in certain scenarios

Hello:


Run this function against the attached spreadsheet.

private static void TestConditionalFormatting7()
{
Workbook workbook = new Workbook(@“C:\temp\spreadsheets\test_conditional_formatting5.xlsx”);
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet.Cells[“A1”];
Console.Out.WriteLine(“cell.DisplayStringValue = {0}”, cell.DisplayStringValue);
}

If you open the spreadsheet it shows: and not $20 as it is returned by DisplayStringValue.

Is there another way to get the exact value that is displayed in a cell, that would return ($20) in this scenario?

thanks

Hi,


Thanks for providing us the template file and sharing the sample code.

After an initial test, I observed the issue as you mentioned by using your sample code with your template file. It should print “($20)” for DisplyStringValue attribute but it is printing “$20”.

Sample code:
Workbook workbook = new Workbook(@“C:\temp\spreadsheets\test_conditional_formatting5.xlsx”);
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet.Cells[“A1”];
Console.Out.WriteLine(“cell.DisplayStringValue = {0}”, cell.DisplayStringValue); //$20

I have logged a ticket with an id “CELLSNET-42120” for your issue. We will look into your issue soon.
Once we have any update on it, we will let you know here.

thank you.

Hi,

Thanks for using Aspose.Cells.

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

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


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