call display - Page 683

C# - How to get class of Type

- by Tim

I need to use method like: DoSomething<(T)(); But i don't know which Type i have, only object of class Type. How can i call this method if I have only: Type typeOfGeneric;

Excel UDF calculation should return 'original' value

Hi all, I've been struggling with a VBA problem for a while now and I'll try to explain it as thoroughly as possible. I have created a VSTO plugin with my own RTD implementation that I am calling from my Excel sheets. To avoid having to use the full-fledged RTD syntax in the cells, I have created a UDF that hides that API from the sheet. The RTD server I created can be enabled and disabled through a button in a custom Ribbon component. The behavior I want to achieve is as follows: If the server is disabled and a reference to my function is entered in a cell, I want the cell to display Disabled If the server is disabled, but the function had been entered in a cell when it was enabled (and the cell thus displays a value), I want the cell to keep displaying that value If the server is enabled, I want the cell to display Loading Sounds easy enough. Here is an example of the - non functional - code: Public Function RetrieveData(id as Long) Dim result as String // This returns either 'Disabled' or 'Loading' result = Application.Worksheet.Function.RTD("SERVERNAME", "", id) RetrieveData = result If(result = "Disabled") Then // Obviously, this recurses (and fails), so that's not an option If(Not IsEmpty(Application.Caller.Value2)) Then // So does this RetrieveData = Application.Caller.Value2 End If End If End Function The function will be called in thousands of cells, so storing the 'original' values in another data structure would be a major overhead and I would like to avoid it. Also, the RTD server does not know the values, since it also does not keep a history of it, more or less for the same reason. I was thinking that there might be some way to exit the function which would force it to not change the displayed value, but so far I have been unable to find anything like that. Any ideas on how to solve this are greatly appreciated! Thanks, Che EDIT: By popular demand, some additional info on why I want to do all this: As I said, the function will be called in thousands of cells and the RTD server needs to retrieve quite a bit of information. This can be quite hard on both network and CPU. To allow the user to decide for himself whether he wants this load on his machine, he or she can disable the updates from the server. In that case, he or she should still be able to calculate the sheets with the values currently in the fields, yet no updates are pushed into them. Once new data is required, the server can be enabled and the fields will be updated. Again, since we are talking about quite a bit of data here, I would rather not store it somewhere in the sheet. Plus, the data should be usable even if the workbook is closed and loaded again.

Search Results

Search found 40791 results on 1632 pages for 'call display'.

Page 683/1632 | < Previous Page | 679 680 681 682 683 684 685 686 687 688 689 690 | Next Page >

- by Tim

- by LeChe

- by Claes Gustavsson

- by Omu

- by Chris Jacob

- by Aaron

- by Faruz

- by Simon

- by Moak

- by David

- by Pinu

- by Nilbert

- by Vinoj Nambiar

- by Faisal khan

- by nukefusion

- by user210504

- by Feryt

- by czerasz

- by miplz

- by Buffernet

- by sanjeev40084

- by oddvark

- by Ansari

- by Hun1Ahpu

- by Zoja

< Previous Page | 679 680 681 682 683 684 685 686 687 688 689 690 | Next Page >