https://bugs.documentfoundation.org/show_bug.cgi?id=148590
Bug ID: 148590
Summary: Editing: Formulas pasted as numbers between different
versions of Calc
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If I copy from spreadsheet in Calc 7.2.5.2 and paste to Calc 7.3.1.3 in same
computer, the formulas are converted to numbers. If I select Paste Formulas
then nothing is pasted. Have tried every type in Paste Special.
Same pasting of numbers-only (not formula) to Excel 2010 & Excel 2019, even
selecting SLYK. The reverse direction, from Excel to Calc pastes formula
Possibly related to
https://bugs.documentfoundation.org/show_bug.cgi?id=31077#c27
Example:
In 7.2.5.2 I create spreadsheet, I enter in A1 1, A2 2, A3 =A1+A2
I copy all three cells and paste into a new spreadsheet in Calc 7.3.1.3.
I get A1 1, A2 2, A3 3. No formula
Expected result: Formula is pasted
Actual result: Number only pasted
Reproducible: Always.
Tested on two Windows 11 computers (other 7.2.6.2 to 7.3.2.2 and reverse) with
same results. New user profile, Windows clipboard manager on or off.
Most recent test on:
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-GB
Calc: threaded
Version: 7.3.1.3 (x64) / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: default; VCL: win
Locale: en-NZ (en_NZ); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.