[Libreoffice-bugs] [Bug 89207] Cannot change only part of an array

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jan 25 09:26:16 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=89207

--- Comment #5 from russell <prusselltechgroup at gmail.com> ---
>From the doc: Array Functions -
https://help.libreoffice.org/6.0/he/text/scalc/01/04060107.html

======================
Editing Array Formulas

    Select the cell range or array containing the array formula. To select the
whole array, position the cell cursor inside the array range, 
    then press Ctrl+/, where / is the Division key on the numeric keypad.

    Either press F2 or position the cursor in the input line. Both of these
actions let you edit the formula.

    After you have made changes, press Ctrl+Shift+Enter.

Adjusting an Array Range

    If you want to edit the output array, do the following:

    Select the cell range or array containing the array formula.

    Below the selection, to the right, you will see a small icon with which you
can zoom in or out on the range using your mouse.

Note Icon       

When you adjust the array range, the array formula will not automatically be
adjusted. You are only changing the range in which the result will appear.
======================

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190125/2f48f6e9/attachment.html>


More information about the Libreoffice-bugs mailing list