Click here to Skip to main content
15,916,693 members
Home / Discussions / C#
   

C#

 
GeneralRe: code for IP detection on LAN Pin
Mycroft Holmes9-Mar-09 23:37
professionalMycroft Holmes9-Mar-09 23:37 
GeneralRe: code for IP detection on LAN Pin
dan!sh 9-Mar-09 23:46
professional dan!sh 9-Mar-09 23:46 
AnswerRe: code for IP detection on LAN Pin
dan!sh 9-Mar-09 23:28
professional dan!sh 9-Mar-09 23:28 
GeneralRe: code for IP detection on LAN Pin
EliottA10-Mar-09 3:16
EliottA10-Mar-09 3:16 
QuestionListView in C# Pin
mrithula89-Mar-09 22:02
mrithula89-Mar-09 22:02 
AnswerRe: ListView in C# Pin
MumbleB9-Mar-09 22:11
MumbleB9-Mar-09 22:11 
AnswerRe: ListView in C# Pin
Xmen Real 9-Mar-09 23:42
professional Xmen Real 9-Mar-09 23:42 
QuestionExcel Questions [modified] Pin
MumbleB9-Mar-09 21:43
MumbleB9-Mar-09 21:43 
Hi Guys. I have a working Excel application that reads an input file and writes the data to an Excel sheet. Now, I need to do a few more things though but just can't seem to get it working properly. This is what I need to do and what I have so far.
I need to set the current cell color to red if the Recon Indicator is NN but it sets all the cells before the current cell to RED. My question is how do I select only the current Cell. I have tried numerous things but it doesn't work.
if (RECONCILIATIONIND == "N")
{
    objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
    objRange = objSheet.Cells.Rows.EntireRow;
    objRange.Font.ColorIndex = "3";
}

The next problem I have is that I need to do some calculation on an unknown number of cells and subtract it from a total in a different column. Below is a sample screen.
Nominees & Own Name (Level 1)	Beneficiaries (Level 2)
19326421	
	                                175
	                                84
	                                76
	                                2238
	                                235
	                                14
	                                591
	                                345
	                                122
	                                240
	                                346

From the above, I need to calculate the totals in Beneficiary (level 2) and subtract that from Level 1 total and add the total into a new column. Now, there is an undertermined number of values in Level 2 i.e. there could be 2 or 4 or 50 or 300 values to add. How would I be able to do that?

Any help or advise would be appreciated.
Excellence is doing ordinary things extraordinarily well.

Excellence is doing ordinary things extraordinarily well.

modified on Tuesday, March 10, 2009 4:03 AM

AnswerRe: Excel Questions Pin
Mycroft Holmes9-Mar-09 23:44
professionalMycroft Holmes9-Mar-09 23:44 
GeneralRe: Excel Questions Pin
MumbleB10-Mar-09 0:43
MumbleB10-Mar-09 0:43 
Questionexcel addin doubt Pin
abhiram_nayan9-Mar-09 21:37
abhiram_nayan9-Mar-09 21:37 
Questionhow to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 21:23
Ramin Rahimee9-Mar-09 21:23 
AnswerRe: how to delay sending mail in c# Pin
Mycroft Holmes9-Mar-09 21:27
professionalMycroft Holmes9-Mar-09 21:27 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 21:35
Ramin Rahimee9-Mar-09 21:35 
GeneralRe: how to delay sending mail in c# Pin
N a v a n e e t h9-Mar-09 21:47
N a v a n e e t h9-Mar-09 21:47 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 22:54
Ramin Rahimee9-Mar-09 22:54 
GeneralRe: how to delay sending mail in c# Pin
Christian Graus9-Mar-09 22:02
protectorChristian Graus9-Mar-09 22:02 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 22:52
Ramin Rahimee9-Mar-09 22:52 
GeneralRe: how to delay sending mail in c# Pin
Dave Kreskowiak10-Mar-09 1:29
mveDave Kreskowiak10-Mar-09 1:29 
GeneralRe: how to delay sending mail in c# Pin
Rob Philpott9-Mar-09 23:14
Rob Philpott9-Mar-09 23:14 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 23:47
Ramin Rahimee9-Mar-09 23:47 
GeneralRe: how to delay sending mail in c# Pin
Mycroft Holmes9-Mar-09 23:26
professionalMycroft Holmes9-Mar-09 23:26 
GeneralRe: how to delay sending mail in c# Pin
Ramin Rahimee9-Mar-09 23:42
Ramin Rahimee9-Mar-09 23:42 
QuestionA few Excel Questions Pin
MumbleB9-Mar-09 20:42
MumbleB9-Mar-09 20:42 
AnswerRe: A few Excel Questions Pin
Mycroft Holmes9-Mar-09 21:06
professionalMycroft Holmes9-Mar-09 21:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.