Click here to Skip to main content
15,921,646 members
Home / Discussions / C#
   

C#

 
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 
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 
Hi Jimmanuel. I have used the below and I get an error when it does the calculation. Am I doing this right?

int lastUsedRow = objSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell,
    Type.Missing).Row;


And this is where I add it into the formula.

objRange = objSheet.get_Range("E1", System.Reflection.Missing.Value);
objRange.Formula = "=SUM(J4:J[lastUsedRow])"; //Added in here
objRange.FormulaHidden = true;
objRange.Calculate();
objRange.Font.Bold = true;
objRange.Font.ColorIndex = "5";


Excellence is doing ordinary things extraordinarily well.

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 
Questionform doesn't change when i add button Pin
jaffa4-Jun-08 0:01
jaffa4-Jun-08 0:01 
AnswerRe: form doesn't change when i add button Pin
Colin Angus Mackay4-Jun-08 0:03
Colin Angus Mackay4-Jun-08 0:03 
GeneralRe: form doesn't change when i add button Pin
jaffa4-Jun-08 0:24
jaffa4-Jun-08 0:24 
GeneralRe: form doesn't change when i add button Pin
Colin Angus Mackay4-Jun-08 0:25
Colin Angus Mackay4-Jun-08 0:25 
GeneralRe: form doesn't change when i add button Pin
jaffa4-Jun-08 0:48
jaffa4-Jun-08 0:48 

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.