|
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.
|
|
|
|
|
pretty soon all the data in the database will be =false
|
|
|
|
|
The code is sufficient in this case not to check for null  . The parameters passed are from an event, and the function is called when the field it is bound to changes. Additionally the apiCall function doesn't change anything, but the overhead of making a request to the api should be avoided, hence it's wrapped in an if statement.
|
|
|
|
|
It looks fine syntax wise however you should add what the solution is meant to do. If this is dealing with a database or with some form of data than parameters should be put there. Someone did say Null values and that can come with some downsides. With handling data some limitations should be added. However as I said I have no idea what data the function is trying to deal with. All I know is that it handles two objects. One newData and Two oldData. I know that if newData and oldData are the same than it will be false and in that instance the API would be called. Could you go in depth a little bit further or what type of data you are dealing with.
|
|
|
|
|
The actual data passed is a timestamp when a change has happened. The handleChangeEvent function is an event handler bound to a field, like an input field onchange event in the browser. The framework takes care of when to call this function, and then the control takes responsibility of what needs to happen.
The point of my semi-rant being that the dev in question tried to fix a problem by doing the wrong thing in the wrong place 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
