[Libreoffice-bugs] [Bug 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7929

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 OS|Mac OS X (All)  |All
   Hardware|x86-64 (AMD64)  |All
 Resolution|--- |WORKSFORME

--- Comment #8 from Timur  ---
Doing a simple F9 recalc (when cells selected) solves the issue:
https://help.libreoffice.org/6.2/en-US/text/scalc/01/0608.html

Asking for fileopen recalc also solves the issue:
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01060900.html

I always set "Prompt User". And here it promtps, you say Yes and solved. 
Default is "Never recalculate". Bug 107929 to set "Prompt user" as default for
"Recalculation on file load" is WontFix. 

I close this one as WFM.

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7930

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

--- Comment #7 from Xavier Van Wijmeersch  ---
changing the formula in H3 =F3; and H26; to =IF(F2="";F3;H3) seems to solve the
problem, saving the document and then reopen no need to hard recalculation.

Version: 5.3.7.2
Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059
CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout
Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.2.0.0.alpha0+
Build ID: 83d8331581ab43cf35325ca674cf62d4ba5dc5ad
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded

I think it can be closed as WFM

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

--- Comment #6 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-20180731

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

--- Comment #5 from m.a.riosv  ---
If I'm not wrong control key in Mac is Command ⌘
It should be ⌘ + shift + fn + F9
Maybe you can see the key combinations in Menu/Tools/Customize/Keyboard

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

--- Comment #4 from Ron Cohen  ---
Hard recalc odes not work on my machine (MacOS 10.13.2). control + shift + F9
has no effect, nor does control + shift + fn + F9, and I cannot find any menu
item for "hard recalc".

I do not know how to reproduce this in a few file; copying and pasting from
this file to another does not demonstrate the bug. However I have attached
another file, which is the original file where this bug was first observed. The
smaller file I attached with the bug report was that file with lots of cells
deleted.

Assuming I can get hard recalc to work (how?) then how does one know when that
must be done? In other words, how can I tell that some calculations in a sheet
are wrong and must be reset?

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

--- Comment #3 from Ron Cohen  ---
Created attachment 139045
  --> https://bugs.documentfoundation.org/attachment.cgi?id=139045=edit
original file demonstrating bug

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #2 from m.a.riosv  ---
Doing a hard recalc [ctrl+shift+F9], solves the issue. 
Maybe it was saved in a wrong state. 
I don't there is a bug.
Can you reproduce with a new file from scratch.

-- 
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 114954] Incorrect calculation or failure to recalculate - EDITING

[bugzilla-daemon]

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

Ron Cohen  changed:

   What|Removed |Added

 CC||r...@ron-cohen.net

--- Comment #1 from Ron Cohen  ---
Created attachment 139030
  --> https://bugs.documentfoundation.org/attachment.cgi?id=139030=edit
Calc file showing incorrect calculations

-- 
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