https://bugs.documentfoundation.org/show_bug.cgi?id=166164
Bug ID: 166164
Summary: Paste giving inconsistent results
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a formula eg: =IF(AGI89="-","-",(AGJ89-$ABG89)/$ABG89)
I have tried to copy the formula multiple times. However, when I paste the
formula, using Copy, it doesn't always work. Sometimes it works, but a lot of
the time it doesn't. I get '- in the cells. Sometimes the '- is only on the
first line (of paste) and sometimes all the lines. I have also tried "Paste
Special - Formula". That doesn't always work either!
I would except "Paste" to copy everything (text, formula, format etc.) and
"Paste Special" to copy only text or formula etc.
Steps to Reproduce:
1. Copy (a large block of cells with formatting, text or formulas)
Most of the formulas use the IF statement.
2. Paste (formulas are not always pasted)
3.
Actual Results:
Consider a simplified formula: =IF(A=0,"-",A*B)
If I copy the cells with formula - paste will sometimes paste the formula as
required, sometimes paste the text (from the copy cell) or sometimes paste '-
(which is part of IF statement)
Expected Results:
I expect each cell to contain the correct formula, but I have to go to each
block of cells and check they contain the correct formulas or else copy the
correct formula into a cell
Reproducible: Always
User Profile Reset: No
Additional Info:
Each time I copy a block of cells, approximately 150 rows by 3 columns wide. I
expect the software to paste everything that was in the block of cells.
--
You are receiving this mail because:
You are the assignee for the bug.
