[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #14 from CherylSilvia  ---
What about new update for the gambling site? I want to improve some bug, but
does it work for https://rocketpayz.com/lincoln-casino ? I will be grateful.

-- 
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 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #13 from m.a.riosv  ---
With hard recalc works for me with:
Version: 5.1.6.1 (x64)
Build ID: f3e25ec0581f5012f54d8810dcddd5824f4ee374
CPU Threads: 1; OS Version: Windows 6.19; UI Render: default; 
Locale: es-ES (es_ES); Calc: CL
Version: 5.2.2.2 (x64)
Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 
Locale: es-ES (es_ES); Calc: CL

Maybe it was some of the OpenCL issues solves now. (More than 100 equal
formulas).

-- 
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 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

Markus Mohrhard  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||markus.mohrhard@googlemail.
   ||com
 Resolution|--- |WORKSFORME

--- Comment #12 from Markus Mohrhard  ---
Works in master. This needs a CTRL+SHIFT+F9 and then a resave as the wrong
value is stored in the document.

-- 
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 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||bibisectRequest
 CC||xiscofa...@libreoffice.org

--- Comment #11 from Xisco Faulí  ---
Since we have a bibisect repository for windows covering the branch where this
regression was introduced, adding keyword 'bibisectRequest'.
More info: https://wiki.documentfoundation.org/QA/Bibisect/Windows

-- 
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 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 CC||r...@post.cz

--- Comment #10 from raal  ---
I can not confirm with Version: 5.2.0.0.alpha0+
Build ID: 91a7580e03d5b47c6e2513afce85ddee45e730b6
CPU Threads: 1; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-03_23:51:42

after hard recalc is result 0,0 mg

-- 
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 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #9 from m.a.riosv  ---
Created attachment 118701
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118701=edit
Screenshot after opening with both options at Always recalculate + hard recalc
+ Version box.

Tested with master 32 bits.

Nothing change for me, with both types "always recalculate" activated and after
a hard recalc.

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #8 from GerardF  ---
Forget to say that I try with both FR and US locale.

There is a strange thing : The format used (0,0" "[$mg]) is listed in the
"Currency" category.

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #7 from GerardF  ---
I find why I saw 0 in the 1st attempt :
In Tools > Options > Calc, Formula → "Recalculation on file load" was on
"always recalculate" for ODF spreadsheet.

Trying with a new profile (default settings), I got 2 but Ctrl+Shift+F9 works.

The only difference I see with Markus and Miguel Angel is I'm on 32bit OS (Win
Vista 32)

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #1 from Markus Benter 
 ---
Created attachment 118668
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118668=edit
The Calculation

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

   Keywords||regression
 Status|UNCONFIRMED |NEW
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #3 from m.a.riosv  ---
Hi Markus, thanks for reporting.

Reproducible.
Win10x64
Versión: 4.4.5.2 Id. de compilación: a22f674fd25a3b6f45bdebf25400ed2adff0ff99

Last working
Version: 4.3.7.2 Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba

With an operator before the reference to the first empty cell, it works.

=B314+C314/2 shows the error
=+B314+C314/2 not.

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #2 from Markus Benter 
 ---
Created attachment 118669
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118669=edit
The result of A+B

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

GerardF  changed:

   What|Removed |Added

 CC||gerard.farg...@orange.fr

--- Comment #4 from GerardF  ---
Oddly, I can't reproduce with the same 4.4.5.2
I see 0 at opening and writting again the formula display also 0.

With 5.1.0.0 alpha1+, I see 2 but hard recalc cure the problem.

I try with various settings in calc options and still can't reproduce...
What are your calculation settings ?

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #6 from m.a.riosv  ---
I forgot, hard recalc doesn't solve the issue.

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

[Libreoffice-bugs] [Bug 94186] Let A, B empty cells than A+B/2=2 under certain conditions

[bugzilla-daemon]

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

--- Comment #5 from m.a.riosv  ---
Created attachment 118682
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118682=edit
Screenshot showing results and formulas

Attached a screenshot showing results and formulas.

Maybe some obscure option makes the difference.

I have tried changing Menu/Tools/LibreOffice calc/Formula - Detailed
calculation - Custom - Treat empty string as zero, but no luck.

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