Cell.setValue(Long) error but Cell.setValue(long) work >_< (Java)

Aspose.Cells Product Family
1

Like above

2

Hi,

Thanks for your inquiry.

Well, it works fine. Following is my testing code.

Sample code:

Workbook wb = new Workbook();
Cell cell = wb.getWorksheets().getSheet(0).getCells().getCell(0, 0);
Long longObj = new Long(987654320);
cell.setValue(longObj);
cell = wb.getWorksheets().getSheet(0).getCells().getCell(1, 0);
cell.setValue(new Long(1234567890));
wb.save("e:\\files\\outLongTest.xls");

Which version of the component you are using, kindly try the attached version.

Thank you.

3

Hummm,

You should try minor big one like -9,808,080,080,080

I don’t sure where to find the version number but I’m using the one which is downloaded 1 month ago.

4

Hi,

Well, I tried using the following code and it works fine. The output file is attached.

Sample code:

Workbook wb = new Workbook();
Cell cell = wb.getWorksheets().getSheet(0).getCells().getCell(0, 0);
cell.setValue(Long.parseLong("-9808080080080",10));
wb.save("e:\\files\\out_LongTest.xls");

Please try the version attached in my previous post.

To get the version number of a fix, please try the following code in a Java program.

e.g..,

//Instantiating a Workbook object
Workbook workbook = new Workbook();
System.out.println(CellsHelper.getReleaseVersion());

Thank you.


5

Hi,

After looking into your issue more closely, we found there is a bug in Cell.setValue(Long) as the result is a wrong one. You were right.

Please try the attached version, we have fixed it.

Thank you.