The truth might scare you. You can take the blue pill and see a Range object with magical properties, or you can take the red pill, faceoff with COM and the "real" Excel object model, and see how deep the rabbit hole goes. I liked the blue pill. — Mat's Mug6 secs ago
aside from poisoning your coworkers and murdering the sales department, eating blue pills that make you see magic code will also get you into trouble with HR
http://code.google.com/p/xee/source/browse/XeePhotoshopLoader.m?r=f16763d221dfca6253983824b470adf553a19e06#108
// At this point, I'd like to take a moment to speak to you about the Adobe PSD
// format. PSD is not a good format. PSD is not even a bad format. Calling it
// such would be an insult ...
I must have the worst luck. Not only have I been feeling rather 'backed up' lately but someone at work has also been stealing my sandwiches and / or milk!
I've tried discussing the milk theft with the manager of the team who are responsible as per this question here on milk theft however they se...
I'm trying to loop through excel cells to get value from sql server table. I've written a macro that will take the jobnumber from the excel and query sql server tale to get customer details and dump it on the spreadsheet. So far I'm only able to get data for single cell. How can I loop through th...
Am trying to create a minesweeper game, I have the following code which has to many nested ifs, I want to change the code to take out the nested ifs and make it better to read. But I am stuck on how to change the nested ifs. Any help would be great. thanks
/*method to check cells around a ce...
Problem
Given a square matrix of size NĂ—N, calculate the absolute difference between the sums of its diagonals.
Input Format
The first line contains a single integer, N. The next N lines denote the matrix's rows, with each line containing N space-separated integers describing the columns.
Out...
Welcome to Code Review! Please edit your title to tell us what your code is doing - every single question on this site could have this title, make yours distinctive. — Mat's Mug ♦29 secs ago
You mention [a] small example program with a loop in a loop in a loop which is very inefficient to begin with. What specifically are you trying to do? Can you post the code and some sample data with expected results so that we might suggest alternatives? Or perhaps head on over to CodeReview to have your code improved on for efficiency? As for your very general question about which solution to go with, it's hard to say without more information. Generally speaking though, VB.Net will still be quicker, but we can probably make your code or formulas much more efficient — tigeravatar17 secs ago
> ContextSwitchDeadlock occurred Message: Managed Debugging Assistant 'ContextSwitchDeadlock' has detected a problem in 'C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE'. Additional information: The CLR has been unable to transition from COM context 0xfc79c8 to COM context 0xfc7910 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becomi…
https://github.com/qbolt/Bingo
I created this for a class assignment and I wanted to do it in an object-oriented way. I haven't really shown anyone my code before and none of my teachers thus far have ever given any feedback. I'm just looking for any criticism I can get. I did my best to use git...
@EBrown I'm probably the wrong guy to ask. I don't care for expression bodied members much. They're cool for a second, then you realize they have problems of their own.
@Mat'sMug I actually have a lot of code here that tries to log exceptions to a database, and the logger tries to log it's own failures to the database...
I have the following function and I was wondering if anyone could come up with something more efficient.
It just has to split both the content and the search string and determine how many words are required to be matched before being true.
For example,
"A dog can run.".ContainsV2("Red Dog Run...
I'm writing a Matrix class, and I want to be able to construct a Matrix in two ways:
Supply a 2D array that the Matrix can use internally
Supply the dimensions of the Matrix, and the value to fill each cell with.
In most languages, the obvious solution would be to overload the constructor, ha...