Thursday, September 20, 2007

Row Limit You Ask?

As much as I love Excel 2007 (finally an easy way to save your graphs into templates!), I cannot believe they still enforce a row limit. A "row limit" you ask? Surely not, I mean, it is after all 2007--the years of mandating artificial limits of data sizes are long over, no? Unfortunately not. Excel 2007, row limit=1,048,576.

Um, why?

I'd like to think it's because Excel's dev lead programmed int [] rows = new int[1048576] at the top of the Excel document model.

No comments: