C# Discussion Boards - CodeProject

Re: Microsoft.Office.Interop.Excel

Drew McGhie30-Nov-06 8:38

Drew McGhie

30-Nov-06 8:38

Have you included the Microsoft Interop Assemblies as references in your project?

Re: Microsoft.Office.Interop.Excel

spinz211230-Nov-06 9:30

spinz2112

30-Nov-06 9:30

I did do an add reference, and the on the COM tab chose Microsoft Excel 10 Object Library.
Does this suffice? Do you have to manually install any other interop libraries?

Re: Microsoft.Office.Interop.Excel

Drew McGhie30-Nov-06 10:59

Drew McGhie

30-Nov-06 10:59

I believe that should be sufficient. You might, however, need the Excel 11 libraries, which are included on the install disk for excel if you have 2003 or 2003 Pro (But NOT 2003 basic).
Once you have the right one included, you should be able to access the correct namespaces/methods.

User Control Resize not Obeying Anchors?

cduced29-Nov-06 10:14

cduced

29-Nov-06 10:14

I have a user control with a ListView on the top and two buttons on the lower left. As the control is resized, I want the list to "grow" and the buttons to stay at the lower right. The ListView is anchored to top, bottom, left, right and the buttons are anchored to bottom and right. I can change the size at design time and everything works as planned. When I drop this on a form and drag the size to the size I want, it works fine. But when I close the designer and reopen it, it appears the ListView has expanded to the full size of the control like it is docked to each edge. Any idea what may be wrong?

I also tried setting the size in code but same issue at runtime.

Thanks. -- Bud

Re: User Control Resize not Obeying Anchors?

cduced1-Dec-06 11:25

cduced

1-Dec-06 11:25

Anyone?

RichTextBox - Saving embedded controls

Anthony Queen29-Nov-06 9:32

Anthony Queen

29-Nov-06 9:32

I have written app, borrowing some code from this article ( http://www.codeproject.com/cs/miscctrl/MyExtRichTextBox.asp?df=100&forumid=229962&select=1556581&msg=1556581[^] ). I have controls being inserted at various locations throughout a document and everything looks great. I'm able to query the interface and iterate through each control in the document. Great.

Now, however, I have to be able to save the document to be reloaded at a later time in the same application. When I do this normally, I lose the control information.

So, how can I save the document so that when I reload it, my controls are still showing up in the richtextbox?

Any help is greatly appreciated.

Thanks,
Tony

It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.

Re: RichTextBox - Saving embedded controls [modified]

Anthony Queen29-Nov-06 9:37

Anthony Queen

29-Nov-06 9:37

When I look at the rtf, each place a control should be I have this:

\objattph\'20

So, something is being saved. However, there are properties on each control that are unique for each control inserted. I need to persist this data.

It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.

Re: RichTextBox - Saving embedded controls

mav.northwind29-Nov-06 18:59

mav.northwind

29-Nov-06 18:59

Hi!
What are you using to save/load the contents of the RTB?
I just tried pasting an OLE object into the RTB, then saving it via RichTextBox.SaveFile(). Re-loading it afterwards with RichTextBox.LoadFile() showed the object...

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: RichTextBox - Saving embedded controls

Anthony Queen30-Nov-06 3:57

Anthony Queen

30-Nov-06 3:57

Well, I'm not using an OLE object (which is the most likely reason why this doesn't work), I'm using a control I created in VS 2003. I'm fairly certain that if I implement the correct interfaces in the control that it will save correctly. But, I wouldn't swear to it.

I've tried the save file, I've even tried streaming it straight to disk. The objects are there because I can (using IRichEditOle.GetObjectCount) get a correct count of objects, and actually get the objects back, cast them to the appropriate control and access their properties. This is all before saving though. Once saved, it seems that only a placeholder is saved, and not the object or it's data.

Any ideas on what ole interfaces need to be implemented? Any Examples would be appreciated as well. I can't seem to find a lot of information about this.

Thanks,
Tony

It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.

Re: RichTextBox - Saving embedded controls

Anthony Queen4-Dec-06 3:00

Anthony Queen

4-Dec-06 3:00

Any help is appreciated.

It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.

Listbox and contextmenu

iakob29-Nov-06 9:05

iakob

29-Nov-06 9:05

I have a listbox with a contextmenu. The contextmenu has items such as "add" and "move up" and "move down" and "delete".

But how do I get the listboxitem that were clicked and hence the 'object' for the actions? It's not the selected item on the listbox since I right clicked to get the contextmenu.

I have a feeling that this should be easy, but I just dont know how to do it.

Re: Listbox and contextmenu

led mike29-Nov-06 9:14

led mike

29-Nov-06 9:14

iakob wrote:
But how do I get the listboxitem that were clicked

They hide that information in the documentation[^]

led mike

Re: Listbox and contextmenu

Scott Dorman29-Nov-06 10:57

Scott Dorman

29-Nov-06 10:57

Basically, you need to handle the MouseDown event on the listbox and select the item you clicked.

private void listBox1_MouseDown(object sender, MouseEventArgs e)
{
   ListBox listBox = sender as ListBox;
 
   if (e.Button == MouseButtons.Right)
   {
      int index = listBox.IndexFromPoint(e.X, e.Y);
      if (index >= 0 && index < listBox.Items.Count)
      {
         listBox.SelectedIndex = index;
      }
      listBox.Refresh();
   }
}

In your event handler for the the context menu item, you will need to test if there are any selected items and do the appropriate action. Something like this:

private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
   if (listBox1.SelectedItems.Count > 0)
   {
      MessageBox.Show(listBox1.SelectedItems[0].ToString());
   }
   else
   {
      MessageBox.Show("You didn't select an item!");
   }
}

If you really want to, you would actually enable/disable context menu options in your MouseDown event handler based on an item being selected or the user right clicking in "white space".

-----------------------------
In just two days, tomorrow will be yesterday.

Thanks Was: Listbox and contextmenu

iakob29-Nov-06 20:34

iakob

29-Nov-06 20:34

Thank you both (though one was more impudent than the other Smile | :)

.

I've browsed the documentation and googled the question without finding an answer. Guess I simply failed to spot that particular member. RTFM is simple enough, one should think.

But thanks again.

RichTextBox Coloring Problem

NaNg1524129-Nov-06 9:02

NaNg15241

29-Nov-06 9:02

Hey, this is my problem: i select the last line after i added the new text, i change the color of the line, but then all the lines before becomes the first color inserted and not the color i added them before.

what's the problem and how can i fix it?
this is the code where i add the text in:

private void rtbAddText(String NewText, Color NewColor)
{
    NewText += Environment.NewLine;

    if (NewColor == null)
        this.rtbConsole.Text = NewText;
    else
    {
        int OldLength = rtbConsole.Text.Length;
        this.rtbConsole.Text += NewText;
        this.rtbConsole.Select(OldLength, NewText.Length);
        this.rtbConsole.SelectionColor = NewColor;
        //this.Select();
        //rtbConsole.Select();
    }
}

Thanks... NaNg.

Re: RichTextBox Coloring Problem

Torsten Mauz29-Nov-06 9:31

Torsten Mauz

29-Nov-06 9:31

rather than using

this.rtbConsole.Text += NewText;

you should use

this.rtbConsole.AppendText(NewText);

HTH

Re: RichTextBox Coloring Problem

NaNg1524129-Nov-06 9:46

NaNg15241

29-Nov-06 9:46

Thanks.... was looking for Add() function... (at start) :P

Editing all GridView Rows

Abbas8229-Nov-06 8:52

Abbas82

29-Nov-06 8:52

Hi,

Is it possible to load up a GridView where all rows are in edit mode?

Thanks

Re: Editing all GridView Rows

led mike29-Nov-06 9:15

led mike

29-Nov-06 9:15

Is this an ASP.NET question?

led mike

Re: Editing all GridView Rows

Abbas8229-Nov-06 11:12

Abbas82

29-Nov-06 11:12

I guess so

RichTextBox quandry

Vodstok29-Nov-06 8:38

Vodstok

29-Nov-06 8:38

I have never been able to figure this oneout, or find anything that reliably worked, either.

i am trying to develope an app that uses a richtextbox for input, and has all the options that wordpad does. Now, i realise i may not be able to pull off each and every trick, but there is one in particular that is driving me crazy. in wirdpad, say I have this sentance:

Bold and Italic are font styles.

Now, something i can do very easily is switch individual selections back and forth between one font style and another, so this would be easy:

Bold and Italic are font styles.

the problem is, if i want to do this:

Bold and Italic are font styles.

i get one or the other, basically whichever i selected last. here is the code i am using. rtb is the RichTextBox:

 private void btnBold_Click(object sender, EventArgs e)<br />
        {<br />
            if (rtb.SelectionFont.Bold)<br />
                rtb.SelectionFont = new Font(rtb.SelectionFont.FontFamily, rtb.SelectionFont.Size, FontStyle.Regular);<br />
            else<br />
                rtb.SelectionFont = new Font(rtb.SelectionFont.FontFamily, rtb.SelectionFont.Size, FontStyle.Bold);<br />
            rtb.Select();<br />
        }<br />
<br />
        private void btnItal_Click(object sender, EventArgs e)<br />
        {<br />
            if (rtb.SelectionFont.Italic)<br />
                rtb.SelectionFont = new Font(rtb.SelectionFont.FontFamily, rtb.SelectionFont.Size, FontStyle.Regular);<br />
            else<br />
                rtb.SelectionFont = new Font(rtb.SelectionFont.FontFamily, rtb.SelectionFont.Size, FontStyle.Italic);<br />
            rtb.Select();<br />
        }

I am using C# express and the 2.0 framework. Any ideas?

______________________
Mr Griffin, eleventy billion is not a number... WTF | :WTF:

Re: RichTextBox quandry

NaNg1524129-Nov-06 9:04

NaNg15241

29-Nov-06 9:04

in each one u do not check if it's the other one.
if it is it resets the other one....

think about it.

Re: RichTextBox quandry

Vodstok29-Nov-06 9:34

Vodstok

29-Nov-06 9:34

Granted, that is true, but even if I just set it to italic or bold, like this:

private void btnBold_Click(object sender, EventArgs e)<br />
        {<br />
                rtb.SelectionFont = new Font(rtb.SelectionFont.FontFamily, rtb.SelectionFont.Size, FontStyle.Bold);<br />
            rtb.Select();<br />
        }<br />
<br />
        private void btnItal_Click(object sender, EventArgs e)<br />
        {<br />
                rtb.SelectionFont = new Font(rtb.SelectionFont.FontFamily, rtb.SelectionFont.Size, FontStyle.Italic);<br />
            rtb.Select();<br />
        }

whatever the new fontstyle is, it overrides the existing one. So for example, i have this:

Short sentance

and i highlight like this:
Short sentance

then try setting it to iatlics, rather than getting this:

Short sentance

i get this:
Short sentance

______________________
Mr Griffin, eleventy billion is not a number... WTF | :WTF:

Re: RichTextBox quandry

Anthony Queen29-Nov-06 9:57

Anthony Queen

29-Nov-06 9:57

Try something like this -->

this.richTextBox1.Text = "This is a test";
this.richTextBox1.SelectionStart = 0;
this.richTextBox1.SelectionLength = 7;

System.Drawing.Font currentFont = richTextBox1.SelectionFont;
System.Drawing.FontStyle newFontStyle;
newFontStyle = FontStyle.Bold;
richTextBox1.SelectionFont = new System.Drawing.Font(currentFont.FontFamily, currentFont.Size, newFontStyle);

currentFont = richTextBox1.SelectionFont;
this.richTextBox1.SelectionStart = 5;
this.richTextBox1.SelectionLength = 3;

newFontStyle = FontStyle.Italic | FontStyle.Bold;

richTextBox1.SelectionFont = new System.Drawing.Font(currentFont.FontFamily, currentFont.Size, newFontStyle);

It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.

Re: RichTextBox quandry

Vodstok29-Nov-06 10:16

Vodstok

29-Nov-06 10:16

Awesome! That certainly got me going in the right direction. Its almost emberassing how long i have tried to get this working....

______________________
Mr Griffin, eleventy billion is not a number... WTF | :WTF:

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