Bug 40260 - Formula of Regression curve missing while Copy&Paste from Calc to Writer
Summary: Formula of Regression curve missing while Copy&Paste from Calc to Writer
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
Whiteboard: target:7.2.0
Depends on:
Blocks: Chart Paste
  Show dependency treegraph
Reported: 2011-08-20 16:29 UTC by Frantisek Erben
Modified: 2021-02-12 09:40 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Test file containing Chart (25.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-08-20 16:31 UTC, Frantisek Erben
Chart inserted into Writer document – containing bad result (16.13 KB, application/vnd.oasis.opendocument.text)
2011-08-20 16:32 UTC, Frantisek Erben

Note You need to log in before you can comment on or make changes to this bug.
Description Frantisek Erben 2011-08-20 16:29:52 UTC
How to reproduce:
Copy Chart and paste it into Writer/Presentation/Draw (files included).

In writer is "f(x) = 0x -0" instead of correct formula "f(x) = 1,265…

Expected result:
Same chart as in Calc.

Other observation:
Copy&Paste between 2 .ods documents works fine.
Comment 1 Frantisek Erben 2011-08-20 16:31:07 UTC
Created attachment 50413 [details]
Test file containing Chart
Comment 2 Frantisek Erben 2011-08-20 16:32:37 UTC
Created attachment 50414 [details]
Chart inserted into Writer document – containing bad result
Comment 3 Jeffrey 2011-08-20 19:43:10 UTC
Formula error confirmed for LibreOffice 3.4  340m1(Build:103) on OpenSuse Linux.
Comment 4 Regina Henschel 2011-08-22 06:54:43 UTC
It is only a wrong formatting. Open the chart for editing. Double-click the equation and call format for this object. Set a suitable format in the tab "number". You can avoid such troubles, if already in Calc you do not use the format "standard" but set it to a science format explicitly.
Comment 5 Frantisek Erben 2011-08-22 08:06:47 UTC
Regina your workaround works perfectly, but I disagree with your bug classification.
For me it's still bug with workaround: Writer must keep the number's format from Calc under all circumstances (Drag&Drop, Copy&Paste, Import…).
Importance decreased due workaround existence.
Comment 6 Joel Madero 2014-11-06 17:33:24 UTC
Never confirmed by QA - setting to UNCONFIRMED.
Comment 7 Alex Thurgood 2014-11-10 13:06:35 UTC
Confirming on

Build ID: c1358e5dc875bb923f4b5472ba615ebd19f0d057
Comment 8 QA Administrators 2015-12-20 16:10:45 UTC Comment hidden (obsolete)
Comment 9 Alex Thurgood 2015-12-21 08:31:20 UTC
Confirming also in

Build ID: ce3d3f5543e3e132a3473af27aa2c827336add0f
CPU Threads: 2; OS Version: -; UI Render: default; 
Locale : fr-FR (fr.UTF-8)
Comment 10 QA Administrators 2017-01-03 19:57:28 UTC Comment hidden (obsolete)
Comment 11 eisa01 2017-11-05 19:33:31 UTC
Still present, was in original 3.3 as well, present in Windows an present in Linux as per comment 3

Build ID: 7e03c4eed72452fdfb87341214a21956c08ba969
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2017-10-25_23:45:02
Locale: en-US (en_US.UTF-8); Calc: group
Comment 12 QA Administrators 2018-11-06 03:57:03 UTC Comment hidden (obsolete)
Comment 13 eisa01 2018-12-08 09:04:39 UTC
Still present. Workaround in comment #4 to format as scientific, but I would say this is non-obvious for a user to discover on her own. E.g., I first tried to format as numbers, but that didn't help. As such raising the importance according to the flow chart

Also, I previously tested this to be inherited

Build ID: beae6c7a7f163daad0d4dea63a3d403af2745fd1
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-12-06_23:52:29
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 14 QA Administrators 2019-12-09 03:38:53 UTC Comment hidden (obsolete)
Comment 15 eisa01 2020-02-15 17:14:09 UTC
Bug is still there

Build ID: 0cb4f304abf6f8dd6b40eb800788d2fe80581813
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 17 Commit Notification 2021-02-12 09:40:50 UTC
Xisco Fauli committed a patch related to this issue.
It has been pushed to "master":


tdf#40260: sw_layoutwriter: Add unittest

It will be available in 7.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.