body { margin: 0 0 0 0; padding:0 0 0 0 }
td,div { font-family:Segoe UI;font-size:9pt;vertical-align:top }
/* Copyright IBM Corp. 2011 All Rights Reserved. */
body { margin: 0 0 0 0; padding:0 0 0 0; overflow:hidden; }
.transcript { background-color:#d2d2d2; }
.messageBlock { padding-left:10px; padding-right:10px; margin-bottom:3px }
.message { padding-left:20px; margin-left:95px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre; white-space:pre-wrap;}
.messageCont { padding-left:20px; margin-left:95px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre;white-space:pre-wrap;}
.other { font-size:11px;color:#39577a;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.myself { font-size:11px;color:#da8103;font-style:normal;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont { font-size:8px;text-align:right; color:#39577a;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.myselfCont { font-size:8px;text-align:right; color:#da8103;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.system { font-size:11px; word-wrap:break-word;color:#da8103;font-style:normal;font-weight:normal; white-space:-moz-pre-wrap; _white-space:pre;white-space:pre-wrap; }
.showTimestamp { padding-left:20px; font-size:11px; float:right; color:#999999;font-style:normal;font-weight:normal; }
.other1 { font-size:11px; color:#ac2000;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont1 { font-size:8px;text-align:right; color:#ac2000;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other2 { font-size:11px; color:#3c9fa8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont2 { font-size:8px;text-align:right; color:#3c9fa8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other3 { font-size:11px; color:#e25614;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont3 { font-size:8px;text-align:right; color:#e25614;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other4 { font-size:11px; color:#0b6ac8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont4 { font-size:8px;text-align:right; color:#0b6ac8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other5 { font-size:11px; color:#b23290;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont5 { font-size:8px;text-align:right; color:#b23290;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other6 { font-size:11px; color:#02e7c7;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont6 { font-size:8px;text-align:right; color:#02e7c7;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.other7 { font-size:11px; color:#5b3284;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }
.otherCont7 { font-size:8px;text-align:right; color:#5b3284;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }
.highlight { background-color:#bed6f8; }
.datestamp { padding-right:0px; font-size:11px; cursor:default; margin-bottom:1px; background-color:#c0c0c0; width:100%; float:left; text-align:right; color:#ffffff; font-weight:bold; font-style:italic; }
#chatAlert { float:left; border-bottom:1px solid #E8D091; padding:6px; width:100%; color:#A5754C; }
#chatAlertImage { float:left; }
#chatAlertText { float:left; margin-left:6px; }
#chatAlertClose { float:right; margin-right:10px; padding-right:6px; margin-top:0px; }
#chatAlertText a { color:#A5754C; }
#chatAlertText a:hover { color:#A5754C; text-decoration:none; }
.tsDisplay { display:block }.dsDisplay { display:none }I have an excel sheet with some custom formatted values, when I pass them into Aspose and attempt to retrieve the formatted values (sheet.Cells[x,y].StringValue), I'm not getting the expected values, which is what I see in the Excel sheet itself. Attached is a ConsoleApplication that illustrates this problem. In it you'll find a sample Excel document that has the custom formatting already applied. If you can resolve this issue that would be greatly appreaciated, thank you.
Aspose.Cells version: 7.1.1.1
Office Excel version: 2010
Hi,
Thanks for the sample file and application
Sample code:
var workbook = new Workbook(@"E:\test2\AsposeCustomFormatValues\ConsoleApplication1\ConsoleApplication1\SampleFormattedNumbers.xlsx");
var sheet = workbook.Worksheets[0];
for (int i = 0; i < 13; i++)
{
Debug.WriteLine("Value: " + sheet.Cells[i, 0].Value);
Debug.WriteLine("StringValue: " + sheet.Cells[i, 0].StringValue);
}
Output:
Value: -2500000
StringValue: -(2,500)
Value: -1500
StringValue: -(2)
Value: -750
StringValue: -(1)
Value: -500
StringValue: -(1)
Value: -499
StringValue: (0)
Value: -1
StringValue: (0)
Value: 0
StringValue: (0)
Value: 1
StringValue: (0)
Value: 499
StringValue: (0)
Value: 500
StringValue: 1
Value: 750
StringValue: 1
Value: 1500
StringValue: 2
Value: 2500000
StringValue: 2,500
Thank you.
The issues you have found earlier (filed as CELLSNET-40424) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.