Funkcji polecenia
[ ] indicates optional parameters
ADR.TEKST(odwołanie, [a1])
COFNIJ()
CZCIONKA.WŁAŚCIWOŚCI([czcionka], [czcionka_styl], [rozmiar], [przekreślenie], [indeks_górny], [indeks_dolny], [kontur], [cień], [podkreślenie], [kolor], [normalny], [tło], [znak_początkowy], [znak_licznik])
DANE.FORMULARZ()
DANE.SERIE.DANYCH([wierszkol], [typ_nr], [data_liczba], [krok_wartość], [wartość_końcowa], [reglinw])
EDYCJA.USUŃ([przesuń_liczba])
EDYTUJ.KOLOR(nr_koloru, [czerwony_wartość], [zielony_wartość], [niebieski_wartość])
FILTR([pole], [kryteria1], [operacja], [kryteria2])
FILTR.POKAŻ.WSZYSTKO()
FILTR.ZAAWANSOWANY(operacja, lista_adr, [kryteria_adr], [kopiuj_adr], [unikatowy])
FORMAT.LICZBA(format_tekst)
FORMUŁA(formuła_tekst, [adres])
FORMUŁA.IDŹ.DO([adres], [róg])
FORMUŁA.ZASTĄP(znajdź_tekst, zamień_tekst, [szukaj_w], [szukaj_wg], [aktyw_kom], [uwzgl_wielkość])
FORMUŁA.ZNAJDŹ(tekst, gdzie_liczba, co_liczba, wg_liczba, [kierunek_liczba], [uwzgl_wielkość])
FORMUŁA.ZNAJDŹ.NAST()
FORMUŁA.ZNAJDŹ.POPRZ()
GDY.ARKUSZ([arkusz_tekst], [makro_tekst], [uaktywnij_logiczna])
KATALOG([ścieżka_dostępu_tekst])
KOM.AKT()
KOMUNIKAT(logiczna, [tekst])
KOMÓRKA.ZABEZPIECZENIE([blokada], [ukryte])
KOPIUJ([z_adresu], [do_adresu])
KRAWĘDŹ([kontur], [lewa], [prawa], [górna], [dolna], [cień], [kolor_konturu], [lewa_kolor], [prawa_kolor], [górna_kolor], [dolna_kolor])
KTO.WYWOŁAŁ()
LINIA.PIONOWO([liczba_wierszy])
LINIA.POZIOMO([liczba_kolumn])
NOTATKA([dodaj_tekst], [komórka_adres], [znak_początkowy], [liczba_znaków])
O.NOTATCE([komórka_adres], [znak_początkowy], [liczba_znaków])
O.OBIEKCIE(typ_nr, [obiekt_id], [liczba_początkowa], [licznik_liczba], [element_indeks])
OSTRZEŻENIE(komunikat_tekst, [typ_nr], [pomoc_adres])
PALETA.KOLORÓW(plik_tekst)
PL.CZYTAJ(plik_nr, liczba_znaków)
PL.CZYTAJ.LIN(plik_nr)
PL.OTWÓRZ(plik_tekst, [nr_dostępu])
PL.POZYCJA(plik_nr, [pozycja_nr])
PL.ROZMIAR(plik_nr)
PL.ZAMKNIJ(plik_nr)
PL.ZAPISZ(plik_nr, tekst)
PL.ZAPISZ.LIN(plik_nr, tekst)
PLIK.USUŃ(plik_tekst)
POKAŻ.AKTYWNĄ.KOM()
PRZELICZ.DOKUMENT()
PRZELICZ.TERAZ()
PRZEWIŃ.PIONOWO(pozycja, [wiersz_logiczna])
PRZEWIŃ.POZIOMO(pozycja, [kolumna_logiczna])
SKOROSZYT.NAST()
SKOROSZYT.NAZWA(stara_nazwa_tekst, nowa_nazwa_tekst)
SKOROSZYT.ODKRYJ([arkusz_tekst])
SKOROSZYT.POPRZ()
SKOROSZYT.UAKTYWNIJ(arkusz_tekst)
SKOROSZYT.UKRYJ([arkusz_tekst], [dobrze_ukryty])
SKOROSZYT.USUŃ([arkusz_tekst])
SKOROSZYT.WSTAW([typ_nr])
SORTUJ([orientacja], [klucz1], [kolejność1], [klucz2], [kolejność2], [klucz3], [kolejność3], [nagłówek], [niestandardowy], [wielkie_lit])
STANDARD.SZEROKOŚĆ([standard_nr])
STRONA.PIONOWO([liczba_okien])
STRONA.POZIOMO([liczba_okien])
SYGNAŁ([dźwięk_nr])
SZACUJ(formuła_tekst)
SZEROKOŚĆ.KOLUMNY([szerokość_nr], [adres], [standard], [typ_nr], [standard_nr])
SZUKAJ.WYNIKU(docelowa_komórka, docelowa_wartość, komórka_zmiennej)
TEKST.ADR(tekst, [a1])
UAKTYWNIJ([okno_tekst], [nr_okienka])
WART.POD.ADRESEM(odwołanie)
WEJŚCIE(komunikat_tekst, [typ_nr], [tytuł_tekst], [domyślny], [pozycja_x], [pozycja_y], [pomoc_adres])
WIERSZ.WYSOKOŚĆ([wysokość_nr], [adres], [wysokość_standard], [typ_nr])
WKLEJ([do_adresu])
WKLEJ.SPECJALNIE([wklej_liczba], [operacja_nr], [pomiń_puste], [transponuj])
WSTAW([przesuń_liczba])
WYCZYŚĆ([typ_nr])
WYPEŁNIJ.W.DÓŁ()
WYPEŁNIJ.W.GÓRĘ()
WYPEŁNIJ.W.LEWO()
WYPEŁNIJ.W.PRAWO()
WYRÓWNANIE([wyrówanie_poz], [zawijanie], [wyrównanie_pion], [orientacja], [dodaj_wcięcie])
WYTNIJ([z_adresu], [do_adresu])
WZORKI([deseń], [przód], [tło])
ZABEZPIECZ.DOKUMENT([zawartość], [okna], [hasło], [obiekty], [scenariusze])
ZAPISZ()
ZAZNACZ([wybór], [aktywna_komórka])
ZAZNACZ.KONIEC(kierunek_nr)
ZAZNACZ.OSTATNIĄ.KOMÓRKĘ()
ZAZNACZENIE()
ZOOM([powiększenie])
Funkcji polecenia
ADR.TEKST(odwołanie, [a1])
Returns a string containing the specified reference.
odwołanie | The reference that is to be converted to text. |
a1 | Specifies the style of the reference. The possible values are: |
|
FAŁSZ | R1C1 style |
PRAWDA | A1 style |
|
| If this parameter is omitted it defaults to FAŁSZ. |
COFNIJ()
Simulates the Edycja Cofnij menu option.
CZCIONKA.WŁAŚCIWOŚCI([czcionka], [czcionka_styl], [rozmiar], [przekreślenie], [indeks_górny], [indeks_dolny], [kontur], [cień], [podkreślenie], [kolor], [normalny], [tło], [znak_początkowy], [znak_licznik])
Simulates the Format Komórki dialog Czcionka page.
czcionka | The name of the font to be used. |
czcionka_styl | The style to be used. The possible values are: |
|
"Standardowy" | Removes the bold and italic attributes. |
"Pogrubiony" | Sets the font to bold. |
"Kursywa" | Sets the font to italic. |
"Pogrubiona kursywa" | Sets the font to bold and italic. |
|
| If this parameter is omitted the style is not changed. |
rozmiar | The point size to be used. If this parameter is omitted the size is not changed. |
przekreślenie | Sets the strikethrough attribute. The possible values are: |
|
FAŁSZ | The font does not have the strikethrough attribute |
PRAWDA | The font has the strikethrough attribute |
|
| If this parameter is omitted the strikethrough attribute is not changed. |
indeks_górny | Not currently implemented. |
indeks_dolny | Not currently implemented. |
kontur | Not currently implemented. |
cień | Not currently implemented. |
podkreślenie | The underline style to be used. The possible values are: |
|
0 | Bez podkreślenia |
1 | Pojedyncze |
2 | Podwójne (not currently implemented) |
3 | Księgowe pojedyncze (not currently implemented) |
4 | Księgowe podwójne (not currently implemented) |
|
| If this parameter is omitted the underline style is not changed. |
kolor | The color to be used. The possible values are: |
|
0 | Automatic |
1 to 56 | One of the colors displayed in the Format Cells Font dialog box |
|
| If this parameter is omitted the color is not changed. |
normalny | Not currently implemented. |
tło | Not currently implemented. |
znak_początkowy | Not currently implemented. |
znak_licznik | Not currently implemented. |
DANE.FORMULARZ()
Simulates the Format Dane Formularz menu option.
DANE.SERIE.DANYCH([wierszkol], [typ_nr], [data_liczba], [krok_wartość], [wartość_końcowa], [reglinw])
Simulates the Edycja Wypełnij Serie danych menu option.
wierszkol | 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. |
typ_nr | The way in which the series values change. The possible values are: |
|
1 | Liniowy |
2 | Wzrost |
3 | Data |
4 | Autowypełnianie (not currently implemented) |
|
| If this parameter is omitted it defaults to 1. |
data_liczba | The way in which the date values change. The possible values are: |
|
1 | Dzień |
2 | Dzień roboczy |
3 | Miesiąc |
4 | Rok |
|
| If this parameter is omitted it defaults to 1. |
krok_wartość | The number used to add to or multiply by the series value. If this parameter is omitted it defaults to 1. |
wartość_końcowa | The value at which to stop filling the series. If this parameter is omitted then the entire selection is filled. |
reglinw | Indicates whether to fill the series using trend values calculated from existing data. The possible values are: |
|
FAŁSZ | Don't use trend values. |
PRAWDA | Use trend values (not currently implemented). |
|
| If this parameter is omitted it defaults to FAŁSZ. |
EDYCJA.USUŃ([przesuń_liczba])
Simulates the Edycja Usuń menu option.
przesuń_liczba | The way in which the cell deletion is to be processed. The possible values are: |
|
1 | Przesuń komórki w lewo |
2 | Przesuń komórki do góry |
3 | Cały wiersz |
4 | Cała kolumna |
|
| If this parameter is omitted it defaults to 2. |
EDYTUJ.KOLOR(nr_koloru, [czerwony_wartość], [zielony_wartość], [niebieski_wartość])
Changes the color associated with a specific color number.
nr_koloru | A number from 1 to 56, indicating which color is to be changed. |
czerwony_wartość | A number from 0 to 255, specifying the intensity of the red component. If this parameter is omitted the red component is not changed. |
zielony_wartość | A number from 0 to 255, specifying the intensity of the green component. If this parameter is omitted the green component is not changed. |
niebieski_wartość | A number from 0 to 255, specifying the intensity of the blue component. If this parameter is omitted the blue component is not changed. |
FILTR([pole], [kryteria1], [operacja], [kryteria2])
Simulates the Format Dane Filtr Autofiltr menu option.
pole | 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. |
kryteria1 | A string specifying the criteria to be used. If this parameter is omitted any filter criteria are removed from the specified column. |
operacja | The combination operation when multiple criteria are used. The possible values are: |
| |
| If this parameter is omitted the second criteria is not used. |
kryteria2 | A string specifying the criteria to be used. If this parameter is omitted the second criteria is not used. |
FILTR.POKAŻ.WSZYSTKO()
Simulates the Format Dane Filtr Pokaż wszystko menu option.
FILTR.ZAAWANSOWANY(operacja, lista_adr, [kryteria_adr], [kopiuj_adr], [unikatowy])
Simulates the Format Dane Filtr Zaawansowany filtr menu option.
operacja | 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 |
|
lista_adr | The location of the list to be filtered. |
kryteria_adr | The location of any filter criteria to be used. If this parameter is omitted no criteria will be applied. |
kopiuj_adr | The destination of the copied data. This is only used when operation is 2. |
unikatowy | Whether to select unique records only. The possible values are: |
|
FAŁSZ | Display all records that match the criteria. |
PRAWDA | Display only unique records that match the criteria. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
FORMAT.LICZBA(format_tekst)
Simulates the Format Komórki dialog Liczby page.
format_tekst | The number format to be used. |
FORMUŁA(formuła_tekst, [adres])
Enters the specified formula in the specified reference.
formuła_tekst | The formula to be inserted. |
adres | The reference where formula to be inserted. If this parameter is omitted it defaults to the cursor position on the active worksheet. |
FORMUŁA.IDŹ.DO([adres], [róg])
Simulates the Edycja Idź do menu option.
adres | 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. |
róg | 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: |
|
FAŁSZ | The sheet is not scrolled to move the selection to the top-left corner of the window. |
PRAWDA | The sheet is scrolled to move the selection to the top-left corner of the window. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
FORMUŁA.ZASTĄP(znajdź_tekst, zamień_tekst, [szukaj_w], [szukaj_wg], [aktyw_kom], [uwzgl_wielkość])
Simulates the Edycja Znajdź/Zamień menu option.
znajdź_tekst | The text that you want to find. |
zamień_tekst | The text to replace the found text with. |
szukaj_w | Whether to match the text against all or part of a cell. The possible values are: |
|
1 | Znajdź tylko całe komórki |
2 | Any part of the text in a cell |
|
| If this parameter is omitted it defaults to 1. |
szukaj_wg | Whether to search by rows or by columns. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
aktyw_kom | Whether to replace in just the current cell or in the whole sheet. The possible values are: |
|
PRAWDA | Text in the active cell is replaced |
FAŁSZ | Text in the whole sheet is replaced |
|
| If this parameter is omitted it defaults to FAŁSZ. |
uwzgl_wielkość | Whether the search is case-sensitive. The possible values are: |
|
PRAWDA | The search is case-sensitive |
FAŁSZ | The search is not case-sensitive |
|
| If this parameter is omitted it defaults to the value last used. |
FORMUŁA.ZNAJDŹ(tekst, gdzie_liczba, co_liczba, wg_liczba, [kierunek_liczba], [uwzgl_wielkość])
Simulates the Edycja Znajdź menu option.
tekst | The text that you want to find. |
gdzie_liczba | Where you want to look for the text. The possible values are: |
|
1 | Formuły |
2 | Wartości |
3 | Komentarze |
|
co_liczba | Whether to match this text against all or part of a cell. The possible values are: |
|
1 | Znajdź tylko całe komórki |
2 | Any part of the text in a cell |
|
wg_liczba | Whether to search by rows or by columns. The possible values are: |
| |
kierunek_liczba | Whether to search for the next or previous match. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
uwzgl_wielkość | Whether the search is case-sensitive. The possible values are: |
|
PRAWDA | The search is case-sensitive |
FAŁSZ | The search is not case-sensitive |
|
| If this parameter is omitted it defaults to FAŁSZ. |
FORMUŁA.ZNAJDŹ.NAST()
Finds the next cell based on the current criteria.
FORMUŁA.ZNAJDŹ.POPRZ()
Finds the previous cell based on the current criteria.
GDY.ARKUSZ([arkusz_tekst], [makro_tekst], [uaktywnij_logiczna])
Specifies a macro to be run when a sheet is activated or deactivated.
arkusz_tekst | 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. |
makro_tekst | The defined name that refers to the macro that is to be run. If this parameter is omitted then no macro will be run. |
uaktywnij_logiczna | Specifies whether the macro is to be run when the sheet is activated or deactivated. The possible values are: |
|
PRAWDA | The macro will be run when the sheet is activated. |
FAŁSZ | The macro will be run when the sheet is deactivated. |
|
| If this parameter is omitted it defaults to PRAWDA. |
KATALOG([ścieżka_dostępu_tekst])
Returns the path of the current directory, and optionally allows you to change it.
ścieżka_dostępu_tekst | 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. |
KOM.AKT()
Returns a reference which represents the current position of the cursor on the active worksheet.
KOMUNIKAT(logiczna, [tekst])
Displays a message on the status bar.
logiczna | Whether to display or hide messages. The possible values are: |
|
PRAWDA | Display a message on the status bar. |
FAŁSZ | Remove any message from the status bar. |
|
tekst | The message to be displayed. If this parameter is omitted it defaults to an empty string. |
KOMÓRKA.ZABEZPIECZENIE([blokada], [ukryte])
Simulates the Format Komórki dialog Ochrona page.
blokada | Whether the cell should be locked when the sheet is protected. The possible values are: |
|
FAŁSZ | The cell is not locked |
PRAWDA | The cell is locked |
|
| If this parameter is omitted the setting is not changed. |
ukryte | Whether the cell formula should be hidden when the sheet is protected. The possible values are: |
|
FAŁSZ | The cell formula is not hidden |
PRAWDA | The cell formula is hidden |
|
| If this parameter is omitted the setting is not changed. |
KOPIUJ([z_adresu], [do_adresu])
Simulates the Edycja Kopiuj menu option.
z_adresu | 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. |
do_adresu | The cells where the copied information is to be pasted. If this parameter is omitted then the cells are not pasted. |
KTO.WYWOŁAŁ()
Returns information about the caller of the macro.
Macro called from: | CALLER() 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_otwieranie macro | file name |
Manually (control key combination) | error value #ADR! |
LINIA.PIONOWO([liczba_wierszy])
Scrolls the worksheet vertically by the specified number of rows.
liczba_wierszy | The number of rows to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1. |
LINIA.POZIOMO([liczba_kolumn])
Scrolls the worksheet horizontally by the specified number of columns.
liczba_kolumn | The number of columns to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1. |
NOTATKA([dodaj_tekst], [komórka_adres], [znak_początkowy], [liczba_znaków])
Simulates the Wstaw Komentarz menu option.
dodaj_tekst | The text that is to be added. If this parameter is omitted it defaults to an empty string. |
komórka_adres | The cell where the comment is to be inserted. If this parameter is omitted it defaults to the active cell. |
znak_początkowy | The start position in an existing comment where the new text is to be inserted. If this parameter is omitted it defaults to 1. |
liczba_znaków | 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. |
KRAWĘDŹ([kontur], [lewa], [prawa], [górna], [dolna], [cień], [kolor_konturu], [lewa_kolor], [prawa_kolor], [górna_kolor], [dolna_kolor])
Simulates the Format Komórki dialog Obramowanie page.
kontur | The border type to be applied to the outline of the selected cells. The possible values are: |
|
0 | Brak |
1 | Cienka |
2 | Średnia |
3 | Kreskowana |
4 | Kropkowana |
5 | Gruba |
6 | Podwójna |
7 | Bardzo cienka |
|
| If this parameter is omitted the setting is not changed. |
lewa | The border type to be used for the left border of the selected cells. The possible values are the same as for the kontur parameter. |
| If this parameter is omitted the setting is not changed. |
prawa | The border type to be used for the right border of the selected cells. The possible values are the same as for the kontur parameter. |
| If this parameter is omitted the setting is not changed. |
górna | The border type to be used for the top border of the selected cells. The possible values are the same as for the kontur parameter. |
| If this parameter is omitted the setting is not changed. |
dolna | The border type to be used for the bottom border of the selected cells. The possible values are the same as for the kontur parameter. |
| If this parameter is omitted the setting is not changed. |
cień | Not implemented. |
kolor_konturu | The color to be used for the outline border. The possible values are: |
|
0 | Automatyczne |
1 to 56 | One of the colors displayed in the Format Komórki dialog Obramowanie page |
|
| If this parameter is omitted the setting is not changed. |
lewa_kolor | The color to be used for the left border. The possible values are the same as for the kolor_konturu parameter. |
| If this parameter is omitted the setting is not changed. |
prawa_kolor | The color to be used for the right border. The possible values are the same as for the kolor_konturu parameter. |
| If this parameter is omitted the setting is not changed. |
górna_kolor | The color to be used for the top border. The possible values are the same as for the kolor_konturu parameter. |
| If this parameter is omitted the setting is not changed. |
dolna_kolor | The color to be used for the bottom border. The possible values are the same as for the kolor_konturu parameter. |
| If this parameter is omitted the setting is not changed. |
O.NOTATCE([komórka_adres], [znak_początkowy], [liczba_znaków])
Returns the text of a comment.
komórka_adres | The reference of the cell containing the comment. If this parameter is omitted it defaults to the active cell. |
znak_początkowy | The position of the first character to be returned. If this parameter is omitted it defaults to 1. |
liczba_znaków | The length of the text to be returned. If this parameter is omitted it defaults to the length of the comment. |
O.OBIEKCIE(typ_nr, [obiekt_id], [liczba_początkowa], [licznik_liczba], [element_indeks])
Returns information about the specified object.
typ_nr | The type of information to return. The possible values are: |
|
1 | object type as number: |
| 1 Linia |
| 2 Prostokąt |
| 3 Elipsa |
| 6 Pole tekstowe |
| 7 Przycisk |
| 11 Pole wyboru |
| 12 Przycisk opcji |
| 14 Etykieta |
| 16 Pokrętło |
| 17 Pasek przewijania |
| 18 Pole listy |
| 19 Pole grupy |
| 20 Rozwijana lista |
2 | Zablokuj |
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 Przenoś i zmieniaj rozmiar wraz z komórkami |
| 2 Przenoś z komórkami, lecz nie zmieniaj rozmiaru |
| 3 Nie przenoś ani nie zmieniaj rozmiaru z komórkami |
12 | object text from start_num for count_num characters |
|
obiekt_id | The object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet. |
liczba_początkowa | The text substring start position for type_num 12. If this parameter is omitted it defaults to 1. |
licznik_liczba | The text substring length for type_num 12. If this parameter is omitted it defaults to 255. |
element_indeks | This parameter is not currently used. |
OSTRZEŻENIE(komunikat_tekst, [typ_nr], [pomoc_adres])
Displays a message box containing the specified text. It returns PRAWDA if the OK button is pressed, otherwise FAŁSZ.
komunikat_tekst | The text to be displayed in the message box. |
typ_nr | The type of message box to be displayed. The possible values are: |
|
1 | A box containing a question mark icon and OK and Anuluj 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. |
pomoc_adres | A reference to a Help topic (not currently implemented). |
PALETA.KOLORÓW(plik_tekst)
Copies the color palette from another file.
plik_tekst | 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. |
PL.CZYTAJ(plik_nr, liczba_znaków)
Returns a string of characters from a file.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
liczba_znaków | The number of characters to read. |
PL.CZYTAJ.LIN(plik_nr)
Returns a string of characters from a file, up to the next end of line marker.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
PL.OTWÓRZ(plik_tekst, [nr_dostępu])
Opens a file for reading or writing. The return value is a file number that can be passed as a parameter to the PL.CZYTAJ, PL.CZYTAJ.LIN, PL.ZAPISZ, PL.ZAPISZ.LIN, PL.POZYCJA, PL.ROZMIAR, and PL.ZAMKNIJ functions.
plik_tekst | The name of the file to open. |
nr_dostępu | 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. |
PL.POZYCJA(plik_nr, [pozycja_nr])
Returns the current read/write position in a file, and optionally allows you to change it.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
pozycja_nr | The location where the next read or write will occur. |
| If this parameter is omitted the current position is not changed. |
PL.ROZMIAR(plik_nr)
Returns a size of a file.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
PL.ZAMKNIJ(plik_nr)
Closes a file that was previously opened by the PL.OTWÓRZ function.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
PL.ZAPISZ(plik_nr, tekst)
Writes a string of characters to a file.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
tekst | The text to be written. |
PL.ZAPISZ.LIN(plik_nr, tekst)
Writes a string of characters to a file, followed by an end of line marker.
plik_nr | The file number that was returned by the PL.OTWÓRZ function. |
tekst | The text to be written. |
PLIK.USUŃ(plik_tekst)
Deletes a file.
plik_tekst | The name of the file to be deleted. |
POKAŻ.AKTYWNĄ.KOM()
Scrolls the active cell into view.
PRZELICZ.DOKUMENT()
Causes the current worksheet to be recalculated.
PRZELICZ.TERAZ()
Causes all worksheets to be recalculated.
PRZEWIŃ.PIONOWO(pozycja, [wiersz_logiczna])
Scrolls the worksheet vertically to the specified position.
pozycja | The proportional or absolute position to scroll to. |
wiersz_logiczna | Whether the position parameter represents a proportional or absolute row number. The possible values are: |
|
FAŁSZ | The pozycja parameter is a number between 0 and 1 that represents how far down the worksheet to scroll to. |
PRAWDA | The pozycja parameter is a number between 1 and 65536 that represents the row number to scroll to. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
PRZEWIŃ.POZIOMO(pozycja, [kolumna_logiczna])
Scrolls the worksheet horizontally to the specified position.
pozycja | The proportional or absolute position to scroll to. |
kolumna_logiczna | Whether the pozycja parameter represents a proportional or absolute column number. The possible values are: |
|
FAŁSZ | The pozycja parameter is a number between 0 and 1 that represents how far across the worksheet to scroll to. |
PRAWDA | The pozycja parameter is a number between 1 and 256 that represents the column number to scroll to. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
SKOROSZYT.NAST()
Simulates the Ctrl+Page Down key combination.
SKOROSZYT.NAZWA(stara_nazwa_tekst, nowa_nazwa_tekst)
Simulates the Format Arkusz Zmień nazwę menu option.
stara_nazwa_tekst | The sheet that is to be renamed. |
nowa_nazwa_tekst | The new name for the sheet. |
SKOROSZYT.ODKRYJ([arkusz_tekst])
Simulates the Format Arkusz Odkryj menu option.
arkusz_tekst | The name of the sheet to unhide. If this parameter is omitted it defaults to the first hidden sheet. |
SKOROSZYT.POPRZ()
Simulates the Ctrl+Page Up key combination.
SKOROSZYT.UAKTYWNIJ(arkusz_tekst)
Specifies the sheet that is to be the active worksheet.
arkusz_tekst | The sheet that is to be the active worksheet. |
SKOROSZYT.UKRYJ([arkusz_tekst], [dobrze_ukryty])
Simulates the Format Arkusz Ukryj menu option.
arkusz_tekst | The name of the sheet to hide. If this parameter is omitted it defaults to the currently active sheet. |
dobrze_ukryty | Whether to show the name of the hidden sheet in the Unhide dialog box. The possible values are: |
|
PRAWDA | Do not show the sheet name |
FAŁSZ | Show the sheet name |
|
| If this parameter is omitted it defaults to FAŁSZ. |
SKOROSZYT.USUŃ([arkusz_tekst])
Simulates the Edycja Usuń arkusz menu option.
arkusz_tekst | The sheet that is to be deleted. If this parameter is omitted it defaults to the currently active sheet. |
SKOROSZYT.WSTAW([typ_nr])
Simulates the Wstaw Arkusz, Wykres and Makro menu options.
typ_nr | The type of sheet that is to be added. The possible values are: |
|
1 | Arkusz |
2 | Wykres |
3 | Arkusz makr |
|
| If this parameter is omitted it defaults to the type of the currently active sheet. |
SORTUJ([orientacja], [klucz1], [kolejność1], [klucz2], [kolejność2], [klucz3], [kolejność3], [nagłówek], [niestandardowy], [wielkie_lit])
Simulates the Format Dane Sortuj menu option.
orientacja | Specifies whether to sort the rows or columns. The possible values are: |
| |
| If this parameter is omitted it defaults to 1. |
klucz1 | 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. |
kolejność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. |
klucz2 | Specifies a reference to the second column or row to sort on. If this parameter is omitted then the second key is not used. |
kolejność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. |
klucz3 | Specifies a reference to the third column or row to sort on. If this parameter is omitted then the third key is not used. |
kolejność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. |
nagłówek | 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. |
niestandardowy | 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. |
wielkie_lit | Specifies whether the sort should be case-sensitive. The possible values are: |
|
PRAWDA | The sort is case-sensitive |
FAŁSZ | The sort is not case-sensitive |
|
| If this parameter is omitted it defaults to FAŁSZ. |
STANDARD.SZEROKOŚĆ([standard_nr])
Simulates the Format Kolumna Standardowa szerokość menu option.
standard_nr | The new standard width. If this parameter is omitted then the standard width is not changed. |
STRONA.PIONOWO([liczba_okien])
Scrolls the worksheet vertically by the specified number of pages.
liczba_okien | The number of pages to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1. |
STRONA.POZIOMO([liczba_okien])
Scrolls the worksheet horizontally by the specified number of pages.
liczba_okien | The number of pages to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1. |
SYGNAŁ([dźwięk_nr])
Causes the computer to beep.
dźwięk_nr | 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. |
SZACUJ(formuła_tekst)
Returns the result of evaluating a formula.
formuła_tekst | The formula to be evaluated. |
SZEROKOŚĆ.KOLUMNY([szerokość_nr], [adres], [standard], [typ_nr], [standard_nr])
Simulates the Format Kolumna menu options.
szerokość_nr | The new width of the columns. The width is measured in characters. This parameter is ignored if standard is PRAWDA or type_num is specified. If this parameter is omitted the width of the specified columns is not changed. |
adres | 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: |
|
PRAWDA | The columns are set to the standard width. |
FAŁSZ | The columns are not set to the standard width. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
typ_nr | Specifies whether the columns are to be hidden, unhidden or automatically sized. This parameter is ignored if standard is PRAWDA. 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. |
standard_nr | 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. |
SZUKAJ.WYNIKU(docelowa_komórka, docelowa_wartość, komórka_zmiennej)
Simulates the Format Dane Szukaj wyniku menu option.
docelowa_komórka | The cell that is required to be a certain value. It must be a single cell containing a formula that returns a numeric result. |
docelowa_wartość | The value that the target cell needs to reach. |
komórka_zmiennej | The cell whose value can be changed. It must be a single cell that either contains a number or is empty. |
TEKST.ADR(tekst, [a1])
Returns a reference corresponding to the specified text.
tekst | The string containing the reference. |
a1 | Specifies the style of the reference. The possible values are: |
|
FAŁSZ | R1C1 style |
PRAWDA | A1 style |
|
| If this parameter is omitted it defaults to FAŁSZ. |
UAKTYWNIJ([okno_tekst], [nr_okienka])
Specifies the workbook, sheet and/or pane that is to be active.
okno_tekst | The workbook and/or sheet name. If this parameter is omitted then the active window is not changed. |
nr_okienka | 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. |
WART.POD.ADRESEM(odwołanie)
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.
odwołanie | The reference to the cells whose values you want. |
WEJŚCIE(komunikat_tekst, [typ_nr], [tytuł_tekst], [domyślny], [pozycja_x], [pozycja_y], [pomoc_adres])
Displays a message in a dialog box with an area for user input and OK and Anuluj buttons. If the OK button is pressed then the text entered by the user is returned. If the Anuluj button is pressed then this function returns the value FAŁSZ.
komunikat_tekst | The message that you want displayed in the dialog box. |
typ_nr | 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 | Formuła |
1 | Liczba |
2 | Tekst |
4 | Logiczne |
8 | Odwołanie |
16 | Błąd |
64 | Tablica |
|
| If this parameter is omitted it defaults to 2. |
tytuł_tekst | The title to be used for the dialog box. If this parameter is omitted it defaults to "Wejście". |
domyślny | 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. |
pozycja_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 supported). |
pozycja_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 supported). |
pomoc_adres | 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 supported). |
WIERSZ.WYSOKOŚĆ([wysokość_nr], [adres], [wysokość_standard], [typ_nr])
Simulates the Format Wiersz menu options.
wysokość_nr | The new height of the rows. The height is measured in points. This parameter is ignored if wysokość_standard is PRAWDA or type_num is specified. If this parameter is omitted the height of the specified rows is not changed. |
adres | The rows whose height is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet. |
wysokość_standard | Specifies whether the rows are to be set to the standard row height. The possible values are: |
|
PRAWDA | The rows are set to the standard height. |
FAŁSZ | The rows are not set to the standard height. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
typ_nr | Specifies whether the rows are to be hidden, unhidden or automatically sized. This parameter is ignored if wysokość_standard is PRAWDA. 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. |
WKLEJ([do_adresu])
Simulates the Edycja Wklej menu option.
do_adresu | 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. |
WKLEJ.SPECJALNIE([wklej_liczba], [operacja_nr], [pomiń_puste], [transponuj])
Simulates the Edycja Wklej specjalnie menu option.
wklej_liczba | The type of information to be pasted. The possible values are: |
|
1 | Wszystko |
2 | Formuły |
3 | Wartości |
4 | Formaty |
5 | Komentarze |
6 | Wszystko poza obramowaniem |
|
| If this parameter is omitted it defaults to 1. |
operacja_nr | The way in which the data being pasted is merged with existing data. The possible values are: |
|
1 | Brak |
2 | Dodaj |
3 | Odejmij |
4 | Przemnóż |
5 | Podziel |
|
| If this parameter is omitted it defaults to 1. |
pomiń_puste | Whether to ignore blank cells in the data being pasted. The possible values are: |
|
FAŁSZ | Blank cells are included. |
PRAWDA | Blank cells are skipped. |
|
| If this parameter is omitted it defaults to FAŁSZ. |
transponuj | Whether to transpose the data being pasted. The possible values are: |
|
FAŁSZ | Data is not transposed. |
PRAWDA | Data is transposed. (Not currently supported) |
|
| If this parameter is omitted it defaults to FAŁSZ. |
WSTAW([przesuń_liczba])
Simulates the Wstaw Komórki menu option.
przesuń_liczba | The way in which the cell insertion is to be processed. The possible values are: |
|
1 | Przesuń komórki w prawo |
2 | Przesuń komórki w dół |
3 | Cały wiersz |
4 | Cała kolumna |
|
| If this parameter is omitted it defaults to 2. |
WYCZYŚĆ([typ_nr])
Simulates the Edycja Wyczyść menu option.
typ_nr | The type of information to clear from the current selection on the active worksheet. The possible values are: |
|
1 | Wszystko |
2 | Formaty |
3 | Zawartość |
4 | Komentarze |
|
| If this parameter is omitted it defaults to 3. |
WYPEŁNIJ.W.DÓŁ()
Simulates the Edycja Wypełnij W dół menu option.
WYPEŁNIJ.W.GÓRĘ()
Simulates the Edycja Wypełnij W górę menu option.
WYPEŁNIJ.W.LEWO()
Simulates the Edycja Wypełnij W lewo menu option.
WYPEŁNIJ.W.PRAWO()
Simulates the Edycja Wypełnij W prawo menu option.
WYRÓWNANIE([wyrówanie_poz], [zawijanie], [wyrównanie_pion], [orientacja], [dodaj_wcięcie])
Simulates the Format Komórki dialog Wyrównanie page.
wyrówanie_poz | The horizontal alignment to be used. The possible values are: |
|
1 | Ogólne |
2 | Lewa |
3 | Środek |
4 | Prawa |
5 | Wypełnienie |
6 | Wyjustuj |
7 | Wyrównaj zaznaczenie do środka |
|
| If this parameter is omitted the setting is not changed. |
zawijanie | Whether to wrap the text in the cells. The possible values are: |
|
FAŁSZ | The text is not wrapped |
PRAWDA | The text is wrapped |
|
| If this parameter is omitted the setting is not changed. |
wyrównanie_pion | The vertical alignment to be used. The possible values are: |
|
1 | Górne |
2 | Środek |
3 | Dolne |
4 | Wyjustuj |
|
| If this parameter is omitted the setting is not changed. |
orientacja | Not currently implemented. |
dodaj_wcięcie | Not currently implemented. |
WYTNIJ([z_adresu], [do_adresu])
Simulates the Edycja Wytnij menu option.
z_adresu | 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. |
do_adresu | The cells where the cut information is to be pasted. If this parameter is omitted then the cells are not pasted. |
WZORKI([deseń], [przód], [tło])
Simulates the Format Komórki dialog Desenie page.
deseń | The number of the pattern to be applied. The possible values are: |
|
0 | Brak |
1 | Pełny |
2 | 50% Szary |
3 | 75% Szary |
4 | 25% Szary |
5 | Poziomo Prążkowany |
6 | Pionowo Prążkowany |
7 | Odwrotny Diagonalny Prążkowany |
8 | Diagonalny Prążkowany |
9 | Diagonalny Kreskowany |
10 | Gruba Diagonalny Kreskowany |
11 | Cienka Poziomo Prążkowany |
12 | Cienka Pionowo Prążkowany |
13 | Cienka Odwrotny Diagonalny Prążkowany |
14 | Cienka Diagonalny Prążkowany |
15 | Cienka Poziomo Kreskowany |
16 | Cienka Diagonalny Kreskowany |
17 | 12.5% Szary |
18 | 6.25% Szary |
|
| If this parameter is omitted the setting is not changed. |
przód | The number of the foreground color to be applied. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Komórki dialog Desenie page |
|
| If this parameter is omitted the setting is not changed. |
tło | The number of the background color to be applied. The possible values are: |
|
1 to 56 | One of the colors displayed in the Format Komórki dialog Desenie page |
|
| If this parameter is omitted the setting is not changed. |
ZABEZPIECZ.DOKUMENT([zawartość], [okna], [hasło], [obiekty], [scenariusze])
Simulates the Format Arkusz Chroń menu option.
zawartość | Whether to protect the locked cell contents. The possible values are: |
|
PRAWDA | The locked cell contents are protected |
FAŁSZ | The locked cell contents are unprotected |
|
| If this parameter is omitted it defaults to PRAWDA. |
okna | Whether to protect windows from being moved or sized (not currently implemented). The possible values are: |
|
PRAWDA | The windows are protected |
FAŁSZ | The windows are unprotected |
|
| If this parameter is omitted it defaults to FAŁSZ. |
hasło | An optional case-sensitive password to protect or unprotect the document. |
obiekty | Whether to protect the locked objects (not currently implemented). The possible values are: |
|
PRAWDA | The locked objects are protected |
FAŁSZ | The locked objects are unprotected |
|
| If this parameter is omitted it defaults to PRAWDA. |
scenariusze | Whether to protect the scenarios (not currently implemented). The possible values are: |
|
PRAWDA | The scenarios are protected |
FAŁSZ | The scenarios are unprotected |
|
| If this parameter is omitted it defaults to PRAWDA. |
ZAPISZ()
Simulates the Plik Zapisz menu option.
ZAZNACZ([wybór], [aktywna_komórka])
Sets the selection and cursor cell on the active worksheet.
wybór | The cells that are to be the selection. If this parameter is omitted the current selection is not changed. |
aktywna_komórka | The cell that is to be the cursor cell. If this parameter is omitted it defaults to the top left cell in the selection. |
ZAZNACZ.KONIEC(kierunek_nr)
Simulates the Ctrl+arrow key combination.
kierunek_nr | The direction in which to move the cursor. The possible values are: |
|
1 | W lewo |
2 | W prawo |
3 | W górę |
4 | W dół |
|
ZAZNACZ.OSTATNIĄ.KOMÓRKĘ()
Simulates the Ctrl+End key combination.
ZAZNACZENIE()
Returns a reference which represents the current selection on the active worksheet.
ZOOM([powiększenie])
Simulates the Format Arkusz Powiększenie menu option.
powiększenie | The magnification option. The possible values are: |
|
number | Set the zoom level to the specified number. The number must be between 10 and 400. |
PRAWDA | Set the zoom level so that the current selection fills the window. |
FAŁSZ | Reset the zoom level to 100% |
|
| If this parameter is omitted it defaults to PRAWDA. |