Bug 124006 - EDITING: copy & paste from AOO to LO or between two LO instances fails for formulas
Summary: EDITING: copy & paste from AOO to LO or between two LO instances fails for fo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Windows (All)
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 148590 (view as bug list)
Depends on:
Blocks: Paste
  Show dependency treegraph
 
Reported: 2019-03-11 19:20 UTC by Oliver Brinzing
Modified: 2023-10-05 09:49 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
copy and paste formula between lo instances (101.44 KB, image/png)
2019-03-14 20:20 UTC, Oliver Brinzing
Details
Paste special window (8.87 KB, image/png)
2019-03-14 20:39 UTC, GerardF
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Brinzing 2019-03-11 19:20:47 UTC
steps to reproduce:

- open two instances of LO Calc, e.g. LO 6.0.7.3 and LO 6.1.4.2
  with same locale
- LO 6.0.7.3, cell A1: enter =Today()
- copy with ctrl+c
- LO 6.1.4.2: paste with ctrl+v
-> cell A1 shows number (e.g. 43535) instead of expected formula

same behaviour if copied from AOO 4.1.5 to LO and vice versa

copying from LO into Excel works:
- open Excel 2016
- new a spreadsheet
- cell A1: paste with ctrl+v
- A1 shows =Today()

copy from Excel into LO spreadsheet works too,
Paste Special shows options:
- Microsoft Excel Binary Interchange format (Biff8)
- Microsoft Excel Binary Interchange format (Biff5)
Comment 1 raal 2019-03-12 07:40:02 UTC
Works for me -  copy from 6.3 to 6.0.7.3 and vice versa

Verze: 6.0.7.3
ID sestavení: 1:6.0.7-0ubuntu0.18.04.2

Version: 6.3.0.0.alpha0+
Build ID: 732d630c3d2a168c725c18e4dd8df7a0a4f85566
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Comment 2 Oliver Brinzing 2019-03-14 20:20:55 UTC
Created attachment 149977 [details]
copy and paste formula between lo instances

not working for me with LO 6.3 (dev build) and LO 6.1.5.2 (msi installed) - Win 10
Comment 3 GerardF 2019-03-14 20:39:46 UTC
Created attachment 149979 [details]
Paste special window

I can confirm (on Windows 10).
In both directions (LO Dev → LO 6.1, LO 6.1 → LO Dev)

In attachment, what I get if I use Paste special instead of Paste.
Comment 4 Xisco Faulí 2019-03-22 15:15:35 UTC
I don't think there are many users having different instances of LibreOffice installed at the same time. Let's change the summary to a more realistic scenario...

I can confirm it from AOO 4.1.3 to LO

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

but not the other way around...

it works if paste special is used. Reducing severity...
Comment 5 QA Administrators 2021-03-22 04:19:25 UTC Comment hidden (obsolete)
Comment 6 Aron Budea 2022-06-04 22:15:52 UTC
*** Bug 148590 has been marked as a duplicate of this bug. ***
Comment 7 Aron Budea 2022-06-04 22:19:59 UTC
(In reply to raal from comment #1)
> Works for me -  copy from 6.3 to 6.0.7.3 and vice versa
Seems Windows-specific.

(In reply to Xisco Faulí from comment #4)
> I don't think there are many users having different instances of LibreOffice
> installed at the same time. Let's change the summary to a more realistic
> scenario...
Maybe have both? It's important detail that not only AOO -> LO copy-pasting is affacted, but LO -> LO as well, if for no one else, then to the person who picks up this bug.