delete issue in spreadsheetgear

There is an apparent issue.

When we delete a row from a range (e.g. someRange["1:1"].Delete()) this does not make the range 1 row smaller but keeps an empty row at the end of the range

e.g.  when we save the range this is what we get:

-13,     test-13   ,-13,  test-13    ," ""  -13   ""","  gdfgdf  test-13-t,rim   ",2001-12-29,1.7

,,,,,,,   -- new row

This is not Microsoft excel behavior – excel makes the range smaller.

TextFieldParser reads line feeds as the end of a line

I did this to get rid of lf when they weren't line feeds with carriage returns

originalFile = System.Text.Encoding.UTF8.GetBytes(Regex.Replace(Encoding.UTF8.GetString(originalFile), "[^\r]\n", "")); 

passing a list of a derived class to an argument that expects base

fails. Ienumerable works.

dynamic check boxes

there is an issue with the labels - they are not restored with view state.
I kept the names in a list of strings and renewed oninit

order of events with httpmodules and global asax:

• Global
• Application_Start
• HttpModule
• Init
• Application_BeginRequest
• Global
• Application_BeginRequest
• Application_AuthenticateRequest
• Session_Start
• HttpModule
• Application_EndRequest
• Global
• Application_EndRequest

Occam's Razor

is the developers greatest friend when something is broken , but is unfortunately disregarded. I speak from personal experience

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

i had

<configuration>
  <system.web>
    <httpModules >
      <add name="BlahModule" type="blahModule" />
    </httpModules>
  </system.web>
</configuration>

instead of


<configuration>
    <system.webServer>
      <handlers>
     </handlers>
       <modules>
<add name="BlahModule" type="blahModule" />
        </modules>
     </system.webServer>
</configuration>

Best Article on Closures

here

Compilation removing references

Could be due to conflicts in the target framework. Watch out for projects with client profile.

interface and base classes

in c# base classes must go first. No hints for this from the IDE

Difference Between Throw and Throw Ex

Good article

Arrays in WCF

in order to pass an list and not have .net deserialize to an array you must configure the service reference
here:

Cannot read configuration file due to insufficient permissions

we couldn't get a website working until we gave specific rights to the user for the anonymous logins.

Gartner Magic Quadrant

Gartner Magic Quadrant

How to tell if a chosen range is in the used section of spreadsheet

this is what I did:
I unioned the existing used range with chosen range and checked for equality

if (!worksheet.UsedRange.Union(chosenrange).Equals(worksheet.UsedRange))
throw new EExcelUtilsRangeOutOfBoundsOfData();

Go to statements in Shakespeare (much ado...)

DOGBERRY

Dost thou not suspect my place? dost thou not
suspect my years? O that he were here to write me
down an ass! But, masters, remember that I am an
ass; though it be not written down, yet forget not
that I am an ass. No, thou villain, thou art full of
piety, as shall be proved upon thee by good witness.
I am a wise fellow, and, which is more, an officer,
and, which is more, a householder, and, which is
more, as pretty a piece of flesh as any is in
Messina, and one that knows the law, go to; and a
rich fellow enough, go to; and a fellow that hath
had losses, and one that hath two gowns and every
thing handsome about him. Bring him away. O that
I had been writ down an ass!