C# Discussion Boards - CodeProject

Nick Seng14-Apr-03 23:38

14-Apr-03 23:38

I had this same problem a while ago, and the solution I used was:

Assign the refering name to a variable

String sRef = (String)(nm.RefersToR1C1).Split("!"c)
which will get you something like "RxCy" where X is the row number and y is the Column number. Extract those value out, then

String Value = (String)WB.Sheets(sheetname).Cells.Item(row,col)

It's a long way to do it, but until Office 11 comes out, it's the only way I know

Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain

Get your facts first, and then you can distort them as much as you please
Mark Twain

Re: C# and excel

Chris Austin15-Apr-03 5:16

Chris Austin

15-Apr-03 5:16

Hey Marix, check out the link below. It is a very through look at automating office using .net and C#

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=b7df82d9-3619-465a-bc28-c6f0d2c5fdfd[^]

Hey don't worry, I can handle it. I took something. I can see things no one else can see. Why are you dressed like that?
- Jack Burton

Powering through statements

Adam Turner14-Apr-03 14:28

Adam Turner

14-Apr-03 14:28

Basically, i dont care if a set of statements throws an exception but i dont want the program flow to be interupted. How can i do this? Something like the following:

int[] manyInts = new int[4];<br />
manyInts[0] = 1;<br />
manyInts[1] = 1;<br />
manyInts[2] = 1;<br />
manyInts[3] = 1;<br />
manyInts[4] = 1;<br />
manyInts[5] = 1;

So basically it executes every statement whether it thows an exception or not.

-- ABT

Re: Powering through statements

Jim Stewart14-Apr-03 17:43

Jim Stewart

14-Apr-03 17:43

How about:

try //Outside try block to handle initialization and leave the array visible	
{
    int[] manyInts = new int[4];

    try {manyInts[0] = 1;} 
    catch {/*Empty catch block does nothing*/}

    try {manyInts[1] = 1;} 
    catch {}

    try {manyInts[2] = 1;}
    catch {}

    try {manyInts[3] = 1;}
    catch {}

    try {manyInts[4] = 1;}
    catch {}

    try {manyInts[5] = 1;}
    catch {}
}
catch {}

...Powerful kludgy - but should work

α.γεεκ

Fortune passes everywhere.
Duke Leto Atreides

Re: Powering through statements

Adam Turner14-Apr-03 17:49

Adam Turner

14-Apr-03 17:49

HA.

That is extactly the work around that i am using.

Re: Powering through statements

Jim Stewart14-Apr-03 18:07

Jim Stewart

14-Apr-03 18:07

Sprinkle liberally with cheese and enjoy.

α.γεεκ

Fortune passes everywhere.
Duke Leto Atreides

Shell/OLE Interface Definitions

J. Dunlap14-Apr-03 14:16

J. Dunlap

14-Apr-03 14:16

Do you know where I can get the whole gamut of Shell and OLE interfaces (like IOLEWindow, IViewObject, IContextMenu, IPersistStorage, etc.) in C# definitions?

I could write them myself, but oh, what a time-saver it would be to already have them written!

THANKS!

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Shell/OLE Interface Definitions

James T. Johnson14-Apr-03 17:13

James T. Johnson

14-Apr-03 17:13

I don't know if anyone has put all of them into a single place, but a majority of them may be covered by several articles in the Shell Programming[^] section.

James

"It is self repeating, of unknown pattern"
Data - Star Trek: The Next Generation

Re: Shell/OLE Interface Definitions

J. Dunlap14-Apr-03 18:33

J. Dunlap

14-Apr-03 18:33

Thanks for the pointer. I'm working on an IE ToolBand, and there happens to be a toolband sample which I didn't know about.

But I suppose I'll just have to write a bunch of interface defs myself for all the others.

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Interop Strong Names?

Steven Behnke14-Apr-03 12:33

Steven Behnke

14-Apr-03 12:33

Is there anyway to fool the compiler into working with an Interop library with a strong name? I am receiving the following error when trying to compile my app and sign it.

Assembly generation failed -- Referenced assembly 'Interop.WIALib' does not have a strong name

Thanks,
Steven

Re: Interop Strong Names?

Steven Behnke14-Apr-03 12:48

Steven Behnke

14-Apr-03 12:48

Nevermind guys, I found it. It was listed under the C# Project Options called: "Wrapper Assembly Key File."

Thanks,
Steven

.NET 2003 and C# - Need to deploy app...

ekuhner14-Apr-03 12:12

ekuhner

14-Apr-03 12:12

Ok,

I built a pretty cool app for my company to use, and now I'm trying to deploy the .exe file to other users.

I've copied that file over to another computer that does not have Visual Studio .NET 2003, and it won't run without a bunch of DLL files.

How do I build the distribution app? Or is there an easier way to do this?

Thanks!!

-ed

Re: .NET 2003 and C# - Need to deploy app...

Steven Behnke14-Apr-03 12:49

Steven Behnke

14-Apr-03 12:49

You can use VisualStudio itself to build installers fairly easliy. Check out the C# Today tutorial:

http://www.csharptoday.com/content.asp?id=1691

Re: .NET 2003 and C# - Need to deploy app...

Chris Austin14-Apr-03 12:53

Chris Austin

14-Apr-03 12:53

You need to download and install the .net runtime on the target computer. There is no way around this.

Also, assuming you have the help installed, do a search on 'Setup Project'. You will find a few walkthroughs that show you the basics of deployment.

Hey don't worry, I can handle it. I took something. I can see things no one else can see. Why are you dressed like that?
- Jack Burton

Return S_FALSE

J. Dunlap14-Apr-03 11:29

J. Dunlap

14-Apr-03 11:29

How do you return S_FALSE in C#? Since it translates HRESULTS into errors, I normally raise a System.xxxxException, but I don't know what the exception for S_FALSE is. But I guess it might not even exist, since S_FALSE does not have the SEVERITY_ERROR bit set. Frown | :(

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Return S_FALSE

J. Dunlap14-Apr-03 14:17

J. Dunlap

14-Apr-03 14:17

I'm going to have to tell C# that the HRESULT is an int, so I can do my own return value.

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Bitwise AND

J. Dunlap14-Apr-03 10:47

J. Dunlap

14-Apr-03 10:47

I'm trying to find if a bit is set in a mask.

The code:

if(pdbi.dwMask & olelib.DESKBANDINFO_Masks.DBIM_TITLE)

gets an error:

error CS0029: Cannot implicitly convert type 'olelib.DESKBANDINFO_Masks' to 'bool'

and the code:

if(pdbi.dwMask & (int)olelib.DESKBANDINFO_Masks.DBIM_TITLE)

gets an error:

error CS0029: Operator '&' cannot be applied to operands of type 'olelib.DESKBANDINFO_Masks' and 'int'

Could someone kindly explain how to get around this?

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Bitwise AND

J. Dunlap14-Apr-03 10:59

J. Dunlap

14-Apr-03 10:59

To make myself more clear, 'olelib.DESKBANDINFO_Masks' is an int Enum.

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Bitwise AND

monrobot1314-Apr-03 11:32

monrobot13

14-Apr-03 11:32

Don't know for sure, but I think you need to have the Flags attribute on the olelib.DESKBANDINFO_Masks enum.

- monrobot13

Re: Bitwise AND

J. Dunlap14-Apr-03 11:55

J. Dunlap

14-Apr-03 11:55

Found out it had nothing to do with that. That line of code should be:

if(!((pdbi.dwMask & olelib.DESKBANDINFO_Masks.DBIM_TITLE)==0))

I clean forgot that in C#, true is -1 !!!!

"Do unto others as you would have them do unto you." - Jesus

"An eye for an eye only makes the whole world blind." - Mahatma Gandhi

Re: Bitwise AND

James T. Johnson14-Apr-03 14:33

James T. Johnson

14-Apr-03 14:33

jdunlap wrote:
I clean forgot that in C#, true is -1 !!!!

Its not that true is -1, in C# you cannot implicitly convert from an int to a bool. While pdbi.dwMask & olelib.DESKBANDINFO_Masks.DBIM_TITLE may result in a non-zero value; the if statement requires a bool. Which is why simply comparing that result to zero works, the comparison produces a bool which the if statement can deal with.

James

"It is self repeating, of unknown pattern"
Data - Star Trek: The Next Generation

Tab page events

vlusardi14-Apr-03 10:14

vlusardi

14-Apr-03 10:14

Is there a way to get a tab page change event (or any event for that matter) to fire when you click the "tab" portion of the tab page...??? All the events I've tried seem to need a click in the tab page body in order to fire...

I need to be able to do some "init" coding on tab pages as soon as the tab label is clicked, without having to first click in the tab page body, and I'm wondering if anyone has some advice as to how this can be done...

thanks.

Re: Tab page events

monrobot1314-Apr-03 10:48

monrobot13

14-Apr-03 10:48

You can use the SelectedIndexChanged event of the TabControl. This event fires whenever the selected tab page changes. The selectedindex property of the TabControl will be the page that was selected (0 based).

- monrobot13

Re: Tab page events

vlusardi14-Apr-03 11:09

vlusardi

14-Apr-03 11:09

Yo,

thanks for the clue, that's what I was looking for....

I owe you a beverage...

Getting the average width of a font

monrobot1314-Apr-03 7:37

monrobot13

14-Apr-03 7:37

Is there any easy way to get the width of a font? I see that I can use the ToLogFont method or the Font class and then use the lfWidth member of the LOGFONT structure to get the width, but there has to be an easier way. Am I wrong? If there is no easier way how would I use the ToLogFont method?

Thanks

- monrobot13

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