News for hackers. Stuff that matters.
Re:Damn Excel – How the 'most important application' is ruin... by klodolph on Saturday April 20, 2013 @05:31PM (#5582887)
Yes, it does highlight the cells. But if a mistake does somehow make it in, it is still exceptionally tedious to find the error. It is easy enough to expand a formula for additional cells but accidentally miss a cell, leaving it with the old formula. If you were using SQL, R, or Python, this class of error would never happen.
Re:Damn Excel – How the 'most important application' is ruin... by flatfilefan on Sunday April 21, 2013 @05:08AM (#5584374)
I guess it is just that to do a proper audit you need to have your logic on one page. Otherwise it is extreemly hard to follow the code. In excel every formula is sitting essentially on it's own page. It is easy to code this way but hard to audit.
Re:Damn Excel – How the 'most important application' is ruin... by niggler on Saturday April 20, 2013 @05:40PM (#5582914)
Recent versions of excel do warn you if formulas omit adjacent cells. I agree with your sentiment to some extent but with excel 2011/2013 you have to actively suppress these warnings.