måndag 27 februari 2012

Viewstate availability

Maybe it is obvious, but not for me, but:
Viewstate is not accessable from Page_Init, it is accessable first in Page_Load.

Even worse, a ViewState set in Page_Init is available as long the current "instance" is running, but after a post back it is not available anymore.

fredag 24 februari 2012

OWC11 adding an comma sign after some values

For some reason, and just in the Production environment, if you in the Excel object enter a value that is equal to or greater than 2097152, and is equally dividable with 16, gets an comma sign (,) after the value.

That the problems happens with values from 2097152 has something to do with the length of the value when converting it to binary representation,
up to this value the representation is by 21 bits, but from 2097152 it is represented by 22 bits.

I have no idea why this error occurs, and why just in Production environment.
I have uninstalled Excel from our Development environment, and installed the OWC component, so the environment should be identical with Production, but in this environment this problem does not occur.

To get around this problem I only have the following suggestions:
  • Add an character, for example 'X' before or after the value
  • check for commas when reading data from the Excel object, and remove them.
  • Avoid these numbers.

tisdag 7 februari 2012

Uncompress files in Windows XP

To uncompress all files, from current folder and below, type:
compact /u /s /a /q /i *.*
in a CMD-window.