[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

QA Administrators  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |INSUFFICIENTDATA

--- Comment #16 from QA Administrators  ---
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20180530

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #15 from QA Administrators  ---
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping-20180502

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1

--- Comment #14 from Buovjaga  ---
MD: per JBF's results, do you still see the wrong result in version 5.4.x?

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED
WORKSFORME, if the problem went away.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

Jean-Baptiste Faure  changed:

   What|Removed |Added

 CC||jbfa...@libreoffice.org

--- Comment #13 from Jean-Baptiste Faure  ---
Not reproducible for me with 

Version: 5.4.1.2
Build ID: 1:5.4.1~rc2-0ubuntu0.16.04.1~lo0
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
Locale: fr-FR (fr_FR.UTF-8); Calc: single
Version: 5.4.3.0.0+

Build ID: 3766aa5b3232beba4e4989696b6d19103ba0d62f
Threads CPU : 4; OS : Linux 4.4; UI Render : par défaut; VCL : gtk3; 
Ubuntu_16.04_x86-64
Locale : fr-FR (fr_FR.UTF-8); Calc: single

Version: 6.0.0.0.alpha0+
Build ID: ae0edc4740ea95cd456eb7157bd048615de9212e
Threads CPU : 4; OS : Linux 4.4; UI Render : par défaut; VCL: gtk3; 
Ubuntu_16.04_x86-64
Locale : fr-FR (fr_FR.UTF-8); Calc: single

All these versions give #REF! in B1:B3 and 1 in B147:B153 after step 7.

Best regards. JBF

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

Xisco Faulí  changed:

   What|Removed |Added

 Status|REOPENED|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #12 from Xisco Faulí  ---
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #11 from Xavier Van Wijmeersch  ---
No, your description is clear
But when pressing ctlr+v for B300:B1 nothing happens, no results, only when
saving and reopening the document then the results are correct. That's the
problem I have.
Correct observation as for comment7 and 8

Best regards

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||102593, 108253


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=102593
[Bug 102593] [META] Paste bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #10 from MD  ---
Not sure what you mean by "the only problem I still have is the pasting bit"

Is my description unclear?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #9 from Xavier Van Wijmeersch  ---
Your wright I misunderstood the description.
I have made a new test, the only problem I have is the pasting bit.
This result I have when saved it and re-opened it is

"cells B1 to B3 should display REF as indicated by their formulae
cells B147 to B153 should display 1"

Version: 5.4.2.0.0+
Build ID: 61d85c4e7c30ea0f5242d927b7456190020b4fbe
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Best regards

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #8 from MD  ---
Also: If the sheet is saved then re-opened the cells are calculated correctly

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #7 from MD  ---
Further investigation indicates the paste operation behave correctly
if the paste is from cell B1 to B99
but fails if the paste is made after cell B100

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #6 from MD  ---
repeated using version LibreOffice_5.4.1_Linux_x86-64_rpm.tar.gz

I installed this version locally in my home folder while still having the 
latest OpenSUSE-Leap42 version installed.

I assume they should not interfere.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

MD  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #5 from MD  ---
comment #2. You have misunderstood this bug report

The bug is that cells in column B are incorrect after the paste operation.
Cells with a REF shown in the formula should display REF not 0.
Cells B147 to B153 should display a 1 not 0.

Any formula that then references cells B147 to B153 uses the value of zero and
gets incorrect results.

This results in a spreadsheet quietly miscalculating. 

Clearly I have a simple case that makes it obvious a bug is present.
Others may have more complex sheets and be unaware their calculations are
wrong.
This is why I marked it critical. The spreadsheet is not fit for purpose. 

IMPORTANT NOTE
I tried to reproduce this before making this comment and instead of cell A150
as my starting point I used cell A7. The sheet worked correctly. 
However when I used cell A150 again I got the problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #4 from Xavier Van Wijmeersch  ---
Created attachment 136295
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136295=edit
srceenshot

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

Xisco Faulí  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||xiscofa...@libreoffice.org
 Resolution|--- |NOTABUG

--- Comment #3 from Xisco Faulí  ---
Closing as RESOLVED NOTABUG based on comment 2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #2 from Xavier Van Wijmeersch  ---
Its normal that you have a ref error because B1 is the first cell off column B,
and the formula is looking to B1 minus wish not exist. Have a look at the
screenshot you will see B4 reference to A1(:A7) wish is the first cell off
column A. So B1 to B3 will have a ref error. I think its not a bug.

Best regards

Version: 5.4.2.0.0+
Build ID: 61d85c4e7c30ea0f5242d927b7456190020b4fbe
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 112434] incorrect formula calculation after pasting when some of pasted cells would result in a REF result

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=112434

--- Comment #1 from Xavier Van Wijmeersch  ---
Created attachment 136294
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136294=edit
srceenshot

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs