Search code examples
c#excelintexcellibrary

Excel Library possible integer overflow

I am using Excel Library - http://code.google.com/p/excellibrary/ - To generate an excel 2003 spreadsheet. Everything works fine except when some big values are used.

These are some reference numbers that are used by a client and I simply need to present them as integer values in the spreadsheet.

int val = 1420007117;
worksheet.Celss[row, col] = new Cell(val); // Displays - 352108063

This results in the value 352108063 being displayed in the spreadsheet. If the value is lower, then it displays fine.

Anyone know what the issue might be, or how to work around this problem. Outputting the value as string is not possible as it leaves a green Number stored as Text error.

Solution

  • I would say that doesn't support 64-bit integers and doesn't care about it.

    For such big numbers you better use floating point. This is how Excel handles big numbers.