Click here to Skip to main content
15,924,039 members
Home / Discussions / C#
   

C#

 
GeneralRe: Sine Wave using GDI+ Pin
leppie4-Jun-08 3:42
leppie4-Jun-08 3:42 
GeneralRe: Sine Wave using GDI+ Pin
Alan Balkany4-Jun-08 4:06
Alan Balkany4-Jun-08 4:06 
AnswerRe: Sine Wave using GDI+ Pin
Guffa4-Jun-08 3:28
Guffa4-Jun-08 3:28 
GeneralRe: Sine Wave using GDI+ Pin
vinay_K4-Jun-08 3:44
vinay_K4-Jun-08 3:44 
AnswerRe: Sine Wave using GDI+ Pin
Russell Jones4-Jun-08 5:53
Russell Jones4-Jun-08 5:53 
QuestionPerformance issue when using DLL Import to call C++ function from C# Pin
GalitM4-Jun-08 1:45
GalitM4-Jun-08 1:45 
AnswerRe: Performance issue when using DLL Import to call C++ function from C# Pin
Harvey Saayman4-Jun-08 4:56
Harvey Saayman4-Jun-08 4:56 
QuestionHelp with Excel Formula Pin
MumbleB4-Jun-08 1:43
MumbleB4-Jun-08 1:43 
Hi Guys. I have an application that writes a bunch of records to Excel. At the end of writing the data I need to sum a column. However, I don't know how many records there will be in the file so I can't set the range to sum in the code. I tried this by setting it something like the below but for some reason it doubles the Total that is summed.

I need to know how to get the last range and set that in the formula dynamically.

objRange = objSheet.get_Range("E1", System.Reflection.Missing.Value);
objRange.Formula = "=SUM(J4:J50000)";
objRange.FormulaHidden = true;
objRange.Calculate();
objRange.Font.Bold = true;
objRange.Font.ColorIndex = "5";


From the above I am selecting cel E1 and in this cell I have the formula to sum the totals of the data in Column J. As I don't know what the last line of data is going to be I set the final cell to calculate as J50000.

Can somebody please help me with this??

Cheers

Excellence is doing ordinary things extraordinarily well.

AnswerRe: Help with Excel Formula Pin
Jimmanuel4-Jun-08 2:48
Jimmanuel4-Jun-08 2:48 
GeneralRe: Help with Excel Formula Pin
MumbleB4-Jun-08 2:58
MumbleB4-Jun-08 2:58 
GeneralRe: Help with Excel Formula Pin
Jimmanuel4-Jun-08 3:08
Jimmanuel4-Jun-08 3:08 
GeneralRe: Help with Excel Formula Pin
MumbleB4-Jun-08 3:15
MumbleB4-Jun-08 3:15 
GeneralRe: Help with Excel Formula Pin
MumbleB4-Jun-08 3:24
MumbleB4-Jun-08 3:24 
GeneralRe: Help with Excel Formula Pin
Jimmanuel4-Jun-08 3:31
Jimmanuel4-Jun-08 3:31 
GeneralRe: Help with Excel Formula Pin
MumbleB4-Jun-08 3:36
MumbleB4-Jun-08 3:36 
GeneralRe: Help with Excel Formula Pin
Jimmanuel4-Jun-08 3:41
Jimmanuel4-Jun-08 3:41 
QuestionSend a socket using stream Pin
xax4-Jun-08 1:19
xax4-Jun-08 1:19 
AnswerRe: Send a socket using stream Pin
leppie4-Jun-08 1:25
leppie4-Jun-08 1:25 
QuestionHow to create a install/setup package? Pin
Phoenix1014-Jun-08 1:01
Phoenix1014-Jun-08 1:01 
AnswerRe: How to create a install/setup package? Pin
leppie4-Jun-08 1:20
leppie4-Jun-08 1:20 
AnswerRe: How to create a install/setup package? Pin
GuyThiebaut4-Jun-08 4:06
professionalGuyThiebaut4-Jun-08 4:06 
AnswerRe: How to create a install/setup package? Pin
Muhammad Shahid Farooq4-Jun-08 4:50
professionalMuhammad Shahid Farooq4-Jun-08 4:50 
QuestionHow i can Unzip file using C# code Pin
wasimsharp4-Jun-08 0:51
wasimsharp4-Jun-08 0:51 
AnswerRe: How i can Unzip file using C# code Pin
Vasudevan Deepak Kumar4-Jun-08 0:51
Vasudevan Deepak Kumar4-Jun-08 0:51 
QuestionFlash and c# connectivity problem Pin
Tejal Bhavsar4-Jun-08 0:38
Tejal Bhavsar4-Jun-08 0:38 

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.