All about Plan/IT 4.0 new macros![112; 67;111;117;114;105;101;114; 8"f [116;111;112; 97;122; 9"f As always, as we finished the features for a new release we found that it would be nice if these features had some macro support. In Plan/IT 3.0 the new macros fall into three categories: ARexx support, DataView(tm) and Outline mode. ARexx support ============= Macro: STRING.VALUE Usage: This macro is ONLY valid when it comes in from the ARexx port. It returns the "string" value of the currently selected cell. This means that it returns the string for label cells, the formatted string (including currency symbols, commas, percent symbols, etc.) for value cells and the actual Formula as a text string for cells containing formulas. Note: You can retrieve the value (as a string) for formula cells by using the CONTENTS macro. Using the STRING.VALUE macro you can extract the entire contents of a worksheet as strings. You could then use this information to analyze the worksheet or convert it for input to a foreign system (such as a SYLK file). DataView(tm) Support ==================== You can record a DataView(tm) session and all your actions will be saved using the macros shown below. This, of course, means that you can create macro programs that work when DataView is active. This is particularly important since we enhanced the functionality of DataView by allowing you to write macros that are called when you press the F-keys. Normally, in DataView mode the function keys are ignored. However, each time you press a function key, Plan/IT searches for a macro (on the current macro sheet) named DATAVIEW.Fxx (where xx is the number of the F-key, examples: DATAVIEW.F1, DATAVIEW.F12, etc.) The normal F-keys are F1 through F10 and if you hold down the SHIFT key when you press an F-key it is numbered F11 through F20. In addition, (as noted in the More.DataView file), if the upper left cell in the data range (the first category (field) name cell) contains a cell note then the first line of this cell note is shown at the bottom of the DataView window. This is the place to put the meaning of your function keys! Also, don't forget the MESSAGE macro which can be used to give help. DATAVIEW macros are described on the next page! - - - - - - END OF FIRST PAGE - - - - - - DATAVIEW macros: ================ Macro: ENTER.DATAVIEW Usage: Puts Plan/IT into DataView mode. You should select a database before using this macro. If you do not have a database selected the name selector will prompt the user for a database selection. Macro: EXIT.DATAVIEW Usage: Puts Plan/IT back in to Norm view. Macro: DATAVIEW.FIRST Usage: Moves to first record in the data range. Macro: DATAVIEW.NEXT Usage: Moves to the next record in the data range. Macro: DATAVIEW.PREV Usage: Moves to the previous record in the range. Macro: DATAVIEW.LAST Usage: Moves to the last record in the data range. Macro: ADD.RECORD Usage: Adds new record on the of data range. Positions current record at new area. See next page for Outline macros OUTLINE mode macros: ==================== Macro: OUTLINE.LEVEL(n) Usage: Sets the outline level of the currently selected range to 'n'. Macro: OUTLINE.DISPLAY(n) Usage: Sets the outline display level to 'n'. Redraws screen. This macro is most useful when creating a variety of reports at different outline display levels. - - - - E N D O F D O C U M E N T - - - -