|
The Off-Topic Lounge APPROPRIATE FAMILY-FRIENDLY TOPICS ONLY - READ THE RULES! This forum is for posting anything (excluding topics prohibited by the forum rules) that's unrelated to email. General discussions, in other words. |
|
Thread Tools |
25 Oct 2024, 10:31 PM | #1 | |
The "e" in e-mail
Join Date: Feb 2006
Location: EU
Posts: 4,970
|
Excel just entered its 40th year
Quote:
|
|
26 Oct 2024, 12:45 AM | #2 |
Moderator
Join Date: Nov 2001
Location: British Columbia
Posts: 4,042
|
I remember when Excel for Windows and Word for Windows came with a bare bones version of Windows.
|
26 Oct 2024, 01:59 AM | #3 |
Moderator
Join Date: Nov 2001
Location: British Columbia
Posts: 4,042
|
Interesting thing about Excel is that it did not take into account that there was no February 29th in the year 1900.
In Excel, day 1 was January 1st 1900. When Microsoft released Access, they synced the dates on March 1st 1900 as day 61. In Access this means day 1 is December 31st 1899. I discovered this on February 29th, 2000. I was running a routine in Access involving the DOS mm-dd-yy timestamp on files. The routine wasn't Y2K compatible, but it didn't matter. Except for that day where my function generated an error message. For me it was serendipity because I had written a database where I used the day numbers and I couldn't understand why day 1 was December 31st 1899. |
27 Oct 2024, 07:51 AM | #4 |
The "e" in e-mail
Join Date: Oct 2002
Location: Holon, Israel.
Posts: 4,991
|
John Walker writes about the MS Excel 29 February 1900 bug and more on dates in Excel here in his Fourmilab's Calendar Converter.
|
30 Oct 2024, 11:36 AM | #5 |
Essential Contributor
Join Date: Mar 2007
Location: UK
Posts: 282
|
Excel is great, but it would be even greater if they had stuck with and extended the original concept, instead of shoehorning in ugly new features that undermined its logical structure.
For example: Giving the columns letters instead of numbers. (How many cells to the right of column Q is column AH?! Ridiculous.) Introducing "merged cells", which prevent you from selecting a single column or row, instead of extending the principle of "center across columns" so that you could, for example "center down rows" or "right align across columns". Changing the way lines on cell borders were defined so that it became ambiguous. Abandoning the straightforward and elegant Excel 5 Macro language and replacing it with the cumbersome and hard-to-understand "Visual Basic". I could go on. ...And I often do ! Last edited by Grhm : 30 Oct 2024 at 11:51 AM. |
Thread Tools | |
|
|