https://bugs.documentfoundation.org/show_bug.cgi?id=156357
Bug ID: 156357
Summary: Cannot copy formula by copying cell when displaying
with Show Formula
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
[View]-[Show Formula] in the menu and [LibreOffice Calc]-[View] in the option
dialog and [Display] in Formulas appear to have the same function.
But it behaves differently when copying cells. If this is unintended, it's a
bug.
Steps to Reproduce:
1.start Calc
2.Enter the formula "=123/3" in A1
3.Turn on the menu [View]-[Show formula]
4.Click cell A1 and press Ctrl-C to copy
5.Paste it somewhere in a text editor
The resulting "41" is pasted instead of the displayed formula itself
However, the formula will copy and paste if they follow these steps:
3.instead of step 3 above,
select menu [Tools]-[Options], [LibreOffice Calc]-[View], check [Formula] in
[View], and click [OK]
4.Click cell A1 and press Ctrl-C to copy
5.Paste it somewhere in a text editor
The formula "=123/3" is pasted
These two menu items seem to be on/off affecting each other. If these are the
same function, the copy result should be the same.
If it's different functions, I don't think they should affect each other's
on/off
Actual Results:
The resulting "41" is pasted instead of the displayed formula itself
Expected Results:
The formula "=123/3" is pasted
Reproducible: Always
User Profile Reset: No
Additional Info:
Reproduced in the following versions:
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 45826e60d5f1508d54b0f0a4d98b0e2ebe94a097
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Version: 7.3.6.2 / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
