Year: 2013

Jun

Considerations for storing Excel cell value in code

You may hate Excel, but you may find a discussion of how Excel stores cell values interesting. So I have a spreadsheet library. The biggest concern at the initial stage was how to store all the spreadsheet data efficiently. I hear people talking about millions of cells, so I’m scared. If my program stores a […]

Jun

File upload size limit in IIS

Yay file uploads. As if letting the users to type in stuff into the web application giving me SQL injection nightmares weren’t enough, now I have to let users upload files. Peachy. So during my investigations into the limits of file uploading, I found that I couldn’t upload a file more than 30MB on my […]

Jun

Academic self-publishing

As of this writing, I’ve worked in the academic industry for slightly over 3 months. More on this later. Claire Morgan sent me this article on academic self-publishing. There are good points and bad points regarding self-publishing, which are exaggerated particularly so for the academic industry. I should know, since I’m making a web application […]

Feb

Specious spreadsheet security

If not for Chinese, it would’ve worked. So in Excel, you can set a password for either protecting a particular worksheet, or protecting the entire workbook/spreadsheet. This password is then hashed, and the result is stored within the spreadsheet contents. Now with the use of Open XML spreadsheets, this means the resulting hash is stored […]

Jan

SpreadsheetLight version 3

Version 3 of my spreadsheet library is now available. There’s a whole bunch of updates, including Excel 2010 conditional formatting such as data bars with negative value fill colours and icon sets with no icons. SpreadsheetLight is possibly the most developer-friendly spreadsheet library ever. Even if I do say so myself. 🙂

Jan

In The Mirror (cover)

This is one of my favourite piano pieces by Yanni. I’m not a pianist. I’ve never taken piano lessons. I’m like grade -1 or something. This took me over a dozen tries… Credits and permission granted from: Music by Yanni 23rd Street publishing Inc/Yanni Music Publishing (ASCAP) Used by Permission. All Rights Reserved

Jan

Passion problems

It was a fluke. I just fell into the spreadsheet business. My main products currently, both in writing and in code, revolve around spreadsheets. Specifically around Excel workbooks or spreadsheets or files or whatever you call them. I like programming and writing code. I’m great at it. I just didn’t specifically choose making spreadsheet libraries. […]