3 ms·
>As a consequence, each template could handle only about 65,000 rows of data Oh? Like 65,535 or so? That seemed weird a first that even as old as xls is that o
by SV_BubbleTime 6y ago
>As a consequence, each template could handle only about 65,000 rows of data
Oh? Like 65,535 or so? That seemed weird a first that even as old as xls is that only 16bits were allocated to max rows.
But then maybe not. Each row might get an ID, so that's 16bits * rows you have. I wonder if when XLS was designed they considered it very unlikely many people would have 500MB of db of empty rows and then would needed more data added to each one?
Simplified of course, I bet even original format had some explicit row identifier that could be shortened with optimizations and increment tags.
- usmannk 6y agoXLS does in fact have a 16 bit row counter :/
- emerged 6y agoThat should be enough bits to do everything a computer will ever need to do.
- dan-robertson 6y agoThe xls format is pretty old. The newer formats (xlsx, xlsb, and so on) allow for larger spreadsheets. The reason the spreadsheets in the old format couldn’t grow was probably compatibility. The reason for the limit in the first place was probably about reducing memory on disk and in main memory.