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.

Reply via email to