As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Talk:Excel"

From sasCommunity
Jump to: navigation, search
(New page: Why DDE is a bad direction. * DDE is deprecated. :: Deprecated means that a technology is no longer considered sustainable and support for it MAY be dropped at a later point. Basically, ...)
 
m
 
(One intermediate revision by one user not shown)
Line 4: Line 4:
  
 
:: Deprecated means that a technology is no longer considered sustainable and support for it MAY be dropped at a later point. Basically, it is a warning that it may or may not work long-term. Now the good news is that Microsoft strives to maintain backwards compatibility so the chances of DDE falling off of the face of the planet are slim. Nonetheless, efforts should be made to avoid it and convert older programs.
 
:: Deprecated means that a technology is no longer considered sustainable and support for it MAY be dropped at a later point. Basically, it is a warning that it may or may not work long-term. Now the good news is that Microsoft strives to maintain backwards compatibility so the chances of DDE falling off of the face of the planet are slim. Nonetheless, efforts should be made to avoid it and convert older programs.
 
 
* DDE relies on COM under the covers
 
 
:: COM is older technology and causes loads of problems. Only 1 instance of a sheet can be used at any given time, it is very slow compared to newer technology, is difficult to work with, will not support newer features of Excel.
 
 
  
 
* DDE in SAS completely and utterly loses all metadata
 
* DDE in SAS completely and utterly loses all metadata
Line 18: Line 12:
  
 
--[[User:Savian|Savian]] 07:04, 31 May 2007 (EDT)
 
--[[User:Savian|Savian]] 07:04, 31 May 2007 (EDT)
 +
 +
== DDE requires Excel to be open ==
 +
 +
DDE requires Excel to be open when it is operating.

Latest revision as of 22:20, 13 March 2012

Why DDE is a bad direction.

  • DDE is deprecated.
Deprecated means that a technology is no longer considered sustainable and support for it MAY be dropped at a later point. Basically, it is a warning that it may or may not work long-term. Now the good news is that Microsoft strives to maintain backwards compatibility so the chances of DDE falling off of the face of the planet are slim. Nonetheless, efforts should be made to avoid it and convert older programs.
  • DDE in SAS completely and utterly loses all metadata
put "MySpreadsheet"; has essentially lost all metadata about what 'MySpreadsheet' contains. 'MySpreadsheet is now a string and has info such as the length of the string but that is about it. In newer technologies such as .NET, MySpreadsheet is an object and it contains properties, methods, etc. that describe everything in detail. For example, MySpreadsheet will have cells, colors, printing options, pivot table functionality, exporting, etc.
In modern editors, losing the context of what the spreadsheet contains relegates an end-user to a slow death. Intellisense doesn't work and there is no reflection on the object that helps someone develop applications. Now, for most SAS users, they do not know how important intellisense is for development. Intellisense is simply the editor helping the end user by popping up all of the properties of the object as someone types. How great would it be if someone typed in proc freq in a SAS editor and it popped up all of the options available for freq? Instead of always going to a book for what the syntax/options are, the editor kept all of that context?

--Savian 07:04, 31 May 2007 (EDT)

DDE requires Excel to be open

DDE requires Excel to be open when it is operating.