Hello,

Is possible too add button in a cell that it can trigger event when click it.

Thanks

David Chiang

Thanks for the reply. What I need is for adding one or more button for each row of data. When click the button, which will trigger a event to popup a window or some other action. Do you have example to testing... Thanks a lot.



                       for (int x = 0; x < recCount; x++)
                       {
                             kk = 0;
                             dataRow = dataTable.Rows[x];
                             for (int k = 0; k < columnsVisible.Count; k++)
                             {
                                   //Console.WriteLine("rptExcel 148 : " + " k = " + k + "  datae = " + columnsVisible[k]);
                                   if (columnsVisible[k] == "1")
                                   {
                                         var cell = activeSheet.Cells[k - kk, x + 1];
                                         //cell.Data =dataRow[k].ToString();
                                         cell.Data = ParsingJson.ConvertParamData(colLinkType[k], colLinkID[k], dataRow[k].ToString(), jsonOther, AboutParam.jsonLang);
                                         GenerateRandomFont(ref cell);
                                   }
                                   else kk++;
                             }
                       }


Adding button inside the cell

David Chiang

Maybe try styling cells themselves to look like hyperlinks or buttons, and then run your action from CellClicked event. If you need actual buttons, we could extend the embedded objects system (e.g. images / annotations) to support custom controls for next release.

Regards,
Slavcho

Any example by code behind? Like sample code I put.  How to WorkbookView.HyperlinkClicked popup new window?

Thanks

David Chiang

Here is code I used.

                                         var cell = activeSheet.Cells[k - kk, x + 1];
                                         //cell.Data =dataRow[k].ToString();
                                         cell.Data = ParsingJson.ConvertParamData(colLinkType[k], colLinkID[k], dataRow[k].ToString(), jsonOther, AboutParam.jsonLang);
                                         cell.SetHyperlink(HyperlinkType.WebAddress, ParsingJson.ConvertParamData(colLinkType[k], colLinkID[k], dataRow[k].ToString(), jsonOther, AboutParam.jsonLang), "");
                                         workbookView.HyperlinkClicked +=
                                               (sender, args) => MessageBox.Show(args.Cell.Value.ToString());
                                         GenerateRandomFont(ref cell);


But I am not able to close the messagebox. It keep pop up.
it will popup 5302 times

                                         workbookView.HyperlinkClicked +=
                                               (sender, args) => showWindow();


           void showWindow()
        {
                 Console.WriteLine("KKK");
           }



if I only use

cell.SetHyperlink(HyperlinkType.WebAddress, ParsingJson.ConvertParamData(colLinkType[k], colLinkID[k], dataRow[k].ToString(), jsonOther, AboutParam.jsonLang), "");

the data will not show up.

Thanks

David Chiang

Thanks a lot , any sample to make the cell style like button? Since I like to hide data in behind, Usually I use TAG but there is no TAG attribute in cell. Is there any place I can hide the data?


BTW. How to show the long number to string instead of 1.3434+12?

Is there anyway I can do like

                                               cell.SetAnnotation(dataRow[k].ToString());
cell.SetAnnotation.Visibility = Visibility.Hidden ;
cell.SetHyperlink(HyperlinkType.WebAddress, ParsingJson.ConvertParamData(colLinkType[k], colLinkID[k], dataRow[k].ToString(), jsonOther, AboutParam.jsonLang), "");


Or How do I  inserting a button into the cell-edit UI? Any sample for that.

Thanks again

David Chiang

Quote:


Try setting cell's Style.Format to one different than General, e.g. "0".

Thanks for the reply. The cell format is working now and I might have more then one button per ROW. How can I inserting a button into the cell-edit UI? That I can use button's TAG to hide the data. Any sample for that.

Or the about answer is the way to do?


Thanks a lot

David Chiang