Click here to Skip to main content
15,617,358 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Washing machines vs 286 computers Pin
F-ES Sitecore26-Nov-19 3:19
professionalF-ES Sitecore26-Nov-19 3:19 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 3:23
professionalEddy Vluggen26-Nov-19 3:23 
GeneralRe: Washing machines vs 286 computers Pin
F-ES Sitecore26-Nov-19 3:47
professionalF-ES Sitecore26-Nov-19 3:47 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 3:52
professionalEddy Vluggen26-Nov-19 3:52 
GeneralRe: Washing machines vs 286 computers Pin
F-ES Sitecore26-Nov-19 3:54
professionalF-ES Sitecore26-Nov-19 3:54 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 3:55
professionalEddy Vluggen26-Nov-19 3:55 
GeneralRe: Washing machines vs 286 computers Pin
PIEBALDconsult26-Nov-19 4:56
professionalPIEBALDconsult26-Nov-19 4:56 
GeneralRe: Washing machines vs 286 computers Pin
Dan Neely26-Nov-19 6:12
Dan Neely26-Nov-19 6:12 
PIEBALDconsult wrote:
It turned out to be the ability to extract a list of customers (from Oracle on an AlphaServer) and import it into Excel (on Win 95?). And no one had realized that Excel (95?) limited the number of rows in a worksheet to... fourteen bits !? WTE!


I'm going to take a wild guess and say that the original design optimized ram usage by using the high 2 bits in the row ID to pack a pair of flags into an int16. MaxRows and MaxColumns were picked to limit how badly you could overwhelm system ram and bring the system to an utter and total crawl via swapping; and ~4m cells would be enough to crush a mid 90s system. Dynamic max rows/columns limits based around a cell cap would be too confusing for non-technical users.

Limits went up to 64k x 256 in Excel 97 and and 1M x 16k in Excel 07. Libre Office and Google Sheets have lower limits; the Dump Everything Into a Single Denormalized Sheet report in my current project exceeds both of the non-MS spreadsheets. (I think the customer just uses it as input for a stats tool.)
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt

GeneralRe: Washing machines vs 286 computers Pin
Sander Rossel26-Nov-19 10:08
professionalSander Rossel26-Nov-19 10:08 
GeneralRe: Washing machines vs 286 computers Pin
glennPattonWork326-Nov-19 5:08
professionalglennPattonWork326-Nov-19 5:08 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 5:18
professionalEddy Vluggen26-Nov-19 5:18 
GeneralRe: Washing machines vs 286 computers Pin
Ron Anders26-Nov-19 5:40
Ron Anders26-Nov-19 5:40 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 5:56
professionalEddy Vluggen26-Nov-19 5:56 
GeneralRe: Washing machines vs 286 computers Pin
TheGreatAndPowerfulOz26-Nov-19 8:49
TheGreatAndPowerfulOz26-Nov-19 8:49 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 8:58
professionalEddy Vluggen26-Nov-19 8:58 
GeneralRe: Washing machines vs 286 computers Pin
TheGreatAndPowerfulOz26-Nov-19 9:00
TheGreatAndPowerfulOz26-Nov-19 9:00 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 9:13
professionalEddy Vluggen26-Nov-19 9:13 
GeneralRe: Washing machines vs 286 computers Pin
TheGreatAndPowerfulOz26-Nov-19 9:34
TheGreatAndPowerfulOz26-Nov-19 9:34 
GeneralRe: Washing machines vs 286 computers Pin
Eddy Vluggen26-Nov-19 10:10
professionalEddy Vluggen26-Nov-19 10:10 
GeneralRe: Washing machines vs 286 computers Pin
TheGreatAndPowerfulOz26-Nov-19 10:50
TheGreatAndPowerfulOz26-Nov-19 10:50 
GeneralWSO CCC OTD 2019-11-26 Pin
OriginalGriff25-Nov-19 21:50
mvaOriginalGriff25-Nov-19 21:50 
GeneralRe: WSO CCC OTD 2019-11-26 Pin
dan!sh 25-Nov-19 22:42
professional dan!sh 25-Nov-19 22:42 
GeneralRe: WSO CCC OTD 2019-11-26 Pin
OriginalGriff25-Nov-19 22:45
mvaOriginalGriff25-Nov-19 22:45 
GeneralRe: WSO CCC OTD 2019-11-26 Pin
dan!sh 25-Nov-19 22:49
professional dan!sh 25-Nov-19 22:49 
GeneralRe: WSO CCC OTD 2019-11-26 Pin
OriginalGriff25-Nov-19 22:56
mvaOriginalGriff25-Nov-19 22:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.