This is a migrated thread and some comments may be shown as answers.

problem reading percentage values

4 Answers 495 Views

SpreadProcessing

This is a migrated thread and some comments may be shown as answers.

Innermedia asked on 31 Mar 2015, 02:44 PM

I have been using radspreadsheet for reading .csv files for some time now. I am now working on an application that requires me to read .xslx files. The only issue I have is the following: When reading percentage values, if the values are too small, I get a zero returned for the cell value. For example, if my spreadsheet is:

0.10%
1.00%
10.00%
100.00%

when reading the values, where the cell format is "percentage", I get the following values:
0
0.01
0.1
1

On the spreadsheet, I have the number of decimal points set to 6.

private string GetCellValue(Worksheet ws, int RowIndex, int ColumnIndex)
{
CellSelection cell;
ICellValue value;
string cellvalue = "0";
cell = ws.Cells[RowIndex, ColumnIndex];
value = cell.GetValue().Value;
if (value != null) cellvalue = value.RawValue.ToString();

4 Answers, 1 is accepted

answered on 03 Apr 2015, 11:12 AM

Hi Brian,

I have tested the scenario you have described. Using MS Excel I have created a workbook containing the following values using cell format "percentage" with two decimal places:

0.10%
1.00%
10.00%
100.00%

I have imported it in RadSpreadProcessing and when I get the cell values the result is slightly different from yours:

0.001 - here is the difference
0.01
0.1
1

Could you check if the first value which you get from the cell really is 0.

This is expected behavior. Actually if you multiply the values by 100 you will get the entered percentage values. This behavior can be explained with the formula for calculating the percentage of a number. For example 10% of 40 is 40 * 10% = 40 * 10 / 100 = 40 * 0.1.

If you want to get the formatted result value form the cell you could use the following code:

value = cell.GetValue().Value;

CellValueFormat format = cell.GetFormat().Value;

if (value != null) cellvalue = value.GetResultValueAsString(format);

Regards,
Nikolay Demirev
Telerik

See What's Next in App Development. Register for TelerikNEXT.