Ahoj, pokud se chcete přidat, stačí se přihlásit a začít psát návrhy překladů. Zkontrolujeme je, zařadíme a dle kvality vám časem dáme plná práva. Případné dotazy prosím napište na lokalizace@cz.libreoffice.org. Těšíme se! :-)

Translation status

8,576 Strings 99%
Browse Translate
93,410 Words 99%
789,777 Characters 99%

Strings status

Strings Words Characters
8,576 93,410 789,777
All strings Browse Translate Zen
8,552 93,053 786,990
Translated strings Browse Translate Zen
24 357 2,787
Unfinished strings Browse Translate Zen
24 357 2,787
Untranslated strings Browse Translate Zen
3 41 305
Strings with suggestions Browse Translate Zen
21 316 2,482
Unfinished strings without suggestions Browse Translate Zen
46 372 3,720
Strings with any failing checks Browse Translate Zen
46 372 3,720
Translated strings with any failing checks Browse Translate Zen
27 423 3,978
Translated strings with dismissed checks Browse Translate Zen
36 55 864
Failing check: Unchanged translation Browse Translate Zen
10 317 2,856
Failing check: XML markup Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
Glossary LibreOffice Help - master MPL-2.0 0 0 0 0 0 0 0
text/shared/menu MPL-2.0 0 0 0 0 0 0 0
text/swriter/guide MPL-2.0 0 0 0 0 15 0 0
text/shared/help MPL-2.0 0 0 0 0 0 0 0
text/simpress/00 MPL-2.0 0 0 0 0 0 0 0
text/simpress/01 MPL-2.0 0 0 0 0 1 0 0
text/swriter/librelogo MPL-2.0 0 0 0 0 0 0 0
text/shared/autokorr MPL-2.0 0 0 0 0 0 0 0
auxiliary MPL-2.0 0 0 0 0 0 0 0
text/simpress/04 MPL-2.0 0 0 0 0 12 0 0
Browse all components

Overview

Project website www.libreoffice.org
Translation license Mozilla Public License 2.0
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
File mask */helpcontent2/source/text/scalc/01.po
Translation file Download cs/helpcontent2/source/text/scalc/01.po
Last change June 7, 2024, 6:05 p.m.
Last author Miroslav Streit
yesterday

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 8,576 93,410 789,777
Translated 99% 8,552 99% 93,053 99% 786,990
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 46 1% 372 1% 3,720
Strings with suggestions 1% 3 1% 41 1% 305
Untranslated strings 1% 24 1% 357 1% 2,787
Last 12 months Previous

Activity in last 12 months

52 changes 51 changes 168 changes 1 change 0 changes 0 changes 0 changes 57 changes 196 changes 28 changes 57 changes 110 changes 409 changes 715 changes 216 changes 0 changes 1 change 169 changes 202 changes 93 changes 25 changes 68 changes 29 changes 181 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

93,410
Hosted words
8,576
Hosted strings
99%
Translated
3
Contributors
and previous 30 days

Trends of last 30 days

+1%
Hosted words
+100%
+1%
Hosted strings
+100%
+1%
Translated
+99%
+66%
Contributors
+100%
User avatar Arentaz

Suggestion added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
<input>{=XLOOKUP("Helium";B1:DO1;B1:DO4)}</input> returns the array
array
yesterday
User avatar Arentaz

Suggestion added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
<input>{=XLOOKUP("Atomic Number";A2:A4;A2:DO4)}</input> returns the array
pole
yesterday
User avatar Arentaz

Suggestion added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIF function. For example:
Pro ulehčení zápisu funkce. Můžeme například kritéria SUMIF rozdělit do samostatných buňek ( např. výsledek jiné operace). Do funkce zapisujeme odkaz(pozici).
yesterday
User avatar None

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
The "cs/helpcontent2/source/text/scalc/01.po" file was changed. 2 days ago
User avatar None

String added in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIF function. For example:
 
2 days ago
User avatar None

Changes committed

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
Changes committed 4 days ago
User avatar strepon

Translation added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
XLOOKUP( [Lookup] ; Array ; Return [ ; [ NotFound ] [ ; [MatchType] [ ; SearchMode ] ] ] )
XLOOKUP([Vyhledávání] ; Matice ; Výsledek [ ; [ Nenalezeno ] [ ; [Typ shody] [ ; Režim vyhledávání ] ] ])
4 days ago
User avatar strepon

Translation added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
XLOOKUP function is a modern and flexible replacement for older functions like <link href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link>, <link href="text/scalc/01/04060109.xhp#Section17">HLOOKUP</link>, and <link href="text/scalc/01/04060109.xhp#Section14">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets.
Funkce XLOOKUP je moderní a flexibilní náhradou starších funkcí <link href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link>, <link href="text/scalc/01/04060109.xhp#Section17">HLOOKUP</link> a <link href="text/scalc/01/04060109.xhp#Section14">LOOKUP</link>. XLOOKUP podporuje přibližnou a přesnou shodu, zástupné znaky (* ?) pro částečnou shodu a vyhledávání ve svislých i vodorovných oblastech. Umožňuje vyhledávat odzadu a pro práci s rozsáhlými daty nabízí také rychlé binární vyhledávání.
4 days ago
User avatar strepon

Translation added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
Description
Popis
4 days ago
User avatar strepon

Translation added

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Czech
<input>{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}</input>
<input>{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}</input>
4 days ago
Browse all translation changes