https://bugs.documentfoundation.org/show_bug.cgi?id=172998
Bug ID: 172998
Summary: Calc: Paste Special is unavailable when copying a
complete matrix formula range back onto itself
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In LibreOffice Calc, I cannot use Paste Special to replace a matrix formula
range with its calculated values when the destination range is the same as the
source range.
Steps to reproduce
1. Enter source values in cells A2:A107.
2. In another cell, enter the matrix formula:
{=SORT(UNIQUE(A2:A107))}
In my localized installation, the formula is:
{=ORDENAR(ÚNICO(A2:A107))}
3. Select the entire resulting matrix range, not only its first cell.
4. Copy the selected range.
5. Without changing the selection, try to use Edit → Paste Special or press
Ctrl+Shift+V.
6. Try to paste only the values or unformatted text over the original matrix
range.
Actual result
Paste Special is unavailable when the destination is the same range as the
copied matrix formula
range. Therefore, the formulas cannot be replaced directly with their
calculated values.
As a workaround, I must:
1. Paste the results as values or text into another area.
2. Copy that temporary area.
3. Paste it back over the original range.
4. Delete the temporary data.
Expected result
Paste Special should be available when the copied range and destination range
are the same. I
should be able to paste only the calculated values over the matrix formulas,
thereby converting
the formula-generated range into static data without using a temporary area.
Reproducibility
Always.
Additional information
The problem concerns a complete matrix range. Copying and pasting it into a
different range works;
Paste Special becomes unavailable only when attempting to paste it over its
original range.
Version information:
Version: 26.2.5.2 (X86_64)
Build ID: cd7284b4cbbfeb507e630c1aac019f4157393acb
CPU threads: 20; OS: Linux 7.1; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR
Flatpak
Calc: threaded
Operating system:
Debian Sid
--
You are receiving this mail because:
You are the assignee for the bug.
