using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.IO;
|
|
namespace HH.WMS.Utils.ExcelLibrary.BinaryFileFormat
|
{
|
public partial class FORMULA : Record
|
{
|
public STRING StringRecord;
|
|
public object DecodeResult()
|
{
|
byte[] bytes = BitConverter.GetBytes(Result);
|
if (bytes[6] == 0xFF && bytes[7] == 0xFF)
|
{
|
switch (bytes[0])
|
{
|
case 0: //string value
|
if (StringRecord != null)
|
{
|
return StringRecord.Value;
|
}
|
else
|
{
|
break;
|
}
|
case 1: //Boolean value
|
return Convert.ToBoolean(bytes[2]);
|
case 2: //error value
|
return ErrorCode.ErrorCodes[bytes[2]];
|
case 3: //empty cell
|
return string.Empty;
|
}
|
}
|
return BitConverter.ToDouble(bytes, 0);
|
}
|
}
|
}
|