|
I think it's down to the problem mentioned here[^] - for compatibility's sake they replicated a bug in Lotus 123, which thought that 1900 was a leap year.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Backward compatibility is the cause of numerous problems in computing, I believe.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
It's even documented here[^].
|
|
|
|
|
The sad thing is I immediately knew when I saw the subject and the dates.
|
|
|
|
|
Excel is horrible at a number of things. What causes me much trouble is that there are some string values, e.g. 1DEC, that I am supposed to get from a database, but because along the way from their point of origin to my source they pass through Excel, they come in as 12/1/2013 (whatever the current year is).  So then my ETL process has to detect these and correct them.
|
|
|
|
|
|
Ian Shlasko wrote: it won't be wrong again for 85 more years...
Only if your computer's clock gets reset:
NOTE: Microsoft Excel correctly handles all other leap years, including century years that are not leap years (for example, 2100). Only the year 1900 is incorrectly handled.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I am not a coder, just a person that doesn't know where to turn. I was downloading some software, and a virus encrypted all my files. I can't read any of my files, and don't know where to turn. the virus sends me to a web site where I have to pay to take the encrypting off. this is like kidnapping my files for ransom. can anyone point me to some software that would take away the encrypting. I am so frustrated that I don't know what to do. please send any information to xxxxxxxxxxxxx@msn.com. anything is greatly appreciated....
|
|
|
|
|
First you have to run an antivirus program - probably from boot disk - to clean the virus and identify it...
After that you may find a solution to that specific virus on the web, but it is also possible that you will not be able to recover the file ever, so if you have any backup of the important files, you may better to start over with a clean install...
(Please remove your email - it only will invite spams, you will be notified of any response you may get here)
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
You just caugth a Cryptolock Ransomware attack.
Normally the attackers send you the key to decrypt the files if you pay, in case they are important files and you don't have a backup it's your only way out. If you have a backup, run antivirus to detect were you did catch the infection, then clean your PC and restore a backup.
Geek code v 3.12
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Isnt this one of those 'shell overwrite' viruses?
Try to get a second machine and search on line how to fix this, normally, its something like putting back an original system file or some such.
|
|
|
|
|
Use System Restore point facility of operating system. It will take you to last Restore point. You may loose some of your files. But I think its good to have something rather than nothing.
|
|
|
|
|
|
More like wrong site. While there may be some of us that know how to deal with a virus etc. there are probably many sites/fora that are dedicated to helping solve issues with that kind of thing 
|
|
|
|
|
Numbered lists have annoyed me in office for years, they seem to do all sorts of unpredictable things. To the extent I prefer not to use them and manually number things.
Just got a document from an acceptance tester. He included a numbered list, with a number (identifier) in the first "word" of one item in the list. Like this (underscore is my text, 14. is the numbered item in the list)
14. 472995 more text here.
So I thought "I'll copy that ID and paste it into a query window". My selection exactly matched the underlined portion of text above. Imagine my joy when a copy/paste into SQL window (or anything else) yields...
14. 472995
So, magically, the first word of a paragraph invisibly carries along the list item number. Genius.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
Yes, annoying that. Nobody seems to get this right.
If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams
You must accept one of two basic premises: Either we are alone in the universe, or we are not alone in the universe. And either way, the implications are staggering.-Wernher von Braun
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
|
|
|
|
|
I am right now, experiencing some aggravation with Word 2013...I ask you to do one simple thing, spellcheck a word for me!..and you fool me, for just a few seconds, into thinking that my spelling skills (for words I can never seem to get right!) had magically improved! 'Kewl! No squiggly line...but, it still doesn't look right'...so intentionally misspell (even cp corrected an attempted pun) something as a test...no squiggly lines?  Check everywhere in the ribbon for spellcheck, (which should be on auto according to options) finally find it and it tells me that I'm 'good to go'! OK, maybe I have to put the intentionally misspelled words into sentences for it to work? Nope! 15 minutes later, and I'm going back to Word 2007 which just works! 
"Go forth into the source" - Neal Morse
|
|
|
|
|
Last week I wanted to copy item 4 of a list into an email -- nope, as soon as I paste it it becomes item 1.
|
|
|
|
|
Of course it does, when you paste it onto a brand new page it is the only item in the new list so naturally it becomes 1. You just can’t argue with MS logic which knows how you should be doing things.  
Just because the code works, it doesn't mean that it is good code.
|
|
|
|
|
When the sixteenth President is alone in a room he doesn't become the first President. 
|
|
|
|
|
Now you are just talking sense!
But, according to MS logic, he would be President #1! 
Just because the code works, it doesn't mean that it is good code.
|
|
|
|
|
Ah, but he is the first president in the room since he last checked..
Come on Microsoft, can't you see I have the right stuff to be CEO? Just mail me! 
How do you know so much about swallows? Well, you have to know these things when you're a king, you know.
modified 31-Aug-21 21:01pm.
|
|
|
|
|
Wouldn't that be weird to be pasted in as item #4 when it's the only item in a list?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
We have two functions apiCall and handleChangeEvent. The simplified version below.
function apiCall() {
}
function handleChangeEvent(newData,oldData) {
if(newData !== oldData)
{
apiCall();
}
}
One of my colleagues reports they have a problem with apiCall not being called from handleChangeEvent because of the if condition. They claim that the event is sometimes handled and sometimes not. Suspicious claim, as the apiCall code can be triggered from other locations, but it's an issue they should be able to handle so I didn't investigate further.
Later the cheery colleague says they solved the issue and I decided to review their code. I take a look at their work from time to time to help improve their code and this is the solution they came up with:
function handleChangeEvent(newData,oldData) {
newData = !oldData;
if(newData !== oldData)
{
apiCall();
}
}
 
I told them that this is not the way to solve the issue, and took the time to show them that that apiCall was in fact called from another location. I also gave them a few solutions that could be made and left to take a break. I hope to help guide them, but I fear that there is no helping them . I'm still puzzled and angry that someone would write such a solution!?
|
|
|
|
|
what about handling null values for new and old data parameters? this has bitten me in the ass before.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
