• 33 Posts
  • 229 Comments
Joined 1 year ago
cake
Cake day: June 2nd, 2024

help-circle

  • Look at the last table in my original post. It contains 26 columns (A–Z), some of which are not shown, and 27 rows (blank–Z). There are 27 rows and 26 columns, regardless of the contents of the table. If the top-left cell (A, blank) were a 1 and (B, blank) were a 2, then (Z, blank) would contain a 26, and ZZ would contain a 702. Nothing about the layout of that table changes.

    To summarize: The table will always be lopsided, if you start counting at 0 or at 1.





  • I have been able to outsource low level parsing to third party libraries

    Hahaha!!!

    Today I watched a Java server crash because a library decided it needed more than 3GB of heap space to read a 10MB file. That was after manually removed background colors from around 100,000 cells, which apparently caused the parser to create even more objects in its internal representation of the sheet.