#, fuzzy
msgid ""
msgstr ""
"MIME-Version: 1.0\n"
"Content-Transfer-Encoding: 8bit\n"
"Content-Type: text/plain; charset=UTF-8\n"

msgctxt "63292873e37267a84f7534c7422fcec1"
msgid "Chapter 5  Getting started with Calc"
msgstr ""

msgctxt "980b61ebad016ccaa8c02ea3d685042c"
msgid "<g1><g2></g2></g1><g3>Getting Started</g3> Guide"
msgstr ""

msgctxt "c3b3f20b60e2e1595aae5987722ebd76"
msgid "Chapter <g1>5</g1>  <x2/><g3>Getting Started with Calc</g3>"
msgstr ""

msgctxt "1d7763b8f037953bfe280e16580a4319"
msgid "Using Spreadsheets in LibreOffice"
msgstr ""

msgctxt "6acd930ce5155cec088dc2a82e0643eb"
msgid "<g1></g1>Copyright<g2></g2>"
msgstr ""

msgctxt "b173abbdfcaa7cf3d8e300d44274fa19"
msgid ""
"This document is Copyright <g1>©</g1> <g2>2010–</g2>201<g3>6</g3> by <g4>the "
"LibreOffice Documentation Team. C</g4>ontributors a<g5>re</g5> listed below. "
"You may distribute it and/or modify it under the terms of either the GNU "
"General Public License (<g6>http://www.gnu.org/licenses/gpl.html</g6>), "
"version 3 or later, or the Creative Commons Attribution License "
"(<g7><g8>http://creativecommons.org/licenses/by/4.0/</g8></g7>), version "
"<g9>4</g9>.0 or later."
msgstr ""

msgctxt "524719ddee5e22e44b60a33f49c03bf5"
msgid "All trademarks within this guide belong to their legitimate owners."
msgstr ""

msgctxt "0e5aec0d83c7623253e7c518c6ab95ac"
msgid "<g1></g1>Contributors<g2></g2>"
msgstr ""

msgctxt "a19d66c8eb465f5ff14f60ff51f4f117"
msgid "Jean Hollis Weber"
msgstr ""

msgctxt "261cac45121d03334184bb34ba006951"
msgid "Peter Schofield"
msgstr ""

msgctxt "5af7010aaa25bd11c84ebeac6de14764"
msgid "David Michel"
msgstr ""

msgctxt "eff8e2bdaec5fc8f7db32c876cfdba10"
msgid "Hazel Russman"
msgstr ""

msgctxt "d7bb474a4e6fcc5afedafc84cf1f32d6"
msgid "Ron Faile Jr."
msgstr ""

msgctxt "6d755f42d7cfa3134c5ed61f23f80360"
msgid "Martin Saffron"
msgstr ""

msgctxt "2c955091e7585a2e093670411da7c0ea"
msgid "John A Smith"
msgstr ""

msgctxt "b6578b8e11b346dfc07ee4d10ef35275"
msgid "<g1></g1>Feedback<g2></g2>"
msgstr ""

msgctxt "235798d80b112b50e6084105d6b9cd24"
msgid ""
"Please direct any comments or suggestions about this document to <g1>the "
"Documentation Team’s mailing list</g1>: <g2>documentation@global.libreoffice."
"org</g2>"
msgstr ""

msgctxt "8bdfab753cf87911bbaaf46614c2f6ae"
msgid ""
"<g1>Note: </g1><g2>Everything you send to a mailing list, including your "
"email address and any other personal information that is written in the "
"message, is publicly archived and cannot be deleted.</g2>"
msgstr ""

msgctxt "b99459b8fe80d2408f5ebe6f12d40a4d"
msgid "<g1></g1>Acknowledgments<g2></g2>"
msgstr ""

msgctxt "9bbe7377b474f832a7ea8de6a3d375eb"
msgid ""
"This chapter is based on Chapter 5 of <g1>Getting Started with OpenOffice."
"org 3.3</g1>. The contributors to that chapter are:"
msgstr ""

msgctxt "14980beba7c2eea2a63f3a7fc26c7a80"
msgid ""
"Richard Barnes	Richard Detwiler	John Kane<x1/>Peter Kupfer	Joe Sellman	Jean "
"Hollis Weber<x2/>Linda Worthington	Michele Zarri"
msgstr ""

msgctxt "58d8ab83c4a4c54984b7653bc7c5571e"
msgid "<g1></g1>Publication date and software version<g2></g2>"
msgstr ""

msgctxt "e4bc3e74fb23eb401b944c75f872f741"
msgid "Published <g1>16 January 2016</g1>. Based on LibreOffice <g2>5.0</g2>."
msgstr ""

msgctxt "bb7373b0e8110476d600984d235997da"
msgid "<g1></g1>Note for Mac users<g2></g2>"
msgstr ""

msgctxt "b2af155d8da428946fb57ac3547bedc2"
msgid ""
"Some keystrokes and menu items are different on a Mac from those used in "
"Windows and Linux. The table below gives some common substitutions for the "
"instructions in this chapter. For a more detailed list, see the application "
"Help."
msgstr ""

msgctxt "d8fb3ad7ceab891bec9b53c78d434ce5"
msgid "Windows or Linux"
msgstr ""

msgctxt "f66613705067f67a2842feff2232c246"
msgid "Mac equivalent"
msgstr ""

msgctxt "a62d22910732d5343689f5117999abfa"
msgid "Effect"
msgstr ""

msgctxt "f0d66c2ce10a38561f6615a74f890ca4"
msgid "<g1><g2>Tools > Options</g2></g1> menu selection"
msgstr ""

msgctxt "3138cbd8f125dc61bd8747fc8d9437c9"
msgid "<g1>LibreOffice > Preferences</g1>"
msgstr ""

msgctxt "b48d29d52241ecd112f09d9a80d22e25"
msgid "Access setup options"
msgstr ""

msgctxt "6e8c7ed76a681e9d0b5bb49d59b3311c"
msgid "<g1>Right-click</g1>"
msgstr ""

msgctxt "d692c01d2cbfc108f2bbb106713d4336"
msgid ""
"<g1>Control+click</g1><g2> or </g2><g3>right-click</g3><g4> depending on "
"computer setup</g4>"
msgstr ""

msgctxt "83b5da1fe7b00fa96292e6ce392424b5"
msgid "Opens a context menu"
msgstr ""

msgctxt "e3fb4ca3800ca2b69ad744d5c56c133e"
msgid "<g1>Ctrl (Control)</g1>"
msgstr ""

msgctxt "4d42878bd77cb3b0b6b30f7885726da7"
msgid "<g1>⌘</g1> <g2>(Command)</g2>"
msgstr ""

msgctxt "72b08592e814768e7b62276ffdb71792"
msgid "Used with other keys"
msgstr ""

msgctxt "95e689cc86842290403410e60fa80335"
msgid "<g1>F5</g1>"
msgstr ""

msgctxt "06635bb8834a32723f2e1b32933d8187"
msgid "<g1>Shift</g1>+<g2>⌘</g2>+<g3>F5</g3>"
msgstr ""

msgctxt "b61c233db1540abc3768c6b6b024d16e"
msgid "Open the Navigator"
msgstr ""

msgctxt "afa91f311dc3578fb36afd6346f3d3f7"
msgid "<g1>F11</g1>"
msgstr ""

msgctxt "e1d057f1d376f31be28460fe9bb50bf8"
msgid "<g1>⌘</g1>+<g2>T</g2>"
msgstr ""

msgctxt "b40a02774098d95864b00459c22a02f7"
msgid "Open the Styles and Formatting window"
msgstr ""

msgctxt "c1df1da7a1ce305a3b60af9d5733ac1d"
msgid "Contents"
msgstr ""

msgctxt "ef12f096e7afb93c98dfa67b265d169b"
msgid "<g1>Copyright	2</g1>"
msgstr ""

msgctxt "4f79af9826d01e442fb3d0739a113736"
msgid "<g1>Contributors	2</g1>"
msgstr ""

msgctxt "7f09d11eae19fb618875eafc8cdedf31"
msgid "<g1>Feedback	2</g1>"
msgstr ""

msgctxt "6d6d25a8bcbcfbb63b253b17659571bc"
msgid "<g1>Acknowledgments	2</g1>"
msgstr ""

msgctxt "5510c4931bd5772884626708fe5ea1d7"
msgid "<g1>Publication date and software version	2</g1>"
msgstr ""

msgctxt "4591867c8b2e405fa0a40397858e4b6f"
msgid "<g1>Note for Mac users	2</g1>"
msgstr ""

msgctxt "ad6cb7ed94017f10b7d32fbef0f88415"
msgid "<g1>What is Calc?	6</g1>"
msgstr ""

msgctxt "239d9701e621c2e4d3683746472a7e02"
msgid "<g1>Spreadsheets, sheets and cells	6</g1>"
msgstr ""

msgctxt "a67d77b5c6d4b6e148673f5064a43c74"
msgid "<g1>Calc main window	6</g1>"
msgstr ""

msgctxt "af83de76e0c1ea20f77a853de2734242"
msgid "<g1>Title bar	6</g1>"
msgstr ""

msgctxt "16983b4b7b9201d8761e8914253cb0b8"
msgid "<g1>Menu bar	7</g1>"
msgstr ""

msgctxt "d8696492d7681cd96076ca2255dbd13c"
msgid "<g1>Toolbars	8</g1>"
msgstr ""

msgctxt "ffa30c2355295ccc7ef8c5d77850db31"
msgid "<g1>Formula bar	8</g1>"
msgstr ""

msgctxt "a77fbda7645cbb9d66376864478b8891"
msgid "<g1>Spreadsheet layout	9</g1>"
msgstr ""

msgctxt "667f217b401ea080eddc9a78695173f7"
msgid "<g1>Individual cells	9</g1>"
msgstr ""

msgctxt "8d66ef393ae31d21570075fbcc8ac8ff"
msgid "<g1>Sheet tabs	9</g1>"
msgstr ""

msgctxt "4e986a7f6ead453a1d4fdd03cbab20e2"
msgid "<g1>Status bar	9</g1>"
msgstr ""

msgctxt "59558649da708fee5a5a59c375cfadde"
msgid "<g1>Sidebar	10</g1>"
msgstr ""

msgctxt "8333564d5aa92ad9278d6dafd58011a1"
msgid "<g1>Opening a CSV file	11</g1>"
msgstr ""

msgctxt "1509b17e206f535fd09012812c3206fa"
msgid "<g1>Saving spreadsheets	13</g1>"
msgstr ""

msgctxt "c220951024966e729493397e662c584d"
msgid "<g1>Saving in other spreadsheet formats	13</g1>"
msgstr ""

msgctxt "4bcc5cc582ef9ce59a73f3cbb0f32833"
msgid "<g1>Navigating within spreadsheets	14</g1>"
msgstr ""

msgctxt "9cf4795ec6f8a73e9198823a7b13fc66"
msgid "<g1>Cell navigation	14</g1>"
msgstr ""

msgctxt "69e93860156f53aef8df424008106f57"
msgid "<g1>Sheet navigation	15</g1>"
msgstr ""

msgctxt "8c65d5025691289662a46a06e5d175cc"
msgid "<g1>Keyboard navigation	16</g1>"
msgstr ""

msgctxt "50484a3752d71842e7fef0f4ba22a39f"
msgid "<g1>Customizing the Enter key	18</g1>"
msgstr ""

msgctxt "0cb22c895347ece2ae8b577b2f0f64fc"
msgid "<g1>Selecting items in a spreadsheet	18</g1>"
msgstr ""

msgctxt "8a0eb5a2a33adf3852201008b82f9679"
msgid "<g1>Selecting cells	18</g1>"
msgstr ""

msgctxt "2a1ee9fd098b0e1f54769046597ae719"
msgid "<g1>Single cell	18</g1>"
msgstr ""

msgctxt "068629a140bf8c4459cbddab42ca9a84"
msgid "<g1>Range of contiguous cells	18</g1>"
msgstr ""

msgctxt "42903c77c3b67febae2fe4bf773f41e2"
msgid "<g1>Range of non-contiguous cells	19</g1>"
msgstr ""

msgctxt "488c7acb849ab245c72e0f9a33c1cab7"
msgid "<g1>Selecting columns and rows	19</g1>"
msgstr ""

msgctxt "785ad073844c36920592d8738c7ef138"
msgid "<g1>Single column or row	19</g1>"
msgstr ""

msgctxt "add826f099ac8fdbcf2fba43e106df5b"
msgid "<g1>Multiple columns or rows	19</g1>"
msgstr ""

msgctxt "d572e4bcfe5b735ba9211acc55c2a43f"
msgid "<g1>Entire sheet	19</g1>"
msgstr ""

msgctxt "49b53f9963788316ba34d8fcea4de470"
msgid "<g1>Selecting sheets	20</g1>"
msgstr ""

msgctxt "410e98fa9a653b8b48415304bb55bc95"
msgid "<g1>Single sheet	20</g1>"
msgstr ""

msgctxt "ffad0d58751f90ac1ffb29cc35b56eac"
msgid "<g1>Multiple contiguous sheets	20</g1>"
msgstr ""

msgctxt "82e782a487f0767a4872c36631b07e14"
msgid "<g1>Multiple non-contiguous sheets	20</g1>"
msgstr ""

msgctxt "144f0c118970798635557a051a497069"
msgid "<g1>All sheets	20</g1>"
msgstr ""

msgctxt "b28e265263ce2547e74505006e8db228"
msgid "<g1>Working with columns and rows	20</g1>"
msgstr ""

msgctxt "b78cffde151e22886d26178e53525c13"
msgid "<g1>Inserting columns and rows	20</g1>"
msgstr ""

msgctxt "14754030adb483ca768c0fbbeb20cbe7"
msgid "<g1>Single column or row	20</g1>"
msgstr ""

msgctxt "3fb8648b6f581984c275d5099877967d"
msgid "<g1>Multiple columns or rows	21</g1>"
msgstr ""

msgctxt "cc0454532381ab0e9638702732814af4"
msgid "<g1></g1><g2>Deleting columns and rows	21</g2>"
msgstr ""

msgctxt "026c6a13e45129a219902af45be0e320"
msgid "<g1>Single column or row	21</g1>"
msgstr ""

msgctxt "3fcda0d7befff0255d80a69ccef3fac1"
msgid "<g1>Working with sheets	22</g1>"
msgstr ""

msgctxt "b90c046e4d043a0d0a23310cdb1a3775"
msgid "<g1>Inserting new sheets	22</g1>"
msgstr ""

msgctxt "bc77de9670e4192f1bce73c743707d2c"
msgid "<g1>Moving and copying sheets	22</g1>"
msgstr ""

msgctxt "1be04e94ebe7c4c72f1da26b66dc7039"
msgid "<g1>Dragging and dropping	22</g1>"
msgstr ""

msgctxt "11c23084113ed8034cb6816d243d0788"
msgid "<g1>Using a dialog	23</g1>"
msgstr ""

msgctxt "c6af932263a9bd527a2607108faf2b1b"
msgid "<g1>Deleting sheets	23</g1>"
msgstr ""

msgctxt "a37e51b3f8d11fe9f14183d4b1d2fb99"
msgid "<g1>Renaming sheets	24</g1>"
msgstr ""

msgctxt "a4177264b3bda5f9aa050ef787dff2c7"
msgid "<g1>Viewing Calc	24</g1>"
msgstr ""

msgctxt "6414169ad34c00d3238212f657fd303d"
msgid "<g1>Changing document view	24</g1>"
msgstr ""

msgctxt "a383c5453980cfa7a932fef6b1b9d014"
msgid "<g1>Freezing rows and columns	24</g1>"
msgstr ""

msgctxt "cd9c3f622cb5826c0421a1f9e8e52ed4"
msgid "<g1>Freezing rows or columns	24</g1>"
msgstr ""

msgctxt "bd9a0d78cb6ef73067545936c1a3a20f"
msgid "<g1>Freezing rows and columns	25</g1>"
msgstr ""

msgctxt "423ec363eafde5c7ce565606e33b72d2"
msgid "<g1>Unfreezing	25</g1>"
msgstr ""

msgctxt "d4c527e9a6fe39e18305350f9f114321"
msgid "<g1>Splitting the screen	25</g1>"
msgstr ""

msgctxt "533ed18d2a586b2c2bbd37c8ea4fa0e9"
msgid "<g1>Splitting horizontally or vertically	25</g1>"
msgstr ""

msgctxt "e2b83843ed3d7aea199db0d1b96ed6a0"
msgid "<g1>Splitting horizontally and vertically	26</g1>"
msgstr ""

msgctxt "754d3f5db3fb102c895f4997e537c224"
msgid "<g1>Removing split views	26</g1>"
msgstr ""

msgctxt "fa0443cc0e778d6e21fe5c9ee34977fa"
msgid "<g1>Using the keyboard	26</g1>"
msgstr ""

msgctxt "7e6d163a48f5ab46e48f7eb7465179fa"
msgid "<g1>Numbers	26</g1>"
msgstr ""

msgctxt "97e71df912049551872abe7b24432067"
msgid "<g1>Minus numbers	26</g1>"
msgstr ""

msgctxt "b6b6351cf0a50f42b3fd88b294ce1b0b"
msgid "<g1>Leading zeroes	26</g1>"
msgstr ""

msgctxt "f1f2c3ad8a2f87b2b59f773add08b4f3"
msgid "<g1>Numbers as text	28</g1>"
msgstr ""

msgctxt "06ea2f31423f828a3cdc5375a884d7f1"
msgid "<g1>Text	28</g1>"
msgstr ""

msgctxt "25adaa9ceae45dc0dc8f1d3982a881d5"
msgid "<g1>Date and time	28</g1>"
msgstr ""

msgctxt "a5e52e82893c3a08b7a0797e4002ad80"
msgid "<g1>Autocorrection options	29</g1>"
msgstr ""

msgctxt "c55cf6aa8aca2d855b1bb0c994c59005"
msgid "<g1>Replace	29</g1>"
msgstr ""

msgctxt "2ea500a942ec6a8d72927dc7043b8f3f"
msgid "<g1>Exceptions	29</g1>"
msgstr ""

msgctxt "67c914c04f805716200ff713fd6a32b4"
msgid "<g1>Options	29</g1>"
msgstr ""

msgctxt "a69716ac7fe028ef6fd955e61c49f4d3"
msgid "<g1>Localized options	29</g1>"
msgstr ""

msgctxt "ba20e6c81756be362fc69426db3d98e9"
msgid "<g1>Reset	29</g1>"
msgstr ""

msgctxt "dc0ae39ee06e27742ec10d4cf6650769"
msgid "<g1>Deactivating automatic changes	30</g1>"
msgstr ""

msgctxt "cf1ab8c41c608b74886b0e0ab00e2173"
msgid "<g1>Speeding up data entry	30</g1>"
msgstr ""

msgctxt "2ae559193da5012ba00c38d999f79fb2"
msgid "<g1>Using the Fill tool	30</g1>"
msgstr ""

msgctxt "0a0db1100c3ab1ef90a6179851cffba3"
msgid "<g1>Using a fill series	31</g1>"
msgstr ""

msgctxt "a3b912acdbd0ce63b50ee70251c9df18"
msgid "<g1>Defining a fill series	33</g1>"
msgstr ""

msgctxt "befb633c8d000a8feba6fc3cc821d35e"
msgid "<g1>Using selection lists	33</g1>"
msgstr ""

msgctxt "a434a08257d3687ec40401a80947958c"
msgid "<g1>Sharing content between sheets	33</g1>"
msgstr ""

msgctxt "b0a1b54e98deda138cc754292e54ae82"
msgid "<g1>Validating cell contents	34</g1>"
msgstr ""

msgctxt "675e523a6c6ad228df260e3919241384"
msgid "<g1>Editing data	34</g1>"
msgstr ""

msgctxt "0a595bf5382e92c2afdc645083d9ae54"
msgid "<g1>Deleting data	34</g1>"
msgstr ""

msgctxt "5c41ff7d8fc6b8e30f27fc1e7a5c850f"
msgid "<g1>Deleting data only	34</g1>"
msgstr ""

msgctxt "ef7d44ec48d8664f308360bb37226121"
msgid "<g1>Deleting data and formatting	34</g1>"
msgstr ""

msgctxt "2908edb0219d592bd8e3a06652dc312e"
msgid "<g1>Replacing data	35</g1>"
msgstr ""

msgctxt "fb30ec64a47d5a0276748e964db113d7"
msgid "<g1>Editing data	35</g1>"
msgstr ""

msgctxt "48d8ecea1a6ff030c2fde7424f4f874a"
msgid "<g1></g1><g2>Using the keyboard	35</g2>"
msgstr ""

msgctxt "e61de1f7f02d64e02291695581cb6e8a"
msgid "<g1>Using the mouse	35</g1>"
msgstr ""

msgctxt "24369cfa06803f8aa93d3bdef7aa6e14"
msgid "<g1>Formatting data	35</g1>"
msgstr ""

msgctxt "a71c073bab6732bea0567aaf863c22d0"
msgid "<g1>Multiple lines of text	35</g1>"
msgstr ""

msgctxt "2e59622dfef4c8755c03a2d44222596f"
msgid "<g1>Automatic wrapping	35</g1>"
msgstr ""

msgctxt "76eafa75820501331f88f2d7ce002a43"
msgid "<g1>Manual line breaks	36</g1>"
msgstr ""

msgctxt "3e3fafb00f7e20c4227611a5e458a977"
msgid "<g1>Shrinking text to fit the cell	37</g1>"
msgstr ""

msgctxt "80b117bedb03acd7706da9660700974e"
msgid "<g1>Formatting numbers	37</g1>"
msgstr ""

msgctxt "be85d6d497cc92f7d1d00404c8e611ad"
msgid "<g1>Formatting a font	37</g1>"
msgstr ""

msgctxt "332f50e8877d644cc9754ad98233cb46"
msgid "<g1>Formatting cell borders	38</g1>"
msgstr ""

msgctxt "2e5a8d9f7fb4f2482e693f71676e4832"
msgid "<g1>Formatting cell background	38</g1>"
msgstr ""

msgctxt "c1686e04a960a2e2b499640a53fcf049"
msgid "<g1>AutoFormat of cells	39</g1>"
msgstr ""

msgctxt "06165798b86c741160d4866ec8df4537"
msgid "<g1>Using AutoFormat	39</g1>"
msgstr ""

msgctxt "8b938560e6f975cc196e4b133bea9a33"
msgid "<g1>Defining a new AutoFormat	39</g1>"
msgstr ""

msgctxt "0e29335f24d9ebebc45bf8d372d3c4c5"
msgid "<g1>Using themes	39</g1>"
msgstr ""

msgctxt "2469fb4dd0030dcb4e2da38317a29a66"
msgid "<g1>Using conditional formatting	40</g1>"
msgstr ""

msgctxt "4b024df71c91a0efbec3915789735a95"
msgid "<g1>Hiding and showing data	40</g1>"
msgstr ""

msgctxt "445afd1c2d06c90cceaeecb8114152ef"
msgid "<g1>Hiding data	41</g1>"
msgstr ""

msgctxt "720756d5e425efaf042a7a29a1c531d5"
msgid "<g1>Showing data	42</g1>"
msgstr ""

msgctxt "ce275bb7a8ca0b588351fe7798698d4f"
msgid "<g1>Sorting records	42</g1>"
msgstr ""

msgctxt "ff54911922bd05e6435595916298f037"
msgid "<g1>Using formulas and functions	43</g1>"
msgstr ""

msgctxt "d572ac1042e17a63883f1d09ddbcca99"
msgid "<g1>Analyzing data	43</g1>"
msgstr ""

msgctxt "593f000e12fb5870398ce68d1f04f0c1"
msgid "<g1>Printing	43</g1>"
msgstr ""

msgctxt "3aece0d4edc843429b95b560e9e12dae"
msgid "<g1>Print ranges	43</g1>"
msgstr ""

msgctxt "9f5a870c13a72edb223006c66604cd81"
msgid "<g1>Defining a print range	43</g1>"
msgstr ""

msgctxt "a279d02114673ce76422dd1addcc2781"
msgid "<g1>Adding to a print range	44</g1>"
msgstr ""

msgctxt "9f42d86f156e222a26891335dec45075"
msgid "<g1>Removing a print range	44</g1>"
msgstr ""

msgctxt "1c43e8f6dcc54c783654c84589b23095"
msgid "<g1>Editing a print range	44</g1>"
msgstr ""

msgctxt "57da0ffd19b75bf003fd81c825cd314a"
msgid "<g1>Printing options	44</g1>"
msgstr ""

msgctxt "c571c4d277ccfa3897e06e671b8e22c4"
msgid "<g1>Repeat printing of rows or columns	44</g1>"
msgstr ""

msgctxt "576733abe3cd6a6fe109d78e251d5ac2"
msgid "<g1>Page breaks	45</g1>"
msgstr ""

msgctxt "2922e706476e50bbba597596e1611a1a"
msgid "<g1>Inserting a break	46</g1>"
msgstr ""

msgctxt "1677ed905a22c4be56e84a9167ff286f"
msgid "<g1>Deleting a page break	46</g1>"
msgstr ""

msgctxt "ca385b6f9cbe5c79b16e50aa4456fb63"
msgid "<g1>Headers and footers	46</g1>"
msgstr ""

msgctxt "bb5b87760fa5d3fcfcfa32b7b46ddff6"
msgid "<g1>Setting a header or footer	46</g1>"
msgstr ""

msgctxt "3613295b32066e12b9c25641b416fd2d"
msgid "<g1></g1>What is Calc?<g2></g2>"
msgstr ""

msgctxt "9a95800c27bea94256d0a0a96e5bc991"
msgid ""
"Calc is the spreadsheet component of LibreOffice. You can enter data "
"(usually numerical) in a spreadsheet and then manipulate this data to "
"produce certain results."
msgstr ""

msgctxt "3177f3fcb159ab7306157361b8cfc94a"
msgid ""
"Alternatively, you can enter data and then use Calc in a “What if...” manner "
"by changing some of the data and observing the results without having to "
"retype the entire spreadsheet or sheet."
msgstr ""

msgctxt "6c36e2a958106701b660a80cbbd859e3"
msgid "<g1></g1>Other features provided by Calc include:"
msgstr ""

msgctxt "9fc259a36245d5a0ae0da0ea1366c59b"
msgid ""
"Functions, which can be used to create formulas to perform complex "
"calculations on data."
msgstr ""

msgctxt "eaab64bc4c3f4146cb6c6260c22a98c4"
msgid "Database functions, to arrange, store, and filter data."
msgstr ""

msgctxt "c302b07bf460ffc7f98a1754f2b15a08"
msgid "Dynamic charts; a wide range of 2D and 3D charts."
msgstr ""

msgctxt "2acf688925aa3f08f1a7070dfc17c58f"
msgid ""
"Macros, for recording and executing repetitive tasks; scripting languages "
"supported include LibreOffice Basic, Python, BeanShell, and JavaScript."
msgstr ""

msgctxt "3f254de3abfab5defbc32270f95bb5b7"
msgid "Ability to open, edit, and save Microsoft Excel spreadsheets."
msgstr ""

msgctxt "1917a4a93463231f18b8664ceebea9b6"
msgid ""
"Import and export of spreadsheets in multiple formats, including HTML, CSV, "
"PDF, and PostScript."
msgstr ""

msgctxt "3b0649c72650c313a357338dcdfb64ec"
msgid "Note"
msgstr ""

msgctxt "f827a2e106792d68134d3bdd503f030d"
msgid ""
"If you want to use macros written in Microsoft Excel using the VBA macro "
"code in LibreOffice, you must first edit the code in the LibreOffice Basic "
"IDE editor. See <g1>Chapter 13 Getting Started with Macros</g1> and <g2>Calc "
"Guide Chapter 12 Calc Macros</g2>."
msgstr ""

msgctxt "e5a8ad5920e7acb45f1dcabb4a43d32b"
msgid "<g1></g1>Spreadsheets, sheets and cells<g2></g2>"
msgstr ""

msgctxt "b85e4a24f46e59cbb38e1ed2bb5de60f"
msgid ""
"Calc works with elements called <g1></g1><g2>spreadsheets</g2>. Spreadsheets "
"consist of a number of individual <g3></g3><g4>sheets</g4>, each sheet "
"containing cells arranged in rows and columns. A particular cell is "
"identified by its row number and column letter."
msgstr ""

msgctxt "cd0a91f235d3462a3e4d714c6e21a418"
msgid ""
"<g1></g1>Cells hold the individual elements – text, numbers, formulas, and "
"so on – that make up the data to display and manipulate."
msgstr ""

msgctxt "8f6855e17b52d2e66e99b0af11b663cf"
msgid ""
"Each spreadsheet can have several sheets, and each sheet can have several "
"individual cells. In Calc, each sheet can have a maximum of 1,048,576 rows "
"(65,536 rows in Calc 3.2 and earlier) and a maximum of 1024 columns."
msgstr ""

msgctxt "759ee8dddcae24b3c644f33475c02770"
msgid "<g1></g1>Calc main window<g2></g2>"
msgstr ""

msgctxt "3d8ca444edf6681daa2ad248d74acd94"
msgid ""
"When Calc is started, the <g1></g1>main window opens (<g2>Figure 1</g2>). "
"The parts of this window are described below."
msgstr ""

msgctxt "077abffb951da269180a8d44219e18a2"
msgid "<g1></g1>Title bar<g2></g2>"
msgstr ""

msgctxt "91ac6ecd3deb1e5dca6fcabf61bd6a1e"
msgid ""
"The <g1></g1>Title bar, located at the top, shows the name of the current "
"spreadsheet. When the spreadsheet is newly created, its name is <g2>Untitled "
"X</g2>, where <g3>X</g3> is a number. When you save a spreadsheet for the "
"first time, you are prompted to enter a name of your choice."
msgstr ""

msgctxt "30a2da7bc895ea7657832e4357026b99"
msgid "<g1></g1><g2></g2>Menu bar<g3></g3>"
msgstr ""

msgctxt "49fb983bb2ff22529bc383516e76f4f2"
msgid ""
"The <g1></g1>Menu bar is where you select one of the menus and various sub-"
"menus appear giving you more options. You can also customize the Menu bar; "
"see <g2>Chapter 14 Customizing LibreOffice</g2> for more information."
msgstr ""

msgctxt "8740c92e2e15fef2fd717476c53cf5c0"
msgid "<g1><g2></g2></g1>"
msgstr ""

msgctxt "78dc2b39ce04161a95069f0fc40b33c9"
msgid ""
"<g1>Figure </g1><g2><g3>1</g3></g2><g4>:</g4> Calc main dialog, without "
"Sidebar"
msgstr ""

msgctxt "baddd540a398e57eb39ae605dc11082d"
msgid "<g1><g2><x3/><x4/></g2></g1>"
msgstr ""

msgctxt "05e4af39d0c9cc573a629ceb60ecceec"
msgid ""
"<g1>File</g1> – contains commands that apply to the entire document; for "
"example <g2>Open</g2>, <g3>Save</g3>, <g4>Wizards</g4>, <g5>Export as PDF</"
"g5>, <g6>Print</g6>, <g7>Digital Signatures</g7> and so on."
msgstr ""

msgctxt "2de8fcdd7e475285ef0a20c58fd779a1"
msgid ""
"<g1>Edit</g1> – contains commands for editing the document; for example "
"<g2>Undo</g2>, <g3>Copy</g3>, <g4>Changes</g4>, <g5>Fill</g5>, <g6>Plug-in</"
"g6> and so on."
msgstr ""

msgctxt "b9588eabfc7c8f3c9052536566483e2b"
msgid ""
"<g1>View</g1> – contains commands for modifying how the Calc user interface "
"looks; for example <g2>Toolbars</g2>, <g3>Column & Row Headers</g3>, "
"<g4>Full Screen</g4>, <g5>Zoom</g5> and so on."
msgstr ""

msgctxt "bc749077213d8f3530930708b79a58e6"
msgid ""
"<g1>Insert</g1> – contains commands for inserting elements into a "
"spreadsheet; for example <g2>Cells</g2>, <g3>Rows</g3>, <g4>Columns</g4>, "
"<g5>Sheets</g5>, <g6>Picture</g6> and so on."
msgstr ""

msgctxt "8801d40e5926288f0e88396d64c2458e"
msgid ""
"<g1>Format</g1> – contains commands for modifying the layout of a "
"spreadsheet; for example <g2>Cells</g2>, <g3>Page</g3>, <g4>Styles and "
"Formatting</g4>, <g5>Alignment</g5> and so on."
msgstr ""

msgctxt "fd89f2608a3e1bead56ebaca274427d5"
msgid ""
"<g1>Tools</g1> – contains various functions to help you check and customize "
"your spreadsheet, for example <g2>Spelling</g2>, <g3>Share Document</g3>, "
"<g4>Gallery</g4>, <g5>Macros</g5> and so on."
msgstr ""

msgctxt "b562594b0c2522582cfdf5b1cd233d44"
msgid ""
"<g1>Data</g1> – contains commands for manipulating data in your spreadsheet; "
"for example <g2>Define</g2> <g3>Range</g3>, <g4>Sort</g4>, <g5>Consolidate</"
"g5> and so on."
msgstr ""

msgctxt "ac862889f3898e249383f6e0e2043849"
msgid ""
"<g1>Window</g1> – contains commands for the display window; for example "
"<g2>New Window</g2>, <g3>Split</g3> and so on."
msgstr ""

msgctxt "f7f47c3cad1579955abc4ebaf793f6c7"
msgid ""
"<g1>Help</g1> – contains links to the help system included with the software "
"and other miscellaneous functions; for example <g2>Help</g2>, <g3>License "
"Information</g3>, <g4>Check for Updates</g4> and so on."
msgstr ""

msgctxt "d021c97f7939856187965c9870005974"
msgid "<g1></g1><g2></g2>Toolbars<g3></g3>"
msgstr ""

msgctxt "d9aa70a6b1a7c16eb97de552ecc1df9f"
msgid ""
"The default setting when Calc opens is for the Standard and Formatting "
"toolbars to be docked at the top of the workspace (<g1><g2>Figure 1</g2></"
"g1>)."
msgstr ""

msgctxt "8e1d29650ff372dcb93404e95c7668d5"
msgid ""
"<g1></g1>Calc toolbars can be either docked and fixed in place, or floating, "
"allowing you to move a toolbar into a more convenient position on your "
"workspace. Docked toolbars can be undocked and <g2>either </g2>moved to "
"different docked position on the workspace, or <g3>left</g3> <g4>as</g4> a "
"floating toolbar. Toolbars that are floating when opened can be docked into "
"a fixed position on your workspace."
msgstr ""

msgctxt "4b290891aedfbee2c8249851e9d18897"
msgid ""
"The default set of icons (sometimes called buttons) on toolbars provide a "
"wide range of common commands and functions. You can also remove or add "
"icons to toolbars, see <g1>Chapter 14 Customizing LibreOffice</g1> for more "
"information."
msgstr ""

msgctxt "a062c5bf3178c67e637bf2a643d009b7"
msgid "<g1></g1>Formula bar<g2></g2>"
msgstr ""

msgctxt "7487af6bbfa96549b4c993de23648c29"
msgid ""
"The <g1></g1>Formula Bar is located at the top of the sheet in the Calc "
"workspace. The Formula Bar is permanently docked in this position and cannot "
"be used as a floating toolbar. If the Formula Bar is not visible, go to "
"<g2>View</g2> on the Menu bar and select <g3>Formula Bar</g3>."
msgstr ""

msgctxt "d0b2fd8238bcd597663deb31bea49eb7"
msgid "Figure <g1>2</g1>: Formula bar"
msgstr ""

msgctxt "024f6ef62b9505fbae7c304e45fbbde6"
msgid ""
"Going from left to right and referring to <g1><g2>Figure 2</g2></g1>, the "
"Formula Bar consists of the following:"
msgstr ""

msgctxt "23369c999d9f3442af5d9973f743720f"
msgid ""
"<g1>Name Box</g1> – gives the <g2>current active </g2>cell reference using a "
"combination of a letter and number, for example A1. The letter indicates the "
"column and the number indicates the row of the selected cell."
msgstr ""

msgctxt "cdc13dc73eb3e100c05c4c84dceaba2a"
msgid ""
"<g1>Function Wizard</g1> <g2><g3><g4><g5></g5></g4></g3></g2> – <g6></"
"g6>opens a dialog from which you can search through a list of available "
"functions. This can be very useful because it also shows how the functions "
"are formatted."
msgstr ""

msgctxt "94b7cdf40a001097833d050abe92f35c"
msgid ""
"<g1>Sum</g1> <g2><g3><g4><g5></g5></g4></g3></g2> – clicking on the Sum icon "
"totals the numbers in the cells above the selected cell and then places the "
"total in the selected cell. If there are no numbers above the selected cell, "
"then the cells to the left are totaled."
msgstr ""

msgctxt "79e007782c74fdeed364c89c7d95ec94"
msgid ""
"<g1>Function</g1> <g2><g3><g4><g5></g5></g4></g3></g2> – clicking on the "
"Function icon inserts an equals (=) sign into the selected cell and the "
"<g6>Input line</g6>, allowing a formula to be entered."
msgstr ""

msgctxt "75161563fb363f7a34c18d53029a5281"
msgid ""
"<g1>Input line</g1> – displays the contents of the selected cell (data, "
"formula, or function) and allows you to edit the cell contents."
msgstr ""

msgctxt "a32d40936f83284e74f26922ad4461ef"
msgid ""
"You can also edit the contents of a cell directly in the cell itself by "
"double-clicking on the cell. When you enter new data into a cell, the Sum "
"and Function icons change to <g1>Cancel</g1> and <g2>Accept</g2> icons "
"<g3><g4><g5><g6></g6></g5></g4></g3>."
msgstr ""

msgctxt "89cd9e43a4b7cea009d91910199716b9"
msgid ""
"In a spreadsheet the term “function” covers much more than just mathematical "
"functions. See the <g1>Calc Guide Chapter 7 Using Formulas and Functions</"
"g1> for more information."
msgstr ""

msgctxt "3f339610a5654837d9e62224aa32b3fb"
msgid "<g1></g1><g2></g2>Spreadsheet layout<g3></g3>"
msgstr ""

msgctxt "3c284369c795dbbf82357243a7294350"
msgid "<g1></g1>Individual cells<g2></g2>"
msgstr ""

msgctxt "fd370b5f12cf0155831478435287f2e9"
msgid ""
"The main section of the workspace in Calc displays the <g1></g1>cells in the "
"form of a grid. Each cell is formed by the intersection of <g2>one </"
"g2>column and <g3>one</g3> row in the spreadsheet."
msgstr ""

msgctxt "4efea45434c1f1fc0575666742453a90"
msgid ""
"At the top of the columns and the left end of the rows are a series of "
"header boxes containing letters and numbers. The column headers use an alpha "
"character starting at A and go on to the right. The row headers use a "
"numerical character starting at 1 and go down."
msgstr ""

msgctxt "a10b2e7258f6bbd156a5306335a7dcce"
msgid ""
"These column and row headers form the cell references that appear in the "
"Name Box on the Formula Bar (<g1><g2>Figure 2</g2></g1>). If the headers are "
"not visible on your spreadsheet, go to <g3>View</g3> on the Menu bar and "
"select <g4>Column & Row Headers</g4>."
msgstr ""

msgctxt "fb8e7322a906ca4cd89bf2afd851ad10"
msgid "<g1></g1>Sheet tabs<g2></g2>"
msgstr ""

msgctxt "e3dee788553d701cd7cedcf352ceabe2"
msgid ""
"In Calc you can have more than one sheet in a spreadsheet. At the bottom of "
"the grid of cells in a spreadsheet <g1></g1>are sheet tabs indicating how "
"many sheets there are in your spreadsheet. Clicking on a tab enables access "
"to each individual sheet and displays that sheet. An active sheet is "
"indicated with a white tab (default Calc setup). You can also select "
"multiple sheets by holding down the <g2>Ctrl</g2> key while you click on the "
"sheet tabs."
msgstr ""

msgctxt "9fb61877ec8cea25d5734d64aa93c289"
msgid ""
"To change the default name for a sheet (Sheet1, Sheet2, and so on), right-"
"click on a sheet tab and select <g1>Rename Sheet</g1> from the context menu. "
"A dialog opens, in which you can type a new name for the sheet. Click "
"<g2>OK</g2> when finished to close the dialog."
msgstr ""

msgctxt "b0ce580b1c7f76bd604122f280137fd8"
msgid ""
"To change the color of a sheet tab, right-click on the tab and select "
"<g1>Tab Color</g1> from the context menu to open the <g2>Tab Color</g2> "
"dialog (<g3><g4>Figure 3</g4></g3>). Select your color and click <g5>OK</g5> "
"when finished to close the dialog. To add new colors to this color palette, "
"see <g6>Chapter 14 Customizing LibreOffice</g6> for more information."
msgstr ""

msgctxt "08cd1d2cb652ee643d66aef76715fda3"
msgid "Figure <g1>3</g1>: Tab color dialog"
msgstr ""

msgctxt "482413f2408ca4cfbc09a35dba3db058"
msgid "<g1><g2><g3><x4/><x5/></g3></g2></g1>"
msgstr ""

msgctxt "a23e0d6837b8049531f264100c9f3c1e"
msgid "<g1></g1>Status bar<g2></g2>"
msgstr ""

msgctxt "38007132420c3d3909f3847b43bce23f"
msgid ""
"The <g1></g1>Calc status bar (<g2><g3>Figure 4</g3></g2>) provides "
"information about the spreadsheet as well as quick and convenient ways to "
"change some of its features. Most of the fields are similar to those in "
"other components of LibreOffice; see <g4>Chapter 1 Introducing LibreOffice</"
"g4> in this guide and the <g5>Calc Guide Chapter 1 Introducing Calc</g5> for "
"more information."
msgstr ""

msgctxt "c99f8c8d120a074a223baccec9f69c14"
msgid "Figure <g1>4</g1>: Calc status bar"
msgstr ""

msgctxt "4eb880565ff27ba70f200f0b7bd982f3"
msgid "<g1></g1><g2><g3><g4><x5/><x6/></g4></g3></g2>"
msgstr ""

msgctxt "3875f16513af1102db94cfa1dc992fdf"
msgid "<g1></g1>Sidebar<g2></g2>"
msgstr ""

msgctxt "3f608492054d3e111ce5de9336b59ccf"
msgid ""
"The Calc Sidebar (<g1>View > Sidebar</g1>) is located on the right side of "
"the window. It is a mixture of toolbar and dialog and consists of five <g2></"
"g2>decks: Properties, Styles and Formatting, Gallery,  Navigator, and "
"Functions. Each deck has a corresponding icon on the <g3></g3>Tab panel to "
"the right of the sidebar, allowing you to switch between them."
msgstr ""

msgctxt "21c4137e95b95d72ab2e24efd6426c0f"
msgid "Figure <g1>5</g1>: Calc Sidebar with Properties open"
msgstr ""

msgctxt "ac1082618f70cfde04c78566b60d002d"
msgid "The decks are described below."
msgstr ""

msgctxt "60a51d7dfe9d00d7f820454a38f04d64"
msgid "<g1>Properties</g1>: This deck includes four content panels."
msgstr ""

msgctxt "a71e81d24aba839c65de95ebf80d369f"
msgid ""
"<g1>Character</g1>: Provides controls for formatting the text, such as font "
"family, size, and color. Some controls, such as superscript, only become "
"active when the text cursor is active in the Input line of the Formula bar "
"or the cell."
msgstr ""

msgctxt "6aca284fd76be22e551475e0a088517a"
msgid ""
"<g1>Alignment</g1>: Provides controls to align the text in various ways, "
"including horizontal and vertical alignment, wrapping, indenting, merging, "
"text orientation, and vertical stacking."
msgstr ""

msgctxt "78c73b326ae1d31fd68a6200145d7b3f"
msgid ""
"<g1>Cell Appearance:</g1> Provides controls to set the appearance options, "
"including cell background color, cell border formats including line color "
"and style, and grid lines."
msgstr ""

msgctxt "7fbf027c8accc0b0118d7684d1fb1d03"
msgid ""
"<g1></g1><g2>Number Format:</g2> Provides a way to quickly change the format "
"of numbers including decimals, currency, dates, or numeric text. Numerical "
"and label field controls for Forms are also available."
msgstr ""

msgctxt "a880f252bb6f08d2c1cea1969db3f548"
msgid ""
"Each of these panels has a <g1>More Options</g1> button, which opens a "
"dialog that gives a greater number of options. These dialogs lock the "
"document for editing until they are closed."
msgstr ""

msgctxt "9a95cba0cd955548314faec62c4a73f7"
msgid ""
"<g1>Styles and Formatting:</g1> This deck contains a single panel, which is "
"the same as that opened by selecting the <g2>Styles and Formatting</g2> "
"button (<g3>F11</g3>) from the Text Formatting toolbar."
msgstr ""

msgctxt "53587984adbf1f88d1f2717f0b978afb"
msgid ""
"<g1>Gallery</g1>: This deck contain a single panel, which is the same as "
"that opened by selecting <g2>Gallery</g2> from the Standard toolbar or "
"<g3>Tools > Gallery</g3> from the Menu bar."
msgstr ""

msgctxt "ad7c86374fa36d7aed46b4c69f3eb4b5"
msgid ""
"<g1>Navigator</g1>: This deck contains a single panel, which is essentially "
"the same as the Navigator window opened by clicking the <g2>Navigator</g2> "
"button on the Standard toolbar or selecting <g3>View > Navigator</g3> "
"(<g4>F5</g4>) from the Menu bar. Only the <g5>Contents</g5> button is absent "
"in the Sidebar’s Navigator panel."
msgstr ""

msgctxt "a7e0c56643fb60c96f5b02bfb2db70b1"
msgid ""
"<g1>Functions</g1>: This deck contains a single panel, which is the same as "
"the window opened by selecting <g2>Insert > Function List</g2> from the Menu "
"bar."
msgstr ""

msgctxt "dae499a3ad84927431014af61ebdf230"
msgid ""
"To the right side of the title bar of each open deck is a <g1>Close</g1> "
"button (<g2>X</g2>), which closes the deck to leave only the Tab bar open. "
"Clicking on any Tab button reopens the deck."
msgstr ""

msgctxt "9978d0d468fcd1e7be6a78038e216db0"
msgid ""
"The Sidebar can be hidden, or revealed if already hidden, by clicking on the "
"edge Hide/Show button. You can adjust the deck width by dragging on the left "
"edge of the sidebar."
msgstr ""

msgctxt "b67fc0ac9011c41ecf192ad2c9c3ec57"
msgid "<g1></g1>Opening a CSV file<g2></g2>"
msgstr ""

msgctxt "60ebd037f287525820c093853c7a46c4"
msgid ""
"<g1></g1><g2></g2>Comma-separated-values (CSV) files are spreadsheet files "
"in a text format where cell contents are separated by a character, for "
"example a comma or semi-colon. Each line in a CSV text file represents a row "
"in a spreadsheet. Text is entered between quotation marks; numbers are "
"entered without quotation marks."
msgstr ""

msgctxt "24d4920960873236c1ee7527d0cf93bc"
msgid "<g1></g1>To open a CSV file in Calc:"
msgstr ""

msgctxt "08180ecb17417b3c15296a512611041f"
msgid ""
"Choose <g1>File > Open</g1> on the Menu bar and locate the CSV file that you "
"want to open."
msgstr ""

msgctxt "47ea008a63cde8970b56821e518b5ff0"
msgid ""
"Select the file and click <g1>Open</g1>. By default, a CSV file has the "
"extension <g2>.csv</g2>. However, some CSV files may have a <g3>.txt</g3> "
"extension."
msgstr ""

msgctxt "be9b1097d62f7cdd37f66b41aba0b919"
msgid ""
"The <g1>Text Import</g1> dialog (<g2><g3>Figure 6</g3></g2>) opens allowing "
"you to select the various options available when importing a CSV file into a "
"Calc spreadsheet."
msgstr ""

msgctxt "a625ed7b8d0c1f9bc76c266ca2a28def"
msgid "Click <g1>OK</g1> to open and import the file."
msgstr ""

msgctxt "967171a552ffb6fe19eb1b98710b599c"
msgid ""
"The various options for importing CSV files into a Calc spreadsheet are as "
"follows:"
msgstr ""

msgctxt "c5153c389de4d4ce4261aaa0b38b5415"
msgid "<g1>Import</g1>"
msgstr ""

msgctxt "2a5f09eb15bb6cc0f8c30c3bb278efe3"
msgid ""
"<g1>Character Set</g1> – specifies the character set to be used in the "
"imported file."
msgstr ""

msgctxt "2c83a68feeecd4ee7cf4b3fd5d7f5e11"
msgid ""
"<g1>Language</g1><g2> – determines how the number strings are imported.<x3/"
"><x4/>If Language is set to Default for CSV import, Calc will use the "
"globally set language. If Language is set to a specific language, that "
"language will be used when importing numbers.</g2>"
msgstr ""

msgctxt "aaee1eb34202e5205e15294995cb955f"
msgid ""
"<g1>From Row</g1> – specifies the row where you want to start the import. "
"The rows are visible in the preview window at the bottom of the dialog."
msgstr ""

msgctxt "1a2f3d80ad9c06429d909a0acb5adfc1"
msgid "Figure <g1>6</g1>: Text Import dialog"
msgstr ""

msgctxt "e306f62d352b59d564bd65b744515dc8"
msgid "<g1></g1><g2><g3><x4/><x5/></g3></g2>"
msgstr ""

msgctxt "32d800fffd695c2f5ce1c54f5d4b0f09"
msgid ""
"<g1>Separator Options</g1> – specifies whether your data uses separators or "
"fixed widths as delimiters."
msgstr ""

msgctxt "5d55b28e30816bfacf2e930706049e72"
msgid ""
"<g1>Fixed width</g1> – separates fixed-width data (equal number of "
"characters) into columns. Click on the ruler in the preview window to set "
"the width."
msgstr ""

msgctxt "ee1ff72dbeb320aafa74b4d455b02a17"
msgid ""
"<g1>Separated by</g1> – select the separator used in your data to delimit "
"the data into columns. When you select <g2>Other</g2>, you specify the "
"character used to separate data into columns. This custom separator must "
"also be contained in your data."
msgstr ""

msgctxt "196a3f3a797e750514c4b21788712812"
msgid ""
"<g1>Merge delimiters</g1> – combines consecutive delimiters and removes "
"blank data fields."
msgstr ""

msgctxt "c08a2922a9ec966eb9c030351f8e3d3b"
msgid "<g1>Text delimiter</g1> – select a character to delimit text data."
msgstr ""

msgctxt "89ffa344a0ca6b1ff5a51f22fdb0cd94"
msgid "<g1>Other options</g1>"
msgstr ""

msgctxt "18c524fef36b23a3669b85aec97f5632"
msgid ""
"<g1>Quoted fields as text</g1> – when this option is enabled, fields or "
"cells whose values are quoted in their entirety (the first and last "
"characters of the value equal the text delimiter) are imported as text."
msgstr ""

msgctxt "0dac3d26bb40559ee46b18812001855b"
msgid ""
"<g1>Detect special numbers</g1> – <g2>w</g2><g3>hen this option is enabled, "
"Calc will automatically detect all number formats, including special number "
"formats such as dates, time, and scientific notation. The selected language "
"</g3>also <g4>influences how such special numbers are detected, since "
"different languages and regions many have different conventions for such "
"special numbers.</g4>"
msgstr ""

msgctxt "b6b225f2178d7799ffa2c37866b0bf8d"
msgid ""
"<g1>W</g1><g2>hen this option is disabled, Calc will detect and convert only "
"decimal numbers. The rest, including numbers formatted in scientific "
"notation, will be imported as text. A decimal number string can have digits "
"0-9, thousands separators, and a decimal separator. Thousands separators and "
"decimal separators may vary with the selected language and region.</g2>"
msgstr ""

msgctxt "a2cc5726d4a54ac9eaafdb88d65ad751"
msgid ""
"<g1></g1><g2>Fields</g2> – shows how your data will look when it is "
"separated into columns."
msgstr ""

msgctxt "d0d255ffce3b1d3b07bb5323886432c4"
msgid ""
"<g1>Column type</g1> – select a column in the preview window and select the "
"data type to be applied the imported data."
msgstr ""

msgctxt "e7dd1f18a7cdc176908ba5da3f7d9d41"
msgid "<g1>Standard </g1>– Calc determines the type of data."
msgstr ""

msgctxt "af708ae25a6095f1541d11e6591b2679"
msgid "<g1>Text</g1> – imported data are treated as text."
msgstr ""

msgctxt "5997f47b195485ce1ba6064cc606b4e4"
msgid ""
"<g1>US English</g1> – numbers formatted in US English are searched for and "
"included regardless of the system language. A number format is not applied. "
"If there are no US English entries, the <g2>Standard</g2> format is applied."
msgstr ""

msgctxt "119a89d5bd1bcfccc6a90cb37bbf7fe4"
msgid "<g1>Hide</g1> – the data in the column are not imported."
msgstr ""

msgctxt "cd24f16320e3d01486b3e77209106327"
msgid "<g1></g1><g2></g2><g3></g3>Saving spreadsheets<g4></g4>"
msgstr ""

msgctxt "dc9433923367e0ec8c46e4ef354911b4"
msgid ""
"To save a spreadsheet, see <g1>Chapter 1 Introducing LibreOffice</g1> for "
"more details on how to save files manually or automatically. Calc can also "
"save spreadsheets in a range of formats and also export spreadsheets to PDF, "
"HTML and XHTML file formats; see the <g2>Calc Guide Chapter 6 Printing, "
"Exporting, and E-mailing</g2> for more information."
msgstr ""

msgctxt "32a18493373ab7cf51183664eabee9df"
msgid "<g1></g1><g2></g2>Saving in other spreadsheet formats<g3></g3>"
msgstr ""

msgctxt "35998c1337713ddf666a0a64ba750f34"
msgid ""
"If you need to exchange files with users who are unable to receive "
"spreadsheet files in Open Document Format (ODF) (<g1>*.ods</g1>), which Calc "
"uses as default format, you can save a spreadsheet in another format."
msgstr ""

msgctxt "ee37a00f2c2935ebb45f944978268836"
msgid ""
"Save your spreadsheet in Calc spreadsheet file format (<g1>*.ods</g1>)."
msgstr ""

msgctxt "aee816b1f58d88f96f36245f1ead2f8c"
msgid ""
"Select <g1>File > Save As</g1> on the Menu bar to open the <g2>Save As</g2> "
"dialog (<g3><g4>Figure 7</g4></g3>)."
msgstr ""

msgctxt "3de01d3af10e3ab92ef8cfdf686445ac"
msgid "Figure <g1>7</g1>: Save As dialog"
msgstr ""

msgctxt "a8888c4eccfa1003fb704bed1380e68d"
msgid ""
"In <g1>File name</g1>, if you wish, enter a new file name for the "
"spreadsheet."
msgstr ""

msgctxt "3a97be7fb6e1e74864973ab874e10c98"
msgid ""
"In <g1>File type</g1> drop-down menu, select the type of spreadsheet format "
"you want to use."
msgstr ""

msgctxt "9df432af777a7bb301fc741eb63293bd"
msgid ""
"If <g1>Automatic file name extension</g1> is selected, the correct file "
"extension for the spreadsheet format you have selected will be added to the "
"file name."
msgstr ""

msgctxt "e3977ee1beb4e6521ba5b06c5c694fb5"
msgid "<g1></g1>Click <g2>Save</g2>."
msgstr ""

msgctxt "57d746247a295722190bbcddcf6d1f2a"
msgid ""
"Each time you click <g1>Save</g1>, the <g2>Confirm File Format</g2> dialog "
"opens (<g3><g4>Figure 8</g4></g3>). Click <g5>Use [xxx] Format</g5> to "
"continue saving in your selected spreadsheet format or click <g6>Use ODF "
"Format</g6> to save the spreadsheet in Calc ODS format."
msgstr ""

msgctxt "56afb2106377d6ff2b799a81254e35db"
msgid ""
"If you select <g1>Text CSV</g1> format (<g2>*.csv</g2>) for your "
"spreadsheet, the <g3>Export Text File</g3> dialog (<g4><g5>Figure 9</g5></"
"g4>) opens allowing you to select the character set, field delimiter, text "
"delimiter and so on to be used for your CSV file."
msgstr ""

msgctxt "dd91e7fe1c39a20a8226678d1dfeb843"
msgid "Figure <g1>8</g1>: Confirm File Format dialog"
msgstr ""

msgctxt "d0c3d98561190b54c1432801b9eb8a15"
msgid "Figure <g1>9</g1>: Export Text File dialog for CSV files"
msgstr ""

msgctxt "12ae2a12586001e30745cb0457586ae3"
msgid "Tip"
msgstr ""

msgctxt "6a83b652c52afe78d60bbc4cda748b33"
msgid ""
"To have Calc save documents by default in a file format other than the "
"default ODF format, go to <g1>Tools > Options > Load/Save > General</g1>. In "
"<g2>Default file format</g2> and<g3> </g3><g4>ODF settings > Document type</"
"g4>, select <g5>Spreadsheet,</g5> then in <g6>Always save as</g6>, select "
"your preferred file format."
msgstr ""

msgctxt "f7eb730da2f091fb7cd334070c76270d"
msgid "<g1></g1><g2></g2>Navigating within spreadsheets<g3></g3>"
msgstr ""

msgctxt "94be49c82700eb17fca95f3abff670ef"
msgid ""
"Calc provides many ways <g1></g1>to navigate within a spreadsheet from cell "
"to cell and sheet to sheet. You can generally use the method you prefer."
msgstr ""

msgctxt "e01538a7f03b0827bdf452881f191075"
msgid "<g1></g1>Cell navigation<g2></g2>"
msgstr ""

msgctxt "fb289cefc0b77adfad52800455211ea7"
msgid ""
"When a cell is selected or in focus, the cell borders are emphasized. When a "
"group of cells is selected, the cell area is colored. The color of the cell "
"border emphasis and the color of a group of selected cells depends on the "
"operating system being used and how you have set up LibreOffice."
msgstr ""

msgctxt "7f67ce577a1c28f36054e3d437c2851d"
msgid ""
"<g1></g1><g2>Using the mouse</g2> – place the mouse pointer over the cell "
"and click the left mouse button. To move the focus to another cell using the "
"mouse, simply move the mouse pointer to the cell where you want the focus to "
"be and click the left mouse button."
msgstr ""

msgctxt "24ac4c16d5244ba577b48ce8317f5608"
msgid ""
"<g1></g1><g2>Using a cell reference</g2><g3></g3> – highlight or delete the "
"existing cell reference in the Name Box on the Formula Bar (<g4><g5>Figure "
"2</g5></g4> on page <g6><g7>8</g7></g6>). Type the new cell reference of the "
"cell you want to move to and press <g8>Enter</g8> key. Cell references are "
"case-insensitive: for example, typing either a3 or A3 will move the focus to "
"cell A3."
msgstr ""

msgctxt "54f17f12cf625b474e42f182286fa809"
msgid ""
"<g1>Using the Navigator</g1> – click on <g2></g2>the <g3>Navigator</g3> icon "
"<g4><g5><g6></g6></g5></g4> on the Standard toolbar or press the <g7>F5</g7> "
"key to open the <g8>Navigator</g8> dialog (<g9><g10>Figure 10</g10></g9>) or "
"click the <g11>Navigator Tab</g11> button in the open Sidebar. Type the cell "
"reference into the Column and Row fields and press the <g12>Enter</g12> key."
msgstr ""

msgctxt "ecdad884aeca89acd1f58745cf8eda0f"
msgid ""
"<g1>Using the Enter key</g1> – pressing <g2>Enter</g2> moves the cell focus "
"down in a column to the next row. Pressing <g3>Shift+Enter</g3> moves the "
"focus up in a column to the next row."
msgstr ""

msgctxt "28cc6f3b9f07ffc144a6bbd604de4aa5"
msgid ""
"<g1>Using the Tab key</g1> – pressing Tab moves the cell focus right in a "
"row to the next column. Pressing <g2>Shift+Tab</g2> moves the focus to the "
"left in a row to the next column."
msgstr ""

msgctxt "e570713dbb76c940578e191f9cfe6af8"
msgid ""
"<g1>Using the arrow keys</g1> – pressing<g2></g2><g3></g3> the arrow keys on "
"the keyboard moves the cell focus in the direction of the arrow pressed."
msgstr ""

msgctxt "553398b4c9ac68f9c0723e8961f48502"
msgid "Figure <g1>10</g1>: Navigator dialog in Calc"
msgstr ""

msgctxt "b232246e67e72e75ca47576ca83048b2"
msgid ""
"<g1>Using Home</g1>, <g2>End</g2>, <g3>Page Up</g3> and <g4>Page Down</g4>"
msgstr ""

msgctxt "17b9ea1715671869f6d104dac6b71888"
msgid "<g1>Home</g1> moves the cell focus to the start of a row."
msgstr ""

msgctxt "14defdf68d88a6ad95f0c4b963ea97c6"
msgid ""
"<g1>End</g1> moves the cell focus to the last cell on the right in the row "
"that contains data."
msgstr ""

msgctxt "48ce36c0249af0dd41cdf82993878bc2"
msgid ""
"<g1>Page Down</g1> moves the cell focus down one complete screen display."
msgstr ""

msgctxt "267ff526dd3d8afd2322135db6571623"
msgid "<g1>Page Up</g1> moves the cell focus up one complete screen display."
msgstr ""

msgctxt "f484c6c23523f98eba1d976c3cd05665"
msgid "<g1></g1><g2></g2><g3></g3>Sheet navigation<g4></g4>"
msgstr ""

msgctxt "b3e83288a7eb624df017a0a41a42efc4"
msgid ""
"Each sheet in a spreadsheet is independent of the other sheets in a "
"spreadsheet, though references can be linked from one sheet to another sheet."
" There are three ways to navigate between different sheets in a spreadsheet."
msgstr ""

msgctxt "103d9292e0814473c976e5b4fc5c3be6"
msgid ""
"<g1>Using the Navigator</g1> – when the Navigator is open (<g2><g3>Figure "
"10</g3></g2>), double-clicking on any of the listed sheets selects the sheet."
""
msgstr ""

msgctxt "c4ce4d9fc4268e67176fed9df6528bfa"
msgid ""
"<g1></g1><g2>Using the keyboard</g2> – using key combinations <g3>Ctrl+Page "
"Down</g3> moves one sheet to the right and <g4>Ctrl+Page Up</g4> moves one "
"sheet to the left."
msgstr ""

msgctxt "bddb713326d2656156b9344d2180cc7d"
msgid ""
"<g1>Using the mouse</g1> – clicking on one of the sheet tabs at the bottom "
"of the spreadsheet selects that sheet."
msgstr ""

msgctxt "942b29d8c0dfc0cb297f50b76e716063"
msgid ""
"If your spreadsheet contains a lot of sheets, then some of the sheet tabs "
"may be hidden behind the horizontal scroll bar at the bottom of the screen. "
"If this is the case:"
msgstr ""

msgctxt "8a53bdb8b7a5a68d7132ebd3c58a4003"
msgid ""
"Using the four buttons to the left of the sheet tabs can move the tabs into "
"view (<g1>Figure 11</g1>)."
msgstr ""

msgctxt "edfdefe8f212b206da7a1e1d7091ca01"
msgid "Dragging the scroll bar edge to the right may reveal all the tabs."
msgstr ""

msgctxt "c90e73c5741874c35a132d14cb30d764"
msgid ""
"Right-clicking on any of the arrows opens a context menu where you can "
"select a sheet (see <g1>Figure 12</g1>)."
msgstr ""

msgctxt "bae78bc626db42f84183524465ebd9de"
msgid ""
"When you insert a new sheet into your spreadsheet, Calc automatically uses "
"the next number in the numeric sequence as a name. Depending on which sheet "
"is open when you insert a new sheet, and the method you use to insert a new "
"sheet, the new sheet may not be in numerical order. It is recommended to "
"rename sheets in your spreadsheet to make them more recognizable."
msgstr ""

msgctxt "d8d7b970c7bf5447ba195f05d74d0fe3"
msgid "Figure <g1>11</g1>: Navigating sheet tabs"
msgstr ""

msgctxt "2969148ce0b260927f4db55301731130"
msgid "Figure <g1>12</g1>: Right-click any arrow button"
msgstr ""

msgctxt "b0e0f9eada383d9d2f5d6df13843efc4"
msgid "<g1></g1>Keyboard navigation<g2></g2>"
msgstr ""

msgctxt "a5e65661881ff46f9ee7abbcf52ca4ae"
msgid ""
"Pressing a key or a combination of keys allows you to navigate a spreadsheet "
"using the keyboard. A key combination is where you press more than one key "
"together, for example <g1>Ctrl+Home</g1> key combination to move to cell A1. "
"<g2><g3>Table 1</g3></g2> lists the keys and key combinations you can use "
"for spreadsheet navigation in Calc."
msgstr ""

msgctxt "b764d64df4d4562e4291c43336992e18"
msgid "<g1></g1>Table <g2>1</g2>. Keyboard cell navigation"
msgstr ""

msgctxt "89fd3695e7d8c39822cbec979aa00be3"
msgid "Keyboard shortcut"
msgstr ""

msgctxt "a7835ef5539e9eb04f482c370bcdfe23"
msgid "Cell navigation"
msgstr ""

msgctxt "c18015634df324f3d8d655cc860fbe78"
msgid "<g1>→</g1>"
msgstr ""

msgctxt "e4bc8c4dd2ac85fd7629032d4da5dd6c"
msgid "Moves cell focus right one cell"
msgstr ""

msgctxt "a0d9e9b9f5a27826700d19f8c489a7ac"
msgid "<g1>←</g1>"
msgstr ""

msgctxt "9ed9013b0dea0e9206a44ca5601ded55"
msgid "Moves cell focus left one cell"
msgstr ""

msgctxt "8ae68b16d825f6fba2bca52228c316f1"
msgid "<g1>↑</g1>"
msgstr ""

msgctxt "017b7935e6c8dbbf74442a3fc5612e30"
msgid "Moves cell focus up one cell"
msgstr ""

msgctxt "db4cc6af69d47e6f7e93af74ffac7882"
msgid "<g1>↓</g1>"
msgstr ""

msgctxt "970a53fa998ce25570d2050387d93a36"
msgid "Moves cell focus down one cell"
msgstr ""

msgctxt "58c8e1226e3b5ff375ae24536b3c3faa"
msgid "<g1>Ctrl+→</g1>"
msgstr ""

msgctxt "efb29f660fc81a0d0289da9e33d6c5f8"
msgid ""
"Moves cell focus to the first column on the right containing data in that "
"row if cell focus is on a blank cell."
msgstr ""

msgctxt "08111e5b6ecf4091eac2872bd8b1b4e7"
msgid ""
"Moves cell focus to the last column on the right <g1>in the same range of "
"occupied cells </g1>in that row if cell focus is on a cell containing data."
msgstr ""

msgctxt "cc2d729c0a0ac89a7da6ba0cc44af340"
msgid ""
"Moves cell focus to the last column on the right in the spreadsheet if there "
"are no more cells containing data."
msgstr ""

msgctxt "fb33fa52a9763f2c2aba8ae68be5c0d1"
msgid "<g1>Ctrl+←</g1>"
msgstr ""

msgctxt "c8922e6f86c4e3b974e58f7b58bd9ad6"
msgid ""
"Moves cell focus to the last column on the left containing data in that row "
"if cell focus is on a blank cell."
msgstr ""

msgctxt "9f6fe6d05e74b0b2666584691109228d"
msgid ""
"Moves cell focus to the first column on the left <g1>in the same range of "
"occupied cells in that row</g1> if cell focus is on a cell containing data."
msgstr ""

msgctxt "83ed897d5fd95800691ea1a43b0f5be2"
msgid ""
"Moves cell focus to the first column in that row if there are no more cells "
"containing data."
msgstr ""

msgctxt "b2446d7e2563e4182befcec1fa9e6d95"
msgid "<g1>Ctrl+↑</g1>"
msgstr ""

msgctxt "93ff5e27e759d94cee885c630afa3482"
msgid ""
"Moves cell focus from a blank cell to the first cell above containing data "
"in the same column."
msgstr ""

msgctxt "4143b0590a6704606f266881f7f00fc2"
msgid ""
"Moves cell focus <g1>to the first row in the same range of occupied cells if "
"cell focus is on a cell containing data.</g1>"
msgstr ""

msgctxt "1c08aa257f5c6a9ce210257ef6f34770"
msgid ""
"Moves cell focus from the last cell containing data to the cell in the same "
"column in the last row of the spreadsheet."
msgstr ""

msgctxt "3ba222212979cfffeb22b07b000fa48f"
msgid "<g1>Ctrl+↓</g1>"
msgstr ""

msgctxt "e06ea0e8c907efb8e85e82c265d95c4d"
msgid ""
"Moves cell focus from a blank cell to the first cell below containing data "
"in the same column."
msgstr ""

msgctxt "847657f1901b49fa2003c3bf5212932b"
msgid ""
"Moves cell focus <g1>to the last row in the same range of occupied cells in "
"that column if cell focus is on a cell containing data.</g1>"
msgstr ""

msgctxt "ddca15004a68734c66724e1bf1535fe4"
msgid "<g1>Ctrl+Home</g1>"
msgstr ""

msgctxt "76f9c374b68c6af860464dd688151588"
msgid ""
"Moves cell focus from anywhere on the spreadsheet to Cell A1 on the same "
"sheet."
msgstr ""

msgctxt "3c5f41b025beeff4adc9eda9d9ec67e7"
msgid "<g1>Ctrl+End</g1>"
msgstr ""

msgctxt "1e10a72539bb22dc3407e31d630cda40"
msgid ""
"Moves cell focus from anywhere on the spreadsheet to the last cell in the "
"lower right-hand corner of the rectangular area of cells containing data on "
"the same sheet."
msgstr ""

msgctxt "07db7e4f42958614d6b05cc42f6ad7f4"
msgid "<g1>Alt+Page Down</g1>"
msgstr ""

msgctxt "a788b6f00efe4bcbdbe93b450a18a33c"
msgid "Moves cell focus one screen to the right (if possible)."
msgstr ""

msgctxt "cf3a2b1da5eb63f081a8b92012e0b191"
msgid "<g1>Alt+Page Up</g1>"
msgstr ""

msgctxt "dfe2e308f63f5a799a8f67ee968502ab"
msgid "Moves cell focus one screen to the left (if possible)."
msgstr ""

msgctxt "6177b370001f5ab4a65c41b969391a65"
msgid "<g1>Ctrl+Page Down</g1>"
msgstr ""

msgctxt "a3367796be89fb1f7e33109d14bf08a6"
msgid ""
"Moves cell focus to the same cell on the next sheet to the right in sheet "
"tabs if the spreadsheet has more than on sheet."
msgstr ""

msgctxt "86075978afdab43dfdf2ca675c7811a2"
msgid "<g1>Ctrl+Page Up</g1>"
msgstr ""

msgctxt "3538f2d8f4f1ab6d18e11ea74ab51187"
msgid ""
"Moves cell focus to the same cell on the next sheet to the left in sheet "
"tabs if the spreadsheet has more than on sheet."
msgstr ""

msgctxt "fb050942e3aa93db5178b130a1a14424"
msgid "<g1>Tab</g1>"
msgstr ""

msgctxt "6fe969d8d8c5b214e5d9eb6e1cd372cc"
msgid "Moves cell focus to the next cell on the right"
msgstr ""

msgctxt "b8540de82e0917584f74af5c4caa25d2"
msgid "<g1>Shift+Tab</g1>"
msgstr ""

msgctxt "10ae3050c8eb66b165207d87995e73d0"
msgid "Moves cell focus to the next cell on the left"
msgstr ""

msgctxt "7f0df3b1682a4cd64ad495e9485866cd"
msgid "<g1>Enter</g1>"
msgstr ""

msgctxt "d4f246bfbe8c1cc53ac05a2f89570042"
msgid "Down one cell (unless changed by user)"
msgstr ""

msgctxt "f2098d3d1426967a091834fda2adccc7"
msgid "<g1>Shift+Enter</g1>"
msgstr ""

msgctxt "4e40046e591070ecffac75db360c2900"
msgid "Up one cell (unless changed by user)"
msgstr ""

msgctxt "baf5d1e8602dc9ab695b49bec0b4b3a7"
msgid "<g1></g1><g2></g2><g3></g3>Customizing<g4></g4> the Enter key<g5></g5>"
msgstr ""

msgctxt "8a1d349ca488e6c2535574786b475c40"
msgid ""
"You can customize the direction in which the <g1>Enter</g1> key moves the "
"cell focus by going to <g2>Tools > Options > LibreOffice Calc > General</g2>."
" Select the direction cell focus moves from the drop-down list. Depending on "
"the file being used or the type of data being entered, setting a different "
"direction can be useful. The <g3>Enter</g3> key can also be used to switch "
"into and out of editing mode. Use the first two options under <g4>Input "
"settings</g4> in <g5><g6>Figure 13</g6></g5> to change the <g7>Enter</g7> "
"key settings."
msgstr ""

msgctxt "167466b2b93c991a5bc98f5ddd72d7bc"
msgid "Figure <g1>13</g1>: Customizing the Enter key"
msgstr ""

msgctxt "d46224732b957ca21452a82e36352abb"
msgid "<g1><g2><g3><g4><x5/><x6/></g4></g3></g2></g1>"
msgstr ""

msgctxt "920f887547310e7a0a9763c98571fe2e"
msgid "<g1></g1>Selecting items in a spreadsheet<g2></g2>"
msgstr ""

msgctxt "bdb92744f069d5167c7dc56b2ea329b8"
msgid "<g1></g1><g2></g2><g3></g3>Selecting cells<g4></g4>"
msgstr ""

msgctxt "58197e32dd090f9ae790290d6432df76"
msgid "<g1></g1>Single cell<g2></g2>"
msgstr ""

msgctxt "91bec4432e32b50dcd8b83dca56b860d"
msgid ""
"Left-click in the cell. You can verify your selection by looking in the Name "
"Box on the Formula Bar (<g1>Figure 2</g1> on page <g2>8</g2>)."
msgstr ""

msgctxt "a7f739338d2079fb5b1e65dfedd4b13d"
msgid "<g1></g1>Range of contiguous cells<g2></g2>"
msgstr ""

msgctxt "a6f9366398124fb376e8f17e9a98b0b8"
msgid ""
"<g1></g1>A range of cells can be selected using the keyboard or the mouse."
msgstr ""

msgctxt "596e8803b1e5dad348197c670591ed68"
msgid "To select a range of cells by dragging the mouse cursor:"
msgstr ""

msgctxt "a7d6948b4d3635d25fb7785fd6e995bd"
msgid "Click in a cell."
msgstr ""

msgctxt "30289a0418b9b64b45c47ccf38a7662c"
msgid "Press and hold down the left mouse button."
msgstr ""

msgctxt "35f5b8b5fb2b8034736d2e8d09249496"
msgid "Move the mouse around the screen."
msgstr ""

msgctxt "6ad7e4c5987dc5f854d16d5ac23e72d4"
msgid ""
"Once the desired block of cells is highlighted, release the left mouse "
"button."
msgstr ""

msgctxt "a78a880c9e1cc62b9a603458dafa1126"
msgid "To select a range of cells without dragging the mouse:"
msgstr ""

msgctxt "9d7829ab6862e6cbbcd4744ce91973e3"
msgid "Click in the cell which is to be one corner of the range of cells."
msgstr ""

msgctxt "4d55952ad7594ef5f4f6dacacd0e38ae"
msgid "Move the mouse to the opposite corner of the range of cells."
msgstr ""

msgctxt "bf618d6fdbfedcf053ed30b9917c3176"
msgid "Hold down the <g1>Shift</g1> key and click."
msgstr ""

msgctxt "aaa26deebaaddb498c5686ab0ed0bd3e"
msgid ""
"You can also select a contiguous range of cells by first clicking in the "
"<g1>Selection mode</g1> field on the Status Bar (<g2><g3>Figure 4</g3></g2> "
"on page <g4><g5>10</g5></g4>) and selecting <g6>Extending selection</g6> "
"before clicking in the opposite corner of the range of cells. Make sure to "
"change back to <g7>Standard selection</g7> or you may find yourself "
"extending a cell selection unintentionally."
msgstr ""

msgctxt "7d7ec4171a3fcd09947ccc011ebfa1f4"
msgid "<g1></g1>To select a range of cells without using the mouse:"
msgstr ""

msgctxt "ca6e18e14418eb25a7dd0cea99d5f76b"
msgid "Select the cell that will be one of the corners in the range of cells."
msgstr ""

msgctxt "6e312f38bc402ea7c47ada43df56acfe"
msgid ""
"While holding down the <g1>Shift</g1> key, use the cursor arrows to select "
"the rest of the range."
msgstr ""

msgctxt "5e11ff40d39f8211d59bca97713bc54b"
msgid ""
"You can also directly select a range of cells using the Name Box. Click into "
"the Name Box on the Formula Bar (<g1><g2>Figure 2</g2></g1> on page "
"<g3><g4>8</g4></g3>). To select a range of cells, enter the cell reference "
"for the upper left-hand cell, followed by a colon (:), and then the lower "
"right-hand cell reference. For example, to select the range that would go "
"from A3 to C6, you would enter <g5>A3:C6</g5>."
msgstr ""

msgctxt "8caf8d86a46d8896dfd8b7ab2f9528f4"
msgid "<g1></g1>Range of non-contiguous cells<g2></g2>"
msgstr ""

msgctxt "22037c55b61286d72a36ce3aba23135d"
msgid "Select the cell or range of cells using one of the methods above."
msgstr ""

msgctxt "f95f8a3e70dd3b13c5de1edec94ae7d9"
msgid "Move the mouse pointer to the start of the next range or single cell."
msgstr ""

msgctxt "bc7803c6e8f108debe40ed8926195b49"
msgid ""
"Hold down the <g1>Ctrl</g1> key and click or click-and-drag to select "
"another range of cells to add to the first range."
msgstr ""

msgctxt "b754213dbd04fcb6d971851384e65b52"
msgid "Repeat as necessary."
msgstr ""

msgctxt "88873e0c4075a6c11cea1c14a8b5f4c0"
msgid "<g1></g1><g2></g2>Selecting<g3></g3> columns and rows<g4></g4>"
msgstr ""

msgctxt "1cfd6c65b97c947d43322ba75dd1101d"
msgid "<g1></g1>Single column or row<g2></g2>"
msgstr ""

msgctxt "e3f8a0892aa71c26c9b2cd2555179b2f"
msgid ""
"To select a single column, click on the column header (<g1>Figure 1</g1> on "
"page <g2>7</g2>)."
msgstr ""

msgctxt "1434b577f4247c4480c039a55b1f13fa"
msgid "To select a single row, click on the row header."
msgstr ""

msgctxt "86c0ac10806ca0f91fb6387cec5ba810"
msgid "<g1></g1>Multiple columns or rows<g2></g2>"
msgstr ""

msgctxt "106f533746846cee2b51d3de63ac1cb3"
msgid "To select multiple columns or rows that are contiguous:"
msgstr ""

msgctxt "98b1f7c85497dc1a6167eabe8698aaf4"
msgid "Click on the first column or row in the group."
msgstr ""

msgctxt "0b8e4f1187e418d64f13dd3d6459ded4"
msgid "Hold down the <g1>Shift</g1> key."
msgstr ""

msgctxt "b2f61b3cfc8f20c56123a6f4e272f5b2"
msgid "Click the last column or row in the group."
msgstr ""

msgctxt "0c23164a6d7c8ab2e7da536325069aac"
msgid "To select multiple columns or rows that are not contiguous:"
msgstr ""

msgctxt "5d002987e77b8d8ec1bffb4e9b4a375e"
msgid "Hold down the <g1>Ctrl</g1> key."
msgstr ""

msgctxt "99f778b875ecdeea60197d25aee3380b"
msgid ""
"Click on all of the subsequent columns or rows while holding down the "
"<g1>Ctrl</g1> key."
msgstr ""

msgctxt "579688ca7145447b6ae37be78cc23089"
msgid "<g1></g1>Entire sheet<g2></g2>"
msgstr ""

msgctxt "3e33c0040dfea28173e33074c068b369"
msgid ""
"To select the entire sheet, click on the small box between the column "
"headers and the row headers (<g1><g2>Figure 14</g2></g1>), or use the key "
"combination <g3>Ctrl+A</g3> to select the entire sheet, or go to <g4>Edit</"
"g4> on the Menu bar and select <g5>Select All</g5>."
msgstr ""

msgctxt "fb6965ca362b443b4a007cf8f14be845"
msgid "Figure <g1>14</g1>: Select All box"
msgstr ""

msgctxt "cb7cbb19a36f4c190f7530d8654d6cc2"
msgid "<g1></g1><g2></g2><g3></g3><g4></g4>Selecting sheets<g5></g5>"
msgstr ""

msgctxt "9cacac9f529eead7a2bb0371cb217e54"
msgid ""
"You can select either one or multiple sheets in Calc. It can be advantageous "
"to select multiple sheets, especially when you want to make changes to many "
"sheets at once."
msgstr ""

msgctxt "5085f534a15b8c151416ba296cc325c8"
msgid "<g1></g1>Single sheet<g2></g2>"
msgstr ""

msgctxt "e18197d7067e0c6e33145e5f6f454fbe"
msgid ""
"Click on the sheet tab for the sheet you want to select. The tab for the "
"selected sheet becomes white (default Calc setup)."
msgstr ""

msgctxt "2f87413ba7f79afae5dd78c289392af7"
msgid "<g1></g1>Multiple contiguous sheets<g2></g2>"
msgstr ""

msgctxt "17bf87e33e9b1a14d4503efd0e39d0a4"
msgid "To select multiple contiguous sheets:"
msgstr ""

msgctxt "fcacd58df83de778b5adcda5f3281641"
msgid "Click on the sheet tab for the first desired sheet."
msgstr ""

msgctxt "f3f779c970e248dc436debf404f58d18"
msgid "Move the mouse pointer over the sheet tab for the last desired sheet."
msgstr ""

msgctxt "0b1d78888f5fe749dcfacb1e6e64ea56"
msgid "Hold down the <g1>Shift</g1> key and click on the sheet tab."
msgstr ""

msgctxt "f024ac6650b77c3d020ea57198356962"
msgid ""
"All tabs between these two selections will turn white (default Calc setup). "
"Any actions that you perform will now affect all highlighted sheets."
msgstr ""

msgctxt "3fdd346bec4c2c2b0bfb56cadb562f72"
msgid "<g1></g1>Multiple non-contiguous sheets<g2></g2>"
msgstr ""

msgctxt "1aae99f3ece1cedfa7e3093b8832c9b6"
msgid "To select multiple non-contiguous sheets:"
msgstr ""

msgctxt "085f2dcad9ec03c516ae0f2e450cc81a"
msgid ""
"Move the mouse pointer over the sheet tab for the second desired sheet."
msgstr ""

msgctxt "df88c281caa76b16a70f3bb4e229bc1c"
msgid "Hold down the <g1>Ctrl</g1> key and click on the sheet tab."
msgstr ""

msgctxt "9f53dce2cade9d9322f561f5220d5c3a"
msgid ""
"The selected tabs will turn white (default Calc setup). Any actions that you "
"perform will now affect all highlighted sheets."
msgstr ""

msgctxt "577eec2993f237d93ec2733ec525188b"
msgid "<g1></g1>All sheets<g2></g2>"
msgstr ""

msgctxt "62ef4cf73c4a16d71d320ccea76867a7"
msgid ""
"Right-click a sheet tab and choose <g1>Select All Sheets</g1> from the "
"context menu."
msgstr ""

msgctxt "be5220f9b7d2288b515c0e4523647f56"
msgid "<g1></g1>Working with columns and rows<g2></g2>"
msgstr ""

msgctxt "bf5595d1c2225cdd6bc336c71b0606c1"
msgid ""
"<g1></g1><g2></g2><g3></g3><g4></g4>Inserting columns and rows<g5></g5>"
msgstr ""

msgctxt "ac99e02120d7e9f6f561c564cfda47c4"
msgid ""
"When you insert a column, it is inserted to the left of the highlighted "
"column. When you insert a row, it is inserted above the highlighted row."
msgstr ""

msgctxt "8f1cb30238684b91787aa2ef00cda2cb"
msgid ""
"When you insert columns or rows, the cells take the formatting of the "
"corresponding cells in the next column to left or the row above."
msgstr ""

msgctxt "285725374a5171d9633a7a57b3dd9b90"
msgid "Using the <g1>Insert</g1> menu:"
msgstr ""

msgctxt "a48592181174d182084f9312e74bcca5"
msgid ""
"Select a cell, column, or row where you want the new column or row inserted."
msgstr ""

msgctxt "56d1492fe85952da42fa8ad577a92320"
msgid ""
"Go to <g1>Insert</g1> on the Menu bar and select either <g2>Insert > Columns "
"</g2>or<g3> Insert > Rows.</g3>"
msgstr ""

msgctxt "01debd2d210fdad53cbe454515585ff0"
msgid "<g1></g1>Using the mouse:"
msgstr ""

msgctxt "e0eb7191ba22181b7aaa04af607f8796"
msgid "Select a column or row where you want the new column or row inserted."
msgstr ""

msgctxt "6f938ab624117ec312e205feeb3cb535"
msgid "Right-click the column or row header."
msgstr ""

msgctxt "c48c897c2ca62313f2fd4eb5f5ab494f"
msgid ""
"Select <g1>Insert Columns </g1>or <g2>Insert Rows</g2> from the context menu."
""
msgstr ""

msgctxt "a7ba21f7eefc40437ca97489367111bd"
msgid ""
"Multiple columns or rows can be inserted at once rather than inserting them "
"one at a time."
msgstr ""

msgctxt "c0555eaa860950d6c5dd2f58cb285c82"
msgid ""
"Highlight the required number of columns or rows by holding down the left "
"mouse button on the first one and then dragging across the required number "
"of identifiers."
msgstr ""

msgctxt "fe57339a1c89ad6aeb5303832becb535"
msgid "Proceed as for inserting a single column or row above."
msgstr ""

msgctxt "7e0379d9b2bd1e96d723b9c706ade9a6"
msgid "<g1></g1><g2></g2><g3></g3>Deleting<g4></g4> columns and rows<g5></g5>"
msgstr ""

msgctxt "05c2e7a7eafeaecd04624fdc72dfdce5"
msgid "To delete a single column or row:"
msgstr ""

msgctxt "3c5d394151c7a98825128ccf1994a848"
msgid "Select a cell in the column or row you want to delete."
msgstr ""

msgctxt "93487a6ca39bfc9ac24cc8b685d63414"
msgid ""
"Go to <g1>Edit</g1> on the Menu bar and select <g2>Delete Cells</g2> or "
"right-click and select <g3>Delete</g3> from the context menu."
msgstr ""

msgctxt "d0628a9c4904e75a848cd594b16809cd"
msgid ""
"Select the option you require from the <g1>Delete Cells</g1> dialog "
"(<g2><g3>Figure 15</g3></g2>)."
msgstr ""

msgctxt "3763494bae21998a6a24deab783d29c4"
msgid "Figure <g1>15</g1>: Delete Cells dialog"
msgstr ""

msgctxt "783c6e0ce12d21d7cda595dca34c425a"
msgid "Alternatively:"
msgstr ""

msgctxt "ff6083a2a3a3d2312361855dc38838cc"
msgid "Click in the column or header to select the column or row."
msgstr ""

msgctxt "039948f8797fcf7ec16bbe20a54f1854"
msgid ""
"Go to <g1>Edit</g1> on the Menu bar and select <g2>Delete Cells</g2> or "
"right-click and select <g3>Delete Columns</g3> or <g4>Delete Rows</g4> from "
"the context menu."
msgstr ""

msgctxt "57c35226742f82e15f0f6001ad7a0964"
msgid "To delete multiple columns or rows:"
msgstr ""

msgctxt "4fda90c1a749e22d03615b17c72e10bd"
msgid ""
"Select the columns or rows, see “<x1/>” on page <x2/> for more information."
msgstr ""

msgctxt "ed2eded440c51f462a600d565394ec98"
msgid "<g1></g1><g2></g2>Working with sheets<g3></g3>"
msgstr ""

msgctxt "30b209ce168d5a2a2ba4c685644b5c3e"
msgid "<g1></g1><g2></g2><g3></g3>Inserting new sheets<g4></g4>"
msgstr ""

msgctxt "4d44e9df0a70a0edf3ed77e3db20eefb"
msgid ""
"Click on the <g1>Add Sheet</g1> icon <g2><g3><g4></g4></g3></g2>. This "
"inserts a new sheet after the last sheet in the spreadsheet without opening "
"the <g5>Insert Sheet</g5> dialog. The following methods open the <g6>Insert "
"Sheet</g6> dialog (<g7><g8>Figure 16</g8></g7>) where you can position the "
"new sheet, create more than one sheet, name the new sheet, or select a sheet "
"from a file."
msgstr ""

msgctxt "0490db224fd4d647a35ce60643428045"
msgid ""
"Select the sheet where you want to insert a new sheet, then go to <g1>Insert "
"> Sheet</g1> on the Menu bar."
msgstr ""

msgctxt "dcda9d95c9e853a8c14ca7673b687dc6"
msgid ""
"Right-click on the sheet tab where you want to insert a new sheet and select "
"<g1>Insert Sheet</g1> from the context menu."
msgstr ""

msgctxt "cdd49433536b227fc49eee77d450c008"
msgid "Click in the empty space at the end of the sheet tabs."
msgstr ""

msgctxt "5ef04387737daa9b718d78823d5ef860"
msgid ""
"Right-click in the empty space at the end of the sheet tabs and select "
"<g1>Insert Sheet</g1> from the context menu."
msgstr ""

msgctxt "59a80c1e52b2dff0af156cf5ef06944f"
msgid "Figure <g1>16</g1>: Insert Sheet dialog"
msgstr ""

msgctxt "e7c824538b233733e1af6b280f00507b"
msgid "<g1></g1>Moving and <g2></g2>copying sheets<g3></g3>"
msgstr ""

msgctxt "2cb5ab0c86fd3383075099dfcb8fe2fb"
msgid ""
"You can move or copy sheets within the same spreadsheet by dragging and "
"dropping or using the <g1>Move/Copy Sheet</g1> dialog. To move or copy a "
"sheet into a different spreadsheet, you have to use the <g2>Move/Copy Sheet</"
"g2> dialog."
msgstr ""

msgctxt "2e00f751d1bc54b27c3cab6823e02b53"
msgid "<g1></g1>Dragging and dropping<g2></g2>"
msgstr ""

msgctxt "861448b00485368e863ddb77e998eef6"
msgid ""
"To move a sheet to a different position within the same spreadsheet, click "
"and hold on the sheet tab and drag it to its new position before releasing "
"the mouse button."
msgstr ""

msgctxt "4f3cff17600d32f4b720ed5bcdbe2233"
msgid ""
"To <g1>copy</g1> a sheet within the same spreadsheet, hold down the "
"<g2>Ctrl</g2> key (<g3>Option</g3> key on Mac) then click on the sheet tab "
"and drag it to its new position before releasing the mouse button. The mouse "
"pointer may change to include a plus sign depending on the setup of your "
"operating system."
msgstr ""

msgctxt "df03a4ee5419bb04c21cfbdcb569a14d"
msgid "<g1></g1><g2></g2>Using a dialog<g3></g3>"
msgstr ""

msgctxt "9ea3d05bf9d5d87d59b63cdb9e804861"
msgid ""
"Use the <g1>Move/Copy Sheet</g1> dialog (<g2><g3>Figure 17</g3></g2>) to "
"specify exactly whether you want the sheet in the same or a different "
"spreadsheet, its position within the spreadsheet, the sheet name when you "
"move or copy the sheet."
msgstr ""

msgctxt "a16aa74997a010493d4c7af5165a010e"
msgid ""
"In the current document, right-click on the sheet tab you wish to move or "
"copy and select <g1>Move/Copy Sheet</g1> from the context menu or go to "
"<g2>Edit > Sheet > Move/Copy</g2> on the Menu bar."
msgstr ""

msgctxt "428d08804eed6214c6bcc01e71a30266"
msgid ""
"Select <g1>Move</g1> to move the sheet or <g2>Copy</g2> to copy the sheet."
msgstr ""

msgctxt "ba1877c2124a9c7328966a73547f3f66"
msgid ""
"Select the spreadsheet where you want the sheet to be placed from the drop-"
"down list in <g1>To document</g1>. This can be the same spreadsheet, another "
"spreadsheet already open, or you can create a new spreadsheet."
msgstr ""

msgctxt "8fac866a3ff08c9d2fde6addf96c5eb9"
msgid ""
"Select the position in <g1>Insert before</g1> where you want to place the "
"sheet."
msgstr ""

msgctxt "412b7b4d62b79e44ddf9bc2499b93e81"
msgid ""
"Type a name in the <g1>New name</g1> text box if you want to rename the "
"sheet when it is moved or copied. If you do not enter a name, Calc creates a "
"default name (Sheet 1, Sheet 2, and so on)."
msgstr ""

msgctxt "e7dfcc3aec700277372fffdc054c4103"
msgid "Click <g1>OK</g1> to confirm the move or copy and close the dialog."
msgstr ""

msgctxt "764a2caff05993fc0d3eff5de7b225e9"
msgid "Caution"
msgstr ""

msgctxt "2c3a0ca9dce6a571e17476c3336255d4"
msgid ""
"When you move or copy to another spreadsheet or a new spreadsheet, a "
"conflict may occur with formulas linked to other sheets in the previous "
"location."
msgstr ""

msgctxt "984fe72125b3b37677b2d1f544bb92fb"
msgid "Figure <g1>17</g1>: Move/Copy Sheet dialog"
msgstr ""

msgctxt "e23111aba42997952b0006532aadf02a"
msgid "<g1></g1><g2></g2>Deleting sheets<g3></g3>"
msgstr ""

msgctxt "65a84418b73c71e3c6d26de345b33bf7"
msgid ""
"To delete a single sheet, right-click on the sheet tab you want to delete "
"and select <g1>Delete Sheet</g1> from the context menu, or go to <g2>Edit > "
"Sheet > Delete</g2> from on the Menu bar. Click <g3>Yes</g3> to confirm the "
"deletion."
msgstr ""

msgctxt "92318c5af18381bd25c08b088e9dcef1"
msgid ""
"<g1></g1>To delete multiple sheets, select the sheets (see “<g2><x3/></g2>” "
"on page <g4><x5/></g4>), then right-click one of the sheet tabs and select "
"<g6>Delete Sheet</g6> from the context menu, or go to <g7>Edit > Sheet > "
"Delete</g7> from on the Menu bar. Click <g8>Yes</g8> to confirm the deletion."
""
msgstr ""

msgctxt "c30817a76ddc382b54d91ba9c247e098"
msgid "<g1></g1><g2></g2><g3></g3>Renaming sheets<g4></g4>"
msgstr ""

msgctxt "4be4c9ad2c71ef8b9e40bd4378824fe9"
msgid ""
"By default, the name for each new sheet added is <g1>Sheet</g1>X, where "
"<g2>X</g2> is the number of the next sheet to be added. While this works for "
"a small spreadsheet with only a few sheets, it can become difficult to "
"identify sheets when a spreadsheet contains many sheets."
msgstr ""

msgctxt "b97d1025a4ae9267a06722986d8f177e"
msgid "You can rename a sheet using one of the following methods:"
msgstr ""

msgctxt "880b50cf325c6bc9a4513c7c2e8f0314"
msgid ""
"Enter the name in the <g1>Name</g1> text box when you create the sheet using "
"the Insert Sheet dialog (<g2>Figure 16</g2> on page <g3>22</g3>)."
msgstr ""

msgctxt "f65089ed7ddf69cf79c0e6baed35e56e"
msgid ""
"Right-click on a sheet tab and select <g1>Rename Sheet</g1> from the context "
"menu to replace the existing name with a different one."
msgstr ""

msgctxt "9b0793fd39577802c8b1ee1844f7f9e9"
msgid "Double-click on a sheet tab to open the <g1>Rename Sheet</g1> dialog."
msgstr ""

msgctxt "653954df49d44d267e3192edf9e4eca6"
msgid ""
"Sheet names must start with either a letter or a number; other characters "
"including spaces are not allowed. Apart from the first character of the "
"sheet name, permitted characters are letters, numbers, spaces, and the "
"underscore character. Attempting to rename a sheet with an invalid name will "
"produce an error message."
msgstr ""

msgctxt "1ccd6941766b4ed994cf715e67f99255"
msgid "<g1></g1><g2></g2>Viewing Calc<g3></g3>"
msgstr ""

msgctxt "20fefaa0ee1b874a0cbee3e3c046c80a"
msgid "<g1></g1>Changing document view<g2></g2>"
msgstr ""

msgctxt "b5998d6b4e109eb64e240cef4d0f3df8"
msgid ""
"Use <g1></g1>the zoom function to show more or fewer cells in the window "
"when you are working on a spreadsheet. For more about zoom, see <g2>Chapter "
"1 Introducing LibreOffice</g2> in this guide."
msgstr ""

msgctxt "24ccbe071d1f7c9239643572868cae7b"
msgid "<g1></g1><g2></g2>Freezing<g3></g3> rows and columns<g4></g4>"
msgstr ""

msgctxt "4d9b75d54aa82ed211f59bca68131464"
msgid ""
"Freezing locks a number of rows at the top of a spreadsheet or a number of "
"columns on the left of a spreadsheet or both rows and columns. Then, when "
"moving around within a sheet, the cells in frozen rows and columns always "
"remain in view."
msgstr ""

msgctxt "7d643e68507cbfda178d9420e5a7d7df"
msgid ""
"<g1>Figure 18</g1> shows some frozen rows and columns. The heavier "
"horizontal line between rows 3 and 23 and the heavier vertical line between "
"columns F and Q indicate that rows 1 to 3 and columns A to F are frozen. The "
"rows between 3 and 23 and the columns between F and Q have been scrolled off "
"the page."
msgstr ""

msgctxt "fde189f1df9066e73e1a37407de63e8c"
msgid "Figure <g1>18</g1>: Frozen rows and columns"
msgstr ""

msgctxt "06512cf49f3b48aaeaaed272c5f81c1e"
msgid "<g1></g1><g2></g2>Freezing rows or column<g3></g3>s<g4></g4>"
msgstr ""

msgctxt "c75e56dabd5a6783e043e5d07a462677"
msgid ""
"Click on the row header below the rows where you want the freeze, or click "
"on the column header to the right of the columns where you want the freeze."
msgstr ""

msgctxt "ce95ff8b599f25f847603ab035e028a1"
msgid ""
"<g1></g1>Go to <g2>Window</g2> on the Menu bar and select <g3>Freeze</g3>. A "
"heavier line appears between the rows or columns indicating where the freeze "
"has been placed."
msgstr ""

msgctxt "e02f3c8acfd80c7e9d478f762e4c71cf"
msgid "<g1></g1>Freezing rows and columns<g2></g2>"
msgstr ""

msgctxt "ab71be432d58ac414a277a50292b3a6a"
msgid ""
"Click into the cell that is immediately below the rows you want frozen and "
"immediately to the right of the columns you want frozen."
msgstr ""

msgctxt "7f8fc5dab41ac17a5cc9a94dfa2569e7"
msgid ""
"Go to <g1>Window</g1> on the Menu bar and select <g2>Freeze</g2>. A heavier "
"line appears between the rows or columns indicating where the freeze has "
"been placed."
msgstr ""

msgctxt "9586eeb6479ba089f73aacdfc6d7a497"
msgid "<g1></g1>Unfreezing<g2></g2>"
msgstr ""

msgctxt "e22671c9913ed7513c78e4db75669748"
msgid ""
"To unfreeze rows or columns, go to <g1>Window</g1> on the Menu bar and "
"uncheck <g2>Freeze</g2>. The heavier lines indicating freezing will "
"disappear."
msgstr ""

msgctxt "71f5164e34328598e19108bdbf4ace51"
msgid "<g1></g1>Splitting the screen<g2></g2>"
msgstr ""

msgctxt "3c54c8bae0c90644f054404c6c16667c"
msgid ""
"Another way to change the view is by splitting the screen your spreadsheet "
"is displayed in (also known as splitting the window). The screen can be "
"split horizontally, vertically, or both giving you up to four portions of "
"the spreadsheet in view at any one time. An example of splitting the screen "
"is shown in <g1>Figure 19</g1> where a split is indicated by additional "
"window borders within the sheet."
msgstr ""

msgctxt "a22f10aecda3a0088de01a70778704d4"
msgid ""
"Why would you want to do this? For example, consider a large spreadsheet in "
"which one cell contains a number that is used by three formulas in other "
"cells. Using the split-screen technique, you can position the cell "
"containing the number in one section and each of the cells with formulas in "
"the other sections. You can then change the number in one cell and watch how "
"it affects each of the formulas."
msgstr ""

msgctxt "50d7fdf7998f25ccd5b6b39ee7536195"
msgid "Figure <g1>19</g1>: Split screen example"
msgstr ""

msgctxt "72be8a4a70437c2081c984b6f62889fa"
msgid "<g1></g1>Splitting horizontally or vertically<g2></g2>"
msgstr ""

msgctxt "6dee053af3fdb32462a85ee4f65d2f08"
msgid ""
"Click on the row header below the rows where you want to split the screen "
"horizontally or click on the column header to the right of the columns where "
"you want to split the screen vertically."
msgstr ""

msgctxt "3c8402e0cc37ab17851e411a7b86238d"
msgid ""
"Go to <g1>Window</g1> on the Menu bar and select <g2>Split. </g2>Window "
"borders appear between the rows or columns indicating where the split has "
"been placed, as shown in <g3>Figure 20</g3>."
msgstr ""

msgctxt "ed3d89138ad9e1246556cb1d8ac2bbd5"
msgid "Alternatively "
msgstr ""

msgctxt "9b81d9aa40dca707988466990c20b22c"
msgid ""
"For a horizontal split, drag the new horizontal window border beneath the "
"row where you want the horizontal split positioned."
msgstr ""

msgctxt "40c7694af52e80246bb4ce3c2e25869f"
msgid ""
"For a vertical split, drag the new vertical window border across to the "
"right of the column where you want the vertical split positioned."
msgstr ""

msgctxt "c23db903f366b15b9e61ee5b68e3dbc4"
msgid "<g1></g1><g2></g2>Splitting horizontally and vertically<g3></g3>"
msgstr ""

msgctxt "18f5553fdef4f322292e46613dd5f76d"
msgid ""
"Click in the cell that is immediately below the rows where you want to split "
"the screen horizontally and immediately to the right of the columns where "
"you want to split the screen vertically."
msgstr ""

msgctxt "eda969c7c6cbd177a05d3e600c36d2d8"
msgid ""
"Go to <g1>Window</g1> on the Menu bar and select <g2>Split. </g2><g3>H</"
"g3>eavy black line<g4>s</g4> appear between the rows or columns indicating "
"where the split has been placed."
msgstr ""

msgctxt "a3fda7baf1835cc407d2c96ca581d23a"
msgid "Figure <g1>20</g1>: Split screen window borders"
msgstr ""

msgctxt "ae714667bb27644ae321f995049254d1"
msgid "<g1></g1>Removing split views<g2></g2>"
msgstr ""

msgctxt "fdd57a1f5daea50458d720ca0b92d843"
msgid "To remove a split view, do one of the following:"
msgstr ""

msgctxt "03e98fa6900c028af251b386263a4305"
msgid ""
"Drag the split window borders back to their places at the ends of the scroll "
"bars."
msgstr ""

msgctxt "126fa9024b18004a0e4dbdfd7a4cdfc0"
msgid "Go to <g1>Window</g1> on the Menu bar and uncheck <g2>Split.</g2>"
msgstr ""

msgctxt "24bf5fb864b1976c4ea2fbb2b5b4ae35"
msgid "<g1></g1>Using the keyboard<g2></g2>"
msgstr ""

msgctxt "e3e1e6dbb79740cb2ee63dae346af8fb"
msgid "Most data entry in Calc can be accomplished using the keyboard."
msgstr ""

msgctxt "2a51df6d04736770e267731dd28bccc2"
msgid "<g1></g1><g2></g2>Numbers<g3></g3>"
msgstr ""

msgctxt "6b7319aba0dbd91e6db59ded8bf9f19e"
msgid ""
"Click in the cell and type in a number using the number keys on either the "
"main keyboard or numeric keypad. By default, numbers are right aligned in a "
"cell."
msgstr ""

msgctxt "cbc868624ea18a5572a1d90d84d3c96b"
msgid "<g1></g1>Minus numbers<g2></g2>"
msgstr ""

msgctxt "211feb1970193a5abdc45929b74eddfc"
msgid ""
"To enter a negative number, either type a minus (–) sign in front of the "
"number or enclose the number in parentheses (), for example (1234). The "
"result for both methods of entry will be the same, for example -1234."
msgstr ""

msgctxt "b16b541e5a3b647498d59743bf15f335"
msgid "<g1></g1>Leading zeroes<g2></g2>"
msgstr ""

msgctxt "7a1bb2b5d3125ab58dd63d6b5ae5590b"
msgid ""
"To retain a minimum number of integer characters in a cell when entering "
"numbers in order to retain the number format, for example 1234 and 0012, "
"leading zeros have to be added using one of the following methods:"
msgstr ""

msgctxt "e143116f1c347a392ad4710a54dccc97"
msgid "<g1></g1><g2>Method 1</g2>"
msgstr ""

msgctxt "f632bffef67e47dd5cec36464e8f39d5"
msgid ""
"With the cell selected, right-click on the cell, select <g1>Format Cells</"
"g1> from the context menu or go to <g2>Format > Cells</g2> on the Menu bar "
"or use the keyboard shortcut <g3>Ctrl+1</g3> to open the <g4>Format Cells</"
"g4> dialog (<g5>Figure 21</g5>)."
msgstr ""

msgctxt "50cb98882031455d96ccc4b9f6e345bf"
msgid "Figure <g1>21</g1>: Format Cells dialog – Numbers page"
msgstr ""

msgctxt "5c6368bc28366d5af6b0a70e5c0dfad3"
msgid ""
"Make sure the <g1>Numbers</g1> tab is selected then select <g2>Number</g2> "
"in the <g3>Category</g3> list."
msgstr ""

msgctxt "75e7552b53949d3535f80b18d5d6eeea"
msgid ""
"In <g1>Options > Leading Zeros</g1>, enter the minimum number of characters "
"required. For example, for four characters, enter 4. Any number less than "
"four characters will have leading zeros added, for example 12 becomes 0012."
msgstr ""

msgctxt "86b7d7b73a871dd0efac6830f54ad409"
msgid ""
"<g1>Click </g1><g2>OK</g2><g3>. The number entered retains its number format "
"and any formula used in the spreadsheet will treat the entry as a number in "
"formula functions.</g3>"
msgstr ""

msgctxt "6d3770f81b9316ea480e89613358777d"
msgid "<g1>Method 2</g1>"
msgstr ""

msgctxt "a809241a7146a52611c9320ad36960d0"
msgid "Select the cell."
msgstr ""

msgctxt "6a2c851b216f3357dd675cd8990618ab"
msgid ""
"Open the Sidebar (<g1>View > Sidebar</g1>) and click the <g2>Open Panel</g2> "
"(<g3>+</g3>) icon on the <g4>Number Format</g4> panel to open it."
msgstr ""

msgctxt "3736bbacc7986890e0d5eac82ac2c217"
msgid "Select <g1>Number</g1> in the <g2>Category</g2> list box."
msgstr ""

msgctxt "4a08daa5a9ac09040f0e0cc724a7ae6b"
msgid ""
"Set the <g1>Leading zeroes</g1> value box to <g2>4</g2>. Formatting is "
"applied immediately."
msgstr ""

msgctxt "f579399ab45f33e09195d9739059c96d"
msgid "Figure <g1>22</g1>: Set Leading zeroes"
msgstr ""

msgctxt "8ee021a577ce88f8bc575391f6942b94"
msgid ""
"<g1></g1>If a number is entered with leading zeroes, for example 01481, "
"without first setting the Leading zeros parameter, then by default Calc will "
"automatically drop the leading 0. To preserve leading zeros in a number:"
msgstr ""

msgctxt "a621fee3cd70e3761da94a4e68a95b95"
msgid "Type an apostrophe (') before the number, for example '01481."
msgstr ""

msgctxt "850215611743ca089d5b08f484142782"
msgid ""
"Move the cell focus to another cell. The apostrophe is automatically "
"removed, the leading zeros are retained and the number is converted to text "
"left aligned."
msgstr ""

msgctxt "4c3d25a65b1668c925a76c5a78c3d9f4"
msgid "<g1></g1><g2></g2>Numbers as text<g3></g3>"
msgstr ""

msgctxt "c14ad522a3006abf3351ddd3e7ce073f"
msgid ""
"Numbers can also be entered as text using one of the following methods."
msgstr ""

msgctxt "4612c69420735af56887140ef062638a"
msgid "<g1>Method 1</g1>"
msgstr ""

msgctxt "fdf97f231d723365cd9a537a685ef52c"
msgid ""
"With the cell selected, right-click on the cell and select <g1>Format Cells</"
"g1> from the context menu or go to <g2>Format > Cells</g2> on the Menu bar "
"or use the keyboard shortcut <g3>Ctrl+1</g3> to open the <g4>Format Cells</"
"g4> dialog (<g5>Figure 21</g5>)."
msgstr ""

msgctxt "f1ba2a548e26dd616cae7b80319d6c03"
msgid ""
"Make sure the <g1>Numbers</g1> page is selected, then select <g2>Text</g2> "
"from the <g3>Category</g3> list."
msgstr ""

msgctxt "324664a8055fff23c0924d7b34ac1e26"
msgid ""
"Click <g1>OK</g1> and the number, when entered, is converted to text and, by "
"default, left aligned."
msgstr ""

msgctxt "7b8d196a040795d2e0b18cdc2eb35ef8"
msgid ""
"Open the Sidebar (<g1>View > Sidebar</g1>) and click the <g2>Open Panel</g2> "
"(<g3>+</g3>) icon on the <g4>Number Format</g4> panel."
msgstr ""

msgctxt "2ba3f1d2a6f56e1854dc3790daab87ba"
msgid ""
"Select <g1>Text</g1> in the <g2>Category</g2> list box. Formatting is "
"applied to the cell immediately."
msgstr ""

msgctxt "d17bd763fea58ed23ca87d503a0068a7"
msgid ""
"Click back on the cell. Enter the number and move focus from the cell to "
"have the data formatted."
msgstr ""

msgctxt "a7a575f56b731a89043d273296f6eaa1"
msgid ""
"Any numbers that have been formatted as text in a spreadsheet will be "
"treated as a zero by any formulas used in the spreadsheet. Formula functions "
"will ignore text entries."
msgstr ""

msgctxt "6201c8e86405c06c5b214856e3a4d8ae"
msgid "<g1></g1><g2></g2>Text<g3></g3>"
msgstr ""

msgctxt "ce2725c7547f366e2bb40f893d1d39d3"
msgid ""
"Click in the cell and type the text. By default, text is left-aligned in a "
"cell."
msgstr ""

msgctxt "7222d8fe6f7a062d12a73bb003ad10b8"
msgid "<g1></g1><g2></g2>Date and time<g3></g3>"
msgstr ""

msgctxt "458ff9bef33484fc52f456c083145743"
msgid "Select the cell and type the date or time."
msgstr ""

msgctxt "84f6a34c8b20ae1ab18fd262a5ad944c"
msgid ""
"You can separate the date elements with a slash (/) or a hyphen (–) or use "
"text, for example 10 Oct 2012. The date format automatically changes to the "
"selected format used by Calc."
msgstr ""

msgctxt "ae339e54c44ce76415d6c728b6aff601"
msgid ""
"When entering a time, separate time elements with colons, for example 10:43:"
"45. The time format automatically changes to the selected format used by "
"Calc."
msgstr ""

msgctxt "28b79348e5127310f95364d5b8d465e5"
msgid ""
"To change the date or time format used by Calc, use one of the following "
"methods."
msgstr ""

msgctxt "298c12829e15f60e3de96656076e0a94"
msgid ""
"With the cell selected, right-click on the cell and select <g1>Format Cells</"
"g1> from the context menu, or go to <g2>Format > Cells</g2> on the Menu bar, "
"or use the keyboard shortcut <g3>Ctrl+1</g3>, to open the <g4>Format Cells</"
"g4> dialog (<g5>Figure 21</g5>)."
msgstr ""

msgctxt "932370e12cced6705cf18aa914a81b32"
msgid ""
"Make sure the <g1>Numbers</g1> page is selected, then select <g2>Date</g2> "
"or <g3>Time</g3> from the <g4>Category</g4> list."
msgstr ""

msgctxt "73eb7b70a70cbe3a72c367215990df63"
msgid ""
"Select the date or time format you want to use from the <g1>Format</g1> list."
""
msgstr ""

msgctxt "33ac651b7addcf81d00ae75c22ba06f4"
msgid "Click <g1>OK</g1>."
msgstr ""

msgctxt "d93b7ac90c4ff5bb6ae93cfd5f398011"
msgid "<g1></g1><g2>Method 2</g2>"
msgstr ""

msgctxt "555f554a85dcae7fd9e5c92c5707ce05"
msgid ""
"Select <g1>Date</g1> in the <g2>Category</g2> list box, or click the "
"<g3>Date</g3> icon below the list box."
msgstr ""

msgctxt "0681ef791d1b4c9f60bb79826d5ca696"
msgid ""
"Click the <g1>More Options</g1> button in the panel title bar to open the "
"<g2>Format Cells</g2> dialog."
msgstr ""

msgctxt "b63c2402f1e2e9535ca2d9e06aed984d"
msgid "Figure <g1>23</g1>: Select Date and More Options"
msgstr ""

msgctxt "63828dfe609df707e573bfa9c18e4d6d"
msgid "<g1></g1><g2></g2>Autocorrection options<g3></g3>"
msgstr ""

msgctxt "ce36efee40d8dfc25906ad5bc2da03c5"
msgid ""
"Calc automatically applies many changes during data input using "
"autocorrection, unless you have deactivated any autocorrect changes. You can "
"also undo any autocorrection changes by using the keyboard shortcut "
"<g1>Ctrl+Z</g1> or manually by going back to the change and replacing the "
"autocorrection with what you want to actually see."
msgstr ""

msgctxt "3273a2e946544f49fbc040eb044114db"
msgid ""
"To change the autocorrect options, go to <g1>Tools > AutoCorrect Options</"
"g1> on the Menu bar to open the <g2>AutoCorrect</g2> dialog (<g3>Figure 24</"
"g3>)."
msgstr ""

msgctxt "6f8ee287085adf69e4ac33465371ce24"
msgid "<g1></g1>Replace<g2></g2>"
msgstr ""

msgctxt "424b69fba5b670100f0d4211808516d7"
msgid ""
"Edits the replacement table for automatically correcting or replacing words "
"or abbreviations in your document."
msgstr ""

msgctxt "6d24470f73577e71c5b3736018960c9c"
msgid "<g1></g1>Exceptions<g2></g2>"
msgstr ""

msgctxt "2630825b0cfb0ea3b99adeb5ff55b109"
msgid ""
"Specify the abbreviations or letter combinations that you do not want "
"LibreOffice to correct automatically."
msgstr ""

msgctxt "5345aa9eb0dc1e2c51c4af534f3e4026"
msgid "<g1></g1>Options<g2></g2>"
msgstr ""

msgctxt "9e69efc08cd5eaa0a5d24d3711194c79"
msgid ""
"Select the options for automatically correcting errors as you type and then "
"click <g1>OK</g1>."
msgstr ""

msgctxt "a074022cc9563e3b7e61ec479dba9f49"
msgid "<g1></g1>Localized options<g2></g2>"
msgstr ""

msgctxt "6607d9f8caa684157f2144b65892b783"
msgid ""
"Specify the AutoCorrect options for quotation marks and for options that are "
"specific to the language of the text."
msgstr ""

msgctxt "162b06ddd617998fdb8c7e56d69f48e9"
msgid "<g1></g1>Reset<g2></g2>"
msgstr ""

msgctxt "7e768a592f1ee417460c5999ac5917ec"
msgid "Resets modified values back to the LibreOffice default values."
msgstr ""

msgctxt "1caf6c680127be798abbd15603bf00ec"
msgid "Figure <g1>24</g1>: AutoCorrect dialog"
msgstr ""

msgctxt "b25e0b9819fc2f57dcbcc4cdbed93431"
msgid "<g1></g1>Deactivating automatic changes<g2></g2>"
msgstr ""

msgctxt "39c20d942ed122c25a00ba889cd6f90b"
msgid ""
"Some AutoCorrect settings are applied when you press the spacebar after you "
"enter data. To turn off or on Calc AutoCorrect, go to <g1>Tools > Cell "
"Contents</g1> on the Menu bar and deselect or select <g2>AutoInput</g2>."
msgstr ""

msgctxt "914e825067e64b8e97b582d9f712bde2"
msgid "<g1></g1><g2></g2>Speeding up data entry<g3></g3>"
msgstr ""

msgctxt "d06bd1ad94e79c58ce459068f4867d3e"
msgid ""
"Entering data into a spreadsheet can be very labor-intensive, but Calc "
"provides several tools for removing some of the drudgery from input."
msgstr ""

msgctxt "ce4c91bb5c13e7f009434964776272be"
msgid ""
"The most basic ability is to drop and drag the contents of one cell to "
"another with a mouse. Many people also find AutoInput helpful. Calc also "
"includes several other tools for automating input, especially of repetitive "
"material. They include the fill tool, selection lists, and the ability to "
"input information into multiple sheets of the same document."
msgstr ""

msgctxt "f819dbec122b393d370ad9f2400f21b5"
msgid "<g1></g1>Using <g2></g2><g3></g3>the Fill tool<g4></g4>"
msgstr ""

msgctxt "9e9762046f7592c5af9119b4424aa8ac"
msgid ""
"The Calc Fill tool is used to duplicate existing content or create a series "
"in a range of cells in your spreadsheet (<g1>Figure 25</g1>)."
msgstr ""

msgctxt "b1b40c30e1dd7fd49246c25f27636373"
msgid ""
"Select the cell containing the contents you want to copy or start the series "
"from."
msgstr ""

msgctxt "12658d560b0c688360a091b9e2374530"
msgid ""
"Drag the mouse in any direction or hold down the <g1>Shift</g1> key and "
"click in the last cell you want to fill."
msgstr ""

msgctxt "593b10fffe53ddbbab1e392dd3b7481b"
msgid ""
"Go to <g1>Edit > Fill</g1> on the Menu bar and select the direction in which "
"you want to copy or create data (<g2>Up</g2>, <g3>Down</g3>, <g4>Left</g4> "
"or <g5>Right</g5>) or <g6>Series</g6> from the context menu."
msgstr ""

msgctxt "51e2cbc9160088cfc54ee2755bb34e67"
msgid "<g1></g1>Alternatively, you can use a shortcut to fill cells."
msgstr ""

msgctxt "3388ca4dd3828c306ab10a18061382cc"
msgid ""
"Move the cursor over the small square in the bottom right corner of the "
"selected cell. The cursor will change shape."
msgstr ""

msgctxt "6770ce759b3c1048ee21535fd773e225"
msgid ""
"Click and drag in the direction you want the cells to be filled. If the "
"original cell contained text, then the text will automatically be copied. If "
"the original cell contained a number, a series will be created."
msgstr ""

msgctxt "3532a1105776e21a80868395f36fcadc"
msgid "Figure <g1>25</g1>: Using the Fill tool"
msgstr ""

msgctxt "91acbf4b652f2c7a5a5cbb18a0474eef"
msgid "<g1></g1>Using a fill series<g2></g2>"
msgstr ""

msgctxt "9af58f6af53c3534eaa1ded36a41fb27"
msgid ""
"When you select a series fill from <g1>Edit > Fill > Series</g1>, the "
"<g2>Fill Series</g2> dialog (<g3>Figure 26</g3>) opens. <g4>Here </g4>you "
"<g5>can </g5>select the type of series you want."
msgstr ""

msgctxt "61b1f3c6012908f03c628a4fec0c163b"
msgid "Figure <g1>26</g1>: Fill Series dialog"
msgstr ""

msgctxt "3567ef718a0a4708f7d6d0f1830a3145"
msgid "<g1>Direction</g1> – determines the direction of series creation."
msgstr ""

msgctxt "e37276e0b88147d40ab7b6e67c9b8d91"
msgid ""
"<g1>Down</g1> – creates a downward series in the selected cell range for the "
"column using the defined increment to the end value."
msgstr ""

msgctxt "6e221b9255d598a50e041d2b3c15e154"
msgid ""
"<g1>Right</g1> – creates a series running from left to right within the "
"selected cell range using the defined increment to the end value."
msgstr ""

msgctxt "cd3018ba5beacfc66d0c3b7ac96ffba3"
msgid ""
"<g1>Up</g1> – creates an upward series in the cell range of the column using "
"the defined increment to the end value."
msgstr ""

msgctxt "5c976b7459438cea2dc8aaa70e7d0165"
msgid ""
"<g1>Left</g1> – creates a series running from right to left in the selected "
"cell range using the defined increment to the end value."
msgstr ""

msgctxt "5ffa992663a451d69d33485048a4f453"
msgid "<g1></g1><g2>Series Type</g2> – defines the series type."
msgstr ""

msgctxt "b0ba0d762338de57078ee6923a54baf3"
msgid ""
"<g1>Linear</g1> – creates a linear number series using the defined increment "
"and end value."
msgstr ""

msgctxt "3a6e7f382651f6dd70aecd760adec43b"
msgid ""
"<g1>Growth</g1> – creates a growth series using the defined increment and "
"end value."
msgstr ""

msgctxt "0880c50badfa75e83177e3ec70bf350b"
msgid ""
"<g1>Date</g1> – creates a date series using the defined increment and end "
"date."
msgstr ""

msgctxt "a9d908872efe3918ddfa5994fbfbe381"
msgid ""
"<g1>AutoFill</g1> – forms a series directly in the sheet. The AutoFill "
"function takes account of customized lists. For example, by entering January "
"in the first cell, the series is completed using the list defined in "
"<g2>LibreOffice > Tools > Options > LibreOffice Calc > Sort Lists</g2>. "
"AutoFill tries to complete a value series by using a defined pattern. For "
"example, a numerical series using 1,3,5 is automatically completed with "
"7,9,11,13; a date and time series using 01.01.99 and 15.01.99, an interval "
"of fourteen days is used."
msgstr ""

msgctxt "9c85ec0123c9ee7f8f047f0355f5cb04"
msgid ""
"<g1>Unit of Time</g1> – in this area you specify the desired unit of time. "
"This area is only active if the Date option has been chosen in the Series "
"type area."
msgstr ""

msgctxt "63b00790216b92819a72bc1938623ade"
msgid ""
"<g1>Day</g1> – use the Date series type and this option to create a series "
"using seven days."
msgstr ""

msgctxt "37cc4d6dfdf46158e55529636a520af0"
msgid ""
"<g1>Weekday</g1> – use the Date series type and this option to create a "
"series of five day sets."
msgstr ""

msgctxt "c8aedea7c850c8755a1d41c3a68da1b1"
msgid ""
"<g1>Month</g1> – use the Date series type and this option to form a series "
"from the names or abbreviations of the months."
msgstr ""

msgctxt "446e53c9e349e31f4979b1b7d8219cf5"
msgid ""
"<g1>Year</g1> – use the Date series type and this option to create a series "
"of years."
msgstr ""

msgctxt "4330689e03d74b50b5df11727c34cdb6"
msgid ""
"<g1>Start Value</g1> – determines the start value for the series. Use "
"numbers, dates or times."
msgstr ""

msgctxt "246795daac6a855d56b9c13434c49534"
msgid ""
"<g1>End Value</g1> – determines the end value for the series. Use numbers, "
"dates or times."
msgstr ""

msgctxt "9d8970ee59606fe477286f194b7e3115"
msgid ""
"<g1>Increment</g1> – determines the value by which the series of the "
"selected type increases by each step. Entries can only be made if the "
"linear, growth or date series types have been selected."
msgstr ""

msgctxt "e000092fc99ba49ecf901dbaf7a152de"
msgid "<g1><g2></g2></g1>Figure <g3>27</g3>: Sort Lists dialog"
msgstr ""

msgctxt "f86f00898c028d01ac287f6b82ac7376"
msgid "<g1><g2><x3/></g2></g1>"
msgstr ""

msgctxt "3dc490f9816658b5d9a4a099ead58762"
msgid "<g1></g1><g2></g2>Defining a fill series<g3></g3>"
msgstr ""

msgctxt "18bfd6fc16052d98d32527214fec0b37"
msgid "To define your own fill series:"
msgstr ""

msgctxt "ae182b2a431a9373366a2e912de3a594"
msgid ""
"Go to <g1>Tools > Options > LibreOffice Calc > Sort Lists</g1> to open the "
"Sort Lists dialog (<g2>Figure 27</g2>). This dialog shows the previously-"
"defined series in the <g3>Lists</g3> box on the left and the contents of the "
"highlighted list in the <g4>Entries</g4> box."
msgstr ""

msgctxt "d17f5f24b1c81ef0e8bbe82a9ca78740"
msgid "Click <g1>New</g1> and the <g2>Entries</g2> box is cleared."
msgstr ""

msgctxt "3f5b501c31f921bae91023cef13b91ed"
msgid ""
"Type the series for the new list in the <g1>Entries</g1> box (one entry per "
"line)."
msgstr ""

msgctxt "8108a646c023d0a9aa8cf2ceca24c29f"
msgid ""
"Click <g1>Add</g1> and the new list will now appear in the <g2>Lists</g2> "
"box."
msgstr ""

msgctxt "b954be59e17e4ade12aac4564bbdd3bd"
msgid "Click <g1>OK</g1> to save the new list."
msgstr ""

msgctxt "075b68b774a9070ab2c257fe017d39a7"
msgid "<g1></g1><g2></g2>Using <g3></g3>selection lists<g4></g4>"
msgstr ""

msgctxt "a687db65ee3b4a870a568a0db24dfb9a"
msgid ""
"Selection lists are available only for text and are limited to using only "
"text that has already been entered in the same column."
msgstr ""

msgctxt "8d4225e58a348e3d10c05e6f4f9b8ad4"
msgid "Select a blank cell in a column that contains cells with text entries."
msgstr ""

msgctxt "8c4a5312e46a735527aec3e472a08f24"
msgid ""
"Right-click and select <g1>Selection Lists</g1> from the context menu. A "
"drop-down list appears listing any cell in the same column that either has "
"at least one text character or whose format is defined as text."
msgstr ""

msgctxt "bc3b0cda9f9c90e92fc0c211441db79e"
msgid ""
"Click on the text entry you require and it is entered into the selected cell."
""
msgstr ""

msgctxt "6213ced260f996ed1e877733ad21dc6f"
msgid "<g1></g1><g2></g2>Sharing content between sheets<g3></g3>"
msgstr ""

msgctxt "d7003c197a457bc4ed9701029fa176b8"
msgid ""
"You might want to enter the same information in the same cell on multiple "
"sheets, for example to set up standard listings for a group of individuals "
"or organizations. Instead of entering the list on each sheet individually, "
"you can enter the information in several sheets at the same time."
msgstr ""

msgctxt "4e18be46bf185ec157dca5d6d23068a0"
msgid ""
"Go to <g1>Edit > Sheet > Select</g1> on the Menu bar to open the <g2>Select "
"Sheets</g2> dialog."
msgstr ""

msgctxt "7d337ddbcd2de5479ce80dc9041f6ca6"
msgid "Figure <g1>28</g1>: Select Sheets dialog"
msgstr ""

msgctxt "2bd023c2506a1a021cc651312f8d7fc7"
msgid ""
"Select the individual sheets where you want the information to be repeated. "
"Use the <g1>Shift</g1> and <g2>Ctrl</g2> (<g3>Options</g3> on Mac) keys to "
"select multiple sheets."
msgstr ""

msgctxt "1ee1773d617ff10a19b438d2747ebdc6"
msgid ""
"Click <g1>OK</g1> to select the sheets and the sheet tabs will change color."
msgstr ""

msgctxt "3c7a6424b7cf2d6c7c18e7ff718f3e52"
msgid ""
"Enter the information in the cells on the first sheet where you want it to "
"appear and it will be repeated in all the selected sheets."
msgstr ""

msgctxt "e4935e0a6ea1e976ab083ae4d6d4afd6"
msgid ""
"This technique automatically overwrites, without any warning, any "
"information that is already in the cells on the selected sheets. Make sure "
"you deselect the additional sheets when you are finished entering "
"information that is going to be repeated before continuing to enter data "
"into your spreadsheet."
msgstr ""

msgctxt "ccbd97e159439ad65e4afc6865d20fad"
msgid "<g1></g1><g2></g2><g3></g3><g4></g4>Validating cell contents<g5></g5>"
msgstr ""

msgctxt "659ee597e2ff256d4fbf3be3691dc232"
msgid ""
"When creating spreadsheets for other people to use, validating cell contents "
"ensures that they enter data that is valid and appropriate for the cell. You "
"can also use <g1></g1>validation in your own work as a guide to entering "
"data that is either complex or rarely used."
msgstr ""

msgctxt "381f8a36ca8f593cf7950a73aadc6d9a"
msgid ""
"Fill series and selection lists can handle some types of data, but are "
"limited to predefined information. To validate new data entered by a user, "
"select a cell and go to <g1>Data > Validity</g1> on the Menu bar to define "
"the type of contents that can be entered in that cell. For example, a cell "
"may require a date or a whole number with no alphabetic characters or "
"decimal points, or a cell may not be left empty."
msgstr ""

msgctxt "f04f9e8f715addd2a375717d50e0e0b8"
msgid ""
"Depending on how validation is set up, validation can also define the range "
"of contents that can be entered, provide help messages explaining the "
"content rules set up for the cell and what users should do when they enter "
"invalid content. You can also set the cell to refuse invalid content, accept "
"it with a warning, or start a macro when an error is entered. See the "
"<g1>Calc Guide Chapter 2 Entering, Editing and Formatting Data</g1> for more "
"information on validating cell contents."
msgstr ""

msgctxt "d71b7f3338bd2742f0bae7c35a63686c"
msgid "<g1></g1><g2></g2><g3></g3>Editing data<g4></g4>"
msgstr ""

msgctxt "90ffc6cee9171f8a6298d057fe9cac8a"
msgid "<g1></g1><g2></g2>Deleting data<g3></g3>"
msgstr ""

msgctxt "078d4d8eadaa5a417d09129c36b52d53"
msgid "<g1></g1>Deleting data only<g2></g2>"
msgstr ""

msgctxt "0f4be70c9a85affc810e9ff01978119a"
msgid ""
"Data can be deleted from a cell without deleting any of the cell formatting. "
"Click in the cell to select it and then press the <g1>Delete</g1> key."
msgstr ""

msgctxt "cd00d6956036bf24bafc28f4f259da5b"
msgid "<g1></g1>Deleting data and formatting<g2></g2>"
msgstr ""

msgctxt "2b8bff4565501d82e72e23d3e3ef7c68"
msgid "Data and cell formatting can be deleted from a cell at the same time."
msgstr ""

msgctxt "735b593926511a08b816ffe838dca393"
msgid "Click in the cell to select it."
msgstr ""

msgctxt "09650170ee62d815a944978d2d04cf56"
msgid ""
"Press the <g1>Backspace</g1> key, or right-click in the cell and select "
"<g2>Delete Contents</g2> from the context menu, or go to <g3>Edit > Delete "
"Contents</g3>) on the Menu bar to open the <g4>Delete Contents</g4> dialog "
"(<g5>Figure 29</g5>). <g6>Here</g6> you <g7>can</g7> delete the different "
"aspects of the data in the cell or to delete everything in the cell."
msgstr ""

msgctxt "757377cf8d3b8c68ea5cc52096ccc9bc"
msgid "Figure <g1>29</g1>: Delete Contents dialog"
msgstr ""

msgctxt "a1874891b52fae54d9de696e763b4de5"
msgid "<g1></g1><g2></g2><g3></g3>Replacing data<g4></g4>"
msgstr ""

msgctxt "d9c10f2a3d4d58ec36b15ccabff6087a"
msgid ""
"To completely replace data in a cell and insert new data, select the cell "
"and type in the new data. The new data will replace the data already "
"contained in the cell but will retain the original formatting used in the "
"cell."
msgstr ""

msgctxt "b0e4d89dca348fcc0cac4cd39f9cfd68"
msgid ""
"<g1></g1>Alternatively, click in the Input Line on the Formula Bar "
"(<g2>Figure 2</g2> on page <g3>8</g3>), then double-click on the data to "
"highlight it completely and type the new data.<g4></g4>"
msgstr ""

msgctxt "f0114e547cac6d919f8046789cde7b2b"
msgid "<g1></g1><g2></g2>Editing data<g3></g3>"
msgstr ""

msgctxt "db085e840a1ae667aa06e2389c2e9f1b"
msgid ""
"Sometimes it is necessary to edit the contents of cell without removing all "
"of the data from the cell. For example, changing the phrase “Sales in Qtr. "
"2”  to “Sales rose in Qtr” can be done as follows."
msgstr ""

msgctxt "e840166f17b6b02d2c833fd63293e8fc"
msgid ""
"Press the <g1>F2</g1> key and the cursor is placed at the end of the cell."
msgstr ""

msgctxt "6c1d7eaa2bd961b58a3c9eb5bed83c4a"
msgid ""
"Use the keyboard arrow keys to reposition the cursor where you want to start "
"entering the new data in the cell."
msgstr ""

msgctxt "100a5c13bad074be7b61a3d918696079"
msgid ""
"When you have finished, press the <g1>Enter</g1> key and your editing "
"changes are saved."
msgstr ""

msgctxt "0555c5e99e8ac0637bfe0e712784b59d"
msgid "<g1></g1>Using the mouse<g2></g2>"
msgstr ""

msgctxt "4d2b418f26aaa8e41a1edabfd109966c"
msgid ""
"Double-click on the cell to select it and place the cursor in the cell for "
"editing."
msgstr ""

msgctxt "c34066260c4a444c86fe395a55866c15"
msgid "Either:"
msgstr ""

msgctxt "9784f4c0e0aa651e456d6aa92b0e42c8"
msgid ""
"Reposition the cursor to where you want to start entering the new data in "
"the cell."
msgstr ""

msgctxt "e3187f81380145636d15c2d91c3dd1c5"
msgid "Single-click to select the cell."
msgstr ""

msgctxt "0dde691461af5c96c2d114beab11180e"
msgid ""
"Move the cursor to the Input Line on the Formula Bar (<g1>Figure 2</g1> on "
"page <g2>8</g2>) and click at the position where you want to start entering "
"the new data in the cell."
msgstr ""

msgctxt "646b84d7954e0c835b4d21ff5a531d89"
msgid ""
"When you have finished, click away from the cell to deselect it and your "
"editing changes are saved."
msgstr ""

msgctxt "c5190001cd95b45adaddfa9363cabaaa"
msgid "<g1></g1>Formatting data<g2></g2>"
msgstr ""

msgctxt "a439a3ca91b1f027a0b562198bfc3f9d"
msgid ""
"All the settings discussed in this section can also be set as a part of the "
"cell style. See the <g1>Calc Guide Chapter 4 Using Styles and Templates in "
"Calc</g1> for more information."
msgstr ""

msgctxt "4d2ba55f363a28dd9e9181ec5af70978"
msgid "<g1></g1>Multiple lines of text<g2></g2>"
msgstr ""

msgctxt "2917024df0435072869de0dfc81f77e4"
msgid ""
"Multiple lines of text can be entered into a single cell using automatic "
"wrapping or manual line breaks. Each method is useful for different "
"situations."
msgstr ""

msgctxt "7f32ea7ffeabefe9131f533520ed4a2a"
msgid "<g1></g1>Automatic wrapping<g2></g2>"
msgstr ""

msgctxt "237430db4b7e5c3e4fe40191964f2e6f"
msgid ""
"To automatically wrap multiple lines of text in a cell, use one of the "
"following methods."
msgstr ""

msgctxt "97716eceea0a7fe63e66ddd49765d5f7"
msgid ""
"Right-click on the cell and select <g1>Format Cells</g1> from the context "
"menu, or go to <g2>Format > Cells</g2> on the Menu bar, or press <g3>Ctrl+1</"
"g3>, to open the Format Cells dialog."
msgstr ""

msgctxt "3ef4861eece85ede4d455602739b3968"
msgid "Click on the <g1>Alignment</g1><g2> </g2>tab (<g3>Figure 30</g3>)."
msgstr ""

msgctxt "970c911f0f3db4e876c80cf2381d13a9"
msgid ""
"<g1></g1>Under <g2>Properties</g2>, select Wrap text automatically and click "
"<g3>OK</g3>."
msgstr ""

msgctxt "c7d51013b1099867d6280e79a16a8548"
msgid "Figure <g1>30</g1>: Format Cells dialog – Alignment page"
msgstr ""

msgctxt "ca2d8c5a2f0caa7e6ad1c78862c9edf8"
msgid ""
"Open the Sidebar (<g1>View > Sidebar</g1>) and click the <g2>Open Panel</g2> "
"(<g3>+</g3>) icon on the <g4>Alignment</g4> panel."
msgstr ""

msgctxt "8cd259c96ea07f0d34dcdf055157d6f8"
msgid ""
"Select the <g1>Wrap text</g1> option to apply the formatting immediately."
msgstr ""

msgctxt "922b2fd3748ad73075909112d50bddea"
msgid "Figure <g1>31</g1>: Wrap text formatting"
msgstr ""

msgctxt "c0dc6422a531036731537581462e8b7e"
msgid "<g1></g1>Manual line breaks<g2></g2>"
msgstr ""

msgctxt "b92f75faa17c71fc58ea4a0516ae019b"
msgid ""
"To insert a manual line break while typing in a cell, press <g1>Ctrl+Enter</"
"g1>. This method does not work with the cursor in the input line. When "
"editing text, double-click the cell, then reposition the cursor to where you "
"want the line break."
msgstr ""

msgctxt "a8540d0787db5c593b59fe656fdc32b9"
msgid ""
"When a manual line break is entered, the cell width does not change and your "
"text may still overlap the end of the cell. You have to change the cell "
"width manually or reposition your line break so that your text does not "
"overlap the end of the cell."
msgstr ""

msgctxt "5cd74d8ff82e42e2fcfb00a9a7f4a8b6"
msgid "<g1></g1><g2></g2>Shrinking text to fit the cell<g3></g3>"
msgstr ""

msgctxt "9fb65cdf7297d2229891fa75ac080a93"
msgid ""
"The font size of the data in a cell can automatically adjust to fit inside "
"cell borders. To do this, select the <g1>Shrink to fit cell size</g1> option "
"under <g2>Properties</g2> in the Format Cells dialog (<g3>Figure 30</g3>) on "
"the <g4>Alignment</g4> page. This dialog is also available by clicking the "
"<g5>More Options</g5> button in the <g6>Character</g6> title bar of the "
"<g7>Properties</g7> deck on the opened Sidebar."
msgstr ""

msgctxt "fd610cbd88c801b368ff787c6ba3b170"
msgid "<g1></g1>Formatting numbers<g2></g2>"
msgstr ""

msgctxt "17c0395b33cf018f59d5d5b36a3afe18"
msgid ""
"Several different number formats can be applied to cells by using icons on "
"the Formatting toolbar (highlighted in <g1>Figure 32</g1>). Select the cell, "
"then click the relevant icon to change the number format."
msgstr ""

msgctxt "8eddf783560d223e539cc6b4b9a5697c"
msgid "Figure <g1>32</g1>: Number icons on Formatting toolbar"
msgstr ""

msgctxt "b24854b4400761a9dd8e340900a46eac"
msgid ""
"For more control or to select other number formats, use the <g1>Numbers</g1> "
"page of the Format Cells dialog (<g2>Figure 21</g2> on page <g3>27</g3>):"
msgstr ""

msgctxt "7d4745cdede1a8fd86710d488a0269bc"
msgid "Apply any of the data types in the <g1>Category</g1> list to the data."
msgstr ""

msgctxt "ad642c2e76de0570c43c787de420c72c"
msgid ""
"Control the number of decimal places and leading zeros in <g1>Options</g1>."
msgstr ""

msgctxt "d9694df925e52973bd6a185b81527be7"
msgid "Enter a custom format code."
msgstr ""

msgctxt "cdc57a53a09c7c825734f6cc6196ea2c"
msgid ""
"The <g1>Language</g1> setting controls the local settings for the different "
"formats such as the date format and currency symbol."
msgstr ""

msgctxt "a23e72f5141801edc34f0c3677547a4c"
msgid ""
"Some number formats are available from the Sidebar’s <g1>Number Format</g1> "
"panel in the Properties deck. Click the <g2>More Options</g2> button to open "
"the Format Cells dialog described above."
msgstr ""

msgctxt "3536a25e9d25896169771795aabe5243"
msgid ""
"Figure <g1>33</g1>: Number format icons in the Number Format panel on the "
"Sidebar"
msgstr ""

msgctxt "54e89777c6e5ee7a894819ebbc41a248"
msgid "<g1></g1>Formatting a font<g2></g2>"
msgstr ""

msgctxt "cb3800df2b8f9a9ae5d98fee36b418f5"
msgid "To quickly select a font and format it for use in a cell:"
msgstr ""

msgctxt "e4c42118c06c6c28932eed5cf8116912"
msgid ""
"Click the small triangle on the right of the Font Name box on the Formatting "
"toolbar (highlighted in <g1>Figure 34</g1>) and select a font from the drop-"
"down list."
msgstr ""

msgctxt "d465a02e4bad33be379e633eccb57312"
msgid ""
"Click on the small triangle on the right of the Font Size on the Formatting "
"toolbar and select a font size from the drop down list."
msgstr ""

msgctxt "bc1057fb52ca603e8d18077e06792ca3"
msgid "Figure <g1>34</g1>: Font Name and Size on Formatting toolbar"
msgstr ""

msgctxt "9c947297160ea4d1a11bd7299d93d03a"
msgid ""
"To change the character format, click on the <g1>Bold</g1>, <g2>Italic</g2>, "
"or Underline icons."
msgstr ""

msgctxt "c9d5a6ff8010a7ab90187395af317582"
msgid ""
"<g1></g1>To change the paragraph alignment of the font, click on one of the "
"four alignment icons (Left, Center, Right, Justified) <g2><g3></g3></g2>."
msgstr ""

msgctxt "225f6158ae30482d90c5423d306c5d1e"
msgid ""
"To change the font color, click the arrow next to the Font Color icon "
"<g1><g2></g2></g1> to display the color palette, then select the desired "
"color."
msgstr ""

msgctxt "a2fb0fbb763a149b5be8b9663bc4e785"
msgid ""
"The <g1>Properties</g1> deck of the Sidebar has two panels, <g2>Character</"
"g2> and <g3>Alignment</g3>, which between them contain all the formatting "
"controls from the Formatting toolbar."
msgstr ""

msgctxt "ec2ec67f11cb702c80e02108e45f5d06"
msgid ""
"To specify the language used in the cell, open the <g1>Font</g1> page on the "
"Format Cells dialog. You can also select the <g2>More Options</g2> button on "
"either of the Sidebar panels to open the Format Cells dialog. Changing "
"language in a cell allows different languages to be used within the same "
"document."
msgstr ""

msgctxt "2459d5599d7d1a767d73b37efdfca0df"
msgid ""
"Use the <g1>Font Effects</g1> tab on the Format Cells dialog to set other "
"font characteristics. See the <g2>Calc Guide Chapter 4 Using Styles and "
"Templates in Calc</g2> for more information."
msgstr ""

msgctxt "a8c9a9c50f344020ebc9a543313aa668"
msgid "<g1></g1>Formatting cell borders<g2></g2>"
msgstr ""

msgctxt "0894228ba1590f931830c478f21bbf15"
msgid ""
"To format the borders of a cell or a group of selected cells, click on the "
"Borders icon <g1><g2></g2></g1> on the Formatting toolbar, and select one of "
"the border options displayed in the palette."
msgstr ""

msgctxt "81752593e33a289196377425851d97c2"
msgid ""
"To format the line style and line color for the borders of a cell, click the "
"small arrows next to the Line Style <g1><g2></g2></g1> and Line Color "
"(Border Color) <g3><g4></g4></g3> icons on the Formatting toolbar. A line "
"style palette and a border color palette respectively are displayed."
msgstr ""

msgctxt "f380e4f95c98ce20df59e08850e02069"
msgid ""
"The <g1>Cell Appearance</g1> panel of the <g2>Properties</g2> deck in the "
"Sidebar contains <g3>Cell border</g3>, <g4>Line style</g4> and L<g5>ine "
"color</g5> controls."
msgstr ""

msgctxt "e14c78a5cbfaf96306e5f3ddb0aac8f5"
msgid ""
"For more control, including the spacing between cell borders and any data in "
"the cell, use the <g1>Borders</g1> page of the Format Cells dialog "
"(<g2>Figure 21</g2> on page <g3>27</g3>), where you can also define a shadow "
"style. Clicking the <g4>More Options</g4> button on the <g5>Cell Appearance</"
"g5> title bar, or clicking <g6>More</g6> in the panel’s line style drop-down "
"list, opens the Format Cells dialog at the <g7>Borders</g7> page. "
msgstr ""

msgctxt "0580b008f4ed3c1930be4f37e5e5771d"
msgid ""
"See the <g1>Calc Guide Chapter 4 Using Styles and Templates in Calc</g1> for "
"more information."
msgstr ""

msgctxt "267ea12f4ddd8fcb2b375e4cf55fa3e3"
msgid ""
"Cell border properties apply only to the selected cells and can only be "
"changed if you are editing those cells. For example, if cell C3 has a top "
"border, that border can only be removed by selecting C3. It cannot be "
"removed in C2 despite also appearing to be the bottom border for cell C2."
msgstr ""

msgctxt "a5b038a02891df88020ea81006620103"
msgid "<g1></g1>Formatting cell background<g2></g2>"
msgstr ""

msgctxt "3c4121506f1241de58a8691dc821fd6d"
msgid ""
"To format the background color for a cell or a group of cells, click the "
"small arrow next to the Background Color icon <g1><g2></g2></g1> on the "
"Formatting toolbar. A color palette, similar to the Font Color palette, is "
"displayed. You can also use the <g3>Background</g3> tab of the Format Cells "
"dialog (<g4>Figure 21</g4> on page <g5>27</g5>). The <g6>Cell Appearance</"
"g6> panel of the <g7>Properties</g7> deck in the Sidebar contains a <g8>Cell "
"background</g8> control with a color palette. See the <g9>Calc Guide Chapter "
"4 Using Styles and Templates in Calc</g9> for more information."
msgstr ""

msgctxt "ea38e94d32a30996e7e536ae588c72c8"
msgid "<g1></g1><g2></g2>AutoFormat of cells<g3></g3>"
msgstr ""

msgctxt "3aceb0250cf40465811d72dede715dd5"
msgid "<g1></g1>Using AutoFormat<g2></g2>"
msgstr ""

msgctxt "a93572cd2d19859c7e3e504bd2c04b2f"
msgid ""
"You can use <g1></g1><g2></g2>Calc’s AutoFormat<g3></g3> feature to format a "
"group of cells quickly and easily."
msgstr ""

msgctxt "60248a1f205f4091025edcd5db1999cf"
msgid ""
"Select the cells in at least three columns and rows, including column and "
"row headers, that you want to format."
msgstr ""

msgctxt "5dfd6d2c44528f06bac2f5848bdff5b4"
msgid ""
"Go to <g1>Format > AutoFormat</g1> on the Menu bar to open the "
"<g2>AutoFormat</g2> dialog (<g3>Figure 35</g3>)."
msgstr ""

msgctxt "ecdc247ae5399e1f285574d4cb5e9848"
msgid "Select the type of format and format color from the list."
msgstr ""

msgctxt "893da0283237cae51152475d858642e7"
msgid ""
"If necessary, click <g1>More</g1> to open <g2>Formatting</g2> if Formatting "
"is not visible."
msgstr ""

msgctxt "40fefee48764a93599c8b91f12f73e0e"
msgid ""
"Select the formatting properties to be included in the AutoFormat function."
msgstr ""

msgctxt "4b54b0a811ee0d6f8d054184a50ef3f4"
msgid "Figure <g1>35</g1>: AutoFormat dialog"
msgstr ""

msgctxt "4e6431fcbcb39dbc28cc8e3a090c5a94"
msgid "<g1></g1>Defining a new AutoFormat<g2></g2>"
msgstr ""

msgctxt "b864702d92bc81ff244864fa7b5ed4ad"
msgid ""
"You can define a new AutoFormat so that it becomes available for use in all "
"spreadsheets."
msgstr ""

msgctxt "8ce8fea6a62d7044cfc1e196280b51d1"
msgid ""
"Format the data type, font, font size, cell borders, cell background and so "
"on for a group of cells."
msgstr ""

msgctxt "0e5da088572a197c33d67621936367ce"
msgid ""
"Go to <g1>Edit > Select All</g1> on the Menu bar to select the whole "
"spreadsheet."
msgstr ""

msgctxt "ba44139606522df7e7ababd7bec06115"
msgid ""
"Go to <g1>Format > AutoFormat</g1> to open the AutoFormat dialog and the "
"<g2>Add</g2> button is now active."
msgstr ""

msgctxt "563b38aafa44608ee35b9358c8fa31d0"
msgid "Click <g1>Add</g1>."
msgstr ""

msgctxt "6d877a6a404df19e3e3d0d7533965cd6"
msgid ""
"In the <g1>Name</g1> box of the Add AutoFormat dialog that opens, type a "
"meaningful name for the new format."
msgstr ""

msgctxt "e44bb7d81c7f0b5ffe3a3d51ad29a82b"
msgid ""
"Click <g1>OK</g1> to save. The new AutoFormat is now available in the "
"<g2>Format</g2> list in the AutoFormat dialog."
msgstr ""

msgctxt "a1439634a7dfb2acc3d6539ee5f5e957"
msgid "<g1></g1><g2></g2><g3></g3>Using themes<g4></g4>"
msgstr ""

msgctxt "ffa2e69a9ae4bc12ccb73df65a7512c1"
msgid ""
"Calc comes with a predefined set of formatting themes that you can apply to "
"spreadsheets. It is not possible to add themes to Calc and they cannot be "
"modified. However, you can modify their styles <g1></g1>after you apply them "
"to a spreadsheet and the modified styles are only available for use for that "
"spreadsheet when you save the spreadsheet."
msgstr ""

msgctxt "58775d961bf2e275585df24623e91f70"
msgid "To apply a theme to a spreadsheet:"
msgstr ""

msgctxt "7027a3b649c33f7ca0fb0e55f26bfd6c"
msgid ""
"Click the <g1>Choose Themes</g1> icon <g2><g3></g3></g2> in the <g4>Tools</"
"g4> toolbar. If this toolbar is not visible, go to <g5>View > Toolbars</g5> "
"on the Menu bar and select <g6>Tools</g6>, and the <g7>Theme Selection</g7> "
"dialog (<g8>Figure 36</g8>) opens. This dialog lists the available themes "
"for the whole spreadsheet."
msgstr ""

msgctxt "26e3a12524136bddbad3e949974b7547"
msgid ""
"Select the theme that you want to apply. As soon as you select a theme, the "
"theme styles are applied to the spreadsheet and are immediately visible."
msgstr ""

msgctxt "50f4c871e2fed840d327f1ef3bcbce12"
msgid ""
"If you wish, you can now open the Styles and Formatting window to modify "
"specific styles. These modifications do not modify the theme; they only "
"change the appearance of the style in the specific spreadsheet you are "
"creating."
msgstr ""

msgctxt "971abff9b126f3b05a7386de46c82f9c"
msgid "Figure <g1>36</g1>: Theme Selection dialog"
msgstr ""

msgctxt "e6d58ac9d73f8ef88bfba0b56da5191c"
msgid "<g1></g1><g2></g2>Using <g3></g3>conditional formatting<g4></g4>"
msgstr ""

msgctxt "4c1b33f7ff57830dc4215c15a4d7c40b"
msgid ""
"You can set up cell formats to change depending on conditions that you "
"specify. For example, in a table of numbers, you can show all the values "
"above the average in green and all those below the average in red."
msgstr ""

msgctxt "a92661a5809e67232d13b41f0d658134"
msgid ""
"Conditional formatting depends upon the use of styles and the AutoCalculate "
"feature must be enabled. Go to <g1>Tools > Cell Contents > AutoCalculate</"
"g1> on the Menu bar to enable this feature. See the <g2>Calc Guide Chapter 2 "
"Entering, Editing, and Formatting Data</g2> for more information."
msgstr ""

msgctxt "dd105d69004f837529eda06eafd7b699"
msgid "<g1></g1><g2></g2><g3></g3>Hiding and showing data<g4></g4>"
msgstr ""

msgctxt "d4dbc1580098baa5c8167e4e08136fc0"
msgid ""
"In Calc you can hide elements so that they are neither visible on a computer "
"display nor printed when a spreadsheet is printed. However, hidden elements "
"can still be selected for copying if you select the elements around them. "
"For example, if column B is hidden, it is copied when you select columns A "
"and C."
msgstr ""

msgctxt "76d1c2970bb0c5d7a16ffda427d85e37"
msgid ""
"For more information on how to hide and show data, including how to use "
"outline groups and filtering, see the <g1>Calc Guide Chapter 2 Entering, "
"Editing, and Formatting Data</g1>."
msgstr ""

msgctxt "56d72271b8146a8da1f6c3db08920d45"
msgid "<g1></g1><g2></g2>Hiding data<g3></g3>"
msgstr ""

msgctxt "b4df4b20a4dfc6a5841e205bc0c41e0e"
msgid "To hide sheets, rows, and columns:"
msgstr ""

msgctxt "b637a5cea1dd23731caa1ec7ca0a8e25"
msgid "Select the sheet, row or column you want to hide."
msgstr ""

msgctxt "4544d4fdc49fb02843c8b6b3d557d8cb"
msgid ""
"Go to <g1>Format</g1> on the Menu bar and select <g2>Sheet</g2>, <g3>Row</"
"g3> or <g4>Column</g4>."
msgstr ""

msgctxt "b3f05dbe42e76235d478c8eff20dedc2"
msgid ""
"Select <g1>Hide</g1> from the menu and the sheet, row or column can no "
"longer viewed or printed."
msgstr ""

msgctxt "da366180842525ef15dd2be1c3c47428"
msgid ""
"Alternatively, right-click on the sheet tab, row header or column header and "
"select <g1>Hide</g1> from the context menu."
msgstr ""

msgctxt "0820137ed23d864c2815103da37292e4"
msgid "To hide and protect data in selected cells:"
msgstr ""

msgctxt "bda8e22c54acf9ef39746064e3f69bf0"
msgid ""
"Go to <g1>Tools > Protect Document</g1> and select <g2>Sheet</g2> from the "
"menu options. The <g3>Protect Sheet</g3> dialog dialog will open (<g4>Figure "
"37</g4>)."
msgstr ""

msgctxt "876d081e00bfdfe3c2d5935f9b084f1f"
msgid ""
"Select <g1>Protect this sheet and the contents of protected cells</g1>."
msgstr ""

msgctxt "766db48041a55888e701120b11e23e0f"
msgid "Create a password and then confirm the password."
msgstr ""

msgctxt "8ea50a5ca13240ca0a65ab07769d1a55"
msgid "Select or deselect the user selection options for cells."
msgstr ""

msgctxt "8bca9cafbe713d7202dc12585544cb55"
msgid "Select the cells you want to hide."
msgstr ""

msgctxt "e6c5eb7053077c45a3318733fab9cbec"
msgid ""
"Go to <g1>Format > Cells</g1> on the Menu bar, or right-click and select "
"<g2>Format Cells</g2> from the context menu, or use the keyboard shortcut "
"<g3>Ctrl+1</g3> to open the <g4>Format Cells</g4> dialog."
msgstr ""

msgctxt "57f466401a261993425f77208c7a2c2e"
msgid ""
"Click the <g1>Cell Protection</g1> tab (<g2>Figure 38</g2>) and select an "
"option to hide the cells."
msgstr ""

msgctxt "fb742019ffaa7e152477b261792d492d"
msgid "Figure <g1>37</g1>: Protect Sheet dialog"
msgstr ""

msgctxt "07d3bf12047d84ce68c70f38b5eccbdf"
msgid "Figure <g1>38</g1>: Cell Protection page in Format Cells dialog"
msgstr ""

msgctxt "21e979ab3c023f9521c967dbb9fa13e6"
msgid "<g1></g1>Note"
msgstr ""

msgctxt "de5841c78de6281d85baacccf6e29711"
msgid ""
"When data in cells are hidden, <g1>t</g1>he blank cells remain visible in "
"the spreadsheet."
msgstr ""

msgctxt "6386c1a6b40cb1820a3c742cdd714faa"
msgid "<g1></g1>Showing data<g2></g2>"
msgstr ""

msgctxt "8acffbdc1a5ae0436e4dba17f8e0233b"
msgid "To show hidden sheets, rows, and columns:"
msgstr ""

msgctxt "1965f2a6b384d8c76c04e51893e29f90"
msgid ""
"Select the sheets, rows or columns each side of the hidden sheet, row or "
"column."
msgstr ""

msgctxt "4f338cb687d54cc444519c8b5ed466c3"
msgid ""
"Select <g1>Show</g1> from the menu and the sheet, row or column will be "
"displayed and can be printed."
msgstr ""

msgctxt "e82a44077da2aacf44304ba87bc817d0"
msgid ""
"Alternatively, right-click on the sheet tabs, row headers or column headers "
"and select <g1>Show</g1> from the context menu."
msgstr ""

msgctxt "1cb0a6532d5f4b966351b2c57bd5a356"
msgid "To show hidden data in cells:"
msgstr ""

msgctxt "2df40f2ae27b06a027e70d2cf7d94054"
msgid ""
"Go to <g1>Tools > Protect Document</g1> and select <g2>Sheet</g2> from the "
"menu options."
msgstr ""

msgctxt "e8fb70839ed388a558d983287024698d"
msgid "Enter the password to unprotect the sheet and click <g1>OK</g1>."
msgstr ""

msgctxt "51e2aa0c9219f02dea7b731d9382386d"
msgid ""
"Click the <g1>Cell Protection</g1> tab (<g2>Figure 38</g2>) and deselect the "
"hide options for the cells."
msgstr ""

msgctxt "396fcb7768720eec04eaec8a3c94bdae"
msgid "<g1></g1>Sorting records<g2></g2>"
msgstr ""

msgctxt "dafcd849994baf1d5f3668c4759a0cf4"
msgid ""
"<g1></g1><g2></g2>Sorting within Calc arranges the cells in a sheet using "
"the sort criteria that you specify. Several criteria can be used and a sort "
"applies each criteria consecutively. Sorts are useful when you are searching "
"for a particular item and become even more useful after you have filtered "
"data."
msgstr ""

msgctxt "68522af74274c342526989fe58c3bce6"
msgid ""
"Also, sorting is useful when you add new information to your spreadsheet. "
"When a spreadsheet is long, it is usually easier to add new information at "
"the bottom of the sheet, rather than adding rows in their correct place. "
"After you have added information, you then carry out a sort to update the "
"spreadsheet."
msgstr ""

msgctxt "2f2c3db6d8a07933389fe51c1490126c"
msgid ""
"For more information on how to sort records and the sorting options "
"available, see the <g1>Calc Guide Chapter 2 Entering, Editing, and "
"Formatting Data</g1>."
msgstr ""

msgctxt "a3684ecdbe5bf84bc0a3fbd7e448ee21"
msgid "Figure <g1>39</g1>: Sort Criteria dialog"
msgstr ""

msgctxt "9b6f70fe198a421d4d5822b474d83e08"
msgid "<g1></g1>To sort cells in your spreadsheet:"
msgstr ""

msgctxt "2906943c0dff116233d4d2af2d0f25e1"
msgid "Select the cells to be sorted."
msgstr ""

msgctxt "c4f86d1877aeb086325437cae4a763b8"
msgid ""
"Go to <g1>Data > Sort</g1> on the Menu bar to open the <g2>Sort</g2> dialog "
"(<g3><g4>Figure 39</g4></g3>)."
msgstr ""

msgctxt "11544b742e3415ea53ec182538dd6f6d"
msgid ""
"Select the sort criteria from the drop down lists. The selected lists are "
"populated from the selected cells."
msgstr ""

msgctxt "4d40ad358020c64e2501d84d2704bac1"
msgid ""
"Select either ascending order (A-Z, 1-9) or descending order (Z-A, 9-1)."
msgstr ""

msgctxt "5d29b695f41273db32efacb6317c7ced"
msgid "Click <g1>OK</g1> and the sort is carried out on your spreadsheet."
msgstr ""

msgctxt "e11938c54ff4f12462eab7ef34a9cc54"
msgid "<g1></g1>Using formulas and functions<g2></g2>"
msgstr ""

msgctxt "9a68ca1e07efff23b34e23aebc1ad4bd"
msgid ""
"You may need more than numbers and text on your spreadsheet. Often the "
"contents of one cell depend on the contents of other cells. Formulas are "
"equations that use numbers and variables to produce a result. Variables are "
"placed in cells to hold data required equations."
msgstr ""

msgctxt "eeca87eb7b6cf5253ddff3a4983a9fa0"
msgid ""
"A function is a predefined calculation entered in a cell to help you analyze "
"or manipulate data. All you have to do is enter the arguments and the "
"calculation is automatically made for you. Functions help you create the "
"formulas required to get the results that you are looking for."
msgstr ""

msgctxt "8da6a73b825104df56d9472023a1141b"
msgid ""
"See the <g1>Calc Guide Chapter 7 Using Formulas and Functions</g1> for more "
"information."
msgstr ""

msgctxt "7c78117809fe982948caddf35af0956a"
msgid "<g1></g1>Analyzing data<g2></g2>"
msgstr ""

msgctxt "a9087a073ba5a493ab2d50a7d635b64e"
msgid ""
"Calc includes several tools to help you analyze the information in your "
"spreadsheets, ranging from features for copying and reusing data, to "
"creating subtotals automatically, to varying information to help you find "
"the answers you need. These tools are divided between the Tools and Data "
"menus."
msgstr ""

msgctxt "437be1c93b78dab2c11e09dc90111c1b"
msgid ""
"One of the most useful of these tools is the PivotTable, which is used for "
"combining, comparing, and analyzing large amounts of data easily. Using the "
"PivotTable, you can view different summaries of the source data, display the "
"details of areas of interest, and create reports, whether you are a "
"beginner, an intermediate or advanced user."
msgstr ""

msgctxt "1cc12fea0532590d58255d996ff83008"
msgid ""
"See the <g1>Calc Guide Chapter 8 Using Pivot Tables</g1> and <g2>Chapter 9 "
"Data Analysis</g2> for more information on pivot tables and other tools "
"available in Calc to analyze your data."
msgstr ""

msgctxt "f30efadf6b7fcdbaaa04b66b005e7758"
msgid "<g1></g1>Printing<g2></g2>"
msgstr ""

msgctxt "57e52a4aae9f42982c332090b85e5a52"
msgid ""
"Printing from Calc is much the same <g1></g1>as printing<g2></g2> from other "
"LibreOffice components (see <g3>Chapter 10 Printing, Exporting, and "
"Emailing</g3> in this guide). However, some details for printing in Calc are "
"different, especially regarding preparation for printing."
msgstr ""

msgctxt "0ffdc522147b3779bf11e261528ee8c1"
msgid "<g1></g1><g2></g2>Print ranges<g3></g3>"
msgstr ""

msgctxt "6c1eccb0b4d19a26e8b3f7631f00432e"
msgid ""
"Print ranges have several uses, including printing only a specific part of "
"the data or printing selected rows or columns on every page. For more "
"information about using print ranges, see the <g1>Calc Guide Chapter 6 "
"Printing, Exporting, and E-mailing</g1>."
msgstr ""

msgctxt "8a9a908341f1b6dfa45fe0d5dc290bb2"
msgid "<g1></g1><g2></g2><g3></g3>Defining a print range<g4></g4>"
msgstr ""

msgctxt "f0236f2bc17db640206758c694e23136"
msgid "To define a new print range or modify an existing print range:"
msgstr ""

msgctxt "8f662292575a972f0ca48717319dec92"
msgid "Select the range of cells to be included in the print range."
msgstr ""

msgctxt "e130c8aa9b3852fecdc4a5566e68bd81"
msgid ""
"Go to <g1>Format > Print Ranges > Define</g1> on the Menu bar<g2>. P</g2>age "
"break lines are displayed on screen."
msgstr ""

msgctxt "bc1e8a1f8fab4e095c8df251bb06faaa"
msgid ""
"<g1></g1>To check the print range, go to <g2>File > Page Preview </g2>on the "
"Menu bar or click on the <g3>Page Preview</g3> icon <g4><g5><g6></g6></g5></"
"g4>. LibreOffice will display the cells in the print range."
msgstr ""

msgctxt "eeeef72281f3c30cb124578a108cd3ae"
msgid "<g1></g1>Adding to a print range<g2></g2>"
msgstr ""

msgctxt "c34e13df23a77f56f70b100aafdafc0e"
msgid ""
"After defining a print range, you can add more cells to it by creating "
"another print range. This allows multiple, separate areas of the same sheet "
"to be printed while not printing the whole sheet."
msgstr ""

msgctxt "484a51bd6730e79f962b532266d1f690"
msgid ""
"After defining a print range, select an extra range of cells for adding to "
"the print range."
msgstr ""

msgctxt "7c22a2a0339b653feaa3b873e0e1153d"
msgid ""
"Go to <g1>Format > Print Ranges > Add</g1> on the Menu bar to add the extra "
"cells to the print range. The page break lines are no longer displayed on "
"the screen."
msgstr ""

msgctxt "718c43bab5ff6630efdaccfc369714f1"
msgid ""
"To check the print ranges, go to <g1>File > Page Preview</g1> on the Menu "
"bar or click on the <g2>Page Preview</g2> icon <g3><g4><g5></g5></g4></g3>. "
"LibreOffice will display the print ranges as separate pages."
msgstr ""

msgctxt "d52a6d6293c2cd66404dd86ca8ad0ef2"
msgid ""
"The additional print range will print as a separate page, even if both "
"ranges are on the same sheet."
msgstr ""

msgctxt "7fda1c5b7155bef9554d37f87e45084a"
msgid "<g1></g1>Removing a print range<g2></g2>"
msgstr ""

msgctxt "dff77190c5a771b19ef1bd290b5daba1"
msgid ""
"It may become necessary to remove a defined print range, for example, if the "
"whole sheet needs to be printed later."
msgstr ""

msgctxt "44a1564f3c21cd786edf10422ecca81a"
msgid ""
"To remove all the defined print ranges, go to <g1>Format > Print Ranges > "
"Remove on the Menu bar. </g1>After the print ranges have been removed, the "
"default page break lines will appear on the screen."
msgstr ""

msgctxt "70ee15eb2ee0fb8854fd057bb425114d"
msgid "<g1></g1>Editing a print range<g2></g2>"
msgstr ""

msgctxt "1dc47c2bf6bf9ff6765a953d8c57346e"
msgid ""
"At any time, you can directly edit the print range, for example to remove or "
"resize part of the print range. Go to <g1>Format > Print Ranges > Edit</g1> "
"on the Menu bar to open the <g2>Edit Print Ranges</g2> dialog where you can "
"define the print range."
msgstr ""

msgctxt "77a57f9f4298abec88dd945402d3aef7"
msgid "<g1></g1>Printing options<g2></g2>"
msgstr ""

msgctxt "629dede80160f2451a3463265fa7f4b1"
msgid ""
"To select the printing options for <g1></g1>page order, details, and scale "
"to be used when printing a spreadsheet:"
msgstr ""

msgctxt "696137d85c5b8e55117cb17394d48537"
msgid ""
"Go to <g1>Format > Page</g1> on the Menu bar to open the <g2>Page Style</g2> "
"dialog (<g3>Figure 40</g3>)."
msgstr ""

msgctxt "9141618a126ac28b37229b14412274c9"
msgid ""
"Select the <g1>Sheet</g1> tab and make your selections from the available "
"options."
msgstr ""

msgctxt "0877f2566e7bfda7cc21e150734aa568"
msgid "Click <g1>OK.</g1>"
msgstr ""

msgctxt "f672caf729130431ecf4cd07b1b98913"
msgid ""
"For more information on printing options, see the <g1>Calc Guide Chapter 6 "
"Printing, Exporting, and E‑mailing</g1>."
msgstr ""

msgctxt "64afcd0e286c7646bea0609e85666d02"
msgid "<g1></g1>Repeat printing <g2></g2>of rows or columns<g3></g3>"
msgstr ""

msgctxt "ec51a1c966c2e2aeda49d45eb9212d02"
msgid ""
"If a sheet is printed on multiple pages, you can set up certain rows or "
"columns to repeat on each printed page. For example, if the top two rows of "
"the sheet as well as column A need to be printed on all pages, do the "
"following:"
msgstr ""

msgctxt "c614310137369fd0f50e65c812669970"
msgid ""
"Go to <g1>Format > Print Ranges > Edit on t</g1>he Menu bar to open the "
"<g2>Edit Print Ranges</g2> dialog (<g3>Figure 41</g3>)."
msgstr ""

msgctxt "57b914d315c3fb00300300a16fecea69"
msgid ""
"Type the row identifiers in the <g1>Rows to repeat</g1> box. For example, to "
"repeat rows 1 and 2, type <g2>$1:$2</g2>. This automatically changes "
"<g3>Rows to repeat</g3>  from, <g4>- none -</g4>  to <g5>- user defined -</"
"g5>."
msgstr ""

msgctxt "6f73f34b44f444d06d3512da3a8c4dec"
msgid "Figure <g1>40</g1>: Page Style dialog"
msgstr ""

msgctxt "7c9805f06d738aadd5d4d96ea1b19f44"
msgid ""
"Type the column identifiers in the <g1>Columns to repeat</g1> box. For "
"example, to repeat column A, type <g2>$A</g2>. In the <g3>Columns to repeat</"
"g3> list, - <g4>none</g4> - changes to - <g5>user defined</g5> -."
msgstr ""

msgctxt "af2dff2209a74157f4f1dd9dc0dd5f60"
msgid ""
"For more information on editing print ranges, see the <g1>Calc Guide</g1>, "
"Chapter 6 Printing, Exporting, and E‑mailing."
msgstr ""

msgctxt "b2c76a1cde1eebef1dda4e9d12d3c295"
msgid "<g1><g2></g2></g1>Figure <g3>41</g3>: Edit Print Ranges dialog"
msgstr ""

msgctxt "3e465653c28507a23bd92eec63e363f9"
msgid "<g1></g1>Page breaks<g2></g2>"
msgstr ""

msgctxt "ed3ec1a343de7eea0eee63d4432954b7"
msgid ""
"While defining a print range can be a powerful tool, it may sometimes be "
"necessary to manually adjust the Calc printout manually using a <g1>manual "
"or page break</g1>. A page break helps to ensure that your data prints "
"properly according to your page size and page orientation. You can insert a "
"horizontal page break above or a vertical page break to the left of the "
"active cell."
msgstr ""

msgctxt "1451fcf67b1b2c3ac35948525c7b90dd"
msgid ""
"<g1></g1>For more information on manual breaks, see the <g2>Calc Guide "
"Chapter 6 Printing, Exporting, and E‑mailing</g2>."
msgstr ""

msgctxt "a33d58bbe1272c6e6cd5c96d412ee33f"
msgid "<g1></g1>Inserting a <g2></g2><g3></g3>break<g4></g4>"
msgstr ""

msgctxt "80f1043dd30be6f529bf7b48e352e9ff"
msgid "To insert a page break:"
msgstr ""

msgctxt "de01b4bae8c6cc4f53e42db427889a66"
msgid "Navigate to the cell where the page break will begin."
msgstr ""

msgctxt "bf57114124892d6443a4c311f7bd04e2"
msgid "Go to <g1>Insert > Page Break</g1> on the Menu bar."
msgstr ""

msgctxt "eee079b572fbc527bf1aa49ecc9437e8"
msgid ""
"Select <g1>Row Break</g1> to create a page break above the selected cell."
msgstr ""

msgctxt "491377a5125bb7e234f6e349a0dec248"
msgid ""
"Select <g1>Column Break</g1> to create a page break to the left of the "
"selected cell."
msgstr ""

msgctxt "4d7cda88b41c57f6962bb08d2d070dfa"
msgid "<g1></g1>Deleting a page break<g2></g2>"
msgstr ""

msgctxt "f6b8c7f7553228968c4f9d1d61cb132c"
msgid "To remove a page break:"
msgstr ""

msgctxt "700f231acbc61c333dfe2b4902e37184"
msgid "Navigate to a cell that is next to the break you want to remove."
msgstr ""

msgctxt "d015dd69a5b0fd7c72d9a38bc4d6ea40"
msgid "Go to <g1>Edit > Delete Page Break</g1> on the Menu bar."
msgstr ""

msgctxt "6bcbc944fd70cfe8249342710efeb92d"
msgid ""
"Select <g1>Row Break</g1> or <g2>Column Break</g2> depending on your need "
"and break is removed."
msgstr ""

msgctxt "4575c58f2f50b4ef40c42299410ae135"
msgid ""
"Multiple manual row and column breaks can exist on the same page. When you "
"want to remove them, you have to remove each break individually."
msgstr ""

msgctxt "ec8c18b832822fb8c2f827f46309c76e"
msgid "<g1></g1>Headers and footers<g2></g2>"
msgstr ""

msgctxt "bb6e680d8769296107322b2dc7a23115"
msgid ""
"<g1></g1><g2></g2>Headers and footers are predefined pieces of text that are "
"printed at the top or bottom of a page when a spreadsheet is printed. "
"Headers and footers are set and defined using the same method. For more "
"information on setting and defining headers and footers, see the <g3>Calc "
"Guide Chapter 6 Printing, Exporting, and E‑mailing</g3>."
msgstr ""

msgctxt "849f42ec02aed22513f82c3eb610acdf"
msgid ""
"Headers and footers are also assigned to a page style. You can define more "
"than one page style for a spreadsheet and assign different page styles to "
"different sheets within a spreadsheet. For more information on page styles, "
"see the <g1>Calc Guide Chapter 4 Using Styles and Templates</g1>."
msgstr ""

msgctxt "78465c47dc4bf74e3de6259ced1729b6"
msgid "<g1></g1>Setting a header or footer<g2></g2>"
msgstr ""

msgctxt "b75765fe9cca75f37ac02dbbebb19a77"
msgid "To set a header or footer:"
msgstr ""

msgctxt "e5609d19a3ed20bed07f7f62362c249f"
msgid "Navigate to the sheet that you want to set the header or footer for."
msgstr ""

msgctxt "c8541bafe3a3d9a5d06704a97fc6e820"
msgid ""
"Go to <g1>Format > Page</g1> on the Menu bar to open the <g2>Page Style</g2> "
"dialog (<g3>Figure 42</g3>)."
msgstr ""

msgctxt "53bb788cf5604fe3b046c55b784bc953"
msgid ""
"On the Page Style dialog, select <g1>Header</g1> or <g2>Footer</g2> tab."
msgstr ""

msgctxt "946e20166a565df2cdf8175ccf613711"
msgid "Select the <g1>Header on</g1> or <g2>Footer on</g2> option."
msgstr ""

msgctxt "c7f6be56003f0321d5f793726689fec9"
msgid ""
"Select <g1>Same content left/right </g1>option if you want the same header "
"or footer to appear on all the printed pages."
msgstr ""

msgctxt "07b3a87db42d52ca1e4c239719a937a3"
msgid ""
"Set the margins, spacing, and height for the header or footer. You can also "
"select <g1>AutoFit height</g1> box to automatically adjust the height of the "
"header or footer."
msgstr ""

msgctxt "ad04b0cdd4ea89e1731c3ea11ba8bcfe"
msgid ""
"To change the appearance of the header or footer, click on <g1>More</g1> to "
"open the borders and background dialog."
msgstr ""

msgctxt "ea69496282a880596a418e311e359d21"
msgid ""
"To set the contents, for example page number, date and so on, that appears "
"in the header or footer, click on <g1>Edit</g1> to open the style dialog."
msgstr ""

msgctxt "28dc70b2963ca27a2e0ced2d377ed3ec"
msgid "Figure <g1>42</g1>: Header page of Page Style dialog"
msgstr ""

msgctxt "e283de708c5ebe2c91072209a501375c"
msgid "<g1></g1><g2></g2><g3><g4><g5><x6/><x7/></g5></g4></g3><g8></g8>"
msgstr ""

msgctxt "6cddbed1f6a86fc1be803bd9d6a3224a"
msgid "	<g1>Printing</g1> <g2>| </g2><g3>47</g3>"
msgstr ""

msgctxt "4488b896cec3260a84cda6ab8db6fb59"
msgid "<g1>42</g1> <g2>| </g2><g3><x4/></g3>"
msgstr ""

msgctxt "1457098a57c4e6e1711dace694ce8513"
msgid "<x1/> <g2>| </g2><g3>5</g3>"
msgstr ""

msgctxt "e6fd308f375df202974bda63e1f98115"
msgid ""
"<g1>Documentation for LibreOffice is available at </g1><g2><g3><g4>http://"
"www.libreoffice.org/get-help/documentation</g4></g3></g2>"
msgstr ""

msgctxt "29a668fc343209f2feee1be62d70382a"
msgid "<g1><g2>4</g2></g1><g3>| </g3><x4/>"
msgstr ""