https://henryk-dabrowski.pl/index.php?action=history&feed=atom&title=Funkcje_arkusza Funkcje arkusza - Historia wersji 2026-04-24T17:31:25Z Historia wersji tej strony wiki MediaWiki 1.43.6 https://henryk-dabrowski.pl/index.php?title=Funkcje_arkusza&diff=760&oldid=prev HenrykDabrowski o 14:29, 24 maj 2024 2024-05-24T14:29:31Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="pl"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← poprzednia wersja</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Wersja z 16:29, 24 maj 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l41">Linia 41:</td> <td colspan="2" class="diff-lineno">Linia 41:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[LibreOffice Calc – makra | &lt;b&gt;LibreOffice Calc – makra&lt;/b&gt;]]&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;[[Henryk Dąbrowski | &lt;b&gt;Strona główna&lt;/b&gt;]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[LibreOffice Calc – makra <ins style="font-weight: bold; text-decoration: none;">– przykłady </ins>| &lt;b&gt;LibreOffice Calc – makra <ins style="font-weight: bold; text-decoration: none;">– przykłady</ins>&lt;/b&gt;]]&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;[[Henryk Dąbrowski | &lt;b&gt;Strona główna&lt;/b&gt;]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> </table> HenrykDabrowski https://henryk-dabrowski.pl/index.php?title=Funkcje_arkusza&diff=251&oldid=prev HenrykDabrowski: 1 wersja 2022-09-18T20:36:52Z <p>1 wersja</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="pl"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← poprzednia wersja</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Wersja z 22:36, 18 wrz 2022</td> </tr><tr><td colspan="2" class="diff-notice" lang="pl"><div class="mw-diff-empty">(Brak różnic)</div> </td></tr></table> HenrykDabrowski https://henryk-dabrowski.pl/index.php?title=Funkcje_arkusza&diff=250&oldid=prev HenrykDabrowski: Utworzono nową stronę "<div style="text-align:right; font-size: 130%; font-style: italic; font-weight: bold;">05.12.2020</div> __FORCETOC__ == Wstawianie nowego arkusza == Niekiedy potrze..." 2020-12-05T16:27:51Z <p>Utworzono nową stronę &quot;&lt;div style=&quot;text-align:right; font-size: 130%; font-style: italic; font-weight: bold;&quot;&gt;05.12.2020&lt;/div&gt; __FORCETOC__ == Wstawianie nowego arkusza == Niekiedy potrze...&quot;</p> <p><b>Nowa strona</b></p><div>&lt;div style=&quot;text-align:right; font-size: 130%; font-style: italic; font-weight: bold;&quot;&gt;05.12.2020&lt;/div&gt;<br /> <br /> __FORCETOC__<br /> <br /> <br /> <br /> == Wstawianie nowego arkusza ==<br /> <br /> Niekiedy potrzebujemy, aby procedura wstawiła do skoroszytu nowy arkusz i sama dobrała nazwę arkusza różną od nazw już istniejących arkuszy. Zamieszczona niżej procedura rozwiązuje ten problem. Jeśli nie podamy parametru, to wstawianemu arkuszowi zostanie nadana pierwsza wolna nazwa z ciągu: &quot;Arkusz&quot;, &quot;Arkusz1&quot;, &quot;Arkusz2&quot;, &quot;Arkusz3&quot;, ... Jeżeli procedura zostanie wywołana z parametrem, to zostanie stworzony analogiczny ciąg nazw, ale zamiast słowa &quot;Arkusz&quot; będzie użyty tekst podany jako parametr.<br /> <br /> &lt;span style=&quot;color: green&quot;&gt;&lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Sub &lt;/span&gt;&lt;/b&gt;WstawNowyArkusz(&lt;span style=&#039;color:#000080;&#039;&gt;Optional&lt;/span&gt; NazwaArkusza &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;as&lt;/span&gt;&lt;/b&gt; &lt;span style=&#039;color:#000080;&#039;&gt;String&lt;/span&gt;)<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Dim&lt;/span&gt;&lt;/b&gt; sName &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;as&lt;/span&gt;&lt;/b&gt; &lt;span style=&#039;color:#000080;&#039;&gt;String&lt;/span&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Dim&lt;/span&gt;&lt;/b&gt; k &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;as&lt;/span&gt;&lt;/b&gt; &lt;span style=&#039;color:#000080;&#039;&gt;Long&lt;/span&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;If &lt;/span&gt;&lt;/b&gt;IsMissing(NazwaArkusza) &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Then&lt;/span&gt;&lt;/b&gt;<br /> sName &lt;span style=&#039;color:#000080;&#039;&gt;=&lt;/span&gt; &lt;span style=&#039;color:#ff0000;&#039;&gt;&amp;quot;Arkusz&amp;quot;&lt;/span&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Else&lt;/span&gt;&lt;/b&gt;<br /> sName &lt;span style=&#039;color:#000080;&#039;&gt;=&lt;/span&gt; NazwaArkusza<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;End If&lt;/span&gt;&lt;/b&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;If &lt;/span&gt;&lt;/b&gt;&lt;b&gt;&lt;span style=&#039;color:#000000;&#039;&gt;NOT&lt;/span&gt;&lt;/b&gt; ThisComponent.getSheets().hasByName( sName ) &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Then&lt;/span&gt;&lt;/b&gt; &lt;span style=&#039;color:#707070;&#039;&gt;&#039;sprawdza czy arkusz o podanej nazwie już istnieje&lt;/span&gt;<br /> ThisComponent.getSheets().insertNewByName( sName, &lt;span style=&#039;color:#ff0000;&#039;&gt;0&lt;/span&gt; ) &lt;span style=&#039;color:#707070;&#039;&gt;&#039;wstawia nowy arkusz na pozycję 1 (z indeksem 0)&lt;/span&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Exit Sub&lt;/span&gt;&lt;/b&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;End If&lt;/span&gt;&lt;/b&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;For &lt;/span&gt;&lt;/b&gt;k &lt;span style=&#039;color:#000080;&#039;&gt;=&lt;/span&gt; &lt;span style=&#039;color:#ff0000;&#039;&gt;1&lt;/span&gt; &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;to&lt;/span&gt;&lt;/b&gt; &lt;span style=&#039;color:#ff0000;&#039;&gt;10000&lt;/span&gt; &lt;span style=&#039;color:#707070;&#039;&gt;&#039;maksymalna liczba arkuszy&lt;/span&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;If &lt;/span&gt;&lt;/b&gt;&lt;b&gt;&lt;span style=&#039;color:#000000;&#039;&gt;NOT&lt;/span&gt;&lt;/b&gt; ThisComponent.getSheets().hasByName( sName &lt;span style=&#039;color:#000080;&#039;&gt;&amp;amp;&lt;/span&gt; k ) &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Then&lt;/span&gt;&lt;/b&gt; &lt;span style=&#039;color:#707070;&#039;&gt;&#039;sprawdza czy arkusz o podanej nazwie już istnieje&lt;/span&gt;<br /> ThisComponent.getSheets().insertNewByName( sName &lt;span style=&#039;color:#000080;&#039;&gt;&amp;amp;&lt;/span&gt; k, &lt;span style=&#039;color:#ff0000;&#039;&gt;0&lt;/span&gt; ) &lt;span style=&#039;color:#707070;&#039;&gt;&#039;wstawia nowy arkusz na pozycję 1 (z indeksem 0)&lt;/span&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Exit For&lt;/span&gt;&lt;/b&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;End If&lt;/span&gt;&lt;/b&gt;<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Next &lt;/span&gt;&lt;/b&gt;k<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;End Sub&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;<br /> <br /> &lt;span style=&quot;color: green&quot;&gt;&lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;Sub &lt;/span&gt;&lt;/b&gt;Arkusze1()<br /> &lt;b&gt;&lt;span style=&#039;color:#000000;&#039;&gt;Call&lt;/span&gt;&lt;/b&gt; WstawNowyArkusz()<br /> &lt;b&gt;&lt;span style=&#039;color:#000000;&#039;&gt;Call&lt;/span&gt;&lt;/b&gt; WstawNowyArkusz(&lt;span style=&#039;color:#ff0000;&#039;&gt;&amp;quot;Wyniki&amp;quot;&lt;/span&gt;)<br /> &lt;b&gt;&lt;span style=&#039;color:#1f1c1b;&#039;&gt;End Sub&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> [[LibreOffice Calc – makra | &lt;b&gt;LibreOffice Calc – makra&lt;/b&gt;]]&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;[[Henryk Dąbrowski | &lt;b&gt;Strona główna&lt;/b&gt;]]<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> &amp;nbsp;</div> HenrykDabrowski