Índice del Foro Modelizacion Commit Soft Modelizacion Commit Soft
Podra Buscar casos tipicos de errores y soluciones
 
 F.A.Q.F.A.Q.   BuscarBuscar   Lista de MiembrosLista de Miembros   Grupos de UsuariosGrupos de Usuarios   RegístreseRegístrese 
 PerfilPerfil   Conéctese para revisar sus mensajesConéctese para revisar sus mensajes   ConectarseConectarse 

action de Grillas

 
Publicar Nuevo Tema   Responder al Tema    Índice del Foro Modelizacion Commit Soft -> Vb Script
Ver tema anterior :: Ver siguiente tema  
Autor Mensaje
Typhon Software
Site Admin


Registrado: 24 Jul 2006
Mensajes: 248
Ubicación: Bs As Argentina

MensajePublicado: Vie Feb 09, 2007 11:13 am    Título del mensaje: action de Grillas Responder citando

he following settings are available:

Setting Constant
Description
0 - Activate Cell SS_ACTION_ACTIVE_CELL
Sets the active cell
(Use the Col and Row properties to specify the active cell.)


1 - Go To SS_ACTION_GOTO_CELL
Goes to the specified cell without changing the active cell
(Use the Col, Row, and Position properties with this setting.)


2 - Select Block SS_ACTION_SELECT_BLOCK
Selects a block of cells
(Use the Col, Row, Col2, and Row2 properties with this setting.)


3 - Clear SS_ACTION_CLEAR
Clears a cell, a block of cells, a column, a row, or the entire spreadsheet
(Use the Col, Row, Col2, and Row2 properties with this setting.)



4 - Delete Col SS_ACTION_DELETE_COL
Deletes a column
(Use the Col property to specify the column to delete.)Note Deleting columns does not decrease the number of columns set by the MaxCols property. When you use the Action property to delete a column, a blank column is automatically added at the end of the spreadsheet.



5 - Delete Row SS_ACTION_DELETE_ROW
Deletes a row
(Use the Row property to specify the row to delete.)Note Deleting rows does not decrease the number of rows set by the MaxRows property. When you use the Action property to delete a row, a blank row is automatically added at the end of the spreadsheet.



6 - Insert Col SS_ACTION_INSERT_COL
Inserts a column before the specified column
(Use the Col property to specify where to insert the new column.)Caution Inserting columns does not increase the number of columns set by the MaxCols property. To avoid losing data, increase the value of the MaxCols property before inserting columns.



7 - Insert Row SS_ACTION_INSERT_ROW
Inserts a row before the specified row
(Use the Row property to specify where to insert the new row.)Caution  Inserting rows does not increase the number of rows set by the MaxRows property. To avoid losing data, increase the value of the MaxRows property before inserting rows.


8 - Load SS_ACTION_LOAD_SPREAD_SHEET
Loads spreadsheet data
(Use the FileNum property to specify the file to load.)Note This setting is available for VBX controls in Visual Basic and Microsoft Visual C++ only. OCX and Borland C++ users must use the LoadFromFile or LoadTabFile method or function.



9 - Save All SS_ACTION_SAVE_ALL
Saves the current spreadsheet
(Use the FileNum property to specify the file to save.)Note This setting is available for VBX controls in Visual Basic and Microsoft Visual C++ only. OCX and Borland C++ users must use the SaveToFile method or function.


10 - Save Values SS_ACTION_SAVE_VALUES
Saves only the text of the current spreadsheet
(Use the FileNum property to specify the file to save.)Note This setting is available for VBX controls in Visual Basic and Microsoft Visual C++ only. OCX and Borland C++ users must use the SaveTabFile method or function.



11 - Recalculate SS_ACTION_RECALC
Performs manual recalculation on every formula


12 - Clear Text SS_ACTION_CLEAR_TEXT
Removes only data from a cell, a column, a row, a block of cells, or the entire spreadsheet
(Use the Col, Row, Col2, and Row2 properties with this setting.)



13 - Print SS_ACTION_PRINT
Prints the spreadsheet
(Use the associated printing properties, such as PrintBorder, to specify printing options.)


14 - Deselect Block SS_ACTION_DESELECT_BLOCK
Deselects all selected blocks when the spreadsheet is in normal operation mode



15 - Data Save SS_ACTION_DSAVE
Saves all records in a bound Spread control that have been modified
(This setting is valid only if the DAutoSave property is set to False.)


16 - Set Border SS_ACTION_SET_CELL_BORDER
Sets a border around a cell or block of cells
(Use the CellBorderColor, CellBorderStyle, and CellBorderType properties to specify border options.)



17 - Add MultiSel Blocks SS_ACTION_ADD_MULTISELBLOCK
Selects a block of cells if the spreadsheet is in normal operation mode and the AllowMultiBlocks property is set to True
(Use the Col, Row, Col2, Row2, and BlockMode properties to specify the block.)


18 - Get MultiSel Blocks SS_ACTION_GET_MULTI_SELECTION
Records the selected blocks of cells if the spreadsheet is in normal operation mode and the AllowMultiBlocks property is set to True
(Access the recorded information using the MultiSelCount and MultiSelIndex properties. The blocks are indexed from largest to smallestnot the order in which you select them.)


19 - Copy Range SS_ACTION_COPY_RANGE
Copies a block of cells to another location within the spreadsheet
(Use the Col, Row, Col2, Row2, DestCol, and DestRow properties with this setting.)


20 - Move Range SS_ACTION_MOVE_RANGE
Moves a block of cells to another location within the spreadsheet
(Use the Col, Row, Col2, Row2, DestCol, and DestRow properties with this setting.)



21 - Swap Range SS_ACTION_SWAP_RANGE
Swaps a block of cells with another block of cells within the spreadsheet
(Use the Col, Row, Col2, Row2, DestCol, and DestRow properties with this setting.)


22 - Clipboard Copy SS_ACTION_CLIPBOARD_COPY
Copies the data from the selected block of cells to the Clipboard



23 - Clipboard Cut SS_ACTION_CLIPBOARD_CUT
Cuts the data from the selected block of cells to the Clipboard


24 - Clipboard Paste SS_ACTION_CLIPBOARD_PASTE
Pastes the data from the Clipboard to the selected block of cells



25 - Sort SS_ACTION_SORT
Sorts the specified cells within the spreadsheet
(Use the Col, Row, Col2, and Row2 properties to specify the cells and the SortBy, SortKey, and SortKeyOrder properties to specify sorting options.)


26 - Combo Clear SS_ACTION_COMBO_CLEAR
Clears the contents (all items) in a combo box cell



27 - Combo Remove String SS_ACTION_COMBO_REMOVE
Removes an item specified by the TypeComboBoxIndex property from a combo box cell


28 - Reset SS_ACTION_RESET
Clears and resets all attributes of the spreadsheet back to the default settings



29 - Select Mode Clear SS_ACTION_SEL_MODE_CLEAR
Deselects all the selections of a spreadsheet in multiple-selection or extended-selection operation mode


30 - VRefresh Buffer SS_ACTION_VMODE_REFRESH
Forces the spreadsheet to discard current data and re-request the data currently in the buffer
(Use this setting with the VirtualMode property.)


32 - Smart Print SS_ACTION_SMARTPRINT
Prints the spreadsheet using Smart Printing provided by the spreadsheetThe following rules apply: If the spreadsheet is wider than a portrait page, the spreadsheet prints in landscape mode. If the information does not fit in landscape mode, but will fit in landscape mode if the spreadsheet is reduced up to 60% of its original size, the spreadsheet is scaled to fit within the page. If the information cannot be scaled to fit, the spreadsheet tries to reduce column widths to accommodate the widest string within each column. If all attempts to make the spreadsheet print within a page fail, printing resumes normally in the current printer orientation with no reductions.
_________________
http://www.typhon.com.ar - Soporte y Ayuda para la implementacion de Commit Soft ERP. info@typhon.com.ar
Volver arriba
Ver perfil del usuario Enviar mensaje privado Enviar correo Visitar sitio web del autor
Mostrar mensajes anteriores:   
Publicar Nuevo Tema   Responder al Tema    Índice del Foro Modelizacion Commit Soft -> Vb Script Todas las horas están en GMT - 3 Horas
Página 1 de 1

 
Saltar a:  
No puede crear mensajes
No puede responder temas
No puede editar sus mensajes
No puede borrar sus mensajes
No puede votar en encuestas


Powered by PhpBB © 2001, 2005 phpBB Group y Typhon © Empresa Desarrolladora de Software