|
I read somewhere that the Excel data was stored columnwise rather than rowwise so they hit the column limit of 16,384 instead of the row limit of 1,048,576.
But the real problem is everyone blaming a "computer glitch", rather than explaining that the people writing the code misread a QA answer.
|
|
|
|
|
Richard MacCutchan wrote: But the real problem is everyone blaming a "computer glitch", rather than explaining that the people writing the code misread a QA answer.
I wish that was a joke ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
According to arstechnica.com[^] they indeed hit the row limit - which was 65k, not 1M, because they used the old .xls format, rather than the newer (13 years old) .xlsx format.
|
|
|
|
|
Richard MacCutchan wrote: I read somewhere that the Excel data was stored columnwise rather than rowwise
I also read that and considered including it in the OP. I think it's one of the clearer bits of misinformation, I mean who would seriously propose that as a solution? Even the worst of the worst in QA would suggest a new sheet per case rather than a new column.
|
|
|
|
|
F-ES Sitecore wrote: Richard MacCutchan wrote: I read somewhere that the Excel data was stored columnwise rather than rowwise
F-ES Sitecore wrote: Even the worst of the worst in QA would suggest a new sheet per case rather than a new column
Also, XLS only supports 256 cols (A to IV) {and, IIRC, there was a max of 256 sheets as well?}, so it would have to be rows.
|
|
|
|
|
F-ES Sitecore wrote: It's just maddening seeing so much speculation and ill-informed opinions posted as facts, Welcome to the internet.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
F-ES Sitecore wrote: a rather public failing in software system
Was it even a "system" as such? Or was it a work experience student who just didn't know any better?
|
|
|
|
|
Thanks for proving my point
|
|
|
|
|
For the avoidance of doubt, which one?
|
|
|
|
|
F-ES Sitecore wrote: one of the issues with twitter is that there is no single person or thread to respond to, it is just a wall of people all posting the same thing with nothing you can do to counter it.
I read through the whole thing, and honestly what I got out of it is that your problem isn't with Excel or the reasons it was used; it's all with Twitter.
Let me ask you this: Why are you getting the likes of Twitter bother you? To me Twitter simply doesn't exist. I'm not posting anything on Twitter. I'm not following anyone on Twitter. I don't have an account on Twitter. And I've never felt like I've missed out on anything.
Let the people it was designed for waste their time on Twitter. Just don't get involved yourself. Twitter's not a thing. Nobody needs it.
While you're at it, don't let Facebook get under your skin either.
|
|
|
|
|
I get what you're saying, but the reason it bothers me is that today's media climate, unfortunately, is twitter despite only a minority of people using it. Twitter drives what you see in the news, ergo what the general public sees. With so much misinformation on the platform going utterly unchecked it is going to influence what stories are written about it. At the risk of going into soapbox territory we all know that misinformation is politically motivated, and even more egregious is that this misinformation can be spread only because the biased nature of the platforms. If you went on and spread misinformation "the other way" it would be deleted and your account suspended. So these platforms are creating a downward spiral of misinformation.
TLDR; It bothers me that people are wrong on the internet
|
|
|
|
|
I also get, and appreciate, what you're saying.
I'm afraid I have no solution to offer however. Humanity's stupidity is winning out, and will be the cause of our downfall.
|
|
|
|
|
"Exceeded the capacity for XLS" files.
Sounds like management-speak. (If we blame "Office", no one will be the wiser)
(The first time one sees a spread-sheet, it's usually beyond one's "capacity" to handle effectively).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Since I suffered through years of Windows updates I thought I might mention how my first ever major Linux upgrade went.
I was running 18.04 until earlier today.
I ran the upgrade process and it was amazingly, shockingly smooth.
The amazing things were that my machine was completely usable through the entire upgrade until only the last moments where I had to shut down and restart the machine. On Windows I would'a been watching a spinning cursor for 45 minutes or an hour.
I am quite happy because the new OS still consumes relatively small amount of RAM -- only about 4-5GB of the 16GB total.
I'm currently running FireFox, Chrome, Remmina (RDP software connected to three win10 boxes), Android Studio and an Android emulator, VNC (connected to my Mac Mini), Calibre ebook reader and Thunderbird email client and I'm still only at 8GB consumed.
Try that on Win10. Win10 just consumes so much RAM by itself.
I really enjoyed all those years on Windows -- especially on Win 2000 and XP -- but the past year has been great on Ubuntu.
Any other Linuxers out there?
|
|
|
|
|
raddevus wrote: Any other Linuxers out there? I tried years ago but it was so much work to do anything and I had to run sudo every time I wanted to do something that I gave up. I'll spend the $100 on a Windows license.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
ZurdoDev wrote: 'll spend the $100 on a Windows Although my license ended up being $148 after tax.
Don't forget the extra $$$ for 16GB of extra RAM since you're running win10.
|
|
|
|
|
raddevus wrote: 16GB of extra RAM $2.99.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
ZurdoDev wrote: $2.99.
|
|
|
|
|
Yeah, Minit 20 here, same experience upgrading (with the exception of having to install a proprietary driver). Been testing LMDE in a VM and will move to it now that I found a way to do the Mate desktop. Don't much care for the Ubuntu folks way of doing things. Linux has been my main system for over 10 years. Started with SuSE, something like version 5 or 6.
I run several Windows machines in VM's for development. Don't hate Windows, just a contrarian. I think W2000 was the best, still run Office 2000 on a W10 VM (except for Lookout). I use Remina via a (hardware) VPN to connect to a W2014 Server running under ESXi (along with a couple of other Windows VM's). Used to do Exchange until we moved it to the cloud. I don't think sudo is any different than having Windows asking me "mother may I". Guess it is what you get used to. To each his own, fanboys are annoying.
If you can keep your head while those about you are losing theirs, perhaps you don't understand the situation.
|
|
|
|
|
theoldfool wrote: Guess it is what you get used to.
That's the real truth of all software. I'm the same way about Windows, I don't hate it, I'm just a contrarian. Plus the big pull for me was trying to run Android Studio and Android emulator on my windows machine. It killed on Win10 and is super smooth on Ubuntu.
The move of .NET Core, Visual Studio Code and SQL Server to Linux has been a real help too.
|
|
|
|
|
Fedora. Closing a decade on it...
For about three years not even VMs of Windows...
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: Fedora. Closing a decade on it...
Wow!
Kornfeld Eliyahu Peter wrote: For about three years not even VMs of Windows...
Double-wow!!
|
|
|
|
|
I've been on Ubuntu since about 14.04. My web server is still on 16.04LTS.
I just upgraded this (my "social" lappie) to 20.04LTS a couple of days ago. As you experienced, it went very smoothly.
Only found a couple of very minor issues:
The upgrade switched off third-party APT repositories, so I lost a dubious game.
"Panel World Clock" didn't make it.
I'll do my "serious" machine in a couple of days. It's got a SSD, so it'll be interesting to see how long it doesn't take.
I don't think I'm going to upgrade my server. It's due for retirement, and I have the hardware to build a proper one, RAID and all.
Then I can do centralised backups, email sharing, etc.
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Glad to hear of other Ubuntu Linuxers out there.
Always interesting to hear other's stories about how it is (or isn't) working for them. thx
|
|
|
|
|
Sometimes I wonder what people do to have problem with Windows.. I am always up-to-date, since like XP, never blue screen, all good..
That said it is true that Window use lots of RAM compare to, say, Linux. Not that it ever caused me any trouble though....
|
|
|
|