Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 06 Apr 2018 08:07:50 +0200How to copy the values or cells from a matrix subrange in Calc?https://ask.libreoffice.org/en/question/151533/how-to-copy-the-values-or-cells-from-a-matrix-subrange-in-calc/In Calc, version 5.x, if you want to copy only a subrange of cells that are the result of a matrix formula, how to do that?
That is, for example, if you put into cells A1:A5 respectively the values 1 to 5, and to fill B1:B5 you put into B1 the matrix formula {=A1:A5+1} (ctrl+shift+enter). Then, you want to copy only the cells or values B2:B4, but, selecting B2:B4 the copy option isn't enabled, why? how to copy a subrange only of a matrix calculation?
Is properly a problem or design of Calc version 5.x? or is a configuration matter? Is there any way to do that selected subrange copy?
Thanks!SanchoFri, 06 Apr 2018 08:07:50 +0200https://ask.libreoffice.org/en/question/151533/