| Summary: | Paste values only & transpose fails when values come from an array formula EDITING | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | David Lynch <dlynch1319> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | UNCONFIRMED --- | ||
| Severity: | normal | CC: | miguelangelrv, that.man.colin |
| Priority: | medium | ||
| Version: | 7.2.5.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
As I know you cannot do it with part of an array, it happens also with a simple copy-paste. When trying to copy part of an array, nothing is copied. *** Bug 148500 has been marked as a duplicate of this bug. *** |
Description: Paste values only & transpose fails when values come from an array formula Steps to Reproduce: 1. enter an array formula in A1 eg ={ROW(A1:A4)} 2. Select A1:A4 3. Copy 4. Select C1 5. [insert] then click Transpose and click Values only then [OK] Actual Results: C1=1 C2=2 C3=3 C4=4 Expected Results: C1=1 D1=2 E1=3 F1=4 Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded