αž‘αžΌαž‘αŸ…

αž€αŸ†αžŽαžαŸ‹β€‹αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž‘αžΌαž‘αŸ… αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž―αž€αžŸαžΆαžšβ€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈΒ αŸ”

β€‹β€‹αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž”αŸ’αžšαžΎβ€‹β€‹αž”αž‰αŸ’αž‡αžΆβ€‹αž“αŸαŸ‡...

Open a spreadsheet document, choose - LibreOffice Calc - General.


αž”αŸ’αžšαž–αŸαž“αŸ’αž’β€‹αž˜αŸ‰αŸ‚αžαŸ’αžš

αž―αž€αžαžΆβ€‹αžšαž„αŸ’αžœαžΆαžŸαŸ‹

αž€αŸ†αžŽαžαŸ‹β€‹αž―αž€αžαžΆβ€‹αžšαž„αŸ’αžœαžΆαžŸαŸ‹β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈαŸ”

αžˆαž”αŸ‹β€‹αžαŸαž”

αž€αŸ†αžŽαžαŸ‹β€‹αž…αž˜αŸ’αž„αžΆαž™β€‹αžˆαž”αŸ‹β€‹αžαŸαž”αŸ”

αž’αŸ’αžœαžΎβ€‹β€‹αž²αŸ’αž™β€‹β€‹αž‘αžΆαž“αŸ‹β€‹αžŸαž˜αŸαž™

αž’αŸ’αžœαžΎβ€‹αž²αŸ’αž™β€‹αžαŸ†αžŽβ€‹αž‘αžΆαž“αŸ‹β€‹αžŸαž˜αŸαž™ αž–αŸαž›β€‹αž•αŸ’αž‘αž»αž€

warning

Settings for automatic links updates stored in documents are ignored for security reasons. Link updates are always bounded by LibreOffice Security settings in - LibreOffice – Security.


αžαŸ‚αž„αžαŸ‚

Always updates links while loading a document, and only if the document is in a trusted file location or the global security level is Low (Not recommended).

warning

This setting is treated as On request unless either the global macro security level is set to Low in - LibreOffice - Security - Macro Security... - Security Level - Low (not recommended) or the document is located in a trusted place defined by - LibreOffice - Security - Macro Security... - Trusted Sources - Trusted File Locations.


αžαžΆαž˜β€‹αžŸαŸ†αžŽαžΎ

αž’αŸ’αžœαžΎβ€‹αž”αž…αŸ’αž…αž»αž”αŸ’αž”αž“αŸ’αž“αž—αžΆαž–β€‹αžαŸ‚β€‹αžŸαŸ†αžŽαžΎβ€‹αž”αŸ‰αž»αžŽαŸ’αžŽαŸ„αŸ‡ αž–αŸαž›β€‹αž•αŸ’αž‘αž»αž€β€‹αž―αž€αžŸαžΆαžšαŸ”

αž€αž»αŸ†

αž€αž»αŸ†β€‹αž’αŸ’αžœαžΎβ€‹αž”αž…αŸ’αž…αž»αž”αŸ’αž”αž“αŸ’αž“αž—αžΆαž–β€‹αžαŸ†αžŽβ€‹αž–αŸαž›β€‹αž•αŸ’αž‘αž»αž€β€‹αž―αž€αžŸαžΆαžšαŸ”

αž€αžΆαžšβ€‹αž€αŸ†αžŽαžαŸ‹β€‹αž”αž‰αŸ’αž…αžΌαž›

αž…αž»αž…β€‹αž”αž‰αŸ’αž…αžΌαž› (Enter) αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž•αŸ’αž›αžΆαžŸαŸ‹αž‘αžΈβ€‹αž‡αž˜αŸ’αžšαžΎαžŸ

αž€αŸ†αžŽαžαŸ‹β€‹αž‘αž·αžŸβ€‹αž‘αžŸαŸ’αžŸαž“αŸαž‘αŸ’αžšαž“αž·αž…β€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αžŸαŸ€αžœαž—αŸ…β€‹αž”αž‰αŸ’αž‡αžΈβ€‹αžŠαŸ‚αž›β€‹αž“αžΉαž„β€‹αžαŸ’αžšαžΌαžœβ€‹αž•αŸ’αž›αžΆαžŸαŸ‹αž‘αžΈβ€‹αž”αž“αŸ’αž‘αžΆαž”αŸ‹αž–αžΈβ€‹αž’αŸ’αž“αž€β€‹αž…αž»αž…β€‹αž‚αŸ’αžšαžΆαž”αŸ‹αž…αž»αž…β€‹αž”αž‰αŸ’αž…αžΌαž› (Enter) αŸ”

αž…αž»αž…β€‹αž”αž‰αŸ’αž…αžΌαž› (Enter) αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αž”αŸ’αžαžΌαžšβ€‹αž‘αŸ…β€‹αžšαž”αŸ€αž”β€‹αž€αŸ‚β€‹αžŸαž˜αŸ’αžšαž½αž›

αž’αž“αž»αž‰αŸ’αž‰αžΆαžβ€‹αž²αŸ’αž™β€‹αž’αŸ’αž“αž€β€‹αž€αŸ‚αžŸαž˜αŸ’αžšαž½αž›β€‹αž€αŸ’αžšαž‘αžΆβ€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž‡αŸ’αžšαžΎαžŸβ€‹αž—αŸ’αž›αžΆαž˜αŸ— αž”αž“αŸ’αž‘αžΆαž”αŸ‹αž–αžΈβ€‹αž…αž»αž…β€‹β€‹αž‚αŸ’αžšαžΆαž”αŸ‹αž…αž»αž…β€‹αž”αž‰αŸ’αž…αžΌαž› (Enter) αŸ”

αž–αž„αŸ’αžšαžΈαž€β€‹αž€αžΆαžšβ€‹αž’αŸ’αžœαžΎβ€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™

Specifies whether to automatically apply the formatting attributes of the selected cell to the empty adjacent cells. If, for example, the contents of the selected cell have the bold attribute, this bold attribute will also apply to adjacent cells. Cells that already have a special format will not be modified by this function. You can see the range in question by pressing the + * (multiplication sign on the number pad) shortcut. This format also applies to all new values inserted within this range. The normal default settings apply to cells outside this range.

αž–αž„αŸ’αžšαžΈαž€αžŸαŸαž…αž€αŸ’αžαžΈβ€‹β€‹β€‹αž™αŸ„αž„ β€‹αž–αŸαž›β€‹αž‡αž½αžšβ€‹αžŠαŸαž€/αž‡αž½αžšβ€‹αžˆαžšβ€‹β€‹αžαŸ’αž˜αžΈβ€‹β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž‰αŸ’αž…αžΌαž›

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΆβ€‹αžαžΎβ€‹αžαŸ’αžšαžΌαžœβ€‹αž–αž„αŸ’αžšαžΈαž€β€‹αžŸαŸαž…αž€αŸ’αžŠαžΈβ€‹αž™αŸ„αž„β€‹αžŠαŸ‚αžšβ€‹αž¬αž‘αŸ αž–αŸαž›β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹αž‡αž½αžšαžˆαžš αž¬β€‹αž‡αž½αžšαžŠαŸαž€β€‹αž‡αžΆαž”αŸ‹αž‚αŸ’αž“αžΆβ€‹αž‘αŸ…αž€αžΆαž“αŸ‹β€‹αž‡αž½αžšβ€‹αžŸαŸαž…αž€αŸ’αžŠαžΈβ€‹αž™αŸ„αž„αŸ” αžœαžΆβ€‹αž’αžΆαž…β€‹αž’αŸ’αžœαžΎβ€‹αž‘αŸ…β€‹αž”αžΆαž“ αž”αŸ’αžšαžŸαž·αž“αž”αžΎβ€‹αž‡αž½αžšβ€‹αžŸαŸαž…αž€αŸ’αžŠαžΈβ€‹αž™αŸ„αž„ αž€αž“αŸ’αž›αŸ‚αž„β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹αž‡αž½αžšαžˆαžš αž¬β€‹αž‡αž½αžšαžŠαŸαž€ αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž–αž„αŸ’αžšαžΈαž€β€‹αž–αžΈβ€‹αžŠαžΎαž˜β€‹αž™αŸ‰αžΆαž„αžαž·αž…β€‹αž–αžΈαžšβ€‹αž€αŸ’αžšαž‘αžΆβ€‹αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž‘αž·αžŸβ€‹αžŠαŸ‚αž›β€‹αž…αž„αŸ‹β€‹αž”αžΆαž“αŸ”

αž§αž‘αžΆαž αžšαžŽαŸ αŸ– αž”αžΎβ€‹αž‡αž½αžš A1:B1 αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž™αŸ„αž„β€‹αž€αŸ’αž“αž»αž„β€‹αžšαžΌαž”αž˜αž“αŸ’αžβ€‹αž˜αž½αž™ αž αžΎαž™β€‹αž’αŸ’αž“αž€β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹αž‡αž½αžšβ€‹αžˆαžšβ€‹αžαŸ’αž˜αžΈβ€‹αž˜αž½αž™β€‹αž”αž“αŸ’αž‘αžΆαž”αŸ‹β€‹αž–αžΈβ€‹αž‡αž½αžšβ€‹αžˆαžš B αžŸαŸαž…αž€αŸ’αžαžΈβ€‹αž™αŸ„αž„β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž–αž„αŸ’αžšαžΈαž€β€‹αž‘αŸ…β€‹αž‡αžΆ A1:C1Β αŸ” αž”αžΎβ€‹αž‡αž½αžš A1:B1 αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž™αŸ„αž„ αž αžΎαž™β€‹αž‡αž½αžšβ€‹αžŠαŸαž€β€‹αžαŸ’αž˜αžΈβ€‹αž˜αž½αž™β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹αž–αžΈβ€‹αž€αŸ’αžšαŸ„αž˜β€‹αž‡αž½αžšβ€‹αžŠαŸαž€ 1 αžŸαŸαž…αž€αŸ’αžαžΈβ€‹β€‹αž™αŸ„αž„β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž–αž„αŸ’αžšαžΈαž€β€‹αž‘αŸ αžŠαŸ„αž™β€‹αžŸαžΆαžšβ€‹αžαŸ‚β€‹αž˜αžΆαž“β€‹αž€αŸ’αžšαž‘αžΆβ€‹αžαŸ‚β€‹αž˜αž½αž™β€‹αž”αŸ‰αž»αžŽαŸ’αžŽαŸ„αŸ‡β€‹αž€αŸ’αž“αž»αž„β€‹αž‘αž·αžŸβ€‹αž”αž‰αŸ’αžˆαžšΒ αŸ”

αž”αžΎβ€‹αž’αŸ’αž“αž€β€‹αž”αž‰αŸ’αž…αžΌαž›β€‹αž‡αž½αžšβ€‹αžŠαŸαž€ ឬ αž‡αž½αžšβ€‹αžˆαžšβ€‹αž€αŸ’αž“αž»αž„β€‹αž•αŸ’αž“αŸ‚αž€β€‹αž€αžŽαŸ’αžαžΆαž›β€‹αž“αŸƒβ€‹αžαŸ†αž”αž“αŸ‹β€‹αž™αŸ„αž„ αž“αŸ„αŸ‡αžŸαŸαž…αž€αŸ’αžαžΈβ€‹β€‹αž™αŸ„αž„β€‹αžαŸ‚αž„αžαŸ‚β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž–αž„αŸ’αžšαžΈαž€Β αŸ”

αž”αž“αŸ’αž›αž·αž…β€‹αž‡αž˜αŸ’αžšαžΎαžŸβ€‹αž€αŸ’αž“αž»αž„ αž€αŸ’αž”αžΆαž›β€‹αž‡αž½αžšβ€‹αžˆαžšβ€‹/β€‹αž‡αž½αžšβ€‹αžŠαŸαž€

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΆβ€‹αžαžΎβ€‹αžαŸ’αžšαžΌαžœβ€‹αžšαŸ†αž›αŸαž…β€‹αž€αŸ’αž”αžΆαž›β€‹αž‡αž½αžšαžŠαŸαž€ αž¬β€‹αž‡αž½αžšαžˆαžšβ€‹αžŠαŸ‚αžšβ€‹αž¬αž‘αŸ αž“αŸ…β€‹αž€αŸ’αž“αž»αž„β€‹αž‡αž½αžšαžŠαŸαž€ αž¬β€‹αž‡αž½αžšαžˆαžšβ€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž‡αŸ’αžšαžΎαžŸαŸ”

αž”αŸ’αžšαžΎβ€‹αž”αŸ’αžšαž–αŸαž“αŸ’αž’β€‹αž˜αŸ‰αŸ‚αžαŸ’αžšβ€‹αž˜αŸ‰αžΆαžŸαŸŠαžΈαž“β€‹αž”αŸ„αŸ‡αž–αž»αž˜αŸ’αž–β€‹ αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž’αŸ’αžœαžΎβ€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž’αžαŸ’αžαž”αž‘

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΆβ€‹αžαžΎβ€‹αž”αŸ’αžšαž–αŸαž“αŸ’αž’β€‹αž˜αŸ‰αŸ‚αžαŸ’αžšβ€‹αž˜αŸ‰αžΆαžŸαŸŠαžΈαž“β€‹αž”αŸ„αŸ‡αž–αž»αž˜αŸ’αž–β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž’αž“αž»αžœαžαŸ’αžβ€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž€αžΆαžšβ€‹αž”αŸ„αŸ‡αž–αž»αž˜αŸ’αž– αž“αž·αž„β€‹αž€αžΆαžšβ€‹αž’αŸ’αžœαžΎβ€‹αž‘αŸ’αžšαž„αŸ‹αž‘αŸ’αžšαžΆαž™β€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž“αŸ…β€‹αž›αžΎβ€‹αž’αŸαž€αŸ’αžšαž„αŸ‹β€‹αžŠαŸ‚αžšβ€‹αž¬αž‘αŸαŸ” αž”αžΎβ€‹αž”αŸ’αžšαž’αž”αŸ‹β€‹αž“αŸαŸ‡β€‹αž˜αž·αž“β€‹αž’αžΈαž€β€‹αž‘αŸ αž”αŸ’αž›αž„αŸ‹β€‹αž’αžΆαžŸαŸ’αžšαŸαž™β€‹αž˜αŸ‰αžΆαžŸαŸŠαžΈαž“β€‹αž”αŸ„αŸ‡αž–αž»αž˜αŸ’αž– αž“αžΉαž„β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αŸ’αžšαžΎβ€‹αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž€αžΆαžšβ€‹αž”αž„αŸ’αž αžΆαž‰β€‹αž’αŸαž€αŸ’αžšαž„αŸ‹ αž“αž·αž„β€‹αž€αžΆαžšβ€‹αž”αŸ„αŸ‡αž–αž»αž˜αŸ’αž–αŸ”

αž”αž„αŸ’αž αžΆαž‰β€‹β€‹αž–αŸ’αžšαž˜αžΆαž“β€‹αžŸαžšαžŸαŸαžšβ€‹αž‡αžΆαž“αŸ‹β€‹αž›αžΎ β€‹β€‹αž–αŸαž›β€‹αž”αž·αž‘β€‹αž—αŸ’αž‡αžΆαž”αŸ‹β€‹αž‘αž·αž“αŸ’αž“αž“αŸαž™

αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΆβ€‹αžαžΎβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αž„αŸ’αž αžΆαž‰β€‹αžŸαžΆαžšβ€‹αž–αŸ’αžšαž˜αžΆαž“β€‹αžŠαŸ‚αžšβ€‹αž¬αž‘αŸ αž–αŸαž›β€‹αž’αŸ’αž“αž€β€‹αž”αž·αž‘αž—αŸ’αž‡αžΆαž”αŸ‹β€‹αž€αŸ’αžšαž‘αžΆβ€‹αž–αžΈβ€‹αž€αŸ’αžŠαžΆαžšβ€‹αžαž˜αŸ’αž”αŸ€αžβ€‹αžαŸ’αž‘αžΆαžŸαŸ‹β€‹αž‘αŸ…β€‹αž‡αž½αžšβ€‹αž€αŸ’αžšαž‘αžΆβ€‹αžŠαŸ‚αž›β€‹αž˜αž·αž“β€‹αž‘αŸ†αž“αŸαžšαŸ”

Position cell reference with selection

With the option set, expanding a selection (with +Shift+Down/Up) jumps to the end of the range in the column that was added as last to the initial selection. When the option is not set, expanding a selection (with +Shift +Down/Up) jumps to the end of the range in the column where selecting the cell range was started. The same of course applies when extending a selection on rows, with + Shift+Left/Right.

Please support us!