Re: why is there 256 columns on excel?

It was based on memory bytes:

256 = 2^8 or 2*2*2*2*2*2*2*2

8 binary bits, or one byte, can store the integers 0-255 (i.e., 256
numbers).


65536 = 2^16 or 2*2*2*2*2*2*2*2*2*2*2*2*2*2*2*2

16 binary bits, or two bytes, can store the integers 0-65535 (i.e,.
65536 numbers).

So internally, each cell address had a representation that requires
exactly 3 bytes - one for column, and two for row.



In article <F688A76A-2919-404D-85AE-9276AAA3AD17@xxxxxxxxxxxxx>,
"bm" <bm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> im wondering why there is 256 columns and 65536 rows on microsoft excel/
.

Relevant Pages

  • Re: Advice needed for memory intensive app
    ... >a) take the number of things you need to store ... >that has to be main memory, and main memory isn't big enough, you're ... *different* for each cell? ... 3D cellular automaton, chopping it into cuboids might be a good idea. ...
    (comp.programming)
  • Re: Oblivion at CES -- looking hotter than before
    ... The pitiful amount of memory it takes to store some text is not the ... He's trying to divert the argument once again. ... Prev by Date: ...
    (comp.sys.ibm.pc.games.rpg)
  • Re: convert to decimal degree from DMS
    ... are you using Time notation to store the value ... you just multiply the cell by 24. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Synching files on sd card
    ... pda's "built in" memory is not enough to store them so I have put them on an ... Prev by Date: ...
    (microsoft.public.pocketpc.activesync)
  • Matching a sampling # to its row #number
    ... also located in column D in the case of store # 12 above, ... cell in C remain blank. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)