https://bugs.documentfoundation.org/show_bug.cgi?id=153219
Bug ID: 153219
Summary: [UX Productivity enhancement] Copy text of reference
and paste it into a cell works only for single cell
(not for array of references)
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
For the sake of productivity, sometimes we prepare formulas to create other
formulas. Then copy and paste them to the selected place in the sheet. But this
approach is useless in Calc because when pasting a text array with references
as "Unformatted Text", e.g.:
=sum(A1:A4)
=sum(B1:B4)
It appears as text and is not interpreted as formulas in these cells.
Steps to Reproduce:
Version: 7.4.4.2 (x64) / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: en-GB
Calc: threaded
Actual Results:
Formula text pasted into a cell only works as a formula when you paste a single
cell.
Expected Results:
-
Reproducible: Always
User Profile Reset: No
Additional Info:
-
--
You are receiving this mail because:
You are the assignee for the bug.
