Fonctions Macro command
[ ] indicates optional parameters
ACTIVER([fenêtre_texte]; [no_volet])
ACTIVER.CLASSEUR(nom_de_la_feuille)
ACTIVER.OBJET([texte_identificateur_objet]; [active_valeur_logique])
ACTIVER.PREC([classeur_texte])
ACTIVER.SUIV([classeur_texte])
AFFECTER.A.OBJET([réf_macro])
AFFICHER.CELLULE.ACTIVE()
AFFICHER.CLASSEUR([texte_feuille])
AIRES(no_type; [supprimer_superposition])
AJOUTER.TEXTE(no_attacher_à; [no_série]; [no_point])
ALERTE(message_texte; [no_type]; [identificateur_aide])
ANNULER()
ARRIERE.PLAN()
AXES([x_principal]; [y_principal]; [x_secondaire]; [y_secondaire])
BARRES(no_type; [supprimer_superposition])
BIP([nombre_de_son])
CALCULER.DOCUMENT()
CALCULER.MAINTENANT()
CELLULE.ACTIVE()
CELLULE.APPELANTE()
CLASSEUR.PRECEDENT()
CLASSEUR.SUIVANT()
COLLAGE.SPECIAL([no_coller]; [opération]; [non_blanc]; [transposition])
COLLER([référence])
COMMENTAIRES([ajouter_texte]; [référence_cellule]; [caractère_début]; [no_caractères])
COMPLETER.SELECTION(formule_texte; [référence])
CONVERSION.FORMULE(formule_texte; origine_a1; [vers_a1]; [vers_abs]; [réf_rel])
COPIER([réf_origine]; [réf_destination])
COUPER([réf_origine]; [réf_destination])
COURBES(no_type; [supprimer_superposition])
CREER.OBJET(type_objet; réf1; [dist_x1]; [dist_y1]; réf2; [dist_x2]; [dist_y2]; [texte]; [plein]; [modifiable])
DEFILEMENTH(position; [col_log])
DEFILEMENTV(position; [ligne_log])
DEFINIR.NOM(nom_texte; [réfère_à]; [type_macro]; [raccourci_texte]; [masqué]; [catégorie]; [local])
DEFINIR.VALEUR.CONTROLE([valeur])
DEREF(référence)
DOCUMENTS([no_type]; [texte])
DONNEES.SERIE([lig_col]; [no_type]; [no_date]; [valeur_pas]; [valeur_arrêt]; [tendance])
DUPLIQUER()
ECHELLE([no_min]; [no_max]; [princ]; [second]; [coupe]; [logarithmique]; [inversé]; [max])
ECRAN([valeur_logique])
EDITION.SUPPRIMER([no_décaler])
EFFACER([no_type])
ENCADREMENT([contour]; [gauche]; [droit]; [haut]; [bas]; [ombré]; [couleur_contour]; [couleur_gauche]; [couleur_droite]; [couleur_haut]; [couleur_bas])
ENREGISTRER()
ENREGISTRER.DIALOGUE([nom_fichier_init]; [titre]; [texte_bouton]; [filtre_fichier]; [filtre_index])
ENREGISTRER.SOUS([document_texte]; [no_type]; [mot_de_passe_prot]; [copie]; [mot_de_passe_rés_écriture]; [lecture_seule_rec])
ENTRÉE(message_texte; [no_type]; [texte_titre]; [par_défaut]; [pos_x]; [pos_y]; [réf_aide])
ERREUR(activer_valeur_logique; [réf_macro])
ETIQUETTES.DONNEES([affichage_option]; [texte_auto]; [affichage_légende])
EVALUER(formule_texte)
F.DIMENSION(no_fichier)
F.ECRIRE(no_fichier; texte)
F.ECRIRE.LIGNE(no_fichier; texte)
F.FERMER(no_fichier)
F.LIRE(no_fichier; no_car)
F.LIRE.LIGNE(no_fichier)
F.OUVRIR(fichier_texte; [no_accès])
F.POSITION(no_fichier; [no_position])
FICHIER.FERMER([valeur_logique_enregistrer]; [valeur_logique_routage])
FICHIER.SUPPRIMER(fichier_texte)
FICHIERS([répertoire_texte])
FIGER.VOLETS([valeur_logique]; [colonne]; [ligne])
FILTRE([champ]; [critère1]; [options]; [critère2])
FILTRE.AFFICHER.TOUS()
FILTRE.ELABORE(options; réf_liste; [réf_critères]; [réf_copie]; [sans_doublon])
FORMAT.DEPLACEMENT([pos_x]; [pos_y]; [réf])
FORMAT.LEGENDE(no_position)
FORMAT.NOMBRE(format_texte)
FORMAT.TEXTE([align_x]; [align_y]; [no_orientation]; [texte_auto]; [dimension_auto]; [afficher_légende]; [afficher_valeur]; [ajouter_retrait])
FORMULE(formule_texte; [référence])
FORMULE.MATRICIELLE(formule_texte; [référence])
GRAPHIQUE.ANNEAU(no_type; [supprimer_superposition])
GRILLE()
HAUTEUR.LIGNE([hauteur]; [référence]; [standard]; [type_nom])
HISTOGRAMMES(no_type; [supprimer_superposition])
INSERER([no_décaler])
INSERER.CLASSEUR([no_type])
INSERER.TITRE([graphique]; [y_principal]; [x_principal]; [y_secondaire]; [x_secondaire])
LARGEUR.COLONNE([no_largeur]; [référence]; [standard]; [no_type]; [no_larg_standard])
LARGEUR.STANDARD([no_standard])
LEGENDE([valeur_logique])
LIGNEH([no_col])
LIGNEV([no_lignes])
LIRE.CELLULE(no_type; [référence])
LIRE.COMMENTAIRES([réf_cellule]; [car_départ]; [no_car])
LIRE.FORMULE(référence)
LIRE.NOM(nom_texte; [type_info])
LIRE.OBJET(no_type; [identificateur_objet]; [no_départ]; [nb_car]; [élément_index])
MASQUER.CLASSEUR([texte_feuille]; [très_masqué])
MASQUER.OBJET([texte_identificateur_objet]; [masque_valeur_logique])
MESSAGE(valeur_logique; [texte])
MODIFIER.COULEUR(no_couleur; [valeur_rouge]; [valeur_vert]; [valeur_bleu])
MODIFIER.SELECTION(no_direction)
MODIFIER.SERIES([no_série]; [réf_nom]; [réf_x]; [réf_y]; [réf_z]; [ordre_traçage])
MOTIFS([amotif]; [aplan]; [afond])
MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [flargeur]; [flongueur]; [ftype])
MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [arrondis]; [nouvui])
MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [inv]; [sélectionner]; [nouv_rempli])
MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [mauto]; [mstyle]; [mplan]; [mfond]; [sélectionner]; [lissage])
NOMMER.CLASSEUR(ancien_nom; nouveau_nom)
NOMS([document_texte]; [no_type]; [texte])
NOUVEAU.DOCUMENT([no_type]; [séries_xy]; [ajouter])
NUAGES.DE.POINTS(no_type; [supprimer_superposition])
OPTIONS.AFFICHAGE([formule]; [état]; [commentaires]; [affichage_info]; [no_objet]; [sauts_pages]; [formules]; [quadrillage]; [no_couleur]; [en-têtes]; [plan]; [zéros]; [défil_horiz]; [défil_vert]; [onglets_feuilles])
OUVRIR(fichier_texte; [mise_à_jour]; [lecture_seule]; [format]; [mot_passe_prot]; [mot_passe_rés_écriture]; [ignore_lecture_seule_rec]; [fichier_origine]; [séparateur_personnalisé]; [ajouter]; [modifiable]; [accès_fichier]; [notification]; [convertisseur])
OUVRIR.DIALOGUE([filtre_fichier]; [texte_bouton]; [titre]; [filtre_index])
PAGEH([no_fenêtres])
PAGEV([no_fenêtres])
PALETTE.COULEURS(fichier_texte)
POSITION([position_horizontale]; [renvoi_ligne]; [position_verticale]; [orientation]; [ajouter_retrait])
PREMIER.PLAN()
PROPRIETES.BARRE.DEFILEMENT([valeur]; [min]; [max]; [inc]; [page]; [liaison]; [ombrage_3D])
PROPRIETES.CASE.A.COCHER([valeur]; [liaison]; [texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3D])
PROPRIETES.ETIQUETTE([texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3d])
PROPRIETES.OBJET([type_déplacement]; [imprimer_objet])
PROPRIETES.POLICE([police]; [style_police]; [taille]; [barré]; [exposant]; [indice]; [relief]; [ombrage]; [souligné]; [couleur]; [normal]; [fond]; [car_début]; [nb_car])
PROPRIETES.ZONE.LISTE([plage]; [liaison]; [taille_déroul]; [sélection_multiple]; [ombrage_3d])
PROTECTION.CELLULE([verrouillage]; [masquage])
PROTEGER.DOCUMENT([contenu]; [fenêtres]; [mot_de_passe]; [objets]; [scénarios])
QUADRILLAGE([x_princ]; [x_sec]; [y_princ]; [y_sec]; [z_princ]; [z_sec]; [effet_2D])
QUITTER()
RADAR(no_type; [supprimer_superposition])
RECHERCHER.PRECEDENT.SEL()
RECHERCHER.SELECTION(texte; nb_ds; nb_à; nb_par; [nb_dir]; [maj_min])
RECHERCHER.SUIVANT.SEL()
RECOPIER.BAS()
RECOPIER.DROITE()
RECOPIER.GAUCHE()
RECOPIER.HAUT()
REFABS(réf_texte; réf)
REFREL(réf; réf_rel)
REFTEXTE(texte; [a1])
REMPLACER.CELLULE(texte_cherché; texte_remplacé; [comment]; [par]; [cellule_active]; [maj_min])
REPERTOIRE([chemin_accès])
SECTEURS(no_type; [supprimer_superposition])
SEL.DERNIERE.CELLULE()
SELECTION()
SELECTION.ATTEINDRE([référence]; [coin])
SELECTIONNER([sélection]; [cellule_active])
SELECTIONNER([identificateur_objet_texte]; [remplacer])
SELECTIONNER([élément_texte]; [point_unique])
SELON.DOUBLECLIC([feuille_texte]; [macro_texte])
SELON.ENTREE([feuille_texte]; [macro_texte])
SELON.FEUILLE([feuille_texte]; [macro_texte]; [valeur_logique_activation])
SUPPRIMER.CLASSEUR([texte_feuille])
SUPPRIMER.FORMAT(format_texte)
SUPPRIMER.NOM(nom_texte)
TEXTEREF(référence; [a1])
TOUCHE.ARRET(activer_valeur_logique; [réf_macro])
TRIER([orientation]; [clé_1]; [ordre_1]; [clé_2]; [ordre_2]; [clé_3]; [ordre_3]; [en_tête]; [perso]; [maj_min])
VALEUR.CIBLE(cellule_cible; valeur_cible; cellule_variable)
ZONE.TEXTE(ajouter_texte; [identificateur_objet_texte]; [no_départ]; [no_car])
ZOOM([facteur_zoom])
Fonctions Macro command
ACTIVER([fenêtre_texte]; [no_volet])
Specifies the workbook, sheet and/or pane that is to be active.
fenêtre_texte | The workbook and/or sheet name. If this parameter is omitted then the active window is not changed. |
no_volet | For a split window, specifies which pane is to be active. The possible values are: |
|
1 | Upper or upper left. |
2 | Upper right. |
3 | Lower or lower left. |
4 | Lower right. |
|
| If this parameter is omitted it then the active pane is not changed. |
ACTIVER.CLASSEUR(nom_de_la_feuille)
Specifies the sheet that is to be the active worksheet.
nom_de_la_feuille | The sheet that is to be the active worksheet. |
ACTIVER.OBJET([texte_identificateur_objet]; [active_valeur_logique])
Specifies whether an object should respond to mouse clicks.
texte_identificateur_objet | The object to be enabled or disabled. If this parameter is omitted the currently selected object is used. |
active_valeur_logique | Whether the object is enabled. The possible values are: |
|
VRAI | The object is enabled. |
FAUX | The object is disabled. |
|
| If this parameter is omitted the setting is not changed. |
ACTIVER.PREC([classeur_texte])
Simulates the Ctrl+Page Up or Ctrl+Shift+Tab key combination.
classeur_texte | The workbook for which the previous sheet is to be selected. If this parameter is omitted then the previous workbook is selected. |
ACTIVER.SUIV([classeur_texte])
Simulates the Ctrl+Page Down or Ctrl+Tab key combination.
classeur_texte | The workbook for which the next sheet is to be selected. If this parameter is omitted then the next workbook is selected. |
AFFECTER.A.OBJET([réf_macro])
Assigns a macro to an object.
réf_macro | The reference of the macro to be assigned. If this parameter is omitted then any existing macro is removed. |
AFFICHER.CELLULE.ACTIVE()
Scrolls the active cell into view.
AFFICHER.CLASSEUR([texte_feuille])
Simulates the Format Feuille Afficher menu option.
texte_feuille | The name of the sheet to unhide. If this parameter is omitted it defaults to the first hidden sheet. |
AIRES(no_type; [supprimer_superposition])
Changes the active chart to an area chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, no drop lines |
2 | no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, no drop lines (not currently implemented) |
3 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, drop lines (not currently implemented) |
4 | horizontal gridlines, vertical gridlines, linear y axis, no data labels, no drop lines |
5 | no horizontal gridlines, no vertical gridlines, linear y axis, data labels, no drop lines |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
AJOUTER.TEXTE(no_attacher_à; [no_série]; [no_point])
Attaches default text to the active chart. The SELECTIONNER and FORMULE functions can be used to change the text.
no_attacher_à | The item where the default text is to be attached. The possible values are: |
|
1 | Chart title |
2 | Primary y-axis title |
3 | Primary x-axis title |
4 | Data label (not currently implemented) |
5 | Secondary y-axis title (not currently implemented) |
6 | Secondary x-axis title (not currently implemented) |
|
no_série | The series number of the data label (not currently implemented) |
no_point | The point number of the data label (not currently implemented) |
ALERTE(message_texte; [no_type]; [identificateur_aide])
Displays a message box containing the specified text. It returns VRAI if the OK button is pressed, otherwise FAUX.
message_texte | The text to be displayed in the message box. |
no_type | The type of message box to be displayed. The possible values are: |
|
1 | A box containing a question mark icon and OK and Annuler buttons. |
2 | A box containing an information icon and an OK button. |
3 | A box containing an exclamation icon and an OK button. |
|
| If this parameter is omitted it defaults to 2. |
identificateur_aide | A reference to a Help topic (not currently implemented). |
ANNULER()
Simulates the Modifier Annuler menu option.
ARRIERE.PLAN()
Changes the order of the objects on the active worksheet by moving the currently selected object to the back.
AXES([x_principal]; [y_principal]; [x_secondaire]; [y_secondaire])
Changes the active chart axes.
x_principal | Whether to draw the X-axis. The possible values are: |
|
FAUX | Do not draw the X-axis. |
VRAI | Do draw the X-axis. |
|
| If this parameter is omitted the setting is not changed. |
y_principal | Whether to draw the Y-axis. The possible values are: |
|
FAUX | Do not draw the Y-axis. |
VRAI | Do draw the Y-axis. |
|
| If this parameter is omitted the setting is not changed. |
x_secondaire | Whether to draw the secondary X-axis (not currently implemented). |
y_secondaire | Whether to draw the secondary Y-axis (not currently implemented). |
BARRES(no_type; [supprimer_superposition])
Changes the active chart to a bar chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines |
2 | no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines |
3 | no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, stacked, no series lines (not currently implemented) |
4 | no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines |
5 | no horizontal gridlines, no vertical gridlines, 100% x axis, no data labels, stacked, no series lines (not currently implemented) |
6 | no horizontal gridlines, vertical gridlines, linear x axis, no data labels, not stacked, no series lines |
7 | no horizontal gridlines, no vertical gridlines, linear x axis, data values, not stacked, no series lines |
8 | no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines |
9 | no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, stacked, series lines (not currently implemented) |
10 | no horizontal gridlines, no vertical gridlines, 100% x axis, no data labels, stacked, series lines (not currently implemented) |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
BIP([nombre_de_son])
Causes the computer to beep.
nombre_de_son | A number from 1 to 4 indicating which type of beep is to be produced (not currently implemented - all values will produce the same tone). If this parameter is omitted it defaults to 1. |
CALCULER.DOCUMENT()
Causes the current worksheet to be recalculated.
CALCULER.MAINTENANT()
Causes all worksheets to be recalculated.
CELLULE.ACTIVE()
Returns a reference which represents the current position of the cursor on the active worksheet.
CELLULE.APPELANTE()
Returns information about the caller of the macro.
Macro called from: | Function returns: |
User-defined function | reference of cell containing function call |
User-defined function in array formula | reference of array formula range |
Attached to control or drawing object | object identifier |
Auto_Open macro | file name |
Manually (control key combination) | error value #REF! |
SELON.DOUBLECLIC macro | reference of cell that was double-clicked |
SELON.ENTREE macro | reference of cell where data was entered |
SELON.FEUILLE macro | error value #REF! |
CLASSEUR.PRECEDENT()
Simulates the Ctrl+Page Up key combination.
CLASSEUR.SUIVANT()
Simulates the Ctrl+Page Down key combination.
COLLAGE.SPECIAL([no_coller]; [opération]; [non_blanc]; [transposition])
Simulates the Modifier Collage spécial menu option.
no_coller | The type of information to be pasted. The possible values are: |
|
1 | Tout |
2 | Formules |
3 | Valeur |
4 | Formats |
5 | Commentaires |
6 | Tout sauf les bordures |
|
| If this parameter is omitted it defaults to 1. |
opération | The way in which the data being pasted is merged with existing data. The possible values are: |
|
1 | Aucun |
2 | Ajouter |
3 | Soustraction |
4 | Produit |
5 | Division |
|
| If this parameter is omitted it defaults to 1. |
non_blanc | Whether to ignore blank cells in the data being pasted. The possible values are: |
|
FAUX | Blank cells are included. |
VRAI | Blank cells are skipped. |
|
| If this parameter is omitted it defaults to FAUX. |
transposition | Whether to transpose the data being pasted. The possible values are: |
|
FAUX | Data is not transposed. |
VRAI | Data is transposed. (Not currently implemented) |
|
| If this parameter is omitted it defaults to FAUX. |
COLLER([référence])
Simulates the Modifier Coller menu option.
référence | The cells where the copied information is to be pasted. If this parameter is omitted it defaults to the current selection on the active worksheet. |
COMMENTAIRES([ajouter_texte]; [référence_cellule]; [caractère_début]; [no_caractères])
Simulates the Insérer Commentaire menu option.
ajouter_texte | The text that is to be added. If this parameter is omitted it defaults to an empty string. |
référence_cellule | The cell where the comment is to be inserted. If this parameter is omitted it defaults to the active cell. |
caractère_début | The start position in an existing comment where the new text is to be inserted. If this parameter is omitted it defaults to 1. |
no_caractères | The length of text in an existing comment that is to be replaced. If this parameter is omitted it defaults to the length of the existing text. |
COMPLETER.SELECTION(formule_texte; [référence])
Enters the specified formula in the specified range. Any references in the formula must be in R1C1 format. The CONVERSION.FORMULE function can be used to convert references.
formule_texte | The formula to be inserted. |
référence | The reference where formula to be inserted. If this parameter is omitted it defaults to the current selection on the active worksheet. |
CONVERSION.FORMULE(formule_texte; origine_a1; [vers_a1]; [vers_abs]; [réf_rel])
Converts the references in the specified formula from one type to another.
formule_texte | The formula to be converted. |
origine_a1 | Whether references in the formula are in A1 or R1C1 format. The possible values are: |
|
FAUX | The references are in R1C1 format |
VRAI | The references are in A1 format |
|
vers_a1 | Whether references in the formula are converted to A1 or R1C1 format. The possible values are: |
|
FAUX | The references are converted to R1C1 format |
VRAI | The references are converted to A1 format |
|
| If this parameter is omitted the format is not changed. |
vers_abs | Whether references in the formula are converted to use absolute or relative reference type. The possible values are: |
|
1 | Absolute row, absolute column |
2 | Absolute row, relative column |
3 | Relative row, absolute column |
4 | Relative row, relative column |
|
| If this parameter is omitted the reference type is not changed. |
réf_rel | The cell that R1C1 references are relative to. If this parameter is omitted it defaults to the cell containing this function. |
COPIER([réf_origine]; [réf_destination])
Simulates the Modifier Copier menu option.
réf_origine | The cells that are to be copied to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet. |
réf_destination | The cells where the copied information is to be pasted. If this parameter is omitted then the cells are not pasted. |
COUPER([réf_origine]; [réf_destination])
Simulates the Modifier Couper menu option.
réf_origine | The cells that are to be cut to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet. |
réf_destination | The cells where the cut information is to be pasted. If this parameter is omitted then the cells are not pasted. |
COURBES(no_type; [supprimer_superposition])
Changes the active chart to a line chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines |
2 | no markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines |
3 | markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines |
4 | markers, straight lines, horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines |
5 | markers, straight lines, horizontal gridlines, vertical gridlines, linear y axis, no hi-lo lines |
6 | markers, straight lines, horizontal gridlines, no vertical gridlines, logarithmic y axis, no hi-lo lines |
7 | markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, hi-lo lines (not currently implemented) |
8 | high-low-close stock chart (not currently implemented) |
9 | open-high-low-close stock chart (not currently implemented) |
10 | no markers, curved lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines (not currently implemented) |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
CREER.OBJET(type_objet; réf1; [dist_x1]; [dist_y1]; réf2; [dist_x2]; [dist_y2]; [texte]; [plein]; [modifiable])
Simulates the Insérer Object dessin and Insérer Contrôle menu options.
type_objet | The type of object to be created. The possible values are: |
|
1 | Ligne |
2 | Rectangle |
3 | Ellipse |
6 | Zone de texte |
7 | Bouton de commande |
11 | Case à cocher |
12 | Bouton d'option |
14 | Étiquette |
16 | Toupie |
17 | Barre de défilement |
18 | Zone de liste |
19 | Zone de groupe |
20 | Zone de liste modifiable |
|
réf1 | The cell containing the top-left corner of the object. |
dist_x1 | The offset in points of the top-left corner of the object from the left edge of the cell. If this parameter is omitted it defaults to 0. |
dist_y1 | The offset in points of the top-left corner of the object from the top edge of the cell. If this parameter is omitted it defaults to 0. |
réf2 | The cell containing the bottom-right corner of the object. |
dist_x2 | The offset in points of the bottom-right corner of the object from the left edge of the cell. If this parameter is omitted it defaults to 0. |
dist_y2 | The offset in points of the bottom-right corner of the object from the top edge of the cell. If this parameter is omitted it defaults to 0. |
texte | The text to be assigned to the object. If this parameter is omitted then no text is assigned. |
plein | Specifies whether the object is filled or transparent (not currently implemented). |
modifiable | Specifies whether a combo box is editable (not currently implemented). |
DEFILEMENTH(position; [col_log])
Scrolls the worksheet horizontally to the specified position.
position | The proportional or absolute position to scroll to. |
col_log | Whether the position parameter represents a proportional or absolute column number. The possible values are: |
|
FAUX | The position parameter is a number between 0 and 1 that represents how far across the worksheet to scroll to. |
VRAI | The position parameter is a number between 1 and 256 that represents the column number to scroll to. |
|
| If this parameter is omitted it defaults to FAUX. |
DEFILEMENTV(position; [ligne_log])
Scrolls the worksheet vertically to the specified position.
position | The proportional or absolute position to scroll to. |
ligne_log | Whether the position parameter represents a proportional or absolute row number. The possible values are: |
|
FAUX | The position parameter is a number between 0 and 1 that represents how far down the worksheet to scroll to. |
VRAI | The position parameter is a number between 1 and 65536 that represents the row number to scroll to. |
|
| If this parameter is omitted it defaults to FAUX. |
DEFINIR.NOM(nom_texte; [réfère_à]; [type_macro]; [raccourci_texte]; [masqué]; [catégorie]; [local])
Simulates the Insérer Nom Definir Ajouter menu option.
nom_texte | A string containing the name to be defined. |
réfère_à | The value that is to be assigned to the name. If this parameter is omitted it defaults to a reference to the current selection on the active sheet. |
type_macro | The type of macro that this name refers to (not currently implemented). |
raccourci_texte | The shortcut key used to activate a command macro. If this parameter is omitted no shortcut key is assigned. |
masqué | Whether the name is to be hidden in the name definition list. The possible values are: |
|
FAUX | Show the name in the list. |
VRAI | Do not show the name in the list. |
|
| If this parameter is omitted it defaults to FAUX. |
catégorie | Identifies the category of a custom function (not currently implemented). |
local | Whether the name is to local to the active sheet. The possible values are: |
|
FAUX | The name is defined as global. |
VRAI | The name is defined as local. |
|
| If this parameter is omitted it defaults to FAUX. |
DEFINIR.VALEUR.CONTROLE([valeur])
Changes the current value of a control.
valeur | The new value for the control. The possible values are: |
|
Case à cocher | 0 | Non activée |
| 1 | Activée |
| 2 | Grisée |
Bouton d'option | 0 | Non activée |
| 1 | Activée |
Toupie | The new value of the spin control |
Barre de défilement | The new scroll position |
Zone de liste | The selected item (0 = no selection) |
Zone de liste modifiable | The selected item (0 = no selection) |
|
| If this parameter is omitted the setting is not changed. |
DEREF(référence)
Returns the values of cells in a reference. You should not need to use this function, as references are automatically converted to values where necessary when they are used in formulas.
référence | The reference to the cells whose values you want. |
DOCUMENTS([no_type]; [texte])
Returns a horizontal array containing the names of the open files.
no_type | Specifies whether to include add-in workbooks in the list. The possible values are: |
|
1 | List only open files that are not add-in workbooks. |
2 | List only open files that are add-in workbooks. |
3 | List all open files. |
|
| If this parameter is omitted it defaults to 1. |
texte | A template name that may contain wildcard characters. If this parameter is omitted then all workbook names will be included. |
DONNEES.SERIE([lig_col]; [no_type]; [no_date]; [valeur_pas]; [valeur_arrêt]; [tendance])
Simulates the Modifier Recopier Série menu option.
lig_col | Indicates whether the series is in rows or columns. The possible values are: |
| |
| If this parameter is omitted it defaults depending on the shape of the current selection. |
no_type | The way in which the series values change. The possible values are: |
|
1 | Linéaire |
2 | Géométrique |
3 | Date |
4 | Auto (not currently implemented) |
|
| If this parameter is omitted it defaults to 1. |
no_date | The way in which the date values change. The possible values are: |
|
1 | Jour |
2 | Jour ouvré |
3 | Mois |
4 | Année |
|
| If this parameter is omitted it defaults to 1. |
valeur_pas | The number used to add to or multiply by the series value. If this parameter is omitted it defaults to 1. |
valeur_arrêt | The value at which to stop filling the series. If this parameter is omitted then the entire selection is filled. |
tendance | Indicates whether to fill the series using trend values calculated from existing data. The possible values are: |
|
FAUX | Don't use trend values. |
VRAI | Use trend values (not currently implemented). |
|
| If this parameter is omitted it defaults to FAUX. |
DUPLIQUER()
Duplicates the currently selected object.
ECHELLE([no_min]; [no_max]; [princ]; [second]; [coupe]; [logarithmique]; [inversé]; [max])
Changes the attributes of the selected chart value axis scale.
no_min | The minimum value. If this parameter is omitted the setting is not changed. |
no_max | The maximum value. If this parameter is omitted the setting is not changed. |
princ | The major step value. If this parameter is omitted the setting is not changed. |
second | The minor step value (not currently implemented). |
coupe | The value at which the opposite axis crosses this axis (not currently implemented). |
logarithmique | Whether this scale is linear or logarithmic. The possible values are: |
|
FAUX | The scale is linear. |
VRAI | The scale is logarithmic. |
|
| If this parameter is omitted the setting is not changed. |
inversé | Whether the scale values are show in reverse order (not currently implemented). |
max | Whether the opposite axis crosses this axis at the maximum value (not currently implemented). |
ECRAN([valeur_logique])
Controls screen updating while a macro is running.
valeur_logique | Whether to update the screen while the macro is running. The possible values are: |
|
FAUX | Do not update the screen |
VRAI | Do update the screen |
|
| If this parameter is omitted the setting is toggled. |
EDITION.SUPPRIMER([no_décaler])
Simulates the Modifier Supprimer menu option.
no_décaler | The way in which the cell deletion is to be processed. The possible values are: |
|
1 | Décaler les cellules vers la gauche |
2 | Décaler les cellules vers le haut |
3 | Ligne entière |
4 | Colonne entière |
|
| If this parameter is omitted it defaults to 2. |
EFFACER([no_type])
Simulates the Modifier Effacer menu option.
no_type | The type of information to clear from the current selection on the active worksheet. The possible values are: |
|
1 | Effacer tout |
2 | Effacer les formats |
3 | Effacer le contenu |
4 | Effacer les commentaires |
|
| If this parameter is omitted it defaults to 3. |
ENCADREMENT([contour]; [gauche]; [droit]; [haut]; [bas]; [ombré]; [couleur_contour]; [couleur_gauche]; [couleur_droite]; [couleur_haut]; [couleur_bas])
Simulates the Format Cellules dialog Encadrement page.
contour | The border type to be applied to the outline of the selected cells. The possible values are: |
|
0 | No border |
1 | Thin |
2 | Medium |
3 | Dashed |
4 | Dotted |
5 | Thick |
6 | Double |
7 | Hairline |
|
| If this parameter is omitted the setting is not changed. |
gauche | The border type to be used for the left border of the selected cells. The possible values are the same as for the contour parameter. |
| If this parameter is omitted the setting is not changed. |
droit | The border type to be used for the right border of the selected cells. The possible values are the same as for the contour parameter. |
| If this parameter is omitted the setting is not changed. |
haut | The border type to be used for the top border of the selected cells. The possible values are the same as for the contour parameter. |
| If this parameter is omitted the setting is not changed. |
bas | The border type to be used for the bottom border of the selected cells. The possible values are the same as for the contour parameter. |
| If this parameter is omitted the setting is not changed. |
ombré | Not implemented. |
couleur_contour | The color to be used for the outline border. The possible values are: |
|
0 | Automatique |
1 to 56 | One of the colors displayed in the Format Cellules dialog Encadrement page |
|
| If this parameter is omitted the setting is not changed. |
couleur_gauche | The color to be used for the left border. The possible values are the same as for the couleur_contour parameter. |
| If this parameter is omitted the setting is not changed. |
couleur_droite | The color to be used for the right border. The possible values are the same as for the couleur_contour parameter. |
| If this parameter is omitted the setting is not changed. |
couleur_haut | The color to be used for the top border. The possible values are the same as for the couleur_contour parameter. |
| If this parameter is omitted the setting is not changed. |
couleur_bas | The color to be used for the bottom border. The possible values are the same as for the couleur_contour parameter. |
| If this parameter is omitted the setting is not changed. |
ENREGISTRER()
Simulates the Fichier Enregistrer menu option.
ENREGISTRER.DIALOGUE([nom_fichier_init]; [titre]; [texte_bouton]; [filtre_fichier]; [filtre_index])
Returns a file name from the Fichier Enregistrer Sous dialog box, or FAUX if Annuler is selected.
nom_fichier_init | The suggested file name. If this parameter is omitted it defaults to the name of the active file. |
titre | Replacement text for the dialog box title. If this parameter is omitted the title is not changed. |
texte_bouton | Replacement text for the Save button (not currently implemented). |
filtre_fichier | One or more file filters, separated by commas. If this parameter is omitted it defaults to "Tous les fichiers (*.*), *.*". |
filtre_index | The index of the initial file filter. If this parameter is omitted it defaults to 1. |
ENREGISTRER.SOUS([document_texte]; [no_type]; [mot_de_passe_prot]; [copie]; [mot_de_passe_rés_écriture]; [lecture_seule_rec])
Simulates the Fichier Enregistrer Sous menu option.
document_texte | The name for the saved file. If this parameter is omitted the current name will be used. |
no_type | The type of file to save. The possible values are: |
|
1 | Excel workbook (xls) |
3 | Tab-delimited text (txt) |
6 | Comma-separated values (csv) |
17 | Excel template (xlt) |
|
| If this parameter is omitted it defaults to 1. |
mot_de_passe_prot | The password required to unprotect a file (not currently implemented). |
copie | Whether to make a backup of the file (not currently implemented). |
mot_de_passe_rés_écriture | The password required to open a read-only file for writing (not currently implemented). |
lecture_seule_rec | Whether to save the file as read-only recommended (not currently implemented). |
ENTRÉE(message_texte; [no_type]; [texte_titre]; [par_défaut]; [pos_x]; [pos_y]; [réf_aide])
Displays a message in a dialog box with an area for user input and OK and Annuler buttons. If the OK button is pressed then the text entered by the user is returned. If the Annuler button is pressed then this function returns the value FAUX.
message_texte | The message that you want displayed in the dialog box. |
no_type | The acceptable data type(s) for the data that you want returned. It can be any combination of the following (to specify more than one value, add the numbers together): |
|
0 | Formule |
1 | Nombre |
2 | Texte |
4 | Logique |
8 | Référence |
16 | Erreur |
64 | Matrice |
|
| If this parameter is omitted it defaults to 2. |
texte_titre | The title to be used for the dialog box. If this parameter is omitted it defaults to "Input". |
par_défaut | The text that you want to be initially displayed in the input area of the dialog box. If this parameter is omitted the input area will be blank. |
pos_x | The initial x position on the screen where the dialog box will be displayed. If this parameter is omitted it defaults to the center of the screen. (Not currently implemented). |
pos_y | The initial y position on the screen where the dialog box will be displayed. If this parameter is omitted it defaults to the center of the screen. (Not currently implemented). |
réf_aide | The name of help topic that is to be displayed if the user presses the Help button in the dialog box. If this parameter is omitted then no Help button is displayed. (Not currently implemented). |
ERREUR(activer_valeur_logique; [réf_macro])
Specifies the action taken when an error occurs in a macro.
activer_valeur_logique | Whether to interrupt the macro. The possible values are: |
|
FAUX | The macro continues |
VRAI | The macro is interrupted |
|
réf_macro | The macro to be run when an error occurs (not currently implemented) |
ETIQUETTES.DONNEES([affichage_option]; [texte_auto]; [affichage_légende])
Changes the active chart data labels.
affichage_option | The type of label to show. The possible values are: |
|
1 | Aucun |
2 | Afficher valeur |
3 | Afficher pourcentage |
4 | Afficher étiquette |
5 | Afficher étiquette et pourcentage |
|
| If this parameter is omitted the data labels are not changed. |
texte_auto | Whether to reset the data labels (not currently implemented). |
affichage_légende | Whether to show the legend key next to the label (not currently implemented). |
EVALUER(formule_texte)
Returns the result of evaluating a formula.
formule_texte | The formula to be evaluated. |
F.DIMENSION(no_fichier)
Returns a size of a file.
no_fichier | The file number that was returned by the F.OUVRIR function. |
F.ECRIRE(no_fichier; texte)
Writes a string of characters to a file.
no_fichier | The file number that was returned by the F.OUVRIR function. |
texte | The text to be written. |
F.ECRIRE.LIGNE(no_fichier; texte)
Writes a string of characters to a file, followed by an end of line marker.
no_fichier | The file number that was returned by the F.OUVRIR function. |
texte | The text to be written. |
F.FERMER(no_fichier)
Closes a file that was previously opened by the F.OUVRIR function.
no_fichier | The file number that was returned by the F.OUVRIR function. |
F.LIRE(no_fichier; no_car)
Returns a string of characters from a file.
no_fichier | The file number that was returned by the F.OUVRIR function. |
no_car | The number of characters to read. |
F.LIRE.LIGNE(no_fichier)
Returns a string of characters from a file, up to the next end of line marker.
no_fichier | The file number that was returned by the F.OUVRIR function. |
F.OUVRIR(fichier_texte; [no_accès])
Opens a file for reading or writing. The return value is a file number that can be passed as a parameter to the F.LIRE, F.LIRE.LIGNE, F.ECRIRE, F.ECRIRE.LIGNE, F.POSITION, F.DIMENSION and F.FERMER functions.
fichier_texte | The name of the file to open. |
no_accès | The access required to the file. The possible values are: |
|
1 | Open the file for reading and writing. The file must already exist. |
2 | Open the file for reading only. The file must already exist. |
3 | Create a new file for reading and writing. The file will be cleared if it already exists. |
|
| If this parameter is omitted it defaults to 1. |
F.POSITION(no_fichier; [no_position])
Returns the current read/write position in a file, and optionally allows you to change it.
no_fichier | The file number that was returned by the F.OUVRIR function. |
no_position | The location where the next read or write will occur. |
| If this parameter is omitted the current position is not changed. |
FICHIER.FERMER([valeur_logique_enregistrer]; [valeur_logique_routage])
Simulates the Fichier Fermer menu option.
valeur_logique_enregistrer | Whether to save a changed file before closing it. The possible values are: |
|
FAUX | Do not save the file |
VRAI | Save the file |
|
| If this parameter is omitted then the prompt is displayed. |
valeur_logique_routage | Whether to route the file after closing it (not currently implemented). |
FICHIER.SUPPRIMER(fichier_texte)
Deletes a file.
fichier_texte | The name of the file to be deleted. |
FICHIERS([répertoire_texte])
Returns a horizontal array containing the names of the files in a directory.
répertoire_texte | A template name that may contain wildcard characters. If this parameter is omitted then all file names will be included. |
FIGER.VOLETS([valeur_logique]; [colonne]; [ligne])
Simulates the Format Figer menu option.
valeur_logique | Whether to freeze or unfreeze the panes. The possible values are: |
|
FAUX | Unfreeze the panes |
VRAI | Freeze the panes |
|
| If this parameter is omitted the setting is toggled. |
colonne | The number of columns to be frozen. If this parameter is omitted all columns left of the cursor cell are frozen. |
ligne | The number of rows to be frozen. If this parameter is omitted all rows above the cursor cell are frozen. |
FILTRE([champ]; [critère1]; [options]; [critère2])
Simulates the Format Données Filtre Filtre automatique menu option.
champ | The filter column number whose criteria are to be changed. The columns are number from left to right, with 1 being the first filtered column. If this parameter is omitted the filter is just turned on or off. |
critère1 | A string specifying the criteria to be used. If this parameter is omitted any filter criteria are removed from the specified column. |
options | The combination operation when multiple criteria are used. The possible values are: |
| |
| If this parameter is omitted the second criteria is not used. |
critère2 | A string specifying the criteria to be used. If this parameter is omitted the second criteria is not used. |
FILTRE.AFFICHER.TOUS()
Simulates the Format Données Filtre Afficher tout menu option.
FILTRE.ELABORE(options; réf_liste; [réf_critères]; [réf_copie]; [sans_doublon])
Simulates the Format Données Filtre Filtre élaboré menu option.
options | Whether to filter in place or copy to another location. The possible values are: |
|
1 | Filter the list in place |
2 | Copy the list to another location |
|
réf_liste | The location of the list to be filtered. |
réf_critères | The location of any filter criteria to be used. If this parameter is omitted no criteria will be applied. |
réf_copie | The destination of the copied data. This is only used when operation is 2. |
sans_doublon | Whether to select unique records only. The possible values are: |
|
FAUX | Display all records that match the criteria. |
VRAI | Display only unique records that match the criteria. |
|
| If this parameter is omitted it defaults to FAUX. |
FORMAT.DEPLACEMENT([pos_x]; [pos_y]; [réf])
Moves the currently selected object.
pos_x | The offset in points of the top-left corner of the object from the left edge of the cell. If this parameter is omitted it defaults to 0. |
pos_y | The offset in points of the top-left corner of the object from the top edge of the cell. If this parameter is omitted it defaults to 0. |
réf | The cell containing the top-left corner of the object. If this parameter is omitted it defaults to A1. |
FORMAT.LEGENDE(no_position)
Changes the active chart legend placement.
no_position | The placement of the legend. The possible values are: |
|
1 | Bas |
2 | Coin |
3 | Haut |
4 | Droite |
5 | Gauche |
|
FORMAT.NOMBRE(format_texte)
Simulates the Format Cellules dialog Nombre page.
format_texte | The number format to be used. |
FORMAT.TEXTE([align_x]; [align_y]; [no_orientation]; [texte_auto]; [dimension_auto]; [afficher_légende]; [afficher_valeur]; [ajouter_retrait])
Formats the text in a text box or command button.
align_x | The horizontal alignment. The possible values are: |
|
1 | Gauche |
2 | Centré |
3 | Droite |
4 | Justifié |
|
| If this parameter is omitted the setting is not changed. |
align_y | The vertical alignment. The possible values are: |
|
1 | Haut |
2 | Centré |
3 | Bas |
4 | Justifié |
|
| If this parameter is omitted the setting is not changed. |
no_orientation | The text orientation (not currently implemented). |
texte_auto | Resets data label text (not currently implemented). |
dimension_auto | Resets the border around the text (not currently implemented). |
afficher_légende | Shows legend key for data labels (not currently implemented). |
afficher_valeur | Shows values for data labels (not currently implemented). |
ajouter_retrait | Used for Far East versions only (not currently implemented). |
FORMULE(formule_texte; [référence])
Enters the specified formula in the specified reference. Any references in the formula must be in R1C1 format. The CONVERSION.FORMULE function can be used to convert references.
formule_texte | The formula to be inserted. |
référence | The reference where formula to be inserted. If this parameter is omitted it defaults to the cursor position on the active worksheet. |
FORMULE.MATRICIELLE(formule_texte; [référence])
Enters the specified array formula in the specified reference. Any references in the formula must be in R1C1 format. The CONVERSION.FORMULE function can be used to convert references.
formule_texte | The formula to be inserted. |
référence | The reference where formula to be inserted. If this parameter is omitted it defaults to the current selection on the active worksheet. |
GRAPHIQUE.ANNEAU(no_type; [supprimer_superposition])
Changes the active chart to a doughnut chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | no data labels, not exploded |
2 | data labels, not exploded |
3 | no data labels, first segment exploded (not currently implemented) |
4 | no data labels, all segments exploded (not currently implemented) |
5 | data labels, not exploded |
6 | data percentages, not exploded |
7 | data labels and percentages, not exploded |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
GRILLE()
Simulates the Format Données Grille menu option.
HAUTEUR.LIGNE([hauteur]; [référence]; [standard]; [type_nom])
Simulates the Format Ligne menu options.
hauteur | The new height of the rows. The height is measured in points. This parameter is ignored if standard is VRAI or type_nom is specified. If this parameter is omitted the height of the specified rows is not changed. |
référence | The rows whose height is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet. |
standard | Specifies whether the rows are to be set to the standard row height. The possible values are: |
|
VRAI | The rows are set to the standard height. |
FAUX | The rows are not set to the standard height. |
|
| If this parameter is omitted it defaults to FAUX. |
type_nom | Specifies whether the rows are to be hidden, unhidden or automatically sized. This parameter is ignored if standard is VRAI. The possible values are: |
|
1 | The rows are hidden. |
2 | The rows are unhidden. |
3 | The rows are set to the height of the highest displayed value. |
|
| If this parameter is omitted the rows will not be hidden, unhidden or auto-sized. |
HISTOGRAMMES(no_type; [supprimer_superposition])
Changes the active chart to a column chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines |
2 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines |
3 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, stacked, no series lines (not currently implemented) |
4 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines |
5 | no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, stacked, no series lines (not currently implemented) |
6 | horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines |
7 | no horizontal gridlines, no vertical gridlines, linear y axis, data values, not stacked, no series lines |
8 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines |
9 | no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, stacked, series lines (not currently implemented) |
10 | no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, stacked, series lines (not currently implemented) |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
INSERER([no_décaler])
Simulates the Insérer Cellules menu option.
no_décaler | The way in which the cell insertion is to be processed. The possible values are: |
|
1 | Décaler les cellules vers la droite |
2 | Décaler les cellules vers le bas |
3 | Ligne entière |
4 | Colonne entière |
|
| If this parameter is omitted it defaults to 2. |
INSERER.CLASSEUR([no_type])
Simulates the Insérer Feuille, Graphique and Macro menu options.
no_type | The type of sheet that is to be added. The possible values are: |
|
1 | A worksheet |
2 | A chart |
3 | A macro sheet |
|
| If this parameter is omitted it defaults to the type of the currently active sheet. |
INSERER.TITRE([graphique]; [y_principal]; [x_principal]; [y_secondaire]; [x_secondaire])
Attaches default text to the active chart. The SELECTIONNER and FORMULE functions can be used to change the text.
graphique | Whether to add a default chart title. The possible values are: |
|
FAUX | Delete any existing chart title. |
VRAI | Add default chart title if one does not already exist. |
|
| If this parameter is omitted the chart title is not changed. |
y_principal | Whether to add a default primary y-axis title. The possible values are: |
|
FAUX | Delete any existing primary y-axis title. |
VRAI | Add default primary y-axis title if one does not already exist. |
|
| If this parameter is omitted the primary y-axis title is not changed. |
x_principal | Whether to add a default primary x-axis title. The possible values are: |
|
FAUX | Delete any existing primary x-axis title. |
VRAI | Add default primary x-axis title if one does not already exist. |
|
| If this parameter is omitted the primary x-axis title is not changed. |
y_secondaire | Whether to add a default secondary y-axis title (not currently implemented). |
x_secondaire | Whether to add a default secondary x-axis title (not currently implemented). |
LARGEUR.COLONNE([no_largeur]; [référence]; [standard]; [no_type]; [no_larg_standard])
Simulates the Format Colonne menu options.
no_largeur | The new width of the columns. The width is measured in characters. This parameter is ignored if standard is VRAI or type_nom is specified. If this parameter is omitted the width of the specified columns is not changed. |
référence | The columns whose width is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet. |
standard | Specifies whether the columns are to be set to the standard column width. The possible values are: |
|
VRAI | The columns are set to the standard width. |
FAUX | The columns are not set to the standard width. |
|
| If this parameter is omitted it defaults to FAUX. |
no_type | Specifies whether the columns are to be hidden, unhidden or automatically sized. This parameter is ignored if standard is VRAI. The possible values are: |
|
1 | The columns are hidden. |
2 | The columns are unhidden. |
3 | The columns are set to the width of the longest displayed value. |
|
| If this parameter is omitted the columns will not be hidden, unhidden or auto-sized. |
no_larg_standard | Specifies the value to be used for the standard width. The width is measured in characters. If this parameter is omitted the standard width is not changed. |
LARGEUR.STANDARD([no_standard])
Simulates the Format Colonne Largeur Standard menu option.
no_standard | The new standard width. If this parameter is omitted then the standard width is not changed. |
LEGENDE([valeur_logique])
Changes the active chart legend visibility.
valeur_logique | Whether to show the legend. The possible values are: |
|
FAUX | Do not show the legend |
VRAI | Do show the legend |
|
| If this parameter is omitted it defaults to VRAI. |
LIGNEH([no_col])
Scrolls the worksheet horizontally by the specified number of columns.
no_col | The number of columns to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1. |
LIGNEV([no_lignes])
Scrolls the worksheet vertically by the specified number of rows.
no_lignes | The number of rows to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1. |
LIRE.CELLULE(no_type; [référence])
Returns information about the specified cell.
no_type | The type of information to return. The possible values are: |
|
1 | Absolute reference of the upper-left cell in reference, as text |
2 | Row number of the top cell in reference |
3 | Column number of the leftmost cell in reference |
4 | Same as TYPE(référence) |
5 | Contents of reference |
6 | Formula in reference, as text |
7 | Number format of the cell, as text |
8 | Number indicating the cell's horizontal alignment |
9 | Number indicating the left-border style assigned to the cell |
10 | Number indicating the right-border style assigned to the cell |
11 | Number indicating the top-border style assigned to the cell |
12 | Number indicating the bottom-border style assigned to the cell |
13 | Number from 0 to 18, indicating the pattern of the selected cell |
14 | If the cell is locked, returns VRAI; otherwise, returns FAUX |
15 | If the cell's formula is hidden, returns VRAI; otherwise, returns FAUX |
16 | A two-item horizontal array containing the width of the active cell and a logical value indicating whether the cell's width is set to change as the standard width changes (VRAI) or is a custom width (FAUX) |
17 | Row height of cell, in points |
18 | Name of font, as text |
19 | Size of font, in points |
20 | If the cell is bold returns VRAI; otherwise returns FAUX |
21 | If the cell is italic returns VRAI; otherwise returns FAUX |
22 | If the cell is underlined returns VRAI; otherwise returns FAUX |
23 | If the cell is struck out returns VRAI; otherwise returns FAUX |
24 | Font color of cell, as a number in the range 1 to 56. If font color is automatic, returns 0 |
25 | If the cell is outlined returns VRAI; otherwise returns FAUX |
26 | If the cell is shadowed returns VRAI; otherwise returns FAUX |
32 | Name of the workbook and sheet containing the cell |
33 | If the cell is formatted to wrap, returns VRAI; otherwise, returns FAUX |
34 | Left-border color as a number in the range 1 to 56. If color is automatic, returns 0 |
35 | Right-border color as a number in the range 1 to 56. If color is automatic, returns 0 |
36 | Top-border color as a number in the range 1 to 56. If color is automatic, returns 0 |
37 | Bottom-border color as a number in the range 1 to 56. If color is automatic, returns 0 |
38 | Shade foreground color as a number in the range 1 to 56. If color is automatic, returns 0 |
39 | Shade background color as a number in the range 1 to 56. If color is automatic, returns 0 |
42 | The horizontal distance, measured in points, from the left edge of the active window to the left edge of the cell |
43 | The vertical distance, measured in points, from the top edge of the active window to the top edge of the cell |
44 | The horizontal distance, measured in points, from the left edge of the active window to the right edge of the cell |
45 | The vertical distance, measured in points, from the top edge of the active window to the bottom edge of the cell |
46 | If the cell contains a comment, returns VRAI; otherwise, returns FAUX |
48 | If the cell contains a formula, returns VRAI; if a constant, returns FAUX |
49 | If the cell is part of an array, returns VRAI; otherwise, returns FAUX |
50 | Number indicating the cell's vertical alignment |
53 | Contents of the cell as it is currently displayed, as text |
57 | If the cell is superscript returns VRAI; otherwise returns FAUX |
58 | Returns the font style of the cell as text |
59 | Returns the number for the underline style |
60 | If the cell is subscript returns VRAI; otherwise returns FAUX |
66 | Returns the book name of the workbook containing the cell in the form BOOK1.XLS |
|
référence | The cell whose information is to be returned. If this parameter is omitted it defaults to the active cell. |
LIRE.COMMENTAIRES([réf_cellule]; [car_départ]; [no_car])
Returns the text of a comment.
réf_cellule | The reference of the cell containing the comment. If this parameter is omitted it defaults to the active cell. |
car_départ | The position of the first character to be returned. If this parameter is omitted it defaults to 1. |
no_car | The length of the text to be returned. If this parameter is omitted it defaults to the length of the comment. |
LIRE.FORMULE(référence)
Returns the contents of a cell as a string. Any references in a formula will be returned in R1C1 format.
référence | The cell whose contents are to be returned. |
LIRE.NOM(nom_texte; [type_info])
Returns information about a name.
nom_texte | A string containing the name. |
type_info | The type of information to be returned. The possible values are: |
|
1 | Return the definition. |
2 | Return VRAI if it is a local name, or FAUX if it is a global name. |
|
| If this parameter is omitted it defaults to 1. |
LIRE.OBJET(no_type; [identificateur_objet]; [no_départ]; [nb_car]; [élément_index])
Returns information about the specified object.
no_type | The type of information to return. The possible values are: |
|
1 | object type as number: |
| 1 Ligne |
| 2 Rectangle |
| 3 Ellipse |
| 6 Zone de texte |
| 7 Bouton de commande |
| 11 Case à cocher |
| 12 Bouton d'option |
| 14 Étiquette |
| 16 Toupie |
| 17 Barre de défilement |
| 18 Zone de liste |
| 19 Zone de groupe |
| 20 Zone de liste modifiable |
2 | locked |
3 | z-order |
4 | top-left cell as R1C1 reference |
5 | x-offset of top-left corner in points |
6 | y-offset of top-left corner in points |
7 | bottom-right cell as R1C1 reference |
8 | x-offset of bottom-right corner in points |
9 | y-offset of bottom-right corner in points |
10 | reference of the macro as text |
11 | object positioning as number: |
| 1 Déplacer et dimensionner avec les cellules |
| 2 Déplacer sans dimensionner avec les cellules |
| 3 Ne pas déplacer ou dimensionner avec les cellules |
12 | object text from start_num for count_num characters |
13 | font name |
14 | font size |
15 | bold |
16 | italic |
17 | underline |
18 | strikethrough |
19 | outline | |
20 | shadow | |
21 | text color | |
22 | horizontal alignment as number: | |
| 1 Gauche |
| 2 Centré |
| 3 Droite |
| 4 Justifié |
23 | vertical alignment as number: | |
| 1 Haut |
| 2 Centré |
| 3 Bas |
| 4 Justifié |
26 | visible | |
48 | linked cell reference as text | |
49 | object id number | |
56 | enabled | |
62 | current value | |
63 | minimum value | |
64 | maximum value | |
65 | increment value | |
66 | page value | |
71 | list/combo entries | |
73 | input range reference as text | |
74 | dropdown lines | |
75 | draw 3d | |
|
identificateur_objet | The object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet. |
no_départ | The text substring start position for type_num 12. If this parameter is omitted it defaults to 1. |
nb_car | The text substring length for type_num 12. If this parameter is omitted it defaults to 255. |
élément_index | This parameter is not currently used. |
MASQUER.CLASSEUR([texte_feuille]; [très_masqué])
Simulates the Format Feuille Masquer menu option.
texte_feuille | The name of the sheet to hide. If this parameter is omitted it defaults to the currently active sheet. |
très_masqué | Whether to show the name of the hidden sheet in the Unhide dialog box. The possible values are: |
|
VRAI | Do not show the sheet name |
FAUX | Show the sheet name |
|
| If this parameter is omitted it defaults to FAUX. |
MASQUER.OBJET([texte_identificateur_objet]; [masque_valeur_logique])
Hides or shows an object.
texte_identificateur_objet | The object to be hidden or shown. If this parameter is omitted the currently selected object is used. |
masque_valeur_logique | Whether the object is hidden. The possible values are: |
|
FAUX | The object is shown |
VRAI | The object is hidden |
|
| If this parameter is omitted it defaults to VRAI. |
MESSAGE(valeur_logique; [texte])
Displays a message on the status bar.
valeur_logique | Whether to display or hide messages. The possible values are: |
|
VRAI | Display a message on the status bar. |
FAUX | Remove any message from the status bar. |
|
texte | The message to be displayed. If this parameter is omitted it defaults to an empty string. |
MODIFIER.COULEUR(no_couleur; [valeur_rouge]; [valeur_vert]; [valeur_bleu])
Changes the color associated with a specific color number.
no_couleur | A number from 1 to 56, indicating which color is to be changed. |
valeur_rouge | A number from 0 to 255, specifying the intensity of the red component. If this parameter is omitted the red component is not changed. |
valeur_vert | A number from 0 to 255, specifying the intensity of the green component. If this parameter is omitted the green component is not changed. |
valeur_bleu | A number from 0 to 255, specifying the intensity of the blue component. If this parameter is omitted the blue component is not changed. |
MODIFIER.SELECTION(no_direction)
Simulates the Ctrl+arrow key combination.
no_direction | The direction in which to move the cursor. The possible values are: |
|
1 | Gauche |
2 | Droite |
3 | Haut |
4 | Bas |
|
MODIFIER.SERIES([no_série]; [réf_nom]; [réf_x]; [réf_y]; [réf_z]; [ordre_traçage])
Adds or changes a series on the active chart.
no_série | The number of the series to be changed. If this parameter is zero or omitted then a new series is added. |
réf_nom | The series name. If this parameter is omitted the name is not changed. |
réf_x | The X categories or values reference. If this parameter is omitted the reference is not changed. |
réf_y | The Y values reference. If this parameter is omitted the reference is not changed. |
réf_z | The Z values reference (not currently implemented). |
ordre_traçage | The order of this series on the chart (not currently implemented). |
MOTIFS([amotif]; [aplan]; [afond])
Simulates the Format Cellules dialog Motifs page.
amotif | The number of the pattern to be applied. The possible values are: |
|
0 | Aucun |
1 | Solide |
2 | 50% Gris |
3 | 75% Gris |
4 | 25% Gris |
5 | Horizontale Rayure |
6 | Verticale Rayure |
7 | Diagonale Inverse Rayure |
8 | Diagonale Rayure |
9 | Diagonale Hachure Croisée |
10 | Épaisse Diagonale Hachure Croisée |
11 | Fine Horizontale Rayure |
12 | Fine Verticale Rayure |
13 | Fine Diagonale Inverse Rayure |
14 | Fine Diagonale Rayure |
15 | Fine Horizontale Hachure Croisée |
16 | Fine Diagonale Hachure Croisée |
17 | 12,5% Gris |
18 | 6,25% Gris |
|
| If this parameter is omitted the setting is not changed. |
aplan | The number of the foreground color to be applied. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
afond | The number of the background color to be applied. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [flargeur]; [flongueur]; [ftype])
Changes the attributes of the selected line.
lauto | The line setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
lstyle | The line style (not currently implemented). |
lcoul | The line color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
lép | The line weight (not currently implemented). |
flargeur | The arrowhead width (not currently implemented). |
flongueur | The arrowhead length (not currently implemented). |
ftype | The arrowhead type. The possible values are: |
|
1 | Aucun |
2 | Ouvert |
3 | Fermé |
4 | Double ouvert |
5 | Double fermé |
|
| If this parameter is omitted the setting is not changed. |
MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [arrondis]; [nouvui])
Changes the attributes of the selected text box, rectangle or oval.
cauto | The border setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
cstyle | The border style (not currently implemented). |
ccoul | The border color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
cép | The border weight (not currently implemented). |
ombré | Whether to apply a shadow to the object (not currently implemented). |
aauto | The area setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
amotif | The area pattern (not currently implemented). |
aplan | The area foreground color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
afond | The area background color (not currently implemented). |
arrondis | Whether to draw the object with rounded corners (not currently implemented). |
nouvui | Whether to use the new or old user interface color scheme (not currently implemented). |
MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [inv]; [sélectionner]; [nouv_rempli])
Changes the attributes of the selected chart plot areas, bars, columns, pie slices or text labels.
cauto | The border setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
cstyle | The border style. The possible values are: |
|
1 | Solide |
2 | Discontinue |
3 | Pointillé |
4 | Tiret-point |
5 | Tiret-point-point |
6 | Foncé |
7 | Moyenne |
8 | Clair |
|
| If this parameter is omitted the setting is not changed. |
ccoul | The border color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
cép | The border weight (not currently implemented). |
ombré | Whether to apply a shadow to the object (not currently implemented). |
aauto | The area setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
amotif | The area pattern (not currently implemented). |
aplan | The area foreground color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
afond | The area background color (not currently implemented). |
inv | Whether to invert the pattern for a negative value (not currently implemented). |
sélectionner | Whether to apply changes to just this item or all similar items (not currently implemented). |
nouv_rempli | Whether to use the new or old user interface color scheme (not currently implemented). |
MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [mauto]; [mstyle]; [mplan]; [mfond]; [sélectionner]; [lissage])
Changes the attributes of the selected chart series line.
lauto | The line setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
lstyle | The line style. The possible values are: |
|
1 | Solide |
2 | Discontinue |
3 | Pointillé |
4 | Tiret-point |
5 | Tiret-point-point |
6 | Foncé |
7 | Moyenne |
8 | Clair |
|
| If this parameter is omitted the setting is not changed. |
lcoul | The line color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
lép | The line weight (not currently implemented). |
mauto | The marker setting. The possible values are: |
|
0 | Personnalisée |
1 | Automatique |
2 | Aucun |
|
| If this parameter is omitted the setting is not changed. |
mstyle | The marker style. The possible values are: |
|
1 | Carré |
2 | Carreau |
3 | Triangle |
4 | X |
5 | Étoile |
6 | Point |
7 | Tiret |
8 | Cercle |
9 | Croix |
|
| If this parameter is omitted the setting is not changed. |
mplan | The marker foreground color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
mfond | The marker background color. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Cellules dialog Motifs page |
|
| If this parameter is omitted the setting is not changed. |
sélectionner | Whether to apply changes to just this item or all similar items (not currently implemented). |
lissage | Whether to smooth picture markers (not currently implemented). |
NOMMER.CLASSEUR(ancien_nom; nouveau_nom)
Simulates the Format Feuille Renommer menu option.
ancien_nom | The sheet that is to be renamed. |
nouveau_nom | The new name for the sheet. |
NOMS([document_texte]; [no_type]; [texte])
Returns a horizontal array containing defined names.
document_texte | The name of the workbook containing the names. If this parameter is omitted it defaults to the active workbook. |
no_type | The type of name to retrieve. The possible values are: |
|
1 | Visible names |
2 | Hidden names |
3 | All names |
|
| If this parameter is omitted it defaults to 1. |
texte | A template name that may contain wildcard characters. If this parameter is omitted all names will match. |
NOUVEAU.DOCUMENT([no_type]; [séries_xy]; [ajouter])
Simulates the Fichier Nouveau menu option.
no_type | The type of workbook to create. The possible values are: |
|
omitted | New workbook with 1 worksheet of the same type as the active worksheet. |
1 | New workbook with 1 worksheet. |
2 | New workbook with 1 chart based on the current selection (not currently implemented). |
3 | New workbook with 1 macro sheet. |
4 | New workbook with 1 international macro sheet (not currently implemented). |
5 | New workbook based on Classeur.xlt or default template. |
6 | New workbook with 1 VB module (not currently implemented). |
7 | New workbook with 1 dialog sheet (not currently implemented). |
file name | New workbook based on template file. |
|
séries_xy | How to interpret selected data for a new chart (not currently implemented). |
ajouter | Whether to add the specified sheet to the current workbook (not currently implemented). |
NUAGES.DE.POINTS(no_type; [supprimer_superposition])
Changes the active chart to a scatter (XY) chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis |
2 | markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis |
3 | markers, no lines, horizontal gridlines, vertical gridlines, linear y axis, linear x axis |
4 | markers, no lines, horizontal gridlines, no vertical gridlines, logarithmic y axis, linear x axis |
5 | markers, no lines, horizontal gridlines, vertical gridlines, logarithmic y axis, logarithmic x axis |
6 | no markers, curved lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis (not currently implemented) |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
OPTIONS.AFFICHAGE([formule]; [état]; [commentaires]; [affichage_info]; [no_objet]; [sauts_pages]; [formules]; [quadrillage]; [no_couleur]; [en-têtes]; [plan]; [zéros]; [défil_horiz]; [défil_vert]; [onglets_feuilles])
Changes the program, file or sheet view options.
formule | Specifies whether the formula bar is displayed. The possible values are: |
|
FAUX | The formula bar is not displayed |
VRAI | The formula bar is displayed |
|
| If this parameter is omitted the setting is not changed. |
état | Specifies whether the status bar is displayed. The possible values are: |
|
FAUX | The status bar is not displayed |
VRAI | The status bar is displayed |
|
| If this parameter is omitted the setting is not changed. |
commentaires | Specifies whether comments and indicators are displayed (not currently implemented). |
affichage_info | Specifies whether the info window is displayed (not currently implemented). |
no_objet | Specifies how objects are displayed (not currently implemented). |
sauts_pages | Specifies whether page breaks are displayed (not currently implemented). |
formules | Specifies whether to display formulas or values in cells. The possible values are: |
|
FAUX | Values are displayed |
VRAI | Formulas are displayed |
|
| If this parameter is omitted the setting is not changed. |
quadrillage | Specifies whether gridlines are displayed. The possible values are: |
|
FAUX | Gridlines are not displayed |
VRAI | Gridlines are displayed |
|
| If this parameter is omitted the setting is not changed. |
no_couleur | Specifies the color to be used for drawing gridlines (not currently implemented). |
en-têtes | Specifies whether row and column headings are displayed. The possible values are: |
|
FAUX | Row and column headings are not displayed |
VRAI | Row and column headings are displayed |
|
| If this parameter is omitted the setting is not changed. |
plan | Specifies whether outline symbols are displayed (not currently implemented). |
zéros | Specifies whether zero values are displayed (not currently implemented). |
défil_horiz | Specifies whether the horizontal scroll bar is displayed. The possible values are: |
|
FAUX | The horizontal scroll bar is not displayed |
VRAI | The horizontal scroll bar is displayed |
|
| If this parameter is omitted the setting is not changed. |
défil_vert | Specifies whether the vertical scroll bar is displayed. The possible values are: |
|
FAUX | The vertical scroll bar is not displayed |
VRAI | The vertical scroll bar is displayed |
|
| If this parameter is omitted the setting is not changed. |
onglets_feuilles | Specifies whether the sheet tabs are displayed. The possible values are: |
|
FAUX | The sheet tabs are not displayed |
VRAI | The sheet tabs are displayed |
|
| If this parameter is omitted the setting is not changed. |
OUVRIR(fichier_texte; [mise_à_jour]; [lecture_seule]; [format]; [mot_passe_prot]; [mot_passe_rés_écriture]; [ignore_lecture_seule_rec]; [fichier_origine]; [séparateur_personnalisé]; [ajouter]; [modifiable]; [accès_fichier]; [notification]; [convertisseur])
Simulates the Fichier Ouvrir menu option.
fichier_texte | The name of the file to be opened. |
mise_à_jour | Whether to update external references. The possible values are: |
|
0 | Do not update any references |
1 | Update external references |
2 | Update remote references (not currently implemented) |
3 | Update external and remote references (not currently implemented) |
|
| If this parameter is omitted and external references exist then a prompt will be displayed. |
lecture_seule | Whether to open the file as read-only (not currently implemented). |
format | The character used as a delimiter for text files. The possible values are: |
|
1 | Tabulation |
2 | Virgule |
3 | Espace |
4 | Point-virgule |
5 | Nothing |
6 | Personnalisé (specified in the séparateur_personnalisé parameter) |
|
| If this parameter is omitted the text file delimiter will be determined from the file extension. |
mot_passe_prot | The password required to unprotect a file (not currently implemented). |
mot_passe_rés_écriture | The password required to open a read-only file for writing (not currently implemented). |
ignore_lecture_seule_rec | Whether to suppress the display of the read-only recommended message (not currently implemented). |
fichier_origine | The operating system where the file originated (not currently implemented). |
séparateur_personnalisé | The character used as a custom delimiter for text files. |
ajouter | Whether to add the specified file to the current workbook (not currently implemented). |
modifiable | Whether a template file should be opened in read-write mode (not currently implemented). |
accès_fichier | Whether to change the access of a currently open file (not currently implemented). |
notification | Whether to send a message when a shared workbook becomes available (not currently implemented). |
convertisseur | Overrides the default file type (not currently implemented). |
OUVRIR.DIALOGUE([filtre_fichier]; [texte_bouton]; [titre]; [filtre_index])
Returns a file name from the Fichier Ouvrir dialog box, or FAUX if Annuler is selected.
filtre_fichier | One or more file filters, separated by commas. If this parameter is omitted it defaults to "Tous les fichiers (*.*), *.*". |
texte_bouton | Replacement text for the Open button (not currently implemented). |
titre | Replacement text for the dialog box title. If this parameter is omitted the title is not changed. |
filtre_index | The index of the initial file filter. If this parameter is omitted it defaults to 1. |
PAGEH([no_fenêtres])
Scrolls the worksheet horizontally by the specified number of pages.
no_fenêtres | The number of pages to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1. |
PAGEV([no_fenêtres])
Scrolls the worksheet vertically by the specified number of pages.
no_fenêtres | The number of pages to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1. |
PALETTE.COULEURS(fichier_texte)
Copies the color palette from another file.
fichier_texte | The name of the file from which to copy the palette. The file must already be open. If this parameter is an empty string then the colors are reset to the default values. |
POSITION([position_horizontale]; [renvoi_ligne]; [position_verticale]; [orientation]; [ajouter_retrait])
Simulates the Format Cellules dialog Position page.
position_horizontale | The horizontal alignment to be used. The possible values are: |
|
1 | Général |
2 | Gauche |
3 | Center |
4 | Droite |
5 | Recopier |
6 | Justifier |
7 | Centrer sur sélection |
|
| If this parameter is omitted the setting is not changed. |
renvoi_ligne | Whether to wrap the text in the cells. The possible values are: |
|
FAUX | The text is not wrapped |
VRAI | The text is wrapped |
|
| If this parameter is omitted the setting is not changed. |
position_verticale | The vertical alignment to be used. The possible values are: |
|
1 | Haut |
2 | Centré |
3 | Bas |
4 | Justifier |
|
| If this parameter is omitted the setting is not changed. |
orientation | Not currently implemented. |
ajouter_retrait | Not currently implemented. |
PREMIER.PLAN()
Changes the order of the objects on the active worksheet by moving the currently selected object to the front.
PROPRIETES.BARRE.DEFILEMENT([valeur]; [min]; [max]; [inc]; [page]; [liaison]; [ombrage_3D])
Changes the properties of a scroll bar or spin control.
valeur | The current value of the control. If this parameter is omitted the value is not changed. |
min | The minimum value of the control. If this parameter is omitted the value is not changed. |
max | The maximum value of the control. If this parameter is omitted the value is not changed. |
inc | The change to the current value when the arrow button is clicked. If this parameter is omitted the value is not changed. |
page | The change to the current value when the area either side of the scroll bar thumb is clicked. If this parameter is omitted the value is not changed. |
liaison | The cell that is updated by the control. If this parameter is omitted the link is not changed. |
ombrage_3D | Whether to draw the control with 3d shading. The possible values are: |
| |
| If this parameter is omitted the setting is not changed. |
PROPRIETES.CASE.A.COCHER([valeur]; [liaison]; [texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3D])
Changes the properties of a check box or option button control.
valeur | The value of the control. The possible values are: |
|
FAUX | Non activée |
VRAI | Activée |
0 | Non activée |
1 | Activée |
2 | Grisée |
|
| If this parameter is omitted the value is not changed. |
liaison | The cell that is updated by the control. If this parameter is omitted the link is not changed. |
texte_touche_accès_rapide | The accelerator key on a dialog sheet (not currently implemented). |
texte_touche_accès_rapide2 | The second accelerator key on a dialog sheet (not currently implemented). |
ombrage_3D | Whether to draw the control with 3d shading. The possible values are: |
| |
| If this parameter is omitted the setting is not changed. |
PROPRIETES.ETIQUETTE([texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3d])
Changes the properties of a label or group box control.
texte_touche_accès_rapide | The accelerator key on a dialog sheet (not currently implemented). |
texte_touche_accès_rapide2 | The second accelerator key on a dialog sheet (not currently implemented). |
ombrage_3d | Whether to draw the control with 3d shading. The possible values are: |
| |
| If this parameter is omitted the setting is not changed. |
PROPRIETES.OBJET([type_déplacement]; [imprimer_objet])
Changes the properties of an object.
type_déplacement | How the object is attached to the cells. The possible values are: |
|
1 | Déplacer et dimensionner avec les cellules |
2 | Déplacer sans dimensionner avec les cellules |
3 | Ne pas déplacer ou dimensionner avec les cellules |
|
| If this parameter is omitted the setting is not changed. |
imprimer_objet | Whether the object can be printed. The possible values are: |
|
FAUX | The object is not printed |
VRAI | The object is printed |
|
| If this parameter is omitted the setting is not changed. |
PROPRIETES.POLICE([police]; [style_police]; [taille]; [barré]; [exposant]; [indice]; [relief]; [ombrage]; [souligné]; [couleur]; [normal]; [fond]; [car_début]; [nb_car])
Simulates the Format Cellules dialog Police page or changes the font of the selected chart text.
police | The name of the font to be used. |
style_police | The style to be used. The possible values are: |
|
"Regular" | Removes the bold and italic attributes. |
"Gras" | Sets the font to bold. |
"Italique" | Sets the font to italic. |
"Gras Italique" | Sets the font to bold and italic. |
|
| If this parameter is omitted the style is not changed. |
taille | The point size to be used. If this parameter is omitted the size is not changed. |
barré | Sets the strikethrough attribute. The possible values are: |
|
FAUX | The font does not have the strikethrough attribute |
VRAI | The font has the strikethrough attribute |
|
| If this parameter is omitted the strikethrough attribute is not changed. |
exposant | Not currently implemented. |
indice | Not currently implemented. |
relief | Not currently implemented. |
ombrage | Not currently implemented. |
souligné | The underline style to be used. The possible values are: |
|
0 | None |
1 | Single |
2 | Double (not currently implemented) |
3 | Single accounting (not currently implemented) |
4 | Double accounting (not currently implemented) |
|
| If this parameter is omitted the underline style is not changed. |
couleur | The color to be used. The possible values are: |
|
0 | Automatic |
1 to 56 | One of the colors displayed in the Format Cellules Police dialog box |
|
| If this parameter is omitted the color is not changed. |
normal | Not currently implemented. |
fond | Not currently implemented. |
car_début | Not currently implemented. |
nb_car | Not currently implemented. |
PROPRIETES.ZONE.LISTE([plage]; [liaison]; [taille_déroul]; [sélection_multiple]; [ombrage_3d])
Changes the properties of a list box or combo box control.
plage | The input range from which to fill the list. If this parameter is omitted the setting is not changed. |
liaison | The cell that is updated by the control. If this parameter is omitted the link is not changed. |
taille_déroul | The number of lines in the drop-down list of a combo box. If this parameter is omitted the setting is not changed. |
sélection_multiple | Whether to allow more than one list selection (not currently implemented). |
ombrage_3d | Whether to draw the control with 3d shading. The possible values are: |
| |
| If this parameter is omitted the setting is not changed. |
PROTECTION.CELLULE([verrouillage]; [masquage])
Simulates the Format Cellules dialog Protection page.
verrouillage | Whether the cell should be locked when the sheet is protected. The possible values are: |
|
FAUX | The cell is not locked |
VRAI | The cell is locked |
|
| If this parameter is omitted the setting is not changed. |
masquage | Whether the cell formula should be hidden when the sheet is protected. The possible values are: |
|
FAUX | The cell formula is not hidden |
VRAI | The cell formula is hidden |
|
| If this parameter is omitted the setting is not changed. |
PROTEGER.DOCUMENT([contenu]; [fenêtres]; [mot_de_passe]; [objets]; [scénarios])
Simulates the Format Feuille Protéger menu option.
contenu | Whether to protect the locked cell contents. The possible values are: |
|
VRAI | The locked cell contents are protected |
FAUX | The locked cell contents are unprotected |
|
| If this parameter is omitted it defaults to VRAI. |
fenêtres | Whether to protect windows from being moved or sized (not currently implemented). The possible values are: |
|
VRAI | The windows are protected |
FAUX | The windows are unprotected |
|
| If this parameter is omitted it defaults to FAUX. |
mot_de_passe | An optional case-sensitive password to protect or unprotect the document. |
objets | Whether to protect the locked objects (not currently implemented). The possible values are: |
|
VRAI | The locked objects are protected |
FAUX | The locked objects are unprotected |
|
| If this parameter is omitted it defaults to VRAI. |
scénarios | Whether to protect the scenarios (not currently implemented). The possible values are: |
|
VRAI | The scenarios are protected |
FAUX | The scenarios are unprotected |
|
| If this parameter is omitted it defaults to VRAI. |
QUADRILLAGE([x_princ]; [x_sec]; [y_princ]; [y_sec]; [z_princ]; [z_sec]; [effet_2D])
Changes the active chart gridlines.
x_princ | Whether to draw the X-axis major gridlines. The possible values are: |
|
FAUX | Do not draw the X-axis major gridlines. |
VRAI | Do draw the X-axis major gridlines. |
|
| If this parameter is omitted the setting is not changed. |
x_sec | Whether to draw the X-axis minor gridlines (not currently implemented). |
y_princ | Whether to draw the Y-axis major gridlines. The possible values are: |
|
FAUX | Do not draw the Y-axis major gridlines. |
VRAI | Do draw the Y-axis major gridlines. |
|
| If this parameter is omitted the setting is not changed. |
y_sec | Whether to draw the Y-axis minor gridlines (not currently implemented). |
z_princ | Whether to draw the Z-axis minor gridlines (not currently implemented). |
z_sec | Whether to draw the Z-axis minor gridlines (not currently implemented). |
effet_2D | Whether to draw 2D gridlines on 3D charts (not currently implemented). |
QUITTER()
Simulates the Fichier Quitter menu option.
RADAR(no_type; [supprimer_superposition])
Changes the active chart to a radar chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | markers, no horizontal gridlines, linear y axis, not filled |
2 | no markers, no horizontal gridlines, linear y axis, not filled |
3 | no markers, no horizontal gridlines, no y axis, not filled |
4 | no markers, horizontal gridlines, linear y axis, not filled |
5 | no markers, horizontal gridlines, logarithmic y axis, not filled |
6 | no markers, no horizontal gridlines, linear y axis, filled (not currently implemented) |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
RECHERCHER.PRECEDENT.SEL()
Finds the previous cell based on the current criteria.
RECHERCHER.SELECTION(texte; nb_ds; nb_à; nb_par; [nb_dir]; [maj_min])
Simulates the Modifier Chercher menu option.
texte | The text that you want to find. |
nb_ds | Where you want to look for the text. The possible values are: |
|
1 | Formules |
2 | Valeurs |
3 | Commentaires |
|
nb_à | Whether to match this text against all or part of a cell. The possible values are: |
|
1 | Rechercher cellules entiers seulement |
2 | Any part of the text in a cell |
|
nb_par | Whether to search by rows or by columns. The possible values are: |
| |
nb_dir | Whether to search for the next or previous match. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
maj_min | Whether the search is case-sensitive. The possible values are: |
|
VRAI | The search is case-sensitive |
FAUX | The search is not case-sensitive |
|
| If this parameter is omitted it defaults to FAUX. |
RECHERCHER.SUIVANT.SEL()
Finds the next cell based on the current criteria.
RECOPIER.BAS()
Simulates the Modifier Recopier En bas menu option.
RECOPIER.DROITE()
Simulates the Modifier Recopier À droite menu option.
RECOPIER.GAUCHE()
Simulates the Modifier Recopier À gauche menu option.
RECOPIER.HAUT()
Simulates the Modifier Recopier En haut menu option.
REFABS(réf_texte; réf)
Returns an absolute reference corresponding to an offset from another reference.
réf_texte | The offset specified in R1C1 format. |
réf | The base reference. |
REFREL(réf; réf_rel)
Returns a string containing an R1C1 reference that represents the offset of the first reference from the second.
réf | The target reference. |
réf_rel | The base reference. |
REFTEXTE(texte; [a1])
Returns a reference corresponding to the specified text.
texte | The string containing the reference. |
a1 | Specifies the style of the reference. The possible values are: |
|
FAUX | R1C1 style |
VRAI | A1 style |
|
| If this parameter is omitted it defaults to FAUX. |
REMPLACER.CELLULE(texte_cherché; texte_remplacé; [comment]; [par]; [cellule_active]; [maj_min])
Simulates the Modifier Chercher/Remplacer menu option.
texte_cherché | The text that you want to find. |
texte_remplacé | The text to replace the found text with. |
comment | Whether to match the text against all or part of a cell. The possible values are: |
|
1 | Rechercher cellules entiers seulement |
2 | Any part of the text in a cell |
|
| If this parameter is omitted it defaults to 1. |
par | Whether to search by rows or by columns. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
cellule_active | Whether to replace in just the current cell or in the whole sheet. The possible values are: |
|
VRAI | Text in the active cell is replaced |
FAUX | Text in the whole sheet is replaced |
|
| If this parameter is omitted it defaults to FAUX. |
maj_min | Whether the search is case-sensitive. The possible values are: |
|
VRAI | The search is case-sensitive |
FAUX | The search is not case-sensitive |
|
| If this parameter is omitted it defaults to the value last used. |
REPERTOIRE([chemin_accès])
Returns the path of the current directory, and optionally allows you to change it.
chemin_accès | The path to which you want to change the current directory. If this parameter is omitted the current directory is not changed. Note that in Windows CE the current directory is always the root directory and cannot be changed. |
SECTEURS(no_type; [supprimer_superposition])
Changes the active chart to a pie chart.
no_type | The format to be applied to the chart. The possible values are: |
|
1 | no data labels, not exploded |
2 | data labels, not exploded |
3 | no data labels, first segment exploded (not currently implemented) |
4 | no data labels, all segments exploded (not currently implemented) |
5 | data labels, not exploded |
6 | data percentages, not exploded |
7 | data labels and percentages, not exploded |
|
supprimer_superposition | Whether to delete any overlays (not currently implemented). |
SEL.DERNIERE.CELLULE()
Simulates the Ctrl+End key combination.
SELECTION()
Returns a reference which represents the current selection on the active worksheet.
SELECTION.ATTEINDRE([référence]; [coin])
Simulates the Modifier Atteindre menu option.
référence | The cells that are to be selected. If the sheet name is omitted then it defaults to the currently active sheet. If this parameter is omitted it defaults to the sheet and cells that were selected before the last goto command. |
coin | Specifies whether the top-left corner of the selection is to be placed in the top-left corner of the window. The possible values are: |
|
FAUX | The sheet is not scrolled to move the selection to the top-left corner of the window. |
VRAI | The sheet is scrolled to move the selection to the top-left corner of the window. |
|
| If this parameter is omitted it defaults to FAUX. |
SELECTIONNER([sélection]; [cellule_active])
Sets the selection and cursor cell on the active worksheet.
sélection | The cells that are to be the selection. If this parameter is omitted the current selection is not changed. |
cellule_active | The cell that is to be the cursor cell. If this parameter is omitted it defaults to the top left cell in the selection. |
SELECTIONNER([identificateur_objet_texte]; [remplacer])
Selects an object on the active worksheet.
identificateur_objet_texte | The object to be selected. If this parameter is omitted the current selection is not changed. |
remplacer | Whether to replace or add to the existing object selection (not currently implemented). |
SELECTIONNER([élément_texte]; [point_unique])
Selects an object on the active chart.
élément_texte | The object to be selected. The possible values are: |
|
"Chart" | Entire chart |
"Plot" | Plot area |
"Axis 1" | Primary chart value axis |
"Axis 2" | Primary chart category axis |
"Axis 3 | Secondary chart value axis or 3D chart series axis |
"Axis 4" | Secondary chart category axis |
"Title" | Chart title |
"Text Axis 1" | Primary chart value axis title |
"Text Axis 2" | Primary chart category axis title |
"Text Axis 3" | Primary chart series axis title |
"Text n" | nth floating text item |
"Arrow n" | nth arrow |
"Gridline 1" | Value axis major gridlines |
"Gridline 2" | Value axis minor gridlines |
"Gridline 3" | Category axis major gridlines |
"Gridline 4" | Category axis minor gridlines |
"Gridline 5" | Series axis major gridlines |
"Gridline 6" | Series axis minor gridlines |
"Dropline 1" | Primary chart droplines |
"Dropline 2" | Secondary chart droplines |
"Hiloline 1" | Primary chart hi-lo lines |
"Hiloline 2" | Secondary chart hi-lo lines |
"UpBar1" | Primary chart up bar |
"UpBar2" | Secondary chart up bar |
"DownBar1" | Primary chart down bar |
"DownBar2" | Secondary chart down bar |
"Seriesline1" | Primary chart series line |
"Seriesline2" | Secondary chart series line |
"Floor" | 3D chart base |
"Walls" | 3D chart back |
"Corners" | 3D chart corners |
"Sn" | Series n |
"SnPm" | Series n point m data |
"SnTm" | Series n trend line m |
"SnEm" | Series n error bars m |
"Text Sn" | Series n text |
"Text SnPm" | Series n point m text |
"Legend" | Legend |
"Legend Marker n" | Legend marker n |
"Legend Entry n" | Legend entry n |
|
| If this parameter is omitted the current selection is not changed. |
point_unique | Whether to select a single point or the entire series (not currently implemented). |
SELON.DOUBLECLIC([feuille_texte]; [macro_texte])
Specifies a macro to be run when a cell is double-clicked.
feuille_texte | The name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets. |
macro_texte | A string containing a defined name or R1C1 reference indicating the macro that is to be run. If this parameter is omitted then no macro will be run. |
SELON.ENTREE([feuille_texte]; [macro_texte])
Specifies a macro to be run when data is entered.
feuille_texte | The name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets. |
macro_texte | A string containing a defined name or R1C1 reference indicating the macro that is to be run. If this parameter is omitted then no macro will be run. |
SELON.FEUILLE([feuille_texte]; [macro_texte]; [valeur_logique_activation])
Specifies a macro to be run when a sheet is activated or deactivated.
feuille_texte | The name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets. |
macro_texte | A string containing a defined name or R1C1 reference indicating the macro that is to be run. If this parameter is omitted then no macro will be run. |
valeur_logique_activation | Specifies whether the macro is to be run when the sheet is activated or deactivated. The possible values are: |
|
VRAI | The macro will be run when the sheet is activated. |
FAUX | The macro will be run when the sheet is deactivated. |
|
| If this parameter is omitted it defaults to VRAI. |
SUPPRIMER.CLASSEUR([texte_feuille])
Simulates the Modifier Supprimer Feuille menu option.
texte_feuille | The sheet that is to be deleted. If this parameter is omitted it defaults to the currently active sheet. |
SUPPRIMER.FORMAT(format_texte)
Deletes the specified custom number format. Any cells using this format will be changed to use the Général format.
format_texte | A string containing the format to be deleted. |
SUPPRIMER.NOM(nom_texte)
Simulates the Insérer Nom Definir Supprimer menu option.
nom_texte | A string containing the name to be deleted. |
TRIER([orientation]; [clé_1]; [ordre_1]; [clé_2]; [ordre_2]; [clé_3]; [ordre_3]; [en_tête]; [perso]; [maj_min])
Simulates the Format Données Trier menu option.
orientation | Specifies whether to sort the rows or columns. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
clé_1 | Specifies a reference to the first column or row to sort on. If this parameter is omitted it defaults to the first column or row in the selection. |
ordre_1 | Specifies whether to sort the data in ascending or descending order. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
clé_2 | Specifies a reference to the second column or row to sort on. If this parameter is omitted then the second key is not used. |
ordre_2 | Specifies whether to sort the data in ascending or descending order. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
clé_3 | Specifies a reference to the third column or row to sort on. If this parameter is omitted then the third key is not used. |
ordre_3 | Specifies whether to sort the data in ascending or descending order. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
en_tête | Specifies whether the selected cells include a header row or column. The possible values are: |
|
0 | Determine the presence of a header automatically |
1 | There is a header |
2 | There is no header |
|
| If this parameter is omitted it defaults to 2. |
perso | Specifies whether to use a custom list for the first sort key. The possible values are: |
|
1 | Use normal sort sequence |
2 | Day short names |
3 | Day long names |
4 | Month short names |
5 | Month long names |
|
| If this parameter is omitted it defaults to 1. |
maj_min | Specifies whether the sort should be case-sensitive. The possible values are: |
|
VRAI | The sort is case-sensitive |
FAUX | The sort is not case-sensitive |
|
| If this parameter is omitted it defaults to FAUX. |
TEXTEREF(référence, [a1])
Returns a string containing the specified reference.
référence | The reference that is to be converted to text. |
a1 | Specifies the style of the reference. The possible values are: |
|
FAUX | R1C1 style |
VRAI | A1 style |
|
| If this parameter is omitted it defaults to FAUX. |
TOUCHE.ARRET(activer_valeur_logique; [réf_macro])
Specifies the action taken when the Escape key is pressed in a macro.
activer_valeur_logique | Whether to interrupt the macro. The possible values are: |
|
FAUX | The macro continues |
VRAI | The macro is interrupted |
|
réf_macro | The macro to be run when the Escape key is pressed (not currently implemented) |
VALEUR.CIBLE(cellule_cible; valeur_cible; cellule_variable)
Simulates the Format Données Valeur cible menu option.
cellule_cible | The cell that is required to be a certain value. It must be a single cell containing a formula that returns a numeric result. |
valeur_cible | The value that the target cell needs to reach. |
cellule_variable | The cell whose value can be changed. It must be a single cell that either contains a number or is empty. |
ZONE.TEXTE(ajouter_texte; [identificateur_objet_texte]; [no_départ]; [no_car])
Changes the text of an object.
ajouter_texte | The text that is to be added. |
identificateur_objet_texte | The object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet. |
no_départ | The start position in the existing text where the new text is to be inserted. If this parameter is omitted it defaults to 1. |
no_car | The length of existing text that is to be replaced. If this parameter is omitted it defaults to the length of the existing text. |
ZOOM([facteur_zoom])
Simulates the Format Feuille Zoom menu option.
facteur_zoom | The magnification option. The possible values are: |
|
number | Set the zoom level to the specified number. The number must be between 10 and 400. |
VRAI | Set the zoom level so that the current selection fills the window. |
FAUX | Reset the zoom level to 100% |
|
| If this parameter is omitted it defaults to VRAI. |