Click here to Skip to main content
15,887,676 members
Home / Discussions / C#
   

C#

 
GeneralRe: Where can i download iTextSharp.dll (version 4.0.6.0) Pin
Nagy Vilmos17-Mar-09 23:54
professionalNagy Vilmos17-Mar-09 23:54 
GeneralRe: Where can i download iTextSharp.dll (version 4.0.6.0) Pin
MumbleB18-Mar-09 0:51
MumbleB18-Mar-09 0:51 
GeneralRe: Where can i download iTextSharp.dll (version 4.0.6.0) Pin
Nagy Vilmos18-Mar-09 1:14
professionalNagy Vilmos18-Mar-09 1:14 
GeneralRe: Where can i download iTextSharp.dll (version 4.0.6.0) Pin
MumbleB18-Mar-09 1:21
MumbleB18-Mar-09 1:21 
GeneralRe: Where can i download iTextSharp.dll (version 4.0.6.0) Pin
Dan Neely18-Mar-09 2:18
Dan Neely18-Mar-09 2:18 
QuestionWPF StackPanel, ListView update problem Pin
marca29217-Mar-09 21:46
marca29217-Mar-09 21:46 
AnswerRe: WPF StackPanel, ListView update problem Pin
ABitSmart18-Mar-09 0:05
ABitSmart18-Mar-09 0:05 
QuestionExcel Related Question Pin
MumbleB17-Mar-09 21:43
MumbleB17-Mar-09 21:43 
Hi All. I have a wroking application that writes records to and Excel Sheet. I have now been asked by the users to make a small change to the program. After all records has been written to the Sheet I do a Calculation of All values in Two columns and write those totals to "D1" and "D2". I have been asked to write the totals to the bottom of the Sheet rather. Now, the current code I have that does this is as follows:
//Find the last Used Row and Column
int lastUsedRow = objSheet.Cells.SpecialCells
    (Excel.XlCellType.xlCellTypeLastCell, Type.Missing).Row;
int lastUsedColumn = objSheet.Cells.SpecialCells
    (Excel.XlCellType.xlCellTypeLastCell,Type.Missing).Column;

objRange = objSheet.get_Range(lastUsedRow + 1,
    System.Reflection.Missing.Value);
objRange.Value2 = "Total of Level 1";
objRange.Font.Bold = true;
objRange.Font.Italic = true;
objRange.Font.ColorIndex = "5";

When I try and change it to write the totals to the lastUsedRow + 1 it gives me an HRESULT exception. Here the code where it falls over on. I must add that when I debug it seems to be picking up the correct row, i.e. lastUsedRow + 1 but it fails when going onto the next Line of code. Any Ideas as to why this might be happening??
objRange = objSheet.get_Range(lastUsedRow + 1,
    System.Reflection.Missing.Value);
objRange.Value2 = "Total of Level 1";
objRange.Font.Bold = true;
objRange.Font.Italic = true;
objRange.Font.ColorIndex = "5";


Excellence is doing ordinary things extraordinarily well.

AnswerRe: Excel Related Question Pin
Mycroft Holmes17-Mar-09 23:11
professionalMycroft Holmes17-Mar-09 23:11 
GeneralRe: Excel Related Question Pin
MumbleB17-Mar-09 23:28
MumbleB17-Mar-09 23:28 
QuestionCheckForIllegalCrossThreadCalls = false for cross-thread control update Pin
12Code17-Mar-09 21:41
12Code17-Mar-09 21:41 
AnswerRe: CheckForIllegalCrossThreadCalls = false for cross-thread control update Pin
N a v a n e e t h17-Mar-09 22:36
N a v a n e e t h17-Mar-09 22:36 
GeneralRe: CheckForIllegalCrossThreadCalls = false for cross-thread control update Pin
12Code17-Mar-09 22:49
12Code17-Mar-09 22:49 
AnswerRe: CheckForIllegalCrossThreadCalls = false for cross-thread control update Pin
Nagy Vilmos17-Mar-09 22:49
professionalNagy Vilmos17-Mar-09 22:49 
AnswerRe: CheckForIllegalCrossThreadCalls = false for cross-thread control update Pin
Luc Pattyn18-Mar-09 5:44
sitebuilderLuc Pattyn18-Mar-09 5:44 
QuestionDrag & Drop in Datagridview Pin
zeeShan anSari17-Mar-09 21:36
zeeShan anSari17-Mar-09 21:36 
AnswerRe: Drag & Drop in Datagridview Pin
Mycroft Holmes17-Mar-09 23:14
professionalMycroft Holmes17-Mar-09 23:14 
Questionissues with com port Pin
ganeshan.m17-Mar-09 21:18
ganeshan.m17-Mar-09 21:18 
AnswerRe: issues with com port Pin
monstale17-Mar-09 23:28
monstale17-Mar-09 23:28 
AnswerRe: issues with com port Pin
Luc Pattyn18-Mar-09 5:47
sitebuilderLuc Pattyn18-Mar-09 5:47 
QuestionWPF Texbox with "Microsoft Outlook email To field" behavior Pin
marca29217-Mar-09 21:11
marca29217-Mar-09 21:11 
AnswerRe: WPF Texbox with "Microsoft Outlook email To field" behavior Pin
Mycroft Holmes17-Mar-09 23:17
professionalMycroft Holmes17-Mar-09 23:17 
QuestionDrawing an Acr in C#.net using a mouse Pin
b.manan17-Mar-09 20:28
b.manan17-Mar-09 20:28 
AnswerRe: Drawing an Acr in C#.net using a mouse Pin
Christian Graus17-Mar-09 20:38
protectorChristian Graus17-Mar-09 20:38 
GeneralRe: Drawing an Acr in C#.net using a mouse Pin
0x3c018-Mar-09 0:39
0x3c018-Mar-09 0:39 

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.