Monday, April 29, 2013

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", "")); 

Tuesday, April 23, 2013

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

Wednesday, April 17, 2013

Occam's Razor

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

Friday, April 12, 2013

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>