Error checking - Number stored as text


#1

Hi,

While storing data into excel, it includes some currency values e.g. $123.43 or $123,333. When I open the saved excel it shows me the warning that Number is stored as text . Is there a way around that, so that I dont get warnings when I open the excel document.

Thanks,

Sumit


#2

How do you store data into excel? Some code like this:

cell.PutValue("$123.43");

Please change it to:

cell.PutValue(123.43);

or

cell.PutValue("$123.43", true);


#3

Hi,

I am using java version of aspose.cell(1.7) . Could not find any putValue method or any setValue() method which takes two arguments. Is there any other way in the java version?

Thanks,

Sumit


#4

Java version doesn’t support this feature yet. We will check and add this feature in the future version. Could you use your own code to parse string to number before storing data?


#5

Hi Lawrence,

Is this feature there in september 1 release?

Thanks,

Sumit


#6

Hi,

We have supported this feature since the version 1.7.1. You can use Cell.setValue(String,boolean) method.