GrapeCity Forums

hi

   I have a spread(fpSpread2) with 3 columns and 10 rows as shown below.

    ID                Description   

1200-3400         PersonA             >

1200-3401         PersonB

1200-3402         PersonC             >               This arrow mark indicates that there are sub-items for that particular row.The sub-items are in another spread

                                                                   (fpSpread3) which has 2 columns and 5 rows.The columns are ID and Description(but  different from  

                                                                   fpSpread2).

Both these fpSPread2 and fpSpread3 are hosted in 2 different popup controls.The fpSpread2 appears on button click of a main spread(fpSpread1).

Requirement:

     Whenever the user clicks on the button in fpSpread1 ,this fpSpread2 popup appears,which has the above mentioned columns and details.When the user HOVERS over the rows ,only the rows which have sub-items(indicated by arrow mark), must popup(or display) the fpSpread3 and on clicking of an item/row in fpSpread3,the clicked value from fpSpread3 and the hovered value of fpSpread2 must get displayed within the same cell(one below the other) in fpSpread1. 

     IT should work similar to (for example),the "START" button in our computer..Start---> Programs--->Accessories--->Notepad.The user may/maynot click on each level of navigation.Only on click of 'Notepad',the values in the previous levels of navigations are captured by the computer and displays the clicked item.

    Even when the user clicks on the 'Description' column for any of the spreads,only the corresponding 'ID' must get displayed in the cell,and not the 'Description'.

       Hope i have explained my requirement pretty clearly.I tried using the MouseHover and MouseMove event,but in vain.AM not able to proceed.PLease help me out with the coding part,as I have been struggling with this for many days.Am using C# code.

 Thanks a lot for any kind of help...:-)...

 

Droopy

Hello,

What problem(s) are you having. You should be able to use the mouse events to get the x.y coordinates of the mouse and you can use the GetCellFromPixel method to determine the cell you are over in Spread2. Then, store off the cell so you can write values from Spread3 back to this cell and then popup Spread3.

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

Hi Scotts,

   can u send me some sample code...

Hi Scotts,

 I got it....Thanks a lott for your help!!! :-)....If i have any doubts .will get back to you

HI Scotts,

  I have one more question.

  When the user hovers over the row, i want the hovered row to be highlighted.WHen the user leaves that row and moves to next row,the previously hovered row must get unhighlighted and the new row to be highlighted.How do i do this?

I tried this in the fpspread_leavecell event.It dint work.How do i use this in mouse hover event????or any other event?

if((e.NewColumn > -1) && (e.NewRow > -1))

{

fpPIDPrime.Sheets[0].ColumnHeader.Columns[e.NewColumn].BackColor = Color.Red;

fpPIDPrime.Sheets[0].RowHeader.Rows[e.NewRow].BackColor = Color.Red;

if(e.Column != e.NewColumn)

{

fpPIDPrime.Sheets[0].ColumnHeader.Columns[e.Column].ResetBackColor();

}

if(e.Row != e.NewRow)

{

fpPIDPrime.Sheets[0].RowHeader.Rows[e.Row].ResetBackColor();

}

}

Hello,

You can use the mouse events with the GetCellFromPixel method to find the row the mouse is over. Then, you can set the BackColor for that row and store the row number you are over, so when you highlight a new row, then you can reset the BackColor on the row you stored off.

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

Thanks a lotf for your help Scotts...Its working now!!!...

hi

  I have one more question regarding this.

 Am using 5 spread sheets which must get displayed successively, on hovering over rows.I have attached a screen shot of what i have in my screen.All the controls present are spread sheets.Currently, when i hover over a row in a spread(shown as Product Family), the highlighted row(with dark blue background) will popup another spread(ie.Device Category) and so on. The spreads get aligned on the same row as am not able to specify the placement target for these spreads.

My requirement:

I want the controls to work the same way as any normal cascading menu....( have attached the screenshot of a normal cascading menu)

To make it behave like a cascading menu,  I have added another column to my first spread(Product family) and made that column as button type and hidden.I thought that if the user hovers over a row,the hidden button in the same row, can trigger an event to display the next spread. Here, how do i use the 'editing control' property of the button to display the next spread(Device Category) exactly inline with the hovered row?

 Am using C# code.Please help me out with this as it is very urgent!!!!

Thanks a lot!!!

Droopy

Droopy,

You can use the GetCellRectangle method of the parent Spread menu to determine the location of the row you are oovering over. Then, you can set the Location property of the child Spread menu to this location. The hard part would be determining if you want the child Spread menu to 'popup' on the right or left of the parent Spread menu.

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

Hi Scotts,

Thanks for ur reply.

    The problem is that the Popup accesses only conrol type objects.(e.g controls like a button). Since it recognises only controls for its placement target,how do i go about it?That is the reason i thought a column with button celltype would help in some way.Any suggestions?

Hello,

I do not understand how you have this working. The Spread control is a control type object, but you should just be able to set the location of the form or control you are poppnig up to any location you want. And you can get the location you want from the GetCellRectangle method of the Spread in the parent menu. Could you post a small zipped project reproducing the issue yuo aer seeing for us to debug?

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

Scotts

  Iam unable to attach my sample project file.(maybe due to its large size).Can you give me someother Mail Address of yours( if you dont mind). Will try sending it to that.

 

Thanks

Droopy

The size limit is 256K.  Try removing the spread assemblies.  If that does not work send it to fpsupport@fpoint.com.

---

Bob M.
FarPoint Technologies, Inc.

What steps am I supposed to take when running this project?

---

Bob M.
FarPoint Technologies, Inc.

hi 

Click on the button -à hover over the third row in the spread that appears. Inturn, a  spread named 'Device Category' appears. Hover over the third row in Device Category and ' Device Type' spread appears .Again hover over the second row in Device type and 'Candela' spread appears.This is how it works.

 But none of the spreads get displayed near the hovered row, which is what am trying to figure out.