-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathGS6005-GettingStartedWithCalc.xlf
2977 lines (2977 loc) · 346 KB
/
GS6005-GettingStartedWithCalc.xlf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<?xml version='1.0' encoding='UTF-8'?>
<xliff xmlns="urn:oasis:names:tc:xliff:document:1.1" version="1.1">
<file original="GS6005-GettingStartedWithCalc.odt" source-language="en" datatype="plaintext">
<body>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[1]">
<source><x id="0" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[1]/draw:frame[0]"/>Getting Started Guide</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[2]">
<source>Chapter 5 <g id="1"/><g id="2"/>Getting Started with Calc</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[3]">
<source>Using Spreadsheets in LibreOffice</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[0]">
<source><x id="3" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[0]/text:bookmark-start[0]"/>Copyright<x id="4" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[0]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[0]">
<source>This document is Copyright © 2018 by the LibreOffice Documentation Team. Contributors are listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License (<g id="5">http://www.gnu.org/licenses/gpl.html</g>), version 3 or later, or the Creative Commons Attribution License (<g id="6">http://creativecommons.org/licenses/by/4.0/</g>), version 4.0 or later.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[1]">
<source>All trademarks within this guide belong to their legitimate owners.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[1]">
<source><x id="7" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[1]/text:bookmark-start[0]"/>Contributors<x id="8" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[1]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[2]">
<source>This book is adapted and updated from <g id="9">Getting Started with OpenOffice.org 3.3</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[2]">
<source><x id="10" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[2]/text:bookmark-start[0]"/>To <g id="11">t</g>his <g id="12">e</g>dition<x id="13" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[2]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[0]/table:table-row[0]/table:table-cell[0]/text:p[0]">
<source>Amanda Labby</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[0]/table:table-row[0]/table:table-cell[1]/text:p[0]">
<source>Jorge Rodriguez</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[0]/table:table-row[0]/table:table-cell[2]/text:p[0]">
<source>Olivier Hallot</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[0]/table:table-row[1]/table:table-cell[0]/text:p[0]">
<source>Dave Barton</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[0]/table:table-row[1]/table:table-cell[1]/text:p[0]">
<source>Paul Figueiredo</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[0]/table:table-row[1]/table:table-cell[2]/text:p[0]">
<source>Jean Hollis Weber</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[3]">
<source><x id="14" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[3]/text:bookmark-start[0]"/>To <g id="15">p</g>revious <g id="16">e</g>ditions<x id="17" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[3]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[0]/table:table-cell[0]/text:p[0]">
<source>Jean Hollis Weber</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[0]/table:table-cell[1]/text:p[0]">
<source>Peter Schofield</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[0]/table:table-cell[2]/text:p[0]">
<source>David Michel</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[1]/table:table-cell[0]/text:p[0]">
<source>Hazel Russman</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[1]/table:table-cell[1]/text:p[0]">
<source>Ron Faile Jr.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[1]/table:table-cell[2]/text:p[0]">
<source>Martin Saffron</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[2]/table:table-cell[0]/text:p[0]">
<source>John A Smith</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[2]/table:table-cell[1]/text:p[0]">
<source>Olivier Hallot</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[2]/table:table-cell[2]/text:p[0]">
<source>Dave Koelmeyer</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[1]/table:table-row[3]/table:table-cell[0]/text:p[0]">
<source>Leo Moons</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[4]">
<source><x id="18" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[4]/text:bookmark-start[0]"/>Feedback<x id="19" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[4]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[3]">
<source>Please direct any comments or suggestions about this document to the Documentation Team’s mailing list: <g id="20">documentation@global.libreoffice.org</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:list[0]/text:list-item[0]/text:p[0]">
<source>Note</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[4]">
<source>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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[5]">
<source><x id="21" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[5]/text:bookmark-start[0]"/>Publication date and software version<x id="22" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[5]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[5]">
<source>Published <g id="23"/><g id="24">August</g> 2018. Based on LibreOffice 6.0.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[6]">
<source><x id="25" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[6]/text:bookmark-start[0]"/>Using LibreOffice on macOS<x id="26" xid="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:h[6]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:p[6]">
<source>Some keystrokes and menu items are different on macOS from those used in Windows and Linux. The table below gives some common substitutions for the instructions in this book. For a more detailed list, see the application Help.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[0]/table:table-cell[0]/text:p[0]">
<source>Windows or Linux</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[0]/table:table-cell[1]/text:p[0]">
<source>macOS equivalent</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[0]/table:table-cell[2]/text:p[0]">
<source>Effect</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[1]/table:table-cell[0]/text:p[0]">
<source><g id="27">Tools > Options</g> menu selection</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[1]/table:table-cell[1]/text:p[0]/text:span[0]">
<source>LibreOffice > Preferences</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[1]/table:table-cell[2]/text:p[0]">
<source>Access setup options</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[2]/table:table-cell[0]/text:p[0]/text:span[0]">
<source>Right-click</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[2]/table:table-cell[1]/text:p[0]">
<source>Control+click and/or right-click depending on computer setup</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[2]/table:table-cell[2]/text:p[0]">
<source>Open a context menu</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[3]/table:table-cell[0]/text:p[0]">
<source><g id="28">Ctrl</g> (<g id="29">Control</g>)</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[3]/table:table-cell[1]/text:p[0]">
<source>⌘ (<g id="30">Command</g>)</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[3]/table:table-cell[2]/text:p[0]">
<source>Used with other keys</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[4]/table:table-cell[0]/text:p[0]/text:span[0]">
<source>F5</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[4]/table:table-cell[1]/text:p[0]">
<source><g id="31">Shift</g>+⌘+<g id="32">F5</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[4]/table:table-cell[2]/text:p[0]">
<source>Open the Navigator</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[5]/table:table-cell[0]/text:p[0]/text:span[0]">
<source>F11</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[5]/table:table-cell[1]/text:p[0]">
<source>⌘+<g id="33">T</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/table:table[2]/table:table-row[5]/table:table-cell[2]/text:p[0]">
<source>Open the sidebar Styles deck</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:index-title[0]/text:p[0]">
<source>Contents</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[0]/text:a[0]">
<source>Copyright<g id="34"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[1]/text:a[0]">
<source>Contributors<g id="35"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[2]/text:a[0]">
<source>To this edition<g id="36"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[3]/text:a[0]">
<source>To previous editions<g id="37"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[4]/text:a[0]">
<source>Feedback<g id="38"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[5]/text:a[0]">
<source>Publication date and software version<g id="39"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[6]/text:a[0]">
<source>Using LibreOffice on macOS<g id="40"/>2</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[7]/text:a[0]">
<source>What is Calc?<g id="41"/>7</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[8]/text:a[0]">
<source>Compatibility with other spreadsheet applications<g id="42"/>7</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[9]/text:a[0]">
<source>Wildcards<g id="43"/>7</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[10]/text:a[0]">
<source>Formula syntax<g id="44"/>7</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[11]/text:a[0]">
<source>Macros<g id="45"/>7</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[12]/text:a[0]">
<source>Spreadsheets, sheets, and cells<g id="46"/>7</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[13]/text:a[0]">
<source>Calc main window<g id="47"/>8</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[14]/text:a[0]">
<source>Title bar<g id="48"/>8</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[15]/text:a[0]">
<source>Menu bar<g id="49"/>8</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[16]/text:a[0]">
<source>Toolbars<g id="50"/>9</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[17]/text:a[0]">
<source>Formula bar<g id="51"/>9</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[18]/text:a[0]">
<source>Status bar<g id="52"/>10</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[19]/text:a[0]">
<source>Sidebar<g id="53"/>10</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[20]/text:a[0]">
<source>Spreadsheet layout<g id="54"/>11</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[21]/text:a[0]">
<source>Individual cells<g id="55"/>11</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[22]/text:a[0]">
<source>Sheet tabs<g id="56"/>11</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[23]/text:a[0]">
<source>Opening a CSV file<g id="57"/>12</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[24]/text:a[0]">
<source>Saving spreadsheets<g id="58"/>14</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[25]/text:a[0]">
<source>Saving in other spreadsheet formats<g id="59"/>14</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[26]/text:a[0]">
<source>Exporting contents as image<g id="60"/>15</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[27]/text:a[0]">
<source>Navigating within spreadsheets<g id="61"/>15</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[28]/text:a[0]">
<source>Cell navigation<g id="62"/>15</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[29]/text:a[0]">
<source>Sheet navigation<g id="63"/>16</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[30]/text:a[0]">
<source>Keyboard navigation<g id="64"/>17</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[31]/text:a[0]">
<source>Customizing the Enter key<g id="65"/>18</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[32]/text:a[0]">
<source>Selecting items in a spreadsheet<g id="66"/>19</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[33]/text:a[0]">
<source>Selecting cells<g id="67"/>19</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[34]/text:a[0]">
<source>Single cell<g id="68"/>19</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[35]/text:a[0]">
<source>Range of contiguous cells<g id="69"/>19</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[36]/text:a[0]">
<source>Range of non-contiguous cells<g id="70"/>19</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[37]/text:a[0]">
<source>Selecting columns and rows<g id="71"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[38]/text:a[0]">
<source>Single column or row<g id="72"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[39]/text:a[0]">
<source>Multiple columns or rows<g id="73"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[40]/text:a[0]">
<source>Entire sheet<g id="74"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[41]/text:a[0]">
<source>Selecting sheets<g id="75"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[42]/text:a[0]">
<source>Single sheet<g id="76"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[43]/text:a[0]">
<source>Multiple contiguous sheets<g id="77"/>20</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[44]/text:a[0]">
<source>Multiple non-contiguous sheets<g id="78"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[45]/text:a[0]">
<source>All sheets<g id="79"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[46]/text:a[0]">
<source>Hiding and showing sheets<g id="80"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[47]/text:a[0]">
<source>Working with columns and rows<g id="81"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[48]/text:a[0]">
<source>Inserting columns and rows<g id="82"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[49]/text:a[0]">
<source>Single column or row<g id="83"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[50]/text:a[0]">
<source>Multiple columns or rows<g id="84"/>21</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[51]/text:a[0]">
<source>Deleting columns and rows<g id="85"/>22</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[52]/text:a[0]">
<source>Single column or row<g id="86"/>22</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[53]/text:a[0]">
<source>Multiple columns or rows<g id="87"/>22</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[54]/text:a[0]">
<source>Working with sheets<g id="88"/>22</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[55]/text:a[0]">
<source>Inserting new sheets<g id="89"/>22</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[56]/text:a[0]">
<source>Moving and copying sheets<g id="90"/>23</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[57]/text:a[0]">
<source>Dragging and dropping<g id="91"/>23</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[58]/text:a[0]">
<source>Using a dialog<g id="92"/>23</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[59]/text:a[0]">
<source>Deleting sheets<g id="93"/>24</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[60]/text:a[0]">
<source>Renaming sheets<g id="94"/>24</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[61]/text:a[0]">
<source>Viewing Calc<g id="95"/>24</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[62]/text:a[0]">
<source>Changing document view<g id="96"/>24</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[63]/text:a[0]">
<source>Freezing rows and columns<g id="97"/>25</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[64]/text:a[0]">
<source>Freezing rows or columns<g id="98"/>25</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[65]/text:a[0]">
<source>Unfreezing<g id="99"/>25</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[66]/text:a[0]">
<source>Splitting the screen<g id="100"/>25</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[67]/text:a[0]">
<source>Splitting horizontally or vertically<g id="101"/>26</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[68]/text:a[0]">
<source>Removing split views<g id="102"/>26</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[69]/text:a[0]">
<source>Using the keyboard<g id="103"/>26</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[70]/text:a[0]">
<source>Numbers<g id="104"/>26</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[71]/text:a[0]">
<source>Minus numbers<g id="105"/>26</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[72]/text:a[0]">
<source>Leading zeroes<g id="106"/>26</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[73]/text:a[0]">
<source>Numbers as text<g id="107"/>28</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[74]/text:a[0]">
<source>Text<g id="108"/>28</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[75]/text:a[0]">
<source>Date and time<g id="109"/>28</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[76]/text:a[0]">
<source>AutoCorrection options<g id="110"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[77]/text:a[0]">
<source>Replace<g id="111"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[78]/text:a[0]">
<source>Exceptions<g id="112"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[79]/text:a[0]">
<source>Options<g id="113"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[80]/text:a[0]">
<source>Localized options<g id="114"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[81]/text:a[0]">
<source>Reset<g id="115"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[82]/text:a[0]">
<source>Deactivating automatic changes<g id="116"/>29</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[83]/text:a[0]">
<source>Speeding up data entry<g id="117"/>30</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[84]/text:a[0]">
<source>Using the Fill tool<g id="118"/>30</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[85]/text:a[0]">
<source>Using a fill series<g id="119"/>30</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[86]/text:a[0]">
<source>Defining a fill series<g id="120"/>32</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[87]/text:a[0]">
<source>Defining a fill series from a range in a sheet<g id="121"/>32</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[88]/text:a[0]">
<source>Using selection lists<g id="122"/>32</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[89]/text:a[0]">
<source>Sharing content between sheets<g id="123"/>33</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[90]/text:a[0]">
<source>Validating cell contents<g id="124"/>33</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[91]/text:a[0]">
<source>Editing data<g id="125"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[92]/text:a[0]">
<source>Deleting data<g id="126"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[93]/text:a[0]">
<source>Deleting data only<g id="127"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[94]/text:a[0]">
<source>Deleting data and formatting<g id="128"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[95]/text:a[0]">
<source>Replacing data<g id="129"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[96]/text:a[0]">
<source>Changing data<g id="130"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[97]/text:a[0]">
<source>Using the keyboard<g id="131"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[98]/text:a[0]">
<source>Using the mouse<g id="132"/>34</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[99]/text:a[0]">
<source>Formatting data<g id="133"/>35</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[100]/text:a[0]">
<source>Multiple lines of text<g id="134"/>35</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[101]/text:a[0]">
<source>Automatic wrapping<g id="135"/>35</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[102]/text:a[0]">
<source>Manual line breaks<g id="136"/>36</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[103]/text:a[0]">
<source>Shrinking text to fit the cell<g id="137"/>36</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[104]/text:a[0]">
<source>Formatting numbers<g id="138"/>36</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[105]/text:a[0]">
<source>Formatting fonts and text in cells<g id="139"/>36</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[106]/text:a[0]">
<source>Formatting cell borders<g id="140"/>38</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[107]/text:a[0]">
<source>Formatting cell background<g id="141"/>38</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[108]/text:a[0]">
<source>Formatting default cell styles<g id="142"/>38</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[109]/text:a[0]">
<source>AutoFormatting of cells<g id="143"/>38</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[110]/text:a[0]">
<source>Using AutoFormat<g id="144"/>38</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[111]/text:a[0]">
<source>Defining a new AutoFormat<g id="145"/>39</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[112]/text:a[0]">
<source>Using themes<g id="146"/>39</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[113]/text:a[0]">
<source>Using conditional formatting<g id="147"/>41</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[114]/text:a[0]">
<source>Hiding and showing data<g id="148"/>41</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[115]/text:a[0]">
<source>Hiding data<g id="149"/>41</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[116]/text:a[0]">
<source>Showing data<g id="150"/>41</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[117]/text:a[0]">
<source>Cell protection<g id="151"/>42</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[118]/text:a[0]">
<source>Sorting records<g id="152"/>43</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[119]/text:a[0]">
<source>Cell comments<g id="153"/>44</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[120]/text:a[0]">
<source>Using formulas and functions<g id="154"/>44</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[121]/text:a[0]">
<source>The Function Wizard and Function Search<g id="155"/>44</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[122]/text:a[0]">
<source>Analyzing data<g id="156"/>45</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[123]/text:a[0]">
<source>Pivot tables and pivot charts<g id="157"/>45</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[124]/text:a[0]">
<source>Pivot charts<g id="158"/>46</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[125]/text:a[0]">
<source>Printing<g id="159"/>46</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[126]/text:a[0]">
<source>Print ranges<g id="160"/>47</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[127]/text:a[0]">
<source>Defining a print range<g id="161"/>47</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[128]/text:a[0]">
<source>Adding to a print range<g id="162"/>47</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[129]/text:a[0]">
<source>Removing a print range<g id="163"/>47</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[130]/text:a[0]">
<source>Editing a print range<g id="164"/>47</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[131]/text:a[0]">
<source>Printing options<g id="165"/>47</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[132]/text:a[0]">
<source>Repeat printing of rows or columns<g id="166"/>48</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[133]/text:a[0]">
<source>Page breaks<g id="167"/>48</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[134]/text:a[0]">
<source>Inserting a break<g id="168"/>49</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[135]/text:a[0]">
<source>Deleting a page break<g id="169"/>49</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[136]/text:a[0]">
<source>Headers and footers<g id="170"/>49</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:section[0]/text:table-of-content[0]/text:index-body[0]/text:p[137]/text:a[0]">
<source>Setting a header or footer<g id="171"/>49</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[0]">
<source><x id="172" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[0]/text:bookmark-start[0]"/>What is Calc?<x id="173" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[0]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[4]">
<source>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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[5]">
<source>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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[6]">
<source><x id="174" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[6]/text:alphabetical-index-mark[0]"/>Other features provided by Calc include:</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[0]/text:list-item[0]/text:p[0]">
<source>Functions, which can be used to create formulas to perform complex calculations on data.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[0]/text:list-item[1]/text:p[0]">
<source>Database functions, to arrange, store, and filter data.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[0]/text:list-item[2]/text:p[0]">
<source>Dynamic charts; a wide range of 2D and 3D charts.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[0]/text:list-item[3]/text:p[0]">
<source>Macros, for recording and executing repetitive tasks; scripting languages supported include LibreOffice Basic, Python, BeanShell, and JavaScript.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[0]/text:list-item[4]/text:p[0]">
<source>Ability to open, edit, and save Microsoft Excel spreadsheets.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[0]/text:list-item[5]/text:p[0]">
<source>Import and export of spreadsheets in multiple formats, including HTML, CSV, PDF, and PostScript.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[1]">
<source><x id="175" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[1]/text:bookmark-start[0]"/>Compatibility with other spreadsheet applications<x id="176" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[1]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[2]">
<source><x id="177" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[2]/text:bookmark-start[0]"/>Wildcards<x id="178" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[2]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[7]">
<source>Simple wildcards such as the <g id="179">asterisk (*)</g>, <g id="180">question mark (?)</g>, and <g id="181">tilde (~)</g> from other spreadsheet applications are recognized by LibreOffice. Wildcards are more widespread in other spreadsheet applications and adopting a similar option in LibreOffice allows for better compatibility and a better experience for users who may not be familiar with the use of regular expressions.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[3]">
<source><x id="182" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[3]/text:bookmark-start[0]"/>Formula syntax<x id="183" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[3]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[8]">
<source>By default, LibreOffice Calc uses its own formula syntax, referred to as <g id="184">Calc R1</g> rather than the <g id="185">Excel R1</g> syntax that is used by Microsoft Excel. LibreOffice will translate seamlessly between the two. However, if you are familiar with Excel you may wish to change the default syntax in Calc by going to <g id="186">Tools > Options > LibreOffice Calc > Formula > Formula Syntax</g> and choosing <g id="187">Excel R1</g> from the drop-down menu provided.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[9]">
<source>For more information on formula syntax, see the <g id="188">Calc Guide Chapter 7 Formulas and Functions</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[4]">
<source><x id="189" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[4]/text:bookmark-start[0]"/>Macros<x id="190" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[4]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[10]">
<source>Microsoft Office uses <g id="191">Visual Basic for applications</g> (VBA) code, and LibreOffice uses <g id="192">Basic</g> code based on the LibreOffice API. Although the programming languages are the same, the objects and methods are different and therefore not entirely compatible.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[11]">
<source>LibreOffice can however run <g id="193">some</g> Excel Visual Basic Scripts if you enable this feature at <g id="194">Tools > Options > Load/Save > VBA Properties.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[12]">
<source>For more information on macros, refer to the Calc Guide Chapter 12 Calc Macros.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[5]">
<source><x id="195" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[5]/text:bookmark-start[0]"/>Spreadsheets, sheets, and cells<x id="196" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[5]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[13]">
<source>Calc works with documents called <x id="197" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[13]/text:alphabetical-index-mark[0]"/><g id="198">spreadsheets</g>. Spreadsheets consist of a number of individual <x id="199" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[13]/text:alphabetical-index-mark[1]"/><g id="200">sheets</g>, each sheet containing cells arranged in rows and columns. A particular cell is identified by its row number and column letter.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[14]">
<source><x id="201" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[14]/text:alphabetical-index-mark[0]"/>Cells hold the individual elements – text, numbers, formulas, and so on – that make up the data to display and manipulate.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[15]">
<source><x id="202" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[15]/text:soft-page-break[0]"/>Each spreadsheet can have several sheets, and each sheet can have many individual cells. In Calc, each sheet can have a maximum of 1,048,576 rows and a maximum of 1024 columns. LibreOffice Calc can hold up to 32,000 sheets.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[6]">
<source><x id="203" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[6]/text:bookmark-start[0]"/>Calc main window<x id="204" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[6]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[16]">
<source>When Calc is started, the <x id="205" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[16]/text:alphabetical-index-mark[0]"/>main window opens (Figure <x id="206" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[16]"/>). The parts of this window are described below.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[7]">
<source><x id="207" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[7]/text:bookmark-start[0]"/>Title bar<x id="208" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[7]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[17]">
<source>The <x id="209" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[17]/text:alphabetical-index-mark[0]"/>Title bar, located at the top, shows the name of the current spreadsheet. When a spreadsheet is newly created from a template or a blank document, its name is <g id="210">Untitled X</g>, where <g id="211">X</g> is a number. When you save a spreadsheet for the first time, you are prompted to enter a name of your choice.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[18]/draw:frame[0]/draw:text-box[0]/text:p[0]">
<source><x id="212" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[18]/draw:frame[0]/draw:text-box[0]/text:p[0]/draw:frame[0]"/>Figure <x id="213" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[18]/draw:frame[0]/draw:text-box[0]/text:p[0]"/>: Calc main window</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[8]">
<source><x id="214" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[8]/text:bookmark-start[0]"/>Menu bar<x id="215" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[8]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[19]">
<source>When you select an item on the <x id="216" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[19]/text:alphabetical-index-mark[0]"/>Menu bar, a sub-menu drops down to show commands. You can also customize the Menu bar; see <g id="217">Chapter 14 Customizing LibreOffice</g> for more information.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[0]/text:p[0]">
<source><g id="218">File</g> – contains commands that apply to the entire document; for example, <g id="219">Open</g>, <g id="220">Save</g>, <g id="221">Wizards</g>, <g id="222">Export as PDF</g>, <g id="223">Print</g>, <g id="224">Digital Signatures, and Templates.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[1]/text:p[0]">
<source><g id="225">Edit</g> – contains commands for editing the document; for example, <g id="226">Undo, Copy, Paste, Track Changes, Find and Replace, Compare and Merge Documents.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[2]/text:p[0]">
<source><g id="227">View</g> – contains commands for modifying how the Calc user interface looks; for example, <g id="228">Toolbars, Grids, Column & Row Headers, Full Screen, Zoom.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[3]/text:p[0]">
<source><g id="229">Insert</g> – contains commands for inserting elements into a spreadsheet; for example, <g id="230">Pictures, Media, Objects, Formula Design, Frames, Special Characters, Charts, Functions, </g><x id="231" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[3]/text:p[0]/text:soft-page-break[0]"/><g id="232">Shapes, Pivot Tables, Named Ranges, Comments, Hyperlinks, Headers and Footers, Form Controls.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[4]/text:p[0]">
<source><g id="233">Format</g> – contains commands for modifying the layout of a spreadsheet; for example, <g id="234">Cells</g>, <g id="235">Page</g>, <g id="236">Styles</g>, <g id="237">Alignment, Merge Cells, Print Range, Conditional Formatting, Spreadsheet Themes, Image, Chart, Object.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[5]/text:p[0]">
<source><g id="238">Styles </g>– contains commands to apply standard styles to cell, group of cells or sheets contents.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[6]/text:p[0]">
<source><g id="239">Sheet</g> – contains the most often used commands for handling sheets, such as <g id="240">Insert</g> and <g id="241">Delete Cells, Columns, Rows and Sheets, Sheets from File, Cell Reference Type, Link to External Data, </g>as well as<g id="242"> Comments </g>and<g id="243"> Fill cells.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[7]/text:p[0]">
<source><g id="244">Data</g> – contains commands for manipulating data in the spreadsheet; for example, <g id="245">Define Database Range</g>, <g id="246">Sort</g>, Filters, <g id="247">Statistics, Pivot Tables, Consolidate, Forms, Groups and Outlines.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[8]/text:p[0]">
<source><g id="248">Tools</g> – contains various functions to help you check and customize the spreadsheet; for example, <g id="249">Spelling</g>, <g id="250">Share Document</g>, <g id="251">Gallery</g>, <g id="252">Macros, Goal Seek, Solver, Detective, Protect Sheet, XML Filter Settings, Extension Manager.</g></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[9]/text:p[0]">
<source><g id="253">Window</g> – contains commands to open a <g id="254">New</g> window or <g id="255">Close</g> an open window.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[1]/text:list-item[10]/text:p[0]">
<source><g id="256">Help</g> – contains links to the LibreOffice help system and other miscellaneous functions; for example, <g id="257">Help</g>, <g id="258">License Information</g>, <g id="259">User Guides</g>, <g id="260">Check for Updates, Send Feedback</g>, and<g id="261"> Donate</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[9]">
<source><x id="262" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[9]/text:bookmark-start[0]"/>Toolbars<x id="263" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[9]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[20]">
<source>The default setting when Calc opens is for the Standard and Formatting toolbars to be docked at the top of the workspace (Figure <x id="264" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[20]"/>).</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[21]">
<source><x id="265" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[21]/text:alphabetical-index-mark[0]"/>Calc toolbars can be either docked and fixed in place, or floating; you can move a toolbar into a more convenient position on the workspace. Docked toolbars can be undocked and either moved to different docked position on the workspace, or left as a floating toolbar. Toolbars that are floating when opened can be docked into a fixed position on the workspace.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[22]">
<source>You can choose the single-toolbar alternative to the default double toolbar arrangement. It contains the most-used commands. To activate it, enable <g id="266">View > Toolbars > Standard (Single Mode)</g> and disable <g id="267">View > Toolbars > Standard</g> and <g id="268">View > Toolbars > Formatting</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[23]">
<source>The default set of icons (sometimes called buttons) on toolbars provides a wide range of common commands and functions. You can also remove or add icons to toolbars; see <g id="269">Chapter 14 Customizing LibreOffice</g> for more information. When hovering the toolbar with the mouse, a tool tip shows the action performed by each icon in the toolbar.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[10]">
<source><x id="270" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[10]/text:bookmark-start[0]"/>Formula bar<x id="271" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[10]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[24]">
<source>The <x id="272" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[24]/text:alphabetical-index-mark[0]"/>Formula Bar (Figure <x id="273" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[24]"/>) 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 <g id="274">View</g> on the Menu bar and select <g id="275">Formula Bar</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[25]/draw:frame[0]/draw:text-box[0]/text:p[0]">
<source><x id="276" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[25]/draw:frame[0]/draw:text-box[0]/text:p[0]/draw:frame[0]"/>Figure <x id="277" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[25]/draw:frame[0]/draw:text-box[0]/text:p[0]"/>: Formula bar</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[26]">
<source>From left to right, the Formula Bar consists of the following:</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[0]/text:p[0]">
<source><g id="278">Name Box</g> – gives the current active 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. If you have selected a range of cells that is also a named range, the name of the range is shown in this box. You can also type a cell reference in the Name Box <x id="279" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[0]/text:p[0]/text:soft-page-break[0]"/>to jump to the referenced cell. If you type the name of a named range and press the <g id="280">Enter</g> key, the named range is selected and displayed.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[1]/text:p[0]">
<source><g id="281">Function Wizard</g> <g id="282"><x id="283" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[1]/text:p[0]/text:span[1]/draw:frame[0]"/></g><g id="284"/>– <x id="285" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[1]/text:p[0]/text:alphabetical-index-mark[0]"/>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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[2]/text:p[0]">
<source><g id="286">Sum</g> <g id="287"><x id="288" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[2]/text:p[0]/text:span[1]/draw:frame[0]"/></g><g id="289"/>– 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. When the <g id="290">Sum</g> icon is used, Calc suggest the range to sum with a colored box, but does not insert the formula. You need to confirm the suggested range by typing <g id="291">Enter</g>, or reject pressing <g id="292">Esc</g>. You can also adjust the range with the mouse by dragging the colored box or its edges to adjust the range. The icons <g id="293"><x id="294" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[2]/text:p[0]/text:span[5]/draw:frame[0]"/></g><g id="295"><g id="296"/>in the formula bar are equivalent to the </g><g id="297">Enter</g> and <g id="298">Esc</g> commands.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[3]/text:p[0]">
<source><g id="299">Function</g> <g id="300"><x id="301" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[3]/text:p[0]/text:span[1]/draw:frame[0]"/></g><g id="302"/>– clicking on the Function icon inserts an equals (=) sign into the selected cell and the <g id="303">Input line</g>, allowing a formula to be entered. The Name box now displays the most frequently used functions, for a quick access to the function name and syntax.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[2]/text:list-item[4]/text:p[0]">
<source><g id="304">Input line</g> – displays the contents of the selected cell (data, formula, or function) and allows you to edit the cell contents. To turn the Input line into a multiline input area for very long formulas, click the drop down button on the right.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[27]">
<source>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 <g id="305">Cancel</g> and <g id="306">Accept</g> <x id="307" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[27]/draw:frame[0]"/>icons.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[3]/text:list-item[0]/text:p[0]">
<source>Note</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[28]">
<source>In a spreadsheet the term “function” covers much more than just mathematical functions. See the <g id="308">Calc Guide Chapter 7 Using Formulas and Functions</g> for more information.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[11]">
<source><x id="309" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[11]/text:bookmark-start[0]"/>Status bar<x id="310" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[11]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[29]">
<source>The <x id="311" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[29]/text:alphabetical-index-mark[0]"/>Calc status bar (Figure <x id="312" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[29]"/>) 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 <g id="313">Chapter 1 Introducing LibreOffice</g> in this guide and the <g id="314">Calc Guide Chapter 1 Introducing Calc</g> for more information.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[30]/draw:frame[0]/draw:text-box[0]/text:p[1]">
<source>Figure <x id="315" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[30]/draw:frame[0]/draw:text-box[0]/text:p[1]"/>: Calc status bar</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[31]">
<source>The status bar has a quick way to do some math operations on selected cells in the spreadsheet. You can calculate average and sum, count elements, and more on the selection by right-clicking over the cell information area of the status bar and selecting the operations you want to display in the status bar (Figure <x id="316" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[31]"/>).</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[12]">
<source><x id="317" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[12]/text:bookmark-start[0]"/>Sidebar<x id="318" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[12]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[32]">
<source>The Calc Sidebar (<g id="319">View > Sidebar</g>) is located on the right side of the window. It is a mixture of toolbar and dialog. It is similar to the sidebar in Writer (shown in Chapter 1 and Chapter 4 of this book) and consists of five <x id="320" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[32]/text:alphabetical-index-mark[0]"/>decks: Properties, Styles, Gallery, Navigator, and Functions. Each deck has a corresponding icon on the <x id="321" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[32]/text:alphabetical-index-mark[1]"/>Tab panel to the right of the sidebar, allowing you to switch between them. The decks are described below.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[4]/text:list-item[0]/text:p[0]">
<source><x id="322" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[4]/text:list-item[0]/text:p[0]/text:soft-page-break[0]"/><g id="323">Properties</g>: This deck includes five content panels.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[5]/text:list-item[0]/text:p[0]">
<source><g id="324">Styles:</g> Access to the available cell styles, update cell styles, and new cell styles.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[5]/text:list-item[1]/text:p[0]">
<source><g id="325">Character</g>: 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. </source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[5]/text:list-item[2]/text:p[0]">
<source><g id="326">Number Format:</g> Quickly change the format of numbers including decimals, currency, dates, or numeric text. Numerical and label field controls for Forms are also available.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[5]/text:list-item[3]/text:p[0]">
<source><g id="327">Alignment</g>: Controls to align the text in various ways, including horizontal and vertical alignment, wrapping, indenting, merging, text orientation, and vertical stacking.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[5]/text:list-item[4]/text:p[0]">
<source><g id="328">Cell Appearance:</g> Controls to set the appearance options, including cell background color, cell border formats including line color and style, and grid lines.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[6]/text:list-header[0]/text:p[0]">
<source>Each of these panels has a <g id="329">More Options</g> button, which opens a dialog giving a greater number of options. These dialogs lock the document for editing until they are closed.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[6]/text:list-item[0]/text:p[0]">
<source><g id="330">Styles:</g> This deck contains a single panel, which is the same as that opened by selecting the <g id="331">Styles</g> button (<g id="332">F11</g>) from the Text Formatting toolbar.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[6]/text:list-item[1]/text:p[0]">
<source><g id="333">Gallery</g>: This deck contains a single panel, which is the same as that opened by selecting <g id="334">Gallery</g> from the Standard toolbar or <g id="335">Tools > Gallery</g> from the Menu bar.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[6]/text:list-item[2]/text:p[0]">
<source><g id="336">Navigator</g>: This deck contains a single panel, which is essentially the same as the Navigator window opened by clicking the <g id="337">Navigator</g> button on the Standard toolbar or selecting <g id="338">View > Navigator</g> (<g id="339">F5</g>) from the Menu bar. Only the <g id="340">Contents</g> button is absent in the Sidebar’s Navigator panel.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[6]/text:list-item[3]/text:p[0]">
<source><g id="341">Functions</g>: This deck contains a single panel, which is the same as the window opened by selecting <g id="342">Insert > Function...</g> from the Menu bar.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[33]">
<source>To the right side of the title bar of each open deck is a <g id="343">Close</g> button (<g id="344">X</g>), which closes the deck to leave only the Tab bar open. Clicking on any Tab button reopens the deck.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[34]">
<source>To hide the Sidebar, or reveal it if already hidden, click on the edge Hide/Show button. To adjust the deck width, drag on the left edge of the sidebar.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[13]">
<source><x id="345" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[13]/text:bookmark-start[0]"/>Spreadsheet layout<x id="346" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[13]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[14]">
<source><x id="347" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[14]/text:bookmark-start[0]"/>Individual cells<x id="348" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[14]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[35]">
<source>The main section of the workspace in Calc displays the <x id="349" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[35]/text:alphabetical-index-mark[0]"/>cells in the form of a grid. Each cell is formed by the intersection of one column and one row in the spreadsheet.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[36]">
<source>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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[37]">
<source>These column and row headers form the cell references that appear in the Name Box on the Formula Bar (Figure <x id="350" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[37]"/>). If the headers are not visible on the spreadsheet, go to <g id="351">View</g> on the Menu bar and select <g id="352">Column & Row Headers</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[15]">
<source><x id="353" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[15]/text:bookmark-start[0]"/>Sheet tabs<x id="354" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[15]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[38]">
<source>In Calc, you can have more than one sheet in a spreadsheet. At the bottom of the grid of cells in a spreadsheet <x id="355" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[38]/text:alphabetical-index-mark[0]"/>are sheet tabs indicating how many sheets there are in the 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 <g id="356">Ctrl</g> key while clicking on the sheet tabs.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[39]">
<source><x id="357" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[39]/text:soft-page-break[0]"/>To change the default name for a sheet (Sheet1, Sheet2, and so on), right-click on a sheet tab and select <g id="358">Rename Sheet</g> from the context menu or double click on the sheet tab to open a dialog to let you type a new name for the sheet. Click <g id="359">OK</g> when finished to close the dialog.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[40]">
<source>To change the color of a sheet tab, right-click on the tab and select <g id="360">Tab Color</g> from the context menu to open the <g id="361">Tab Color</g> dialog. Select a color and click <g id="362">OK</g> when finished to close the dialog. To add new colors to this color palette, see <g id="363">Chapter 14 Customizing LibreOffice</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[16]">
<source><x id="364" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[16]/text:bookmark-start[0]"/>Opening a CSV file<x id="365" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[16]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[41]">
<source><x id="366" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[41]/text:alphabetical-index-mark[0]"/><x id="367" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[41]/text:alphabetical-index-mark[1]"/>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 semicolon. 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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[7]/text:list-item[0]/text:p[0]">
<source>Note</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[42]">
<source>Most CSV files come from databases tables, queries, or reports, where further calculations and charting are required. On Microsoft Windows, CSV files often have the XLS file name extension to look like an Excel file, but they are still CSV files internally.<x id="368" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[42]/text:alphabetical-index-mark[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[43]">
<source>To open a CSV file in Calc:</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[8]/text:list-item[0]/text:p[0]">
<source>Choose <g id="369">File > Open</g> on the Menu bar and locate the CSV file that you want to open.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[8]/text:list-item[1]/text:p[0]">
<source>Select the file and click <g id="370">Open</g>. By default, a CSV file has the extension <g id="371">.csv</g>. However, some CSV files may have a <g id="372">.txt</g> extension.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[8]/text:list-item[2]/text:p[0]">
<source>The <g id="373">Text Import</g> dialog (Figure <x id="374" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[8]/text:list-item[2]/text:p[0]"/>) opens. Here you can select the various options available when importing a CSV file into a Calc spreadsheet.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[8]/text:list-item[3]/text:p[0]">
<source>Click <g id="375">OK</g> to open and import the file.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[44]/draw:frame[0]/draw:text-box[0]/text:p[0]">
<source><x id="376" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[44]/draw:frame[0]/draw:text-box[0]/text:p[0]/draw:frame[0]"/><g id="377"><g id="378"/></g>Figure <x id="379" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[44]/draw:frame[0]/draw:text-box[0]/text:p[0]"/>: Text Import dialog</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[45]">
<source><x id="380" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[45]/text:soft-page-break[0]"/>The options for importing CSV files into a Calc spreadsheet are as follows:</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[9]/text:list-item[0]/text:p[0]/text:span[0]">
<source>Import</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[10]/text:list-item[0]/text:p[0]">
<source><g id="381">Character Set</g> – specifies the character set to be used in the imported file.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[10]/text:list-item[1]/text:p[0]">
<source><g id="382">Language</g> – determines how the number strings are imported.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[10]/text:list-item[1]/text:p[1]">
<source>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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[10]/text:list-item[2]/text:p[0]">
<source><g id="383">From Row</g> – specifies the row where you want to start the import. The rows are visible in the preview window at the bottom of the dialog.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[11]/text:list-item[0]/text:p[0]">
<source><g id="384">Separator Options</g> – specifies whether the data uses separators or fixed widths as delimiters.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[12]/text:list-item[0]/text:p[0]">
<source><g id="385">Fixed width</g> – separates fixed-width data (equal number of characters) into columns. Click on the ruler in the preview window to set the width.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[12]/text:list-item[1]/text:p[0]">
<source><g id="386">Separated by</g> – select the separator used in the data to delimit the data into columns. If you select <g id="387">Other</g>, specify the character used to separate data into columns. This custom separator must also be contained in the data.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[12]/text:list-item[2]/text:p[0]">
<source><g id="388">Merge delimiters</g> – combines consecutive delimiters and removes blank data fields.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[12]/text:list-item[3]/text:p[0]">
<source><g id="389">Text delimiter</g> – select a character to delimit text data.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[13]/text:list-item[0]/text:p[0]/text:span[0]">
<source>Other Options</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[14]/text:list-item[0]/text:p[0]">
<source><g id="390">Quoted fields as text</g> – 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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[14]/text:list-item[1]/text:p[0]">
<source><g id="391">Detect special numbers</g> – when 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 also influences how such special numbers are detected, since different languages and regions many have different conventions for such special numbers.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[14]/text:list-item[1]/text:p[1]">
<source>When 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.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[15]/text:list-item[0]/text:p[0]">
<source><g id="392">Fields</g> – shows how the data will look when it is separated into columns.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[16]/text:list-item[0]/text:p[0]">
<source><g id="393">Column type</g> – select a column in the preview window and select the data type to be applied the imported data.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[16]/text:list-item[1]/text:p[0]">
<source><g id="394">Standard </g>– Calc determines the type of data.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[16]/text:list-item[2]/text:p[0]">
<source><g id="395">Text</g> – imported data are treated as text.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[16]/text:list-item[3]/text:p[0]">
<source><g id="396">US English</g> – 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 <g id="397">Standard</g> format is applied.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[16]/text:list-item[4]/text:p[0]">
<source><g id="398">Hide</g> – the data in the column are not imported.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[17]">
<source><x id="399" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[17]/text:bookmark-start[0]"/><x id="400" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[17]/text:soft-page-break[0]"/><x id="401" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[17]/text:alphabetical-index-mark[0]"/><x id="402" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[17]/text:alphabetical-index-mark[1]"/>Saving spreadsheets<x id="403" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[17]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[46]">
<source>To save a spreadsheet, see <g id="404">Chapter 1 Introducing LibreOffice</g> 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, XHTML file formats and JPEG and PNG images formats; see the <g id="405">Calc Guide Chapter 6 Printing, Exporting, and E-mailing</g> for more information.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[18]">
<source><x id="406" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[18]/text:bookmark-start[0]"/><x id="407" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[18]/text:alphabetical-index-mark[0]"/>Saving in other spreadsheet formats<x id="408" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[18]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[47]">
<source>If you need to exchange files with users who are unable to receive spreadsheet files in Open Document Format (ODF) (<g id="409">*.ods</g>), which Calc uses as default format, you can save a spreadsheet in another format.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[0]/text:p[0]">
<source>Save the spreadsheet in Calc spreadsheet file format (<g id="410">*.ods</g>).</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[1]/text:p[0]">
<source>Select <g id="411">File > Save As</g> on the Menu bar to open the <g id="412">Save As</g> dialog (Figure <x id="413" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[1]/text:p[0]"/>).</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[2]/text:p[0]">
<source>In <g id="414">File name</g>, you can enter a new file name for the spreadsheet.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[3]/text:p[0]">
<source>In the <g id="415">File type</g> drop-down menu, select the type of spreadsheet format you want to use.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[4]/text:p[0]">
<source>If <g id="416">Automatic file name extension</g> is selected, the correct file extension for the spreadsheet format you have selected will be added to the file name.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[17]/text:list-item[5]/text:p[0]">
<source>Click <g id="417">Save</g>.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[48]/draw:frame[0]/draw:text-box[0]/text:p[0]">
<source><x id="418" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[48]/draw:frame[0]/draw:text-box[0]/text:p[0]/draw:frame[0]"/><g id="419"><g id="420"/></g>Figure <x id="421" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[48]/draw:frame[0]/draw:text-box[0]/text:p[0]"/>: Save As dialog</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[18]/text:list-item[0]/text:p[0]">
<source>When saving in a non default file format, the <g id="422">Confirm File Format</g> dialog opens (Figure <x id="423" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[18]/text:list-item[0]/text:p[0]"/>). Click <g id="424">Use [xxx] Format</g> to continue saving in your selected spreadsheet format or click <g id="425">Use ODF Format</g> to save the spreadsheet in Calc ODS format.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[49]/draw:frame[0]/draw:text-box[0]/text:p[0]">
<source><x id="426" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[49]/draw:frame[0]/draw:text-box[0]/text:p[0]/draw:frame[0]"/><g id="427"><g id="428"/></g>Figure <x id="429" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[49]/draw:frame[0]/draw:text-box[0]/text:p[0]"/>: File Format dialog</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[19]/text:list-item[0]/text:p[0]">
<source><x id="430" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[19]/text:list-item[0]/text:p[0]/text:soft-page-break[0]"/>If you select <g id="431">Text CSV</g> format (<g id="432">*.csv</g>) for your spreadsheet, the <g id="433">Export Text File</g> dialog (Figure <x id="434" xid="office:document-content[0]/office:body[0]/office:text[0]/text:list[19]/text:list-item[0]/text:p[0]"/>) may open. Here you can select the character set, field delimiter, text delimiter, and so on to be used for the CSV file.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[50]/draw:frame[0]/draw:text-box[0]/text:p[0]">
<source><x id="435" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[50]/draw:frame[0]/draw:text-box[0]/text:p[0]/draw:frame[0]"/><g id="436"><g id="437"/></g>Figure <x id="438" xid="office:document-content[0]/office:body[0]/office:text[0]/text:p[50]/draw:frame[0]/draw:text-box[0]/text:p[0]"/>: Export Text File dialog for CSV files</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[20]/text:list-item[0]/text:p[0]">
<source>Tip</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[51]">
<source>To have Calc save documents by default in a file format other than the default ODF format, go to <g id="439">Tools > Options > Load/Save > General</g>. In <g id="440">Default file format</g> and <g id="441">ODF settings > Document type</g>, select <g id="442">Spreadsheet,</g> then in <g id="443">Always save as</g>, select your preferred file format.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:h[19]">
<source><x id="444" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[19]/text:bookmark-start[0]"/>Exporting contents as image<x id="445" xid="office:document-content[0]/office:body[0]/office:text[0]/text:h[19]/text:bookmark-end[0]"/></source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:p[52]">
<source>If you want to send a fragment of your spreadsheet to a colleague, business partner or publish it in the internet, Calc can export a range selection or a selected group of shapes (images) to a PNG or JPG graphics format:</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[21]/text:list-item[0]/text:p[0]">
<source>Select the range or the group of shapes in your spreadsheet.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[21]/text:list-item[1]/text:p[0]">
<source>Select <g id="446">File – Export...</g> to open the Export dialog.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[21]/text:list-item[2]/text:p[0]">
<source>Enter a name for your image in the <g id="447">File name</g> box.</source>
</trans-unit>
<trans-unit xml:space="preserve" id="office:document-content[0]/office:body[0]/office:text[0]/text:list[21]/text:list-item[3]/text:p[0]">
<source>Select the graphics file format in the <g id="448">Type</g> list</source>
</trans-unit>